Transform Json file into CSV in the Data Flow using ION Scripting

Jayson Joaquin

Hi,

We have a Data Flow wherein the output is Json file and being sent to an FTP. However, we would like to know the steps how we can convert/transform a Json file into CSV output before we drop it to FTP. Please see the Data Flow setup below:

May we know how can we use the Scripting in order for the JSON file to be transformed into CSV file before sending it to FTP?

Please see sample JSON File from the MRM application that needs to be converted/transformed into CSV before sending to FTP

SmartStream_PO.json.txt

Brandon Watson

import json

import csv

import io

data = json.loads(input_var_1)

output = io.StringIO()

writer = csv.DictWriter(output, fieldnames=data.keys())

writer.writeheader()

writer.writerow(data)

output_var_1 = output.getvalue()

output.close()

Should be straightfoward. Something like the above should work to conver a json to csv. You may have needs to format the fields specifically, but hopefully this gets you started.