Skip to main content
Question

Why am I getting a invalid payload error for this Zap between Google Sheets and Niceboard?

  • October 24, 2023
  • 6 replies
  • 303 views

Hey folks,

   I wanted to know if anyone has faced this error and was able to troubleshoot it properly between Niceboard and Google Sheets. I want a new job to be created each time a new row in Google Sheets is filled.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 24, 2023

Hi @parker 

Good question.

We would need to see screenshots with how your Zap step 2 is configured.


  • Author
  • New
  • October 24, 2023

Is there anything in particular I should share? Here is a general overview of my Zap

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 24, 2023

@parker 

Depends on the Zap trigger step example record data you are testing with, but the 2 Company fields and the 2 Location fields have conditional requirements.

Company ID and Location ID are dropdown fields which expect certain internal values if being passed dynamically.

 


BT1000
  • December 7, 2023

Hi @Troy Tessalone I’m experiencing the same issue. I’ve tried leaving the company and location ID blank, filling them in, and other combinations but still get the same invalid payload message.

I have the same pics essentially as @parker. Any advice on what to do?


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • December 7, 2023

Hi @BT1000 

You may want to try reaching out to Niceboard Support for guidance about their Zap app integration.


  • New
  • May 25, 2024

Did you figure out a way to avoid this error? What was wrong.