Batch Sharepoint post request - no errors but no results

[NicPrad]

Hi, I'm trying to add some items to a list with a batch request.

Everything seems fine, I get no errors but nothing happens in the list.

In the beginning I tried to fill in lots of fields, but since they were basically all lookup columns, in the request below I tried to fill in a text field only.

Here's the input code in the http request.

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "HttpRequest"
    },
    "parameters": {
        "dataset": "https://xxxxxxxx.sharepoint.com/sites/xxxxxxxx",
        "parameters/method": "POST",
        "parameters/uri": "_api/$batch",
        "parameters/headers": {
            "content-type": "multipart/mixed; boundary=batch_bc2d8b77-ee2f-40b2-8917-eca464ed8623"
        },
        "parameters/body": "--batch_bc2d8b77-ee2f-40b2-8917-eca464ed8623
Content-Type: multipart/mixed; boundary="changeset_31f645bf-df57-487f-9e01-0ca6babb4001"
Content-Transfer-Encoding: binary

--changeset_bc2d8b77-ee2f-40b2-8917-eca464ed8623
Content-Type: application/http
Content-Transfer-Encoding: binary
POST https://xxxxxxxx.sharepoint.com/sites/xxxxxxxx/_api/web/lists/getByTitle('xxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose
{"__metadata":{"type":"SP.Data.xxxxxxxxListItem"},"Note":""}

--changeset_bc2d8b77-ee2f-40b2-8917-eca464ed8623
Content-Type: application/http
Content-Transfer-Encoding: binary
POST https://xxxxxxxx.sharepoint.com/sites/xxxxxxxx/_api/web/lists/getByTitle('xxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose
{"__metadata":{"type":"SP.Data.xxxxxxxxListItem"},"Note":""}

--changeset_31f645bf-df57-487f-9e01-0ca6babb4001--
--batch_bc2d8b77-ee2f-40b2-8917-eca464ed8623--"
    }
}

 and this is the response

{
    "statusCode": 200,
    "headers": {
        "Cache-Control": "no-store, max-age=0, private",
        "Transfer-Encoding": "chunked",
        "Vary": "Origin",
        "Set-Cookie": "ARRAffinity=xxxxxxxxxxxxxxxxxxxt",
        "Strict-Transport-Security": "max-age=31536000",
        "X-NetworkStatistics": "0,525568,0,0,13,0,17745",
        "X-SharePointHealthScore": "0",
        "X-SP-SERVERSTATE": "ReadOnly=0",
        "DATASERVICEVERSION": "3.0",
        "X-Download-Options": "noopen",
        "SPClientServiceRequestDuration": "7",
        "SPRequestDuration": "8",
        "X-DataBoundary": "EU",
        "X-1DSCollectorUrl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/",
        "X-AriaCollectorURL": "https://eu-mobile.events.data.microsoft.com/Collector/3.0",
        "SPRequestGuid": "fb7efea0-e024-7000-dd58-91e646cf3c59",
        "Request-Id": "fb7efea0-e024-7000-dd58-91e646cf3c59",
        "MS-CV": "oP5++yTgAHDdWJHmRs88WQ.0",
        "X-Frame-Options": "SAMEORIGIN,DENY",
        "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com engage.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
        "MicrosoftSharePointTeamServices": "16.0.0.24329",
        "X-Content-Type-Options": "nosniff,nosniff",
        "X-MS-InvokeApp": "1; RequireReadOnly",
        "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
        "X-AspNet-Version": "4.0.30319",
        "X-Powered-By": "ASP.NET",
        "x-ms-request-id": "fb7efea0-e024-7000-dd58-91e646cf3c59",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Thu, 04 Jan 2024 18:36:05 GMT",
        "Content-Type": "multipart/mixed; boundary=batchresponse_0b6f48bb-34a1-4266-b761-b1dbb153b0e0",
        "Expires": "Wed, 20 Dec 2023 18:36:06 GMT",
        "Last-Modified": "Thu, 04 Jan 2024 18:36:06 GMT",
        "Content-Disposition": "attachment",
        "Content-Length": "56"
    },
    "body": {
        "$content-type": "multipart/mixed; boundary=batchresponse_0b6f48bb-34a1-4266-b761-b1dbb153b0e0",
        "$content": "LS1iYXRjaHJlc3BvbnNlXzBiNmY0OGJiLTM0YTEtNDI2Ni1iNzYxLWIxZGJiMTUzYjBlMC0tDQo="
    }
}

