What can we help you with?

Zapier JSON Formatting Examples

When creating a new Zapier integration that utilizes monday.com to either create a new item or fill in column values, Zapier will require these column values to be set within a JSON format. Keep reading to find more! 

 

How does it work?

Every column type within monday.com has a different required JSON format to pass the relevant data to your monday.com board. You can learn more about these various formats within our API v2 documentation -- https://monday.com/developers/v2

You may be required to utilize a Column ID to ensure you're putting the new value within the correct column on your board. This article outlines how you can easily find the relevant column's Column ID - Where to find board, item, and column IDs

 Below you can find examples for various Zapier steps that utilize our most common column types. 

 

Note: In the below examples, any part of the example that's underlined is the Column ID.

  

Create a New Item in monday.com

  • Text Column -  {"text9":"Hello world"}
  • Long Text Column - {"long_text_1":{"text":"Hello World"}}
  • Number Column -  {"numbers5":"42"}
  •  People Column with a Single Person -  {"people8" : {"personsAndTeams":[{"id":4679523,"kind":"person"}]}}
  •  People Column with Multiple People -  {"people8" : {"personsAndTeams":[{"id":4679523,"kind":"person"}, {"id":4579752,"kind":"person"}]}}
  •  Status Column by Index -  {"status2":{"index":1}}
  •  Status Column by Label -  {"status2":{"label":"Working on it"}}
  •  Date Column with No Time -  {"date4":{"date":"2020-12-03"}}
  •  Date Column with Time -  {"date4":{"date":"2020-12-03","time":"13:25:00"}}
  • Dropdown Column by Label with a Single Label -  {"dropdown_1" : {"labels":["This"]}}
  • Dropdown Column by Label with Multiple Labels -  {"dropdown_1" : {"labels":["This", "That", "The other"]}}
  • Email Column - {"email_1" : {"email" : "[email protected]","text":"My Email"}}
  • Link Column{"link_1" : {"url":"http://monday.com","text":"go to monday!"}}
  • Phone Column with Country Flag - {"phone_1":{"phone":"5555555555","countryShortName":"US"}}
  • Phone Column without Country Flag - {"phone_1":{"phone":"5555555555"}}

Create a New Item in monday.com - setting multiple column values:

When setting multiple column values within the "Create a New Item in monday.com" step, you'll need to wrap the entirety of the column values in curly brackets as opposed to each individual column value.

Below is an example showing the formatting for updating both a Link Column and a Long Text Column within the same step:

{"link_1" : {"url":"http://monday.com","text":"go to monday!"}, "long_text2":{"text":"Hello World"}}

Update Item Column Value 

 

Note: You won't need to utilize any Column IDs within the "Update Item Column Value" Zapier step, as you're already selecting your intended column within the "Column ID" dropdown on this step.

  

  • Name Column -  "Hello World"
  • Text Column -  "Hello World"
  • Long Text Column - {"text":"Hello World"}
  • Number Column -  "42"
  • People Column with a Single Person -  {"personsAndTeams":[{"id":4679523,"kind":"person"}]}
  • People Column with Multiple People -  {"personsAndTeams":[{"id":4679523,"kind":"person"}, {"id":4579752,"kind":"person"}]}
  • Status Column by Index -  {"index":1} 
  • Status Column by Label -  {"label":"Working on it"}
  • Date Column with No Time -  {"date":"2020-12-03"}
  • Date Column with Time -  {"date":"2020-12-03","time":"13:25:00"}
  • Dropdown Column by Label with a Single Label -  {"labels":["This"]}
  • Dropdown Column by Label with Multiple Labels -  {"labels":["This", "That", "The other"]}
  • Email Column - {"email" : "[email protected]", "text":"My Email"}
  • Link Column - {"url":"http://monday.com","text":"go to monday!"}
  • Phone Column with Country Flag - {"phone":"5555555555","countryShortName":"US"}
  • Phone Column without Country Flag - {"phone":"5555555555"}

 

Update Item Multiple Column Values

For this step, the Column ID will go in the left field, and the column value will go in the right field.

Learn more about locating Column IDs here - Where to find board, item, and column IDs

You can reference the "Update Item Column Value Step" section above to see how to format the column value field on the right.

 

If you have any further questions please don't hesitate to reach out to us at [email protected]