How to Parse JSON Data into Individual Rows for Enrichment

Kierin F. · 2024-09-29T01:30:16.069715+00:00

I have JSON data that looks like this. How can I parse each out into its own individual row for further enriching?

APP

·

💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

Tomi F.

·

Hello Kierin! Do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1727626500&signature=06474263f5cc6a45c69d6a6f5987531bc9d5901f48352bae0017242c434088f0&req=dSEgF85%2FmohWX%2FMW1HO4zYTywCz6BJET2BKsam%2FhVPv6eg%3D%3D%0A Without looking at the specific table, I think you should be able to put that JSON (if you have it in a chatgpt enrichment for example) into a write to table enrichment and it should pick up the list and write each element to a different row in a separate table. This is what I mean: https://downloads.intercomcdn.com/i/o/1197562977/a24cac8da0dd3254f4fd619c/CleanShot+2024-09-29+at+11_50_23%402x.png?expires=1727626500&signature=604ff195fcd77dccc8c18c9380ad143d1f8ff225d99a5b423a6bbe0355ff7f43&req=dSEuEcx4n4hYXvMW1HO4zc8%2BKzvCp6e6C2Syf%2FkOJNo2xZPn33q0BXcjL8sU%0ARjan%0A

Kierin F.

·

Nice that helped a lot. Thank you!

Channeled

APP

·

Hi Kierin F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

4 comments