Skip to main content
Solved

Extracting nested fields from JSON

  • November 3, 2025
  • 2 replies
  • 39 views

darrylh
Contributor
Forum|alt.badge.img+4

Hi

I have a a workflow exracting data from an API. I have got almsot everything I need from the JSON but need to get as single description field. The JSON structures breaks the description into sever parts all nested within the description part. The number of parts varies by feature.

I essentially need all the text elements in the image below

 

 

When I use a JSON exposer it asks me to specificy each indexed element, but I do not know how many there will be in any given feature

 

 

I imagine there is something really obvious I am missing here

Closest I have got is adding another JSON extractor using the query:

json["fields"]["description"]["content"][*]

 

is giving me:

{"type":"paragraph","content":[{"type":"text","text":"This Jira ticket is for all activities related to the implementation of 365 – "},{"type":"text","text":"Office.com","marks":[{"type":"link","attrs":{"href":"http://Office.com"}}]},{"type":"text","text":" rollout."}]}

Or using:

json["fields"]["description"]["content"][*]["content"][*]["text"]

 

is giving me each text entry in a new row

Best answer by frro

You’re almost there…

Try the JSONFragmenter, it works better for nested JSONS than the JSONExtractor

Dig into the nested structure with a JSON Query using the wildcard [*] - works multi levels.

Expose the desired attribute names and you’re all set.

 

2 replies

darrylh
Contributor
Forum|alt.badge.img+4
  • Author
  • Contributor
  • November 3, 2025

I think I have done what I need using the last method then concatenating using an aggregator.


frro
Contributor
Forum|alt.badge.img+17
  • Contributor
  • Best Answer
  • November 4, 2025

You’re almost there…

Try the JSONFragmenter, it works better for nested JSONS than the JSONExtractor

Dig into the nested structure with a JSON Query using the wildcard [*] - works multi levels.

Expose the desired attribute names and you’re all set.