Thank you for your help! 

[Expiscornovus]

Hi @NicPrad,

Have you double checked if your SP.Data.xxxxxxxxListItem value (ListItemEntityTypeFullName) is correct? And have you checked if the same POST HTTP requests work when you run them as individual HTTP requests?

[NicPrad]

Thank you for the reply. 

You were right, the ListItemEntityTypeFullName wasn't correct. 

However in the batch request I still get no result.

It actually worked for an individual request as you suggested. 

This code worked

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "HttpRequest"
    },
    "parameters": {
        "dataset": "https://XXXXXXXXXXXXXXXXXXX",
        "parameters/method": "POST",
        "parameters/uri": "_api/web/lists/GetByTitle('tbl_documentXXXX')/Items",
        "parameters/headers": {
            "Accept": "application/json;odata=verbose",
            "Content-Type": "application/json;odata=verbose"
        },
        "parameters/body": "{
"__metadata":{"type":"SP.Data.Tbl_x005f_documentXXXXXXXXXXXListItem"},
"Note":"Prova"
}"
    }
}

 This one didn't

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "HttpRequest"
    },
    "parameters": {
        "dataset": "https://xxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxx",
        "parameters/method": "POST",
        "parameters/uri": "_api/$batch",
        "parameters/headers": {
            "content-type": "multipart/mixed; boundary=batch_0632bd4a-c518-4041-9f5f-269970ad9cef"
        },
        "parameters/body": "--batch_0632bd4a-c518-4041-9f5f-269970ad9cef
Content-Type: multipart/mixed; boundary="changeset_cc9d3dba-0024-4aa6-a5a2-2620e00502ba"
Content-Transfer-Encoding: binary

--changeset_0632bd4a-c518-4041-9f5f-269970ad9cef
Content-Type: application/http
Content-Transfer-Encoding: binary
POST https://xxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxx/_api/web/lists/getByTitle('tbl_documenti_xxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose
{"__metadata":{"type":"SP.Data.Tbl_x005f_documentxxxxxxxxxxxxListItem"},"Note":" "}

--changeset_0632bd4a-c518-4041-9f5f-269970ad9cef
Content-Type: application/http
Content-Transfer-Encoding: binary
POST https://xxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxx/_api/web/lists/getByTitle('tbl_documenti_xxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose
{"__metadata":{"type":"SP.Data.Tbl_x005f_documentxxxxxxxxxxxxListItem"},"Note":" "}
--changeset_cc9d3dba-0024-4aa6-a5a2-2620e00502ba--
--batch_0632bd4a-c518-4041-9f5f-269970ad9cef--"
    }
}

[NicPrad]

I was a little confused because I read your name in the first page I found to create the single POST request, and I just found out it's really you 😂

[NicPrad]

I keep trying different variations copied from other users, but I get the same "No errors no results".

Here's the last one:

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "HttpRequest"
    },
    "parameters": {
        "dataset": "https://xxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxx",
        "parameters/method": "POST",
        "parameters/uri": "_api/$batch",
        "parameters/headers": {
            "content-type": "multipart/mixed; boundary=batch_7e8a1751-9cc1-4ca1-b26e-5401925b40a6"
        },
        "parameters/body": "--batch_7e8a1751-9cc1-4ca1-b26e-5401925b40a6
Content-Type: multipart/mixed; boundary="changeset_06c17b6b-e962-499c-bee5-85700439875f"
Host: https://xxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxx
Content-Transfer-Encoding: binary

--changeset_7e8a1751-9cc1-4ca1-b26e-5401925b40a6
Content-Type: application/http
Content-Transfer-Encoding: binary

POST https://xxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxx/_api/web/lists/getByTitle('tbl_documenti_xxxxxxxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{"__metadata":{"type":"SP.Data.Tbl_x005f_documenti_x005f_xxxxxxxxxxxxxxxxListItem"},"Note":"2024-01-02T23:00:00"}

--changeset_7e8a1751-9cc1-4ca1-b26e-5401925b40a6
Content-Type: application/http
Content-Transfer-Encoding: binary

POST https://xxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxx/_api/web/lists/getByTitle('tbl_documenti_xxxxxxxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{"__metadata":{"type":"SP.Data.Tbl_x005f_documenti_x005f_xxxxxxxxxxxxxxxxListItem"},"Note":"2024-01-02T23:00:00"}
--changeset_06c17b6b-e962-499c-bee5-85700439875f--

--batch_7e8a1751-9cc1-4ca1-b26e-5401925b40a6--"
    }
}

 and this result as usual:

