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?
Solved! Go to Solution.
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.
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.
@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.