topic Re: Lookup Table add entry if doesn't exist in Workato Pros Discussion Board

Lookup Table add entry if doesn't exist

deepaks — Tue, 20 Aug 2024 16:55:41 GMT

Is there way to add entry to lookup table only if doesn't already exist (based on a specific column value?)

Came across a recipe which seems to be inefficient - it's looking a search for the value in lookup table, monitoring for error (entry not found error) and then adding/inserting.

Re: Lookup Table add entry if doesn't exist

gary1 — Tue, 20 Aug 2024 16:59:37 GMT

This should be possible. If you're receiving an error when the value is missing, you can use an error handler action to create the lookup table entry and then retry the action.

Re: Lookup Table add entry if doesn't exist

deepaks — Tue, 20 Aug 2024 17:06:28 GMT

That's exactly what is done, but I hoping for better way - for now what you described works. Thanks!!

Re: Lookup Table add entry if doesn't exist

gary1 — Tue, 20 Aug 2024 17:33:06 GMT

Just curious, what would you consider a better way?

Re: Lookup Table add entry if doesn't exist

mppowe — Wed, 21 Aug 2024 12:46:43 GMT

Maybe if it had an Upsert action?