CRUD operation with Multiple records in ODATA

(3) Share

Report

Posted on by CU10121822-0

306

Dear team,

Is it possible to perform CRUD operation in entity for multiple records through ODATA?

Please give me the thoughts. thanks!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

Martin Dráb 239,647 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Yes, OData supports it by allowing you to group multiple operations in a single HTTP request. Here is a link to the relevant part of OData documentation.

Was this reply helpful? Yes No
CU10121822-0 306 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin, for the reply...

I searched in google as well. I have found like

In D365FO, OData indeed supports grouping multiple operations into a single HTTP request through a feature called batch requests.

Batch requests allow us to combine multiple queries and CUD (create, update, delete) operations into one request to the D365FO OData endpoint. This is achieved by sending a single POST request to the main OData endpoint (/data/$batch) with a specific multipart/mixed payload that delineates the individual operations .

for example -

POST .../data/$batch HTTP/1.1
Content-Type: multipart/mixed; boundary=batch_boundary

--batch_boundary
Content-Type: application/http
Content-Transfer-Encoding: binary

POST .../data/Customers V1 HTTP/1.1
Content-Type: application/json
Accept: application/json
Prefer: return=representation

{ "CustomerAccount": "CUST001", "Name": "New Customer" }

--batch_boundary
Content-Type: application/http
Content-Transfer-Encoding: binary

POST .../data/SalesOrderHeaders V1 HTTP/1.1
Content-Type: application/json
Accept: application/json
Prefer: return=representation

{ "CustomerAccount": "CUST001", "dataAreaId": "usmf", "DeliveryDate": "2026-01-01" }

--batch_boundary--

Is it something I need to write code for multiple records operation in ODATA? Am I correct?

Was this reply helpful? Yes No
Martin Dráb 239,647 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You need to make the HTTP request. You don't have to do it from code - for example, you can write it in Postman.

But if you want to do it in code, they you obviously need to create the code doing so. You can create the raw HTTP request on your own, but you can utilize various OData libraries.

Was this reply helpful? Yes No
CU10121822-0 306 on at

Like (0)

Report
Copy link

Link copied!

Okay Martin, could you please give me an example with Postman with multiple records in https call . Sorry, not understand how to start with.

Kindly give me an example , will follow it.

thanks!

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,647 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

You've posted an example above.

Here is another one with a screenshot of Postman: Sending batch request in postman using Data entities in Dynamics 365 for finance and operations.

Was this reply helpful? Yes No
CU10121822-0 306 on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin,

Was this reply helpful? Yes No