Dynamics Community Forum Thread Details

Problem with WEB API bulk operation

Hi EveryOne

I'm using VBA to transfer(get&update) data from DCRM in Excel.

I used WEB API to implement the operation and want to use batch in update operation.

I refered some links about batch request(need boundary...etc)

After finish my code,it doesn't work.

I use fiddler to check the response,some error message like below

HTTP/1.1 400 Bad Request

"Message":"The request line 'POST serviceUri/api/data/v8.1/tasks HTTP/1.1 ' is invalid. The request line at the start of each operation must be of the format 'HttpMethod RequestUrl HttpVersion'.

But I think i have set the request as the format request.

By the way,my envirment is Windows10 64bit,Office 365 64bit(I know a lot of 64bit problem about the vba)

Request COntent

--batch_AAA123
Content-Type: multipart/mixed;boundary=changeset_BBB456

--changeset_BBB456
Content-Type: application/http
Content-Transfer-Encoding:binary
Content-ID: 1

POST serviceUri/tasks HTTP/1.1
Content-Type: application/json;type=entry
{"subject":"Task 2 in batch"}
--changeset_BBB456
Content-Type: application/http
Content-Transfer-Encoding:binary
Content-ID: 2

POST serviceUri/tasks HTTP/1.1
Content-Type: application/json;type=entry
{"subject":"Task 2 in batch"}
--changeset_BBB456--
--batch_AAA123--

Quick Links