KNOWLEDGE BASE

Error: "Unable to evaluate JSON path expression with the given JSON payload." When Connecting to Google Sheets


Published: 14 Mar 2017
Last Modified Date: 28 Apr 2017

Issue

When connecting to Google Sheets with Tableau Desktop, an error may occur when selecting a Sheet:

"Unable to evaluate JSON path expression with the given JSON payload."

Environment

  • Tableau Desktop 10.0.0 and higher
  • Google Sheets

Resolution

Option 1:

The Tableau Desktop logs will have a line specifying what JSON field caused the error. For example:
LogError: Error reading JSON payload with expression 'files.lastModifyingUser.displayName'. Field 'lastModifyingUser'. JSON Error: get_value< Object > called on null Value

The JSON can be connected in Tableau Desktop (copy and paste in the Data menu) to find the documents which are causing the error.

Once the specific documents are known, they can be removed from the Google Drive, or you may replace nulls with actual values.

Option 2:

The sheets can still be searched for in the search box even if the list is not populated. If a specific sheet's name is know enter it into the search box and a connection can be made.

 

 

Cause

The JSON error occurs after creating a Google Sheets connection and such sheet(s) contain some nulls in the data.
Did this article resolve the issue?