Import JSON

sdemichelis

Hi all,

I am trying to import a large file in JSON format. I have attached here a sample. I have tried to use the Json Parse tool but I get mostly blank fields. Is there a way to import this into a table format?

Thank you all for your help and suggestions

Test.zip

grazitti_sapna

@sdemichelis, the format of your JSON file is incorrect when I try to run it as ".json" file format in Alteryx. Please refer to the screenshot below.

Then I checked this on JSON checker online and it showed me the exact error.

The issue is a [ is missing in the beginning and ] at the end and after each record, it should be followed by a comma separator, in your scenario is it not able to distinguish between the records that is why it just read the first record. Attaching the correct JSON file.

Now if you want to keep the same JSON format as per the original file then you can use the below workflow.

Workflow 1

Use the following configuration

Output

Workflow 2(with correct JSON format file)

Use the JSON file attached along

Please let us know if it works for you!

Thanks!

Test.zip

sdemichelis_workflow1.yxzp

sdemichelis_workflow2.yxzp