Solved: Import data using Open Commerce API (OCAPI)

shannoy_g10x · ‎06-25-2021

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 · ‎06-27-2021

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:

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.

View solution in original post

v-yingjl · ‎06-27-2021

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:

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.