Querying Nested Json in a Workflow

💬 Queries and Resources
1

Hello,

I'm having trouble querying nested json with sql in my workflow.

Here is an example of my api response

image
image1075×305 10.9 KB

Here are my results with sql

image
image1048×447 16.7 KB

How can I make it so the name and address in the from object are 2 separate columns?

Thank you!

2

Hey there @bahmed,

You can use a code block to manipulate the results of your query, e.g.

query1.data.map(item => ({
  ...item, // Spread existing properties
  emailName: item.emailAddress?.name || '', // Extract name
  emailAddress: item.emailAddress?.address || '' // Extract address
}))

Hope this makes sense!

3

Thank you! This is what I needed

1 Like