Product updates

Hey there, Community! We just released 3 tutorials in our most popular programming languages! These articles go through the basics of our GraphQL API and are great for anyone just starting out. Each tutorial is aimed at folks with basic familiarity of each programming language. PHP Quickstart Javascript Quickstart Python Quickstart If you have any questions, feel free to open a thread in the community about it! Happy coding! Dipro 🔮

Hey community! We just released the first set of monday apps! Check out the full announcement here: Releasing our first monday apps! Cheers, Dipro 🔮

Hey community! 🔮 You can now access files that are on your board via our API, and also upload them. Here’s the documentation. Moderator Note: Check out the following announcement for examples that upload a file from the client-side: Announcement: Uploading files to monday.com has just become easier :) Reading Files using the API The assets field represents a file that is uploaded to monday.com. You can query the title of the file, the URL, and also generate a public URL that can be used to download the file. Learn more here. Uploading Files using the API Our API also supports uploading files to a file column or update. To do this, you need to send your data as a multipart request (Content-Type: multipart/form-data) with the file in a variable. Here’s more info. Do note that we have a separate endpoint for files (api.monday.com/v2/file). This endpoint has a higher size limit for requests (20MB, which will be increased to 500MB in the coming weeks). An example query: mutation ($file: File!) { add_file_to_column (file: $file, item_id: 256180125, column_id: "files") { id } } Here’s what such a request would look like in Postman: And here’s what that would look like in cURL: curl \\ -F query='mutation ($file: File!) { add_file_to_column(file: $file, item_id: 118607269, column_id: "files") { id } }'\\ -F variables[file]=@/Users/diprobhowmik/screenshots/image.png\\ -H "Authorization: APIKEYHERE" \\ https://api.monday.com/v2/file

Hey y’all! 🔮 I’ve been working with some clients recently who wanted to come up with custom Google Sheets integrations. To give them a taste of our API, I came up with a quick and dirty script to show them how they would send data from Google Sheets to text columns in monday.com. This example is for developers who have some experience with Google’s scripting platform and may be too technical (or bare bones) for non-developers. Description The example below will connect a Google Sheet to a monday.com board, such that every time an item is changed in Google Sheets, the data will update in monday.com. This is a super quick example, so treat this as a jumping-off point for more complicated integrations! Setting up the example To start, you’ll want a Google Sheet with a header row: Then, create a board that has a text column that corresponds to each column in the Google Sheet: Next, you will need to install this Google Script as an add-on to your Google Sheet. You may need to consult the Google Scripts API reference for more information on adding the script to your Google Sheet. Finally, you’ll need to change some variables to correspond to your environment. Add your API key to line 2, change the board ID on line 5, and update the array on line 8. Enjoy!

I just had a great conversation with one of our clients and realized that it would be helpful to have a guide on the structure of the data returned by our API. While each query will return data in a slightly different way, here’s a general guide for understanding response data. Fact: It’s easier when you use a library 😁 Before we dive in, I’d suggest everyone use a JSON parsing library to make the data returned more manageable. There are tons of libraries out there including JSON.NET, Python and JavaScript’s native json libraries, and Java’s Json API. Check out this page for a library in the language of your choice: www.json.org Expressions to access objects Here are some expressions you can use to access objects and fields returned by your query. data : Parent object that holds all the data in the query. This is returned for all successful queries. data.items : List that contains objects that each represent an item. data.items[0] : Access the first item in the list of items (Object) data.items[0].name : The name of the first item (String) data.items[0].id : The ID of the first item. data.items[0].group : Object that represents the group that this item is in. data.items[0].group.name : The name of the group of the first item (String). Example data Here is some data that corresponds to the expressions above: { "data": { "items": [ { "name": "Here's an item", "id": "161366694", "group": { "id": "new_group", "title": "This is a group" } }, { "name": "And this one is also an item", "id": "161366701", "group": { "id": "new_group", "title": "This is a group" } }, { "name": "Guess what this is? A item", "id": "161366747", "group": { "id": "new_group", "title": "This is a group" } }, { "name": "A pulse can be a task", "id": "161366844", "group": { "id": "topics", "title": "Here's another group" } }, { "name": "Or a project", "id": "160540651", "group": { "id": "topics", "title": "Here's another group" } } ] }, "account_id": 1825528 } Example query Here is a query that will return the data above. query { items { name id group { id title } } }

I’m seeing that you can create a column on a board with this: mutation { create_column (board_id: 20178755, title: "Work status", column_type: dropdown) { id } } But no where in the documentation i see a way of defining the labels for the column_type dropdown. When trying to set a label on a item mutation { change_column_value (board_id: 20178755, item_id: 200819371, column_id: "status", value: "{\\"label\\": \\"done\\"}") { id } } You get a error back that the label does not exist. So it seems you can create a column but not define the options of a dropdown column through the api. Is this true?

