Forum Discussion

shannoy_g10x's avatar
shannoy_g10x
Frequent Visitor
5 years ago
Solved

Import data using Open Commerce API (OCAPI)

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!
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    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.

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

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.