Parsing Error

[DarynCarruthers]

Hello

I am trying to create a table from JSON  i got from calling an API but the problem is that when i use JSON parse Tool  , I got his error

ConvError: JSON Parse (6): Error message: Invalid value. at character position: 0

Is there anyway to get this output

I have attached my workflow 

[grossal · Accepted solution]

Hi @DarynCarruthers,

you were pretty close to the answer! Tick the "To a Field - String" option in the Download tool and change the column.

And update the JSON Parse to the new column:

Your new output looks very promising:

I have attached your updated workflow. Let me know if this solves your problem.

Best

Alex

[Jonathan-Sherman · Accepted solution]

Hi @DarynCarruthers,

You want to select "String" in the "To a Field" section in order to pull the JSON which you are then parsing correctly:

Also ensure your JSON parse is looking at your DownloadData field:

Output after the change:

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[DarynCarruthers]

Hello @grossal, 

Thank you for your quick response on this, that is awesome. I am new to Alteryx and want to dive right in, thank you for your guidance it is much appreciated.

[grossal]

You are welcome! And also welcome to the forum!

Would you mind accepting the post as a solution if it helped? People can find accepted solutions much quicker 😃

[DarynCarruthers]

Hey @Jonathan-Sherman,

Thank you for your response to this, this also helped fix my issue. I love getting multiple perspectives on how to solve so that I will know different ways to approach issues.

Thank you