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

Palo Alto parse.yxmd

Luke_C

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