web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Answered

Fast injection of 3000 records into entity via API

(0) ShareShare
ReportReport
Posted on by 30

I have a requirement to be able to inject relatively fast 3000+ records to a custom entity.

Doing it the classic way via API will throttle me at 600 calls per 5 minutes which is unacceptable speed.

I could do the Batch request, but for some reason in my instance this does not seem to work. Can somebody share working example - for instance which creates 2 entries to account entity?

I have the following batch:

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

POST xxx.crm4.dynamics.com/.../accounts HTTP/1.1
Content-Type: application/json;type=entry
{"name":"test5"}

POST xxx.crm4.dynamics.com/.../accounts HTTP/1.1
Content-Type: application/json;type=entry
{"name":"test6"}

--batch_WKQS9Yui9r--

In the response I am getting just one line:

--batchresponse_d7a92030-f185-4f8a-beea-9b82333805ee--

No records are created. Any Ideas?

I have the same question (0)
  • Suggested answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi matnikr2021,

    Is Web API the only option? Can we do it through the Organization service?

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • matnikr2021 Profile Picture
    30 on at

    I would not like to go for solutions which are on the deprecation path.....

  • Suggested answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi matnikr2021,

    I am not able to find any news about its deprecation. Here is the documentation: What is the Organization service - Power Apps | Microsoft Learn. Please hep me to find it.

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

  • Verified answer
    Bipin D365 Profile Picture
    28,983 Moderator on at

    Hi,

    Your syntax seems to be wrong for batch request.

    Please see below example

    learn.microsoft.com/.../execute-batch-operations-using-web-api

  • Suggested answer
    matnikr2021 Profile Picture
    30 on at

    Yes. It seems so. Finally been able to get it right:

    --batch_04fb0926-918b-4fbb-aadc-4105e4e02803

    Content-Type: application/http

    Content-Transfer-Encoding: binary

    POST /api/data/v9.2/accounts HTTP/1.1

    Content-Type: application/json; type=entry

    {

     "name": "account 1"

    }

    --batch_04fb0926-918b-4fbb-aadc-4105e4e02803

    Content-Type: application/http

    Content-Transfer-Encoding: binary

    POST /api/data/v9.2/accounts HTTP/1.1

    Content-Type: application/json; type=entry

    {

     "name": "account 2"

    }

    --batch_04fb0926-918b-4fbb-aadc-4105e4e02803--

    One has to also remember that there has to be the right ID of boundary in call header - the same as in body:

    Content-Type: multipart/mixed; boundary="batch_04fb0926-918b-4fbb-aadc-4105e4e02803"

  • matnikr2021 Profile Picture
    30 on at

    You are right. There was only text about depreciated endpoint... Nevertheless I was looking for solution not requiring .net development. In my stack I use Azure Functions Node.js - therefore need to stick to API. If I need to call the endpoint from D365 I use Kaskela Workflow Elements.

  • Suggested answer
    Abdul Wahab Profile Picture
    12,119 Moderator on at

    Hi matnikr2021 .

    Here are details from Microsoft: Execute batch operations using the Web API (Microsoft Dataverse) - Power Apps | Microsoft Learn

    If I answer your question then please mark it as verified.

    Let me know if I can provide you with more details.

    Thanks
    Regards,

    Abdul Wahab
    Power Platform & Customer Engagement Developer/Lead/Solution Architecture/Project Manager
    Direct/WhatsApp:+923323281237
    E-mail: abdulwahabubit@outlook.com
    Skype: abdul.wahabubit
    Linkedin: www.linkedin.com/.../

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Pallavi Phade Profile Picture

Pallavi Phade 98

#2
Tom_Gioielli Profile Picture

Tom_Gioielli 60 Super User 2025 Season 2

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 43 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans