Pipeline expression building
Hi
In Database i have field called “Product_ID” i need to update the field with ‘P-00001’ when i execute the first time and Second time when i execute the field should be updated with ‘P-00002’ ple...
Forum Discussion
@swatifunde - Here is an example that calls a triggered task until a desired result is returned. I’ve also attached the pipeline that it is calling so you can correlate the query results with the Has Next property in the REST Get.
Community 13497 - Child - Query Snowflake Table_2022_09_28.slp (2.7 KB)
Community 13497 - Poll Snowflake Table_2022_09_28.slp (6.6 KB)
Please note that calling a triggered task on an extremely frequent schedule will create a large amount of noise in your Dashboard. It is possible you may also experience some occasional failures calling the task due to network traffic. If your org has Ultra Tasks enabled, this would resolve the additional traffic in Dashboard and has excellent response since it avoids instantiating a new pipeline with each call.
I tried to implement this solution but somehow I am getting below error
