ScheduleOnce and Monday.com integration in Zapier - JSON issue

Platform discussions monday apps & integrations
1

Our company is trying to integrate ScheduleOnce and Monday.com in Zapier. Our vision is that when a client books an appointment through ScheduleOnce we want their information to show up as a new item in Monday.com. When a client books an appointment they have to fill out a form with their information we want that information to be put into the column we created on our board.

I am stuck on the JSON part in the Monday.com integration. I have read the document that shows you how to do it and I have looked at other peoples posts in the Monday.com community. I keep getting a “internal server error”. Can you help me?

I attached two photos with my JSON code and error message.

JSON Code
JSON Code3000×2000 443 KB

JSON Error code
JSON Error code3000×2000 429 KB

2

Hi @shirst :wave:

Welcome to the monday.com community! We’re glad to have you :slight_smile:

First, can you confirm that the text columns you’re interacting with are Long Text column as opposed to Text Columns? These 2 different column types require different formatting per the documentation you referenced. This is an easy mistake to make, so I think it’s worth starting there!

If you’re not sure, you can always check the column type within the column header’s menu:

image
image527×647 50.3 KB

Additionally, will you please copy and paste your column values JSON from within your screenshots above? This will make it significantly easier to poke around and troubleshoot with the JSON :muscle:

-Scott

3

The “how can we help” is the only one that is a long text column.
Here is my JSON code:

{“phone” : {“phone” : “{{93655731__CustomerMobilePhone}}”,“countryShortName” : “US”},{“email3” : {“email” : “{{93655731__CustomerEmail}}”, “text” : “Email”}, {“text3”: {“text” :"{{93655731__State}}"}, {“age”: {“text” :"{{93655731__Age}}"}, {“marital_status”: {“text” :"{{93655731__Martial Status}}"}, {“text8”: {“text” :"{{93655731__Occupation}}"}, {“text”: {“text” :"{{93655731__Top Concerns}}"}, {“how_can_we_help”: {“text” :"{{93655731__How can we help}}"}

4

Were you able to figure out why this isn’t working for me?