Is it possible to use two lookup objects in a single automation?

Tim Kennett

Hi everyone, 

I'd like to lookup two values from different areas of a schema from our asset DB but I'm finding it difficult to figure out how to do this? 

Is this even possible? 

I can do it once but not twice as the second overrides the previous entry. 

I just want to put the two values into an email. 

I'm sure theirs a better way of doing this. 

Bill Sheboy

Hi @Tim Kennett 

First, a disclaimer: I am not currently using assets and so cannot test this suggestion, although it definitely works with Lookup Issues...

The Create Lookup Table action can preserve the typing / structure of smart value objects (unlike the Create Variable action which always produces text).

And so try this:

• action: Lookup Objects
• action Create Lookup Table
  • name: varFirstLookup
  • row
    • key: first
    • value: {{lookupObjects}}
• action: Lookup Objects, with different criteria...
• something that needs both
  • use {{varFirstLookup.get("first")}} to access the first one
  • use {{lookupObjects}} for the second one

 

Kind regards,
Bill