Using Microsoft Excel for doing queries in SAP SuccessFactors OData API

Using Microsoft Excel for doing queries in SAP SuccessFactors OData API

This post was originally published on this site


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.

Use case:

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.

Steps required:

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

Read Complete Article

The post Using Microsoft Excel for doing queries in SAP SuccessFactors OData API appeared first on HR Tech Feed.