Great!
You can create a lookup table from RIH UI and provide name and respective columns. Have key, value kind so that you can make use of same lookup table for multiple recipes.
Now from a new recipe search for lookup table and search for the key and get the value.
Finally, after the recipe is complete update the same entry with entry id from initial action.
Checkout the workato docs on lookup table: https://docs.workato.com/features/lookup-tables.html#actions
------------------------------
Sheshadri V
Fresh Gravity
------------------------------
Original Message:
Sent: 06-16-2023 12:04
From: Susan Ribe
Subject: Find most recent update date by source in RIH
Yes this is what I want to do. How to create a lookup table, and keep it updated with last successful job run?
------------------------------
Susan Ribe
CleanChoice Energy
------------------------------
Original Message:
Sent: 06-16-2023 11:53
From: Sheshadri V
Subject: Find most recent update date by source in RIH
Hi Susan,
If i understand correctly, you want to get the date time of last successful job.
To achieve this you can create a lookup table in RIH and whenever the job starts have a variable with current time. If the job is successful have the date time updated to lookup table and next time retrieve the same date time from lookup and for some reason if the job fails do not update in lookup table. So that the date time in lookup table reflects last successful job run date time.
Update us if the requirement is different.
I forgot to mention that RIH in fact has the field now
Which you can make use of
------------------------------
Sheshadri V
Fresh Gravity