JSON Parse error debugging

Alteryxuserhere

Hi All

For the JSON Parse tool, is there an easy way to find out which specific row in the data that is is having trouble with? I can identify the potential issue in the results window but I don't know which specific row is causing the issue.

Thanks in advance

Screenshot 2024-01-05 130423.png

OllieClarke

Hi @Alteryxuserhere 

The screenshot tells you which record is 'bad' - you have a row which has a value of "/" (hence "parse error in record /") - you can search your results window, or filter it to find the exact record.
Here's a screenshot which might make things a bit clearer.

Hope that helps,

Ollie