Following is a scenario that does not seem achievable in the current release of Mapping Designer.
- We maintain a job control table (a table that stores our delta ranges for different workflows) in an Oracle database
- When creating a Source in the IC Mapping Designer, we would like to dynamically set the Source's filter condition based upon a record present in the job control table.
- For example, if the Source is related to Salesforce and we are interested in sourcing recently updated Accounts, we'd like to dynamically set the SOQL statement to query the object for records where LastModifiedDate > the date present in the job control table
Is this achievable in IC? If not, is this on the near-term roadmap?
Note: this is above and beyond what the existing $LastRunDate / $LastRunTime data filters offer; I would like the ability to source my variables from outside of IC.