This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 39%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIC%3C/text%3E%3C/svg%3E)
Hi there,
I am trying to do a batch request to add a column to a table in excel, and I get the following error:
Client error: POST https://graph.microsoft.com/v1.0/$batch resulted in a 400 Bad Request response:
{"error":{"code":"BadRequest","message":"Invalid JSON body for request id : 1","innerError":{"date":"2021-05-18T08:58:53","request-id":"1694244a-9ef4-4cda-b28e-423f798842dd","client-request-id":"1694244a-9ef4-4cda-b28e-423f798842dd"}}}
The body is valid JSON: {"name":"Email"}
The request is /me/drive/items/fileidgoeshere/workbook/worksheets/{worksheetid}/tables/{table-id}/columns/add
I found this ticket, but I wasn't able to fix the problem by adding a space in the body payload. https://social.msdn.microsoft.com/Forums/en-US/293f8748-aec0-4093-867e-9b25d503313e/cannot-update-messages-through-rest-batch-request?forum=Office365forDevelopers
I
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 27%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDO%3C/text%3E%3C/svg%3E)
If you calling $batch can you provide the whole structure of the body you have? Here is a sample adding column to workbook using $batch. Refer to https://learn.microsoft.com/en-us/graph/json-batching. Note that if you are just running one request it is not useful to call $batch. You should just call the direct endpoint.
POST https://graph.microsoft.com/v1.0/$batch
{
"requests": [
{
"id": "1",
"url": "/me/drive/items/item-id/workbook/worksheets/worksheet-id/tables/table-id/columns/add",
"method": "POST",
"body": {
"name": "Column X"
},
"headers": {
"Content-Type": "application/json"
}
}
]
}
Hi @Danstan, while fetching the request I found the issue. I am using the PHP SDK, and I sent the request body based on what the SDK creates. Because of that I was sending this "{\"name\":\"Last name\"}" which is not valid JSON. I was able to correct it by manually creating the request without using the sdk, and the endpoint worked. Thank you for the help.