Skip to Content
avatar image
Former Member

SDI OData query SuccessFactors and passing fromdate parameter

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 08, 2017 at 12:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded