Batch request using web api

(0) Share

Report

Posted on by Balasaheb

700

Hi,

We used batch request of web api to retrieve records of multiple entities say suppose accounts and contacts using fetch xml.

We are able to get the response but response is as shown below. Now we need to parse this response and get the separate collection of record for accounts and contacts.

--batchresponse_a5ec534a-1906-4613-ab3c-304cc20c0c5e
Content-Type: application/http
Content-Transfer-Encoding: binary

HTTP/1.1 200 OK
Content-Type: application/json; odata.metadata=minimal
OData-Version: 4.0
Preference-Applied: odata.include-annotations="*"

{"@odata.context":""@Microsoft.Dynamics.CRM.totalrecordcount":-1,"@Microsoft.Dynamics.CRM.totalrecordcountlimitexceeded":false,"value":[{"@odata.etag":"W/\"3356018\"","fullname":"Della">uat54.crm.dynamics.com/.../$metadata Selestewa","contactid":"f4648fd7-e0ad-e911-a9ad-000d3a37fb92"},{"@odata.etag":"W/\"2159222\"","fullname":"Della Selestewa","contactid":"458f8747-d6a2-e911-a998-000d3a37fbce"}]}
--batchresponse_a5ec534a-1906-4613-ab3c-304cc20c0c5e
Content-Type: application/http
Content-Transfer-Encoding: binary

HTTP/1.1 200 OK
Content-Type: application/json; odata.metadata=minimal
OData-Version: 4.0
Preference-Applied: odata.include-annotations="*"

Is any one have solution how can we get separate collection of record for accounts and contacts by parsing above response.

Waiting for your reply.

Thanks!

Balasaheb

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

cloflyMao 25,210 on at

Like (1)

Report

Hi Partner,

Since the response is such a text, thus we should parse it manually with our own function.

My implementation's below:

I split the whole text into an array with "--batch" as separator, it will be split to 4 array item, our target contents are in item 1 and 2, so I select these items and push them into new array.

then I observe the actual data inside the batchresponse is between { and }. Hence I substring of the actual data using the function below.

value.substring(value.indexOf('{'),value.lastIndexOf('}')+1)

Result:

Notes:

I found there is escape character issues in @odata.context value and first contact fullname field Della">uat54,

so I modified these 2 places and the text can be parsed as an JSON object:

Perhaps it's a issue when posting text with many characters.

You could try execute my code in your environment to test whether it works.

Regards,

Clofly

Was this reply helpful? Yes No
Suggested answer

Balasaheb 700 on at

Like (0)

Report

Hi Clofly,

Thanks for your reply.

Thanks!

Was this reply helpful? Yes No
Verified answer

cloflyMao 25,210 on at

Like (0)

Report
Hi Partner,

Did the script work in your environment ?

And has your problem been solved successfully?

Please let me know if you have any other question. :)

Regards,

Clofly

Please mark as verified if the answer is helpful, it would be greatly appreciated.

Was this reply helpful? Yes No