JSON Parse error debugging
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Alteryxuserhere
8 - Asteroid
‎01-04-2024
06:08 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Labels:
- Labels:
- Tips and Tricks
1 REPLY 1
15 - Aurora
‎01-05-2024
03:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
