We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

JSON output as input trouble

hellyars
13 - Pulsar

I forgot how to input a JSON file.  I keep getting the error message: The document is empty at character position 0.  The file is not empty.  To add injury to insult, the file is the JSON output of another workflow.   So, what the heck am I forgetting?

 

 

3 REPLIES 3
grazitti_sapna
17 - Castor

Hi @hellyars, try setting your Code Page setting in the Input Data tool to UTF-8 as shown in the screenshot. I hope this will solve your problem.

 

json_setting.jpg

 

Sapna Gupta
hellyars
13 - Pulsar

I forgot about this step.  But, I still can't get the JSON Parse tool to do anything. After the Input tool, the field names were contained in one column and the values in a second.  Each filed name had a pseudo record ID in front of it (e.g. 01.name, 01.date; 02.name, 02.date...).  I then used a Cross Tab tool to transform the data with field names as the column names.  

 

 

 

 

 

grazitti_sapna
17 - Castor

@hellyars , When you imput a json file with format .json in input tool, I do not think you need a json parser unless you are using download tool to download data from an API in that case json parser might be required. I have attached a sample workflow for your understanding. I hope this helps!

 

Thanks.

grazitti_sapna_0-1591765717515.png

 

Sapna Gupta
Labels
Top Solution Authors