cancel
Showing results for 
Search instead for 
Did you mean: 

Scheduled Dataflow with Custom Connector OR Standard Web API incl. API Key / OAuth2.0 Authentification

Hi!

 

Like already asked for here: https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Dataflows-Authentication-using-API-...

I would like to be able to push some big data via Rest API (json) into my Common Data Service. I'm already able to do that with Power Automate, but here I just can do it for each record via slowly "Apply to each" loop (think about running time with over 10000 records..) and without nice Power Query options.

 

So I can image there some different options:

 

- Power Automate Flow: Flexible triggered REST APi with "Upload JSON records" CDS Action incl. Power Query ETF process

- Dataflow Web API with API Key / OAUTH2.0 Authentification

- Dataflow Custom Connection Option

 

BR,

Sven

Status: New