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

[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