Dynamic pulling mechanism from HTTP web service in SAP CPI

[barath_dv]

Thank you ahead of time!

Team, I need to get data from an HTTP web service using the GET technique.

Condition 1: The iFlow should only process the data once, and then it should not process the same input again. Condition 2: When new data is added to the HTTP webservice, CPI should process it as soon as possible.

When I use the scheduler,

For example, we keep it every Friday at 10 a.m. PST. In rare cases, the webservice team posts the updated file on Thursday owing to a Friday holiday. Here, CPI must process the new data in the same day, which is Thursday.

Please share your thoughts with me in order to achieve this dynamic pulling mechanism.

[yatanveersingh]

What is you target system

[barath_dv]

Target SAP S4

[daviddasilva]

Hi,

Do you have any effective start/end dates on the data that you are pulling? I think you will need at least a Created Date field in order to do this otherwise you will need to persist the data in the middleware which I do not think you want to do.

Assuming you have a created date field to work with, I would just set your GET query to pull records where created date is after a local variable (that you create in Cloud Integration to record the last date time when the iFlow was successful). Ensure that the variable is only updated upon successful completion of the iFlow.

Another approach could be to ensure you have the same Key data fields in both systems - this way, when you try to create again in S4, it won't let you because the key already exists in S4.

Kind regards,

David

[barath_dv]

Thanks for your insight 🙂

Can you help me on your first approach which is script based.