Hey monday.com community! 👋 Our Zendesk integration is amazing for pulling new Zendesk tickets into a board, but what about existing ones? Well, I just posted an example on how to import Zendesk tickets into monday.com with a Python script! 🔮 Check it out on Github here: GitHub - yuhgto/mondaydotcom-import-example.py Enjoy 🍻

Hello everyone, I am happy to announce that Webhooks have been released for everyone. 🙂 You can use Webhooks either from our API v2 or from the integration store. Go check it out!

Hello everyone, I am happy to announce that you can now integrate Webhooks with your monday.com account! The integration is currently open for our Beta users. 🙂 Go check it out! You can use Webhooks either from our API v2 or from the integration store. If you are interested in trying it out, email our support team at support@monday.com with the subject line monday.com Webhooks integration! documentation : monday.com Webhooks

Ever wonder how to send requests to our API using cURL? Here you go 💯 ‼️ A few notes: Executing cURL from the terminal removes backslashes and passes the escaped characters in the resulting string. As a result, if you want to pass \\" to the server you need to include \\\\\\". I ran these examples from the command line on my MacOS machine. Some Windows terminals don’t like single quotes, so you may need to replace them with " if you’re running these examples on a windows machine. If you’re looking for more code examples, check out our quickstart tutorials. Getting the ID of an item with a specific name: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXXXX" 'https://api.monday.com/v2' \\ -d '{"query":"{items_by_column_values(board_id:162169280, column_id:\\"name\\", column_value:\\"This\\"){id name}}"}' Updating a text column on a board: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXX" 'https://api.monday.com/v2' \\ -d '{"query":"mutation{change_column_value(item_id:279187304, board_id:162169280, column_id: \\"text\\", value:\\"\\\\\\"Hello world\\\\\\"\\"){name}}"}' Updating a status column on a board: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXX" 'https://api.monday.com/v2' \\ -d '{"query":"mutation{change_column_value(item_id:279187304, board_id:162169280, column_id:\\"status\\", value:\\"{\\\\\\"label\\\\\\" : \\\\\\"Done\\\\\\"}\\"){name}}"}' Updating a date column on a board: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXXXX" 'https://api.monday.com/v2' \\ -d '{"query":"mutation{change_column_value(item_id:279187304, board_id:162169280, column_id:\\"date\\", value:\\"{\\\\\\"date\\\\\\" : \\\\\\"2019-08-27\\\\\\"}\\"){name}}"}' Updating a person column on a board: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXXX" 'https://api.monday.com/v2' \\ -d '{"query":"mutation{change_column_value(item_id:279187304, board_id:162169280, column_id:\\"person\\", value:\\"{\\\\\\"id\\\\\\" : 4012689}\\"){name}}"}' Updating a people column on a board: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXXX" 'https://api.monday.com/v2' \\ -d '{"query" : "mutation{change_column_value(item_id:279187304, board_id:162169280, column_id: \\"people\\", value:\\"{\\\\\\"personsAndTeams\\\\\\":[{\\\\\\"id\\\\\\":4012689,\\\\\\"kind\\\\\\":\\\\\\"person\\\\\\"}]}\\"){name}}"}' Updating a link column on a board: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXXXX" 'https://api.monday.com/v2' \\ -d '{"query":"mutation{change_column_value(item_id:279187304, board_id:162169280, column_id: \\"link\\", value:\\"{\\\\\\"url\\\\\\" : \\\\\\"http://www.monday.com\\\\\\", \\\\\\"text\\\\\\": \\\\\\"Hello\\\\\\"}\\"){name}}"}' Updating a date, status & text column in the same request: curl -X POST -H "Content-Type:application/json" -H "Authorization:XXXXXX" 'https://api.monday.com/v2' \\ -d '{"query":"mutation{change_multiple_column_values(item_id:279187304, board_id:162169280, column_values:\\"{\\\\\\"status\\\\\\" : {\\\\\\"label\\\\\\" : \\\\\\"Done\\\\\\"}, \\\\\\"text\\\\\\":\\\\\\"Hello world\\\\\\", \\\\\\"date\\\\\\" : {\\\\\\"date\\\\\\" : \\\\\\"2019-08-27\\\\\\"}}\\"){name}}"}' Enjoy, and happy coding 🙂

I’m trying to build an application that will allow my employer to create custom time-tracking reports (ie time spent per person, per week, per project). However I’m not sure how to access the individual time entries for each project/item. When accessing “column_values” for the time-tracking column I get the general column information (see below) “title”: “Time tracking”, “id”: “time_tracking”, “additional_info”: null, “text”: “01:37:52”, “value”: “{“running”:false,“startDate”:1562870160,“duration”:5872,“changed_at”:“2019-07-11T19:37:52.438Z”}” However the data I need is the data that populates when looking at the time tracking log as shown below.