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. 

1. Create a New Item in monday.com

When setting a column value within the "Create a New Item in monday.com" step, you'll be asked to provide the relevant column id as well as the value to update in JSON format.

Below is an example showing the formatting for updating a Link Column:

mceclip0.png

In the left field, place the column id (learn more about locating Column IDs here - Where to find board, item, and column IDs)

In the right field, place the corresponding value in JSON format.

See below the full list of expected JSON format by column type:

  • 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"}

 
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 can now add the values column by column. Click on the + sign below the Column Values row, to add more columns.

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

mceclip2.png

In the left field, place the column id (learn more about locating Column IDs here - Where to find board, item, and column IDs)

In the right field, place the corresponding value in JSON format (see the list of JSON format by column type in the previous section).

2. Update Item Column Value  

When setting a column value within the "Update Item Column Value" step, you'll be asked to select the relevant column as well as set the value to update in JSON format.

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.

  
See below the full list of expected JSON format by column type:

  • 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"}

  Below is an example showing the formatting for updating an Email Column:

mceclip4.png

3. Update Item <Column_Type> Column Value  

You can now update a specific column type without the need for JSON formatting!
To do that, select one of the new actions that will do the hard work for you:

mceclip0.png

 Below is an example showing the formatting for updating an Email Column:

mceclip6.png

4. Update Item Multiple Column Values

When setting multiple column values within the "Update Item Multiple Column Values" step, you can now add the values column by column. Click on the + sign below the Column Values row, to add more columns.

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

mceclip2.png

In the left field, place the column id (learn more about locating Column IDs here - Where to find board, item, and column IDs)

In the right field, place the corresponding value in JSON format (see the list of JSON format by column type in the "Update Item Column Value" section).

 

General Note

You can also pull data dynamically from previous steps of the Zap, and place them inside the column JSON value, e.g.:
mceclip1.png

 

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