Skip to main content

Hotsheet error - 'JSON Parsing Error: 13 Type Mismatch'

Error message: JSON Parsing Error: 13 Type Mismatch. We get an error message when running the Hotsheet excel spreadsheet.

J
Written by Joshua Shooter

If you receive this error when running hotsheets, this is related to the API key not reading the data. To fix this, follow the below troubleshooting options:

  • Create a new API key with access to the queries you wish to export.

  • If this fails, recreate the queries within the system as new assign access to the new queries for the API key.

If the issue persists, raise a new case online and reference the title of this article, providing the following details:

  • screenshots of the Settings tab within the hotsheet and how you populated the fields.

  • name of the API key.

  • grant our team access to your system.

Did this answer your question?