Skip to Content
0
Jul 03, 2019 at 12:42 PM

How to update sender SFSF channel with Dynamic periodic delta date query without mapping .

125 Views Last edit Jul 12, 2019 at 08:22 AM 2 rev

Hi Friends,

Could you please help us with the below request:

We have a requirement where we need to run the effective/periodic delta date query dynamically from successfactor without doing any mapping (pass through ) Currently we are using the static Query where we are changing the date every time when we run the interface for the required information.

SELECT person, personal_information, address_information, employment_information, job_information, national_id_card, email_information FROM CompoundEmployee WHERE (last_modified_on > to_datetime('2019-07-01T01:00:00Z') AND fromDate = to_date('2019-07-05','yyyy-MM-dd') AND toDate = to_date('2019-07-09','yyyy-MM-dd'))

For this query, we will need to dynamically change the WHERE clause as follows

  • For this query, we will need to dynamically change the WHERE clause as follows
  • Last_modified_on > to_datetime(‘yyyy-mm-ddT01:00:00Z’) should be today minus 1. For example, today, 07/03/2019, we will enter the WHERE as “last_modified_on > to_datetime(‘2019-07-02T01:00:00Z’)”. Tomorrow, 07/04/2019, we will need to update the query parameter to be “last_modified_on > to_datetime(‘2019-07-03T01:00:00Z’)”.
  • fromDate = to_date(‘yyyy-mm-dd’,’yyyy-mm-dd’) should be today. For example, today we will send fromDate= to_date(‘2019-07-03,’yyyy-mm-dd’). Tomorrow we will send fromDate= to_date(‘2019-07-04,’yyyy-mm-dd’)
  • toDate= to_date(‘yyyy-mm-dd’,’yyyy-mm-dd’) should be today. For example, today we will send toDate= to_date(‘2019-07-03,’yyyy-mm-dd’). Tomorrow we will send toDate= to_date(‘2019-07-04,’yyyy-mm-dd’)

I have gone through the below blogs but didn't get the accurate result.

https://apps.support.sap.com/sap/support/knowledge/public/en/2528499

https://answers.sap.com/questions/68199/how-to-update-sender-sfsf-channel-with-dynamic-dat.html

Please help me if you have any suggestions.

Thank you.