Skip to Content
avatar image
Former Member

SFSF ODATA DELTA SYNC in SAP HCI

Hi ALL,

1)How to do the Delta Sync with SFSF odata in HCI . Please help me with this.

2) If i want to fetch data from User entity (either i can use the SF Soap or SFSF odata) but data will be same right . SF Soap or SF odata is the way that i am fetching the data but the entity same so no problem right.

Please clarify my doubts.

Thanks and Regards,

Vijay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • May 11, 2017 at 04:31 PM

    Hello Pradeep.

    Below might help.

    1) Model the operation and make sure these parameters are used $filter=${property.last_successfull_run} gt last_modified_on

    First run would be always with Current Date and time and later onwards you can store the last successfull run into Write Variable which needs to be set to property[ ${property.last_successfull_run} in the beginning of your iflow using content modifier.

    2) It depends on the Entity you want to query or data you want [like historical or future or field level changes ], as per SAP recommendation better to go with OData.

    And you can go through the standard contents( there are multiple Integration Project which have Delta with OData Entities ]

    Regards,

    Sriprasad Shivaram Bhat

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi sriprasad,

      if possible can you just put a screenshot of above filter and property which is set to ${property.last_successfull_run} and the connection between the content modifier and write variables

  • avatar image
    Former Member
    Jul 31, 2017 at 11:24 AM

    Hi Sriprasad,

    can you please help with the screen shot,

    Thanks and Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 04, 2018 at 04:14 PM

    Hi Sriprasad Shivaram Bhat ,

    How could we capture last successful run of Interface?

    Current Time stamp capture?

    Since in case of any technical exception the current run is not succesfull may not be the correct one right ?

    Best Regards,
    Suresh S

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 31 at 09:32 AM

    Hi Sriprasad,

    I have tried with the solution that you provided above, but it does not work.
    I am getting an error :

    {

    com.sap.gateway.core.ip.component.odata.exception.OsciException: Header/Property value not found for the parameter ${property.last_successfull_run}

    }

    I have created 'last_successfull_run' as a property with value "${property.last_successfull_run}", once in both Header & Exchange property tab of the Content modifier but i get the same error.

    Any help on this would be much appreciated.

    Thanks & Regards,

    Rishabh

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14 at 12:03 PM

    Hi Akash,

    I have figured out a way for this. Thanks :)

    For those who still need a clarification refer to the following:-

    1. Declare a local variable say 'abc' in the exchange property tab of a Content Modifier and name it as 'last_successfull_run'.

    2. Then create this 'last_successful_run' as an expression with value "${date:now:yyyy-MM-dd'T'hh:mm:ss}" under the same exchange property of that content modifier. This will let the iflow know that the value 'last_successful_run' is of type datetime and takes the current execution date and time of the process.

    3. Now choose write variable from the palette and declare this 'abc' variable as an expression with value "${property.last_successful_run}". This will save the current execution time of local variable 'abc'.

    To obtain delta/changed records you can compare the 'lastModified' field of any entity with '${property.last_successful_run}' by using the expression &$filter=lastModified gt datetime'${property.last_run}'.

    Thanks & regards,

    Rishabh

    Add comment
    10|10000 characters needed characters exceeded