Skip to main content
Question

Pipeline Iterate over JSON nested data

  • July 28, 2022
  • 0 replies
  • 923 views

I was pulling in JSON data from Ground Control and was having some trouble pulling in some nested data while creating a record. Here is how I solved it. I hope I can save some people time.

Used the method posted here to get this started: JSON Handler details

 
Data initially pulled was not an issue at the top level.

Nested inside my data is "customFieldValues". 
Sample: 

        "customFieldValues": [
            {
                "name": "SomeFieldA",
                "value": "Abcdefg"
            },
            {
                "name": "SomeFieldB",
                "value": "1234567"
            },
            {
                "name": "SomeFieldC",
                "value": "CwhatIDidThere?"
            }
]


To pull in this value I needed to use a raw_record Jinja expression and state the location in the array.

{{b.raw_record['customFieldValues'][0]['value']}} 

0 is used since this is the first location in the Array.
(This assumes that b. is the reference used for the other fields such as {{b.status}} )
This is placed in the field reference in Create Record step for SomeFieldA.






------------------------------
James Carlos
------------------------------

Forum|alt.badge.img+11
HI James, 

Thanks for posting this , I was actually struggling with JSON yesterday . I had to give up .

Can you post more screenshots (specially the iteration of JSON records part) or post YAML of your pipeline (without sensitive parts)

------------------------------
Prashant Maheshwari
------------------------------

GeorgiPeev
Forum|alt.badge.img+4
  • Quickbase Staff
  • February 12, 2026

Hey folks, I published a blogpost yesterday on dealing with nested arrays/lists. Would be very grateful if you glance over it and check if I'm missing some corner cases.

Thank you!


GeorgiPeev
Forum|alt.badge.img+4
  • Quickbase Staff
  • August 25, 2026

As of today, these workaround are no longer needed!!!

Loops in pipelines can now handle nested lists :)