Lookup action "Lookup Tables by Workato" seems to change value

JayMappus — Thu, 07 Sep 2023 20:41:44 GMT

Hi,

I'm using the app? "Lookup Tables by Workato" and it seems to change the input value "incident_state" from null to "TX" on the output. Any ideas why or what I can do from preventing this? By doing so it's pulling back the wrong contract_template_ID - what I'm looking for . It's set to "Lookup" not "Search" if that matters. Inputs and outputs are below. The previous lookup did use "TX". Do I need to clear that value somehow?

Thanks in advance

------- Test Run Input -------

{

Lookup table: "2000xx",

Lookup by: {

case_type: "Personal Injury",

incident_state: null,

lead_source: null

}

--------- Test Run Output -----

{

key: Personal InjuryTX,

contract_template_ID: daf229dbc9a7412eb0ea64f9de1c167xxxxxx,

case_type: "Personal Injury",

incident_state: "TX",

lead-source: null

}

Re: Lookup action "Lookup Tables by Workato" seems to change value

ahanumantharaya — Mon, 11 Sep 2023 23:05:42 GMT

Seems to be cache issue. Delete the lookup action and re-create it or create a new recipe and add new lookup action.
Hope that resolve the issue.

topic Lookup action "Lookup Tables by Workato" seems to change value in Workato Pros Discussion Board

Lookup action "Lookup Tables by Workato" seems to change value

Re: Lookup action "Lookup Tables by Workato" seems to change value