Skip to Content
0

SDI OData query SuccessFactors and passing fromdate parameter

Sep 14, 2017 at 06:50 AM

244

avatar image
Former Member

I'm trying to query SuccessFactors from HANA SDI using OData connectors. To load historical data from SuccessFactors we need to pass some extra parameters like fromDate/toDate or asOfDate.
The URL would be like this:

successfactors.com/odata/v2/User?$filter=userId eq '12345'&fromDate=2017-01-01&toDate=2017-06-30

It works great using the browser adding these parameters in, but I am not able to find a way to get SDI to include these parameters in the request. Is that not possible? If it is not possible, how would we load historical data from SuccessFactors into HANA Cloud for reporting?

Thanks,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Dec 07, 2017 at 05:17 PM
0

Hi Josh,

I'm afraid I don't have the answer to your question but I'm trying to do exactly the same thing!

Did you by chance find a way to proceed in the meantime?

Thanks

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 08, 2017 at 12:40 PM
0

Hallo,

the problem is that the fields toDate and fromDate are not included in the $metadata and are therefore not part of the generated virtual table in HANA. These 2 fields have a special meaning . See

https://help.sap.com/viewer/b2b06831c2cb4d5facd1dfde49a7aab5/1708/en-US/b0d67f4df75041419059ae63e748571b.html

A possible solution is to route everything API Management either manipulate the returned $metadata or the request going to the SuccessFactors system. This is done using java script policies. More info about api mgmt here:

https://blogs.sap.com/2016/03/03/sap-api-management-overview-getting-started/

Here is a step by step tutorial for api mgmt. that consumes an ODATA service from an ABAP system but it should not be different than using a SF system.

https://www.sap.com/developer/tutorials/hcp-apim-enable-service.html

cheers Matthias

Share
10 |10000 characters needed characters left characters exceeded