AQ JSON File Import Error

Owned by Stephen Juliano
Last updated: May 30, 2024
2 min read

Problem

Receiving Error message when importing JSON File. Not seeing which item when looking at AQ

Example Errors

How-To Find the Issue

Upload the file to https://jsonformatter.org/ and do the following

  1. Click on the right section

  2. Hit Ctrl+F to bring up the search bar

  3. Enter the Line ID given in the message or type in one of the following, depending on your message

    1. Duplicate, Missing, or Value Too large for AQ Line number use “ItemNumber”: “

      1. For missing, searching for “ItemNumber”:”” will pull them up

    2. Value Too Large for Column use “Spec”: “

    3. TRX Item Too Large for Column use “model”: “

    4. AQ Category Too Large for column use “Category”: “

When using either “item_number”: “ or “Spec”: “ you would use the arrows to cycle through until you find the duplicate, missing AQ Line Number, or Item/Description that was too large.

Solution 3a Example:

Solution 3b & 3c Example