External Lookup - One level deeper on path? | Community
Skip to main content
Daniel_Clarke
Community Advisor
Community Advisor
January 27, 2025
Solved

External Lookup - One level deeper on path?

  • January 27, 2025
  • 1 reply
  • 428 views

Utilizing an external lookup field and was previously pulling in the name of a task... easy enough. Now I need to grab a custom field from that task but the formatting for it is escaping me. I have tried a variety of formats without success, even looking at a fusion output bundle to validate the jump down to the parameterValues level. Thanks in advance for anyone who has already done this!

Best answer by Daniel_Clarke

Digging into Experience League I found the answer!  Thanks to @katherinela for writing such a succinct post on the external lookup field and including a link to the https://jsonpathfinder.com/ which saved the day!

 

This ended up being the correct path to access one level deeper... not the standard dot format I expected!
$.data[*].parameterValues["DE:Custom Value Here"]

1 reply

Daniel_Clarke
Community Advisor
Daniel_ClarkeCommunity AdvisorAuthorAccepted solution
Community Advisor
January 27, 2025

Digging into Experience League I found the answer!  Thanks to @katherinela for writing such a succinct post on the external lookup field and including a link to the https://jsonpathfinder.com/ which saved the day!

 

This ended up being the correct path to access one level deeper... not the standard dot format I expected!
$.data[*].parameterValues["DE:Custom Value Here"]