C4C Data Extraction

[former_member590530]

Dear Experts,

Im trying to find a way to extract Business Partner Details and Calendar to Excel is this possible? if yes, can please have guidance on how I can go about this.

Thank you!

[SCHNEIDERT]

Hi eecruz,

in Sales Cloud you go to "Administrator > OData Service Explorer". Here you can select the SAP OData Service, for example "c4codataapi".

In the upper right you can then choose between "View" or "Test".

Test opens the OData Console where you can then search for the Entity you need (e.g. Corporate Account) and see the Entity Details and directly test the API.

In Excel you can then use the OData Adapter under the "Data" tab like that:

In the pop-up window you can paste the URL shown in the screenshot before.

I think this is the easiest way to extract your data directly to Excel.

BR Tobias

[former_member590530]

Hello Tobias, not sure on how to proceed after following the steps you mentioned above. I am now getting this error.

[former_member590530]

see image above

[SCHNEIDERT]

Hi eecruz,

I just tried with our system and it works fine. Did you choose the "Standard" Authentication or does the error occur already one step before? Did you try in the OData Console in Sales Cloud?

One thing to add: You should make sure that your tenant ID is masked when providing screenshots.

BR Tobias

[former_member590530]

Dear schneidert ,

Unfortunately i do not get that option to choose standard option. as i would already get an error after inputing the url into the pop-up window.

[SCHNEIDERT]

eecruz that's really strange. I tried even with your tenant ID and I get to that second step. So make sure that there are no typing errors or something like that.

[arun02_12]

Dear eecruz,

You can use the master "Business Partner Master Data"
Data source for Business partners.
You can also export from Data workbench or the Business partner work center export option.

For Calendar, there is no explicit export option.
You can filter out the Activities using the "All Activities" data source using the Calendar date or calendar year .


Best Regards,

Arun

[former_member590530]

Dear Arun, i cant seem to find my Business partner workcenter. do you have a detailed step by step instructions on how to do this extraction?

Thanks a lot

[arun02_12]

HI Emmanuel,

The Work center might not have been assigned to your business role.
Kindly check that and refer the below screen capture for the export option

[arun02_12]

Hi Emmanuel Cruz ,

Click on the zipped File in the File name column.

You will get the Where to Save pop up.

Best Regards,

Arun