cancel
Showing results for 
Search instead for 
Did you mean: 

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

JayMappus
Deputy Chef III
Deputy Chef III

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

J

------- 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

  }

}

1 ACCEPTED SOLUTION

ahanumantharaya
Deputy Chef III
Deputy Chef III

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. 

View solution in original post

1 REPLY 1

ahanumantharaya
Deputy Chef III
Deputy Chef III

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.