{
    "statusCode": 200,
    "headers": {
        "Cache-Control": "no-store, max-age=0, private",
        "Transfer-Encoding": "chunked",
        "Vary": "Origin",
        "Set-Cookie": "ARRAffinity=196a83c309c56a708974ff3a9f8713c3f13758cf2adce06853fc42cdccdf5e4f;Path=/;HttpOnly;Secure;Domain=sharepointonline-ne.azconn-ne-003.p.azurewebsites.net,ARRAffinitySameSite=196a83c309c56a708974ff3a9f8713c3f13758cf2adce06853fc42cdccdf5e4f;Path=/;HttpOnly;SameSite=None;Secure;Domain=sharepointonline-ne.azconn-ne-003.p.azurewebsites.net",
        "Strict-Transport-Security": "max-age=31536000",
        "X-NetworkStatistics": "0,4194560,0,0,62150,0,21631",
        "X-SharePointHealthScore": "1",
        "X-SP-SERVERSTATE": "ReadOnly=0",
        "DATASERVICEVERSION": "3.0",
        "X-Download-Options": "noopen",
        "SPClientServiceRequestDuration": "11",
        "SPRequestDuration": "11",
        "X-DataBoundary": "EU",
        "X-1DSCollectorUrl": "https://eu-mobile.events.data.microsoft.com/OneCollector/1.0/",
        "X-AriaCollectorURL": "https://eu-mobile.events.data.microsoft.com/Collector/3.0",
        "SPRequestGuid": "42bcffa0-d0a2-7000-dd58-95c9379e9b93",
        "Request-Id": "42bcffa0-d0a2-7000-dd58-95c9379e9b93",
        "MS-CV": "oP+8QqLQAHDdWJXJN56bkw.0",
        "X-Frame-Options": "SAMEORIGIN,DENY",
        "Content-Security-Policy": "frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com engage.cloud.microsoft *.officeapps.live.com *.office.com *.microsoft365.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com onedrive.live.com *.onedrive.live.com securebroker.sharepointonline.com;",
        "MicrosoftSharePointTeamServices": "16.0.0.24406",
        "X-Content-Type-Options": "nosniff,nosniff",
        "X-MS-InvokeApp": "1; RequireReadOnly",
        "P3P": "CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"",
        "X-AspNet-Version": "4.0.30319",
        "X-Powered-By": "ASP.NET",
        "x-ms-request-id": "42bcffa0-d0a2-7000-dd58-95c9379e9b93",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "x-ms-apihub-obo": "false",
        "Date": "Mon, 08 Jan 2024 15:00:57 GMT",
        "Content-Type": "multipart/mixed; boundary=batchresponse_9a6da1bb-76fb-4775-82ae-60fb3d64a128",
        "Expires": "Sun, 24 Dec 2023 15:00:57 GMT",
        "Last-Modified": "Mon, 08 Jan 2024 15:00:57 GMT",
        "Content-Disposition": "attachment",
        "Content-Length": "56"
    },
    "body": {
        "$content-type": "multipart/mixed; boundary=batchresponse_9a6da1bb-76fb-4775-82ae-60fb3d64a128",
        "$content": "LS1iYXRjaHJlc3BvbnNlXzlhNmRhMWJiLTc2ZmItNDc3NS04MmFlLTYwZmIzZDY0YTEyOC0tDQo="
    }

[Expiscornovus]

Hi @NicPrad,

I see you are missing the X-RequestDigest in your headers. Can you try and add that one?

I have tried the below, which worked in my dev. Have a look at the body and compare. 

Headers

{
  "X-RequestDigest": "digest",
  "Content-Type": "multipart/mixed;boundary=batch_@{actions('Initialize_variable_-_ListName')?['trackedProperties']['batchGUID']}"
}

Body

--batch_@{actions('Initialize_variable_-_ListName')?['trackedProperties']['batchGUID']}
Content-Type: multipart/mixed; boundary="changeset_@{actions('Initialize_variable_-_ListName')?['trackedProperties']['changeSetGUID']}"
Content-Length: 
Content-Transfer-Encoding: binary

--changeset_@{actions('Initialize_variable_-_ListName')?['trackedProperties']['changeSetGUID']}
Content-Type: application/http
Content-Transfer-Encoding: binary

POST @{parameters('SPOSiteCollection_PowerUsers (exp_SPOSiteCollection_PowerUsers)')}/_api/web/lists/getbytitle('@{variables('ListName')}')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{
"__metadata": { "type": "SP.Data.Batch_x0020_ExampleListItem" },
"Note": "Power Automate"
}

--changeset_@{actions('Initialize_variable_-_ListName')?['trackedProperties']['changeSetGUID']}
Content-Type: application/http
Content-Transfer-Encoding: binary

POST @{parameters('SPOSiteCollection_PowerUsers (exp_SPOSiteCollection_PowerUsers)')}/_api/web/lists/getbytitle('@{variables('ListName')}')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{
"__metadata": { "type": "SP.Data.Batch_x0020_ExampleListItem" },
"Note": "Copilot Studio"
}
--changeset_@{actions('Initialize_variable_-_ListName')?['trackedProperties']['changeSetGUID']}--

--batch_@{actions('Initialize_variable_-_ListName')?['trackedProperties']['batchGUID']}--

[NicPrad]

Thank you as usual.
Unfortunately I still get no results 

[Expiscornovus]

Hi @NicPrad,

I cannot see because the body field in the inputs section is cropped in your screenshot. But what is the structure you are using?

Can you try and test the below instead to see if that makes a difference?

Headers

{
  "X-RequestDigest": "digest",
  "Content-Type": "multipart/mixed;boundary=batch_7e8a1751-9cc1-4ca1-b26e-5401925b40a6"
}

Body

--batch_7e8a1751-9cc1-4ca1-b26e-5401925b40a6
Content-Type: multipart/mixed; boundary="changeset_7e8a1751-9cc1-4ca1-b26e-5401925b40a6"
Content-Length: 
Content-Transfer-Encoding: binary

--changeset_7e8a1751-9cc1-4ca1-b26e-5401925b40a6
Content-Type: application/http
Content-Transfer-Encoding: binary

POST https://xxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxx/_api/web/lists/getbytitle('tbl_documenti_xxxxxxxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{
"__metadata": { "type": "SP.Data.Tbl_x005f_documenti_x005f_xxxxxxxxxxxxxxxxListItem" },
"Note": "Power Automate"
}

--changeset_7e8a1751-9cc1-4ca1-b26e-5401925b40a6
Content-Type: application/http
Content-Transfer-Encoding: binary

POST https://xxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxx/_api/web/lists/getbytitle('tbl_documenti_xxxxxxxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{
"__metadata": { "type": "SP.Data.Tbl_x005f_documenti_x005f_xxxxxxxxxxxxxxxxListItem" },
"Note": "Copilot Studio"
}
--changeset_7e8a1751-9cc1-4ca1-b26e-5401925b40a6--

--batch_7e8a1751-9cc1-4ca1-b26e-5401925b40a6--

[NicPrad]

Hi, thank you for your patience! Finally I got it!

It was the dumbest error ever.
I used the batch GUID value instead of that one for the opening  changeset boundary line. 

Now I've changed the header as you suggested and corrected the GUIDs and it works fine.

Thank you again. 

--batch_96ad12c0-83d0-412f-9246-593b1c5594c4
Content-Type: multipart/mixed; boundary="changeset_e996d221-fc8a-4137-92f9-8e4b6ac1ad65"
Content-Length: 794
Content-Transfer-Encoding: binary

--changeset_96ad12c0-83d0-412f-9246-593b1c5594c4
Content-Type: application/http
Content-Transfer-Encoding: binary

POST https://xxxxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxxx/_api/web/lists/getByTitle('tbl_documentixxxxxxxxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{"__metadata":{"type":"SP.Data.Tbl_x005f_documenti_x005fxxxxxxxxxxxxxxxxxListItem"},"Note":"2024-01-02T23:00:00"}

--changeset_96ad12c0-83d0-412f-9246-593b1c5594c4
Content-Type: application/http
Content-Transfer-Encoding: binary

POST https://xxxxxxxxxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxxxxxxxx/_api/web/lists/getByTitle('tbl_documentixxxxxxxxxxxxxxxxx')/items HTTP/1.1
Content-Type: application/json;odata=verbose

{"__metadata":{"type":"SP.Data.Tbl_x005f_documenti_x005fxxxxxxxxxxxxxxxxxListItem"},"Note":"2024-01-02T23:00:00"}
--changeset_e996d221-fc8a-4137-92f9-8e4b6ac1ad65--

--batch_96ad12c0-83d0-412f-9246-593b1c5594c4--