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
Updated over 2 weeks ago

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?