JSON error when importing or updating Google Sheets from QB

Question

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

donlarson · Answer

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.

jamesdalton · Answer

It's not a sandpox per-se. It's essentially just a copy of my production app. I have mirroring pipelines for both test and production that write to a google sheet.

donlarson · Answer

I meant on the Google Sheet side.&nbsp; &nbsp;There is no login difference to get to the two different Google Sheets?

jamesdalton · Answer

No login difference. The two sheets reside in folder that was shared to the google account. Experiencing the same JSON errors with both the test and production pipelines. I suspect it might be a cache issue, could be totally wrong though. I reached out to QB support on this one because I could not find any information on that error message in the API Error documentation...I found some information about the JSON unknown name error on Stack Overflow, but they were using actual hand-coded scripts in say, php or python and that's beyond my current scope of knowledge. Will wait to see -

Forum Discussion

JSON error when importing or updating Google Sheets from QB