Export Data but extract a value from a JSON column

(1) Share

Report

Posted on by CCEP_Mike

219

Hello,

I'm creating a flow which will create a file with a list of records, but within one of the columns it contains JSON which looks like the below:

{"fullname":"MY NAME","internalemailaddress":"my@email.com","systemuserid":"cd382fc9-6e30-XXXX-XXXX-XXXXXXXXXXXX"}

What I'd like to do is instead it writing the full JSON of each record, I'd like it to instead only displays the value of "internalemailaddress" for each record. I'm struggling to figure out how to do this, your help would be much appreciated.

Below is the simple flow i have so far:

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (1)

Answers (0)

Michael E. Gernaey 53,963 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi,

Its a big hard because you aren't sharing what the actual overall JSON looks like.

Also, you do not clearly explain the following

So this JSON above is a Value or a property of the overall JSON???

And instead of you having { XXXXX} as the VALUE for that property, you want it to just be

"myemail.com" correct?

plus you show as if you want to create a CSV, but nothing explained here or shared, makes that make sense to me. please share more of the data.

And please write up a Fake (complete JSON) and how you plan to turn that into a CSV??

THen I can definitley help you fix it up.

Was this reply helpful? Yes No