Skip to main content
Question

JSON error when importing or updating Google Sheets from QB

  • Sep 26, 2024 2:42 PM UTC
  • 0 replies
  • 197 views

Forum|alt.badge.img+5

So I have pipelines to import and update data from quickbase to Google Sheets to essentially mirror each other.

I just tried a pipeline that imports data from a newly created record to Google sheets and got this error message:

Remote service reported an error: Invalid JSON payload received. Unknown name "values": Cannot bind query parameter. Field 'values' could not be found in request message.

When I update a record I get this message: 

Remote service reported an error: Invalid JSON payload received. Unknown name "dataFilters": Cannot bind query parameter. 'dataFilters' is a message type. Parameters can only be bound to primitive types.

I am having a hard time figuring out what this could be as my test environment pipelines for google sheets work fine.

Any insight would be appreciated.

Thanks,

James

 

 

 

 

This topic has been closed for replies.

Forum|alt.badge.img+19
  • Qrew Champion
  • Sep 26, 2024 8:51 PM UTC

Is your Test Environment just a different work book or is it actually some sort of Google Sheet Sandbox for testing?

I know that for Intuit products the endpoint you Post to is different for their testing.