JSON parse tool gives error message, null columns returned

[Roche]

Hi everyone,

I am having trouble parsing using the JSON parse tool since there is a conversion error.  Would appreciate your help. 

The error message is as follows:

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

The flow is attached.

Thank you for helping

Rouche

[Luke_C · Accepted solution]

Hi @Roche 

The download tool appears to be returning the HTML of the page. This is not JSON. You would need to parse the HTML to get the table info. This weekly challenge might be helpful:

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-13-HTML-Table-Parsing/td-p/36741

[Roche]

Hi @Luke_C , thank you for informing me about that.  I am still very new to Java and HTML.  Sorry, accidently accepted my question as the answer😄