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

[JayMappus]

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

  }

}

[ahanumantharaya · Accepted solution]

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.