Load CSV File to Common Data Service Entity

pooja jagtap 1 Reputation point
2020-11-11T18:39:19.567+00:00

Hi All,

Can anyone provide simple c# code for inserting data into CDS Custom Entity, along with connection configuration.
We need to load huge csv file into CDS, facing performance issues from make.powerapp.com, hence want to create custom c# code which can be added into azure function.

Thanks in advance.

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
3,086 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Mike Urnun 9,801 Reputation points Microsoft Employee
    2020-11-12T19:06:41.803+00:00

    @pooja jagtap You should still be able to the CDS Connector though. Could you elaborate on how huge the csv file is? CDS Connector has a throttling limit of 1000 requests per 60 seconds, are you hitting this limit and looking to overcome it with the custom code?


  2. pooja jagtap 1 Reputation point
    2020-11-19T08:52:44.727+00:00

    Hi Mike,

    we have huge data around 900,000 KB csv file, we need to process, which even if we break into smaller chunks is getting thorttled.
    Please suggest best way to import. This is one time activity.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.