output field as json

Question

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

Christine_Assaad · Accepted Answer

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!