Import data using Open Commerce API (OCAPI)

[shannoy_g10x]

Looking for suggestions to import real time orders data from demandware (Salesforce commerce cloud).

Leads on importing data using OCAPI (Open Commerce API) into Power BI.

Thanks in advance!

[v-yingjl · Accepted solution]

Hi @shannoy_g10x ,

You can use the Web connector to connect to Salesforce by OCAPI directly if it has the api key.

Please refer the official document: Getting started with OCAPI 20.8 

In addition, you can try to use Salesforce connector which is built in power bi desktop or try to use Rest API by the Web connector to connect to the data source.

Refer:

1. Salesforce Objects 
2. REST API Developer Guide 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.