Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

JSON Parse Error

arakshe
5 - Atom

I am trying to call this API and when I parse using the JSON Parse tool, I get this error: JSON Parse (3): Error message: Invalid value. at character position: 0

Does anyone have any advice?

3 REPLIES 3
apathetichell
20 - Arcturus

Your error message is flagging something related to a doctype html in an html bracket  ---> what is this? is it a header above your json? Is it a second line of data/second api run (and perhaps an error or other message from your server)? Where is it in your file? Your json is fine.  

arakshe
5 - Atom

I found out it was an issue with the url. I am now trying to get the second api call working, however, after I use the Json parse tool again, I am getting nulls. Do you know why this is happening?

apathetichell
20 - Arcturus

hey --- so you probably don't need to recreate your auth twice (unless you have a second set of basic credentials for the second api call) ---> not 100% sure why you are seeing that - but I'd recommend two things 1) look in the download data before json parse tool ---> 2) see if you have two fields called download data (one from each download) --- and make sure you are looking in the right one. without seeing the download data -it's hard to tell. is response code 200? or 201?

Labels
Top Solution Authors