Post Requests

@alteryxkev That makes more sense with the layout. You'd use similar steps and end up with a row of JSON for each record. Then you would concatenate using a summarize tool and add the square brackets there. After that a formula tool can be used to append the 'items' portion.

How's something like this?

CSVtoJSONv2.yxmd

All comments

Can you confirm your desired format is correct? I don't see any closing square bracket. I think you'll also run into trouble in the 'balance' field since the desired format requires a numeric value but you are passing a string. I also see that mobile/email are supposed to be under address but you don't seem to have it setup for that, which is correct?

Hi @Luke_C,

Oversight from my side, updated file attached.

desiredJSONformat.docx

This should do the trick, but if you're trying to process multiple records, which is what I suspect from this format, it may require some tweaking. Also cleaned up the giant if statement into a mapping table and addressed the data type item I noted.

CSVtoJSON.yxmd

@Luke_C that has sorted that issue out data looks good, thank you! Since you've mentioned multiples, this is what I'm planning next........

Customer Dummy Data.csv

@Luke_C you've really helped me out here, thank you so much!

No problem, give it a shot and if you get stuck post an updated workflow. Creating JSON can be tricky

Hi @Luke_C, really sorry to trouble you again, I feel like I'm getting nowhere fast, if you could have a look at what I'm attempting I'd really appreciate it.

CSVtoJSONv2.yxmd

How's something like this?

CSVtoJSONv2.yxmd

You sir, are a prince among men!