Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.
SOLVED

External Lookup - One level deeper on path?

Avatar

Community Advisor

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

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