Is there a way to pass a pipeline parameter to a child pipeline which has a SOQL, and use that parameter in the SOQL?
I am trying to output a date field from a parent pipeline and pass it into the SOQL which is a part of the child pipeline?
Appreciate your help. Thanks!
Here is sample of how to pass parameter to Salesforce SOQL snap. Unsure about your specific use case but likely you might not need to introduce a sub-pipeline.
Hope this help.
SFDC_User_Role_2019_03_16.slp (6.6 KB)
Thanks for your quick reply! How do i import/view the pipeline attached in your reply?
A bit more information on my usecase:
On a higher level, I am trying to compare a datetime within Salesforce Account object and a sql server database.
I am trying to compare the LastModifiedDate in Salesforce to the last time the pipeline ran in order to get the updated records within the last time-block.
Since I want visibility over my pipeline, I have a created a SQL Server database and I write a timestamp in it every time my parent pipeline runs. I want to pass that timestamp from my parent pipeline to my child pipeline. The child pipeline has a SOQL snap using which I am trying to compare both timestamps and get specific records.
To view his pipeline, you would need to download it from here and import it into your environment, preferably in a test area.
