I am brand new to Alteryx and am trying to prove out a particular Use Case. I want to Source a JSON file, which includes a couple of nested objects, and ultimately store the data in tabular form in an Azure SQL DB.
Using an Input Data component, I connect to a sample JSON file. However, I don't know what to do next! I connect a JSON Parse component, which sort of seems to work. The JSON_Name Input flag shows my data, but everything is prefixed with "0.", meaning I see 0.id, 0.key, etc.
Running the Workflow returns 2 error messages on every field:
Invalid value at character position: 0
The document root must not be followed by other values, at character position: 1
I have attached the .json file I am working with and hope someone can help me figure this out.
Thank you!
