Product updates

Hey amazing community! We released three highly requested features recently and I wanted to give you a heads up about them. Item Views Item views let you create apps that are displayed in an item’s “Updates” pane. The view behaves exactly the same as a board view or widget, only it’s connected to a single item. Check it out in our documentation here! Workspace Templates These let you bundle a set of templates with your app. Super useful if you want your users to have a specific board structure and reduce the amount of app configuration. Documentation is coming soon, but until then you can explore the feature by adding it to your app: Dynamic Mapping and Custom Entities This is also a highly requested feature. You can now create custom entities in your app that map to objects in other tools (or monday.com). You can also specify dependencies for the configuration! We’ll link to more documentation in the next week or so, but here’s a brief explanation of how it works. When a user tries to configure the mapping field, the monday Apps server will send a request to your “Field Definitions URL”. Your server should then respond with a list of field definitions, which your users can use to map item data to. Here’s an example function that returns the field definitions: async function getRemoteFieldDefs(req, res) { return res.status(200).send([ { id: ‘name’, title: ‘Name’, outboundType: ‘text’, inboundTypes: [‘text’] }, { id: ‘desc’, title: ‘Description’, outboundType: ‘text’, inboundTypes: [‘empty_value’, ‘text’, ‘text_array’] }, { id: ‘dueDate’, title: ‘Due Date’, outboundType: ‘date’, inboundTypes: [‘empty_value’, ‘date’, ‘date_time’] }, { id: ‘creationDate’, title: ‘CreateDate’, outboundType: ‘date_time’, inboundTypes: [‘date’, ‘date_time’] }, ]); } You can already explore this by adding a custom field to your app:

Today we opened a few subcategories for our developer’s section to make it a one-stop shop for all things builders. What does this mean for me? You can help us with this transition in a few ways: Go into the new API Feature Requests category and vote for all the features you would like to see added. Voting on a feature will give us visibility into what features are highly requested so we can adjust our product roadmap. If you’ve commented on a feature request, please add a vote so we can track it more easily 🙂 If you have existing topics in the community, please move it to the relevant category if you can! Our team will also move topics to the subcategories in the coming weeks. If you’re opening a new topic, please add it to the relevant subcategory. If your topic was already moved by a moderator, you’re good to go! What categories did we add? We added a few subcategories and moved existing topics into them. We will add new subcategories as our developer’s community grows! We added subcategories for specific topics: monday Apps: for questions and feedback around the monday Apps Framework. This was originally a separate category, but we included it in the Developer’s section for more visibility. API Feature Requests: for any feedback on our GraphQL API. Vote for the features you want to see! API FAQs: for any questions regarding our GraphQL API. Have feedback? If you have any ideas for more categories, or need any clarifications, you can reply to this thread.

We’re super excited to update you that the monday Apps Framework is now released to beta! You can open it by clicking on your avatar inside your monday.com account, and then clicking on monday.labs and activating ‘monday Apps’. Once it’s activated, click again on your avatar and on ‘Developers’ to start building. The monday Apps Framework gives developers the ability to build custom board views and widgets, with automations and integrations coming soon! The apps you’ll build now will be for use inside your own account. The next phase will allow you to share your app with specific accounts and eventually, the entire monday user base through the apps marketplace. Information and documentation Check out this documentation for guides on how to get started and for a quick overview, check out our overview page. Our technical support team will be answering questions about the monday Apps Framework, right here 🙂 We can’t wait to see what you’ll build! The monday Apps team @dipro @Ben @Talh-monday.com

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.