Hello SAP community,
This blog post is similar with this one, but here we will see how to achieve the solution specifically for the SAP SuccessFactors OData API.
All the images and data used here was taken from SalesDemo instance, so we are using dummy data.
With these steps you will be able to extract data from SAP SuccessFactors OData API doing queries in Microsoft Excel, fetching the data quickly to work directly in your spreadsheet.
This sample was built with the Microsoft Excel for Office 365 version 1908.
1. Open Excel, go to Data tab, click in From Web
2. We are going to use one SAP SuccessFactors OData query ready for one SalesDemo instance in the DC4.
This query is returning the results in the json format due the parameter &$format=json
Query = https://apisalesdemo4.successfactors.com:443/odata/v2/EmpJob?$top=10&$select=userId,company,costCenter&$format=json
If you are not familiar building OData queries, one good way is using the SAP SuccessFactors Integration center. More details in the KBA below (follow the steps 1 to 7):
2890064 – Using the integration center tool to export the OData query and helping with your OData upserts – SAP SuccessFactors HXM Suite
Another point that you need to
The post Using Microsoft Excel for doing queries in SAP SuccessFactors OData API appeared first on HR Tech Feed.