JSON -- Error at Character 0

Hello --

I've read every post with this error, but nothing seems to hit the nail on the head. I am trying to download and parse the data from this site: https://d1za7xib05bz10.cloudfront.net/taxdata.json.

Downloading is no problem, but when I try to parse using the JSON Parse tool -- I get the below error:

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

Any advice would be most welcome.

Thanks,

Seth

Developer Tools

API

Accepted answers

fmvizcaino

Hi @smoskowitz ,

I'm not sure what is really going on, maybe it is related to the encoding. I was able to interpret once by erasing and replacing the '{' and '}' so maybe that is something due to it.

Since I was not able to identify the real problem, I've created a workaround.

You need to run the workflow once to generate the file used in the dynamic input tool, then run once again and it should work.

Best,

Fernando Vizcaino

2021-03-17 JSON -- Error at Character 0.yxmd

All comments

fmvizcaino

Hi @smoskowitz ,

I'm not sure what is really going on, maybe it is related to the encoding. I was able to interpret once by erasing and replacing the '{' and '}' so maybe that is something due to it.

Since I was not able to identify the real problem, I've created a workaround.

You need to run the workflow once to generate the file used in the dynamic input tool, then run once again and it should work.

Best,

Fernando Vizcaino

2021-03-17 JSON -- Error at Character 0.yxmd

smoskowitz

This is great @fmvizcaino! Thank you for your help!

kathryn_l

Can you kindly post the template file? having the same problem but not sure how-to setup the data source template. Thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703