Reading a JSON File using Input Tool

[Abishai]

Hi,

I was trying to read a JSON (.JSON) file using the Input Data Tool.

However, when i ran the workflow, no data is coming up. Could anyone help me.

[alexnajm]

Can you show us this behavior?

[Abishai]

[alexnajm · Accepted solution]

It says right there in the warning - the file is empty in its current state. Either select another file to try or change the code page in the options of the Input Data tool to get it to work. Or play around with any of the other settings there

resource: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/JSON-output-as-input-trouble/t...

[apathetichell]

My experience here is that the input data tool/JSON format do not play nicely together --- so do this instead. Bring in your JSON file as csv with \0 (no delimeter) --> expand your field size to some insane but not larger than a max vwstring size (ie use 200000 or something)... Once you have inputted this -> use a summarize tool to concatenate (\n is fine) -> use JSON parse tool. The parse tool works quite well -> so once you've reassembled your JSON as a single field/row - you'll be fine.

[apathetichell · Accepted solution]

One more thing -> I am 95% sure that your Json encoding is incorrect -> it should be UTF-8.  TBH -> this is some silliness on the Alteryx developer end. I don't think I've ever seen an Ansi formatted Json.