Power Platform Community Forum Thread Details

Send an HTTP request to SharePoint - Error

HHy guys,

I'm using an online template for batch create an item in a Sharepoint list.

Link of the template: Power Automate Flow to batch create SharePoint List Items (tachytelic.net)

But I keep getting an error, I believe it´s something on the Json body input.

Here is the input of the body:

--batch_d77df377-7f04-4b3b-9de1-63fecbf5905d
Content-Type: multipart/mixed; boundary="changeset_ed06f849-237d-46c0-957d-97517e6de654"
Content-Length: 489
Content-Transfer-Encoding: binary

--changeset_ed06f849-237d-46c0-957d-97517e6de654
Content-Type: application/http
Content-Transfer-Encoding: binary

POST https://lact.sharepoint.com/sites/DSI-E-Institucional/_api/web/lists(guid'971bd401-213a-4596-a2b0-34d794857e69') HTTP/1.1

Content-Type: application/json;odata=verbose

{"__metadata":{"type":"SP.Data.Atualizao_x0020_de_x0020_PresenasListItem"},"Title":"60000285","N_x002e_Colab_x002e_":"00000093","Nome":"Ricardo Sérgio Silva Marques","Cod_x002e_Status_x0020_SAP":"1"}

--changeset_ed06f849-237d-46c0-957d-97517e6de654--

--batch_d77df377-7f04-4b3b-9de1-63fecbf5905d--

Here is the output:

{
 "$content-type": "multipart/mixed; boundary=batchresponse_fe6dbe53-abb5-442b-a341-6bdac52308c7",
 "$content": "LS1iYXRjaHJlc3BvbnNlX2ZlNmRiZTUzLWFiYjUtNDQyYi1hMzQxLTZiZGFjNTIzMDhjNw0KQ29udGVudC1UeXBlOiBhcHBsaWNhdGlvbi9odHRwDQpDb250ZW50LVRyYW5zZmVyLUVuY29kaW5nOiBiaW5hcnkNCg0KSFRUUC8xLjEgNDAwIEJhZCBSZXF1ZXN0DQpDT05URU5ULVRZUEU6IGFwcGxpY2F0aW9uL2pzb247b2RhdGE9dmVyYm9zZTtjaGFyc2V0PXV0Zi04DQoNCnsiZXJyb3IiOnsiY29kZSI6Ii0xLCBNaWNyb3NvZnQuU2hhcmVQb2ludC5DbGllbnQuSW52YWxpZENsaWVudFF1ZXJ5RXhjZXB0aW9uIiwibWVzc2FnZSI6eyJsYW5nIjoicHQtUFQiLCJ2YWx1ZSI6IlNlcXVcdTAwZWFuY2lhIEpTT04gZm9ybWF0YWRhIGluY29ycmV0YW1lbnRlLiJ9fX0NCi0tYmF0Y2hyZXNwb25zZV9mZTZkYmU1My1hYmI1LTQ0MmItYTM0MS02YmRhYzUyMzA4YzctLQ0K",
 "$multipart": [
 {
 "headers": {
 "Content-Type": "application/http",
 "Content-Transfer-Encoding": "binary"
 },
 "body": {
 "$content-type": "application/http; msgtype=response",
 "$content": "SFRUUC8xLjEgNDAwIEJhZCBSZXF1ZXN0DQpDT05URU5ULVRZUEU6IGFwcGxpY2F0aW9uL2pzb247b2RhdGE9dmVyYm9zZTtjaGFyc2V0PXV0Zi04DQoNCnsiZXJyb3IiOnsiY29kZSI6Ii0xLCBNaWNyb3NvZnQuU2hhcmVQb2ludC5DbGllbnQuSW52YWxpZENsaWVudFF1ZXJ5RXhjZXB0aW9uIiwibWVzc2FnZSI6eyJsYW5nIjoicHQtUFQiLCJ2YWx1ZSI6IlNlcXVcdTAwZWFuY2lhIEpTT04gZm9ybWF0YWRhIGluY29ycmV0YW1lbnRlLiJ9fX0=",
 "$applicationHttp": {
 "headers": {},
 "body": {
 "error": {
 "code": "-1, Microsoft.SharePoint.Client.InvalidClientQueryException",
 "message": {
 "lang": "pt-PT",
 "value": "Sequência JSON formatada incorretamente."
 }
 }
 },
 "statusCode": 400
 }
 }
 }
 ]
}

Error code:

"code": "-1, Microsoft.SharePoint.Client.InvalidClientQueryException",

Message value:

Incorrectly formatted JSON sequence

Quick Links

Leaderboard