output field as json

[bighocho]

Could somebody direct me to the tool or approach to read json and output the entire json as a field to database.

Roughly,

myFile.json ->   file_name    |  file_value

                         -------------------------------

                         'myFile.json' | '{"foo": "bar", ...}'

I can only seem to find documentation that discusses flattening out the json rather than just simply passing the content through.

Thanks

[messi007]

Hello,

Please fin below how you can do it:

Below the file I used as example:

https://support.oneskyapp.com/hc/en-us/articles/208047697-JSON-sample-files 

Hope this helps,

Regards,

[christine_assaad · Accepted solution]

Hi @bighocho 

We do also have a "JSON Build" building block that could be found under "Laboratory".

This is the link to the help doc https://help.alteryx.com/current/designer/json-build-tool

Cheers!