Troubleshoot corrupted JSON metadata

Topic

Sometimes we face issues when some data is corrupted after the migration process, for example when the triggers data is migrated to triggers.TriggerInstances table.

Then you might see the following error in the Console:
 

Instructions 

Here is a simple trick how to find which row contains the faulty data:

1. In the DevTools of Chrome browser switch to the Network tab and the relevant request
2. Select the Preview
3. Expand the received object
4. Right-click on the metadata value
5. Choose Copy string as JSON literal
6. Click on the Start button in the Taskbar
7. Type node and press <Enter> to open the NodeJS command prompt
8. Type let str and press <Enter> to initiate variable
9. Type str= and paste the copied value, no additional quotes are required
10. Type JSON.parse(str) and press <Enter>
11. The output will show the object for correct metadata or error for the corrupted one
12. Repeat the steps 9-10 for the other items