Forum Discussion

Qrew Trainee

2 years ago

Parse JSON field value in Pipelines based on another field value from the object

Hi All, I'm trying to parse a specific value from the JSON. I'm trying to get the value of the "display_value" where the object's GID is equal to "1205664665921946". I need to get it based on the G...

Frontman

Qrew Trainee

The filter doesn't seem to do anything based on my testing, so it's the same result in the activity log either way.

@Jim Harrison - do you have an example you can share? Maybe a screenshot of the flow in Pipelines or the Jinja code?

I've tried tons of different methods but can't find a solution.

Looping through each custom field using the Loop step, then using if conditions in Jinja to get the value when the gid matches a certain value. Result: No value returned.
Looping through each custom field using Jinja (see code in my orig post). Result: No value returned.

------------------------------
Frontman
------------------------------

ChayceDuncan

Qrew Captain

2 years ago

Have you removed the limit of 1 in the JSON handler? Your path looks like the JSON loop should be iterating correctly - setting it to a limit of 1 though stands out. I've never used that as I've never had a reason to limit the JSON response.

------------------------------
Chayce Duncan
------------------------------