API & Apps framework

Hi all, I’ve been building an integration for the past week that only uses custom actions. I would like to enable users to use any trigger of their choosing, however, I haven’t been able to figure out how to do this. My actions only need the Item ID, which is sent by any trigger, I believe. I have to create full recipes every time (button clicked => my action, status changes => my action). But I would like users to be able to just pick up my action and link it to the trigger they want. Is this possible, and if so, how can I implement this? Thanks in advance!

Hi I use webhooks createUpdate and createSubUpdate it works. How can I get changes delete and edit Updates? Thanks, Fedor

Join the monday Developer Success team to ask questions and discuss the API and apps framework! You can bring any questions you’d like –– including questions about the API and developer tools, our marketplace review process and best practices when designing your app. Date & Time: 02:00pm - Thursday, October 27, 2022 (Eastern Time - US & Canada). Where: Join us on Zoom See you there 🚀

Boards and the workspace. API response:

My Monday.com integration has been working until recently I’ve started getting the message below: {"error_code":"ColumnValueException","status_code":200,"error_message":"Invalid column value schema for column type: color. Expected schema is: {\\"changed_at\\"=\\u003e{\\"type\\"=\\u003e[\\"string\\", \\"null\\"]}, \\"index\\"=\\u003e{\\"type\\"=\\u003e[\\"string\\", \\"number\\", \\"null\\"]}, \\"post_id\\"=\\u003e{\\"type\\"=\\u003e[\\"number\\", \\"null\\"]}, \\"label\\"=\\u003e{\\"type\\"=\\u003e[\\"string\\", \\"number\\", \\"null\\"]}, \\"extra_color_index\\"=\\u003e{\\"type\\"=\\u003e[\\"number\\"]}}, received: {\\"labels\\"=\\u003e[\\"- Select -\\"]}","error_data":{"column_value":"{\\"labels\\"=\\u003e[\\"- Select -\\"]}","column_type":"color"}} The query mutation is below. I don’t understand why this is now happening when it was working flawlessly for months.

I struggled to figure out a solution for a C# webhook page. I tried the Javascript example with no success. After much trial and error (several days), I was able to get it working. So I decided to share my code. When creating a webhook, you need to specify a url to send the event payload. The page below is designed to handle the challenge response to verify the webook. Then it will receive any event payload that occurs. The code sample below is a page I called mondaywebhook.ashx . <%@ WebHandler Language="C#" Debug="true" Class="MondayWebhookHandler" %> using System; using System.Web; using System.IO; using System.Net.Mail; public class MondayWebhookHandler : IHttpHandler { public void ProcessRequest(HttpContext context) { context.Response.ContentType = "application/json"; string body = String.Empty; context.Request.InputStream.Position = 0; try { using (var inp

Hello, I’m trying to add columns values using monday’s official sdk ( GitHub - mondaycom/monday-sdk-js: Node.js and JavaScript SDK for developing over the monday.com platform ), but the docs are not helping to much. I’m getting 500 error, this is my code monday.api(`mutation { create_item (board_id: 123456789, item_name: "My Item Name", column_values: "[{\\"text1\\": \\"yellow\\"}, {\\"text2\\": \\"red\\"}, {\\"text3\\": \\"blue\\"}" ) { id } }`).then(res => { console.log(res) }); I tried also with only one column, still error 500 or nothing at all. I don’t want to make another query and use “change_column_value”. Thank you!

I’m very confused on how to format my file as a multipart request stored in a variable. The current code is invalid syntax, I can get it to post when formatted as one string but the data doesn’t deliver so I get an error response. How do I format it properly? Here is my code: import requests with open('monday_key.txt') as f: apiKey = f.read() apiUrl = "https://api.monday.com/v2/file" headers = {"Authorization": apiKey} file = {'file': open('safety_reviews/jjjj.pdf', 'rb' )} data = {'mutation' { 'add_file_to_column' ['item_id': '3366726997', 'column_id': "files", '$file': file ] { 'id' }}} r = requests.post(url=apiUrl, json=data, headers=headers) print (r.content)

How to send a file to https://api.monday.com/v2/file without having the file locally? I wish to send it as binary file through an API, instead of downloading it locally and then sending it to https://api.monday.com/v2/file.

Today, if you have a workspace template that’s part of a live app, changing the boards in the workspace while the app is a Live version results in changes to the workspace when deployed by end users. This seems counter to having app versions, as it makes it entirely possible to corrupt a template inadvertently after going live (and means development requires duplicating the workspace for the next version to do any work on it.) When an app version changes to live, it should snapshot the workspace someplace outside the dev account, and end-user deployments should be based off the snapshot - not off the workspace the template is based on.

Hi all, I have a custom app that i have developed through the quickstart integration for nodejs. When i am running the server locally (npm run-sript start) all is fine and dandy - no issues. I am confused about how this gets pushed back to monday. If I am not running the server locally it appaers to not work at all. Could this please be clarified?

I do see errors in my log files with error_code MutationCallsExceeded. Can’t find any reference in the documentation. Do you know what this means, under what conditions it can appear and how to prevent this?

Whenever trying to delete the item, getting 500 status code instead 404 not found error. Below is the error for non existing item delete mutation. { “error_message”: “Internal server error”, “status_code”: 500 } We are expecting 404 not found in case incorrect item id. Regards Prashanth

I am attempting to upload a number of files using the v2 endpoint, but it seems to fail whenever the file type is a png. I get this response from the server: { error_code: 'RecordInvalidException', status_code: 422, error_message: 'Validation failed: Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError', error_data: { error_data: 'Validation failed: Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByImageMagickError, Resource Paperclip::Errors::NotIdentifiedByI

For example some triggers return the itemId as a string “12346790” and some as a number 12346790. Specifically “when date arrives” returns the itemId as a string not a number, but other triggers return a number. Along that note, boards.id is a number but items.board.id is a string. Someday some consistency in these types would be nice 🙂

Hi All. I really could use some advice. I’m a volunteer for a non-profit animal rescue. I know a little about a lot, enough to be dangerous, but I’m very new to APIs. I understand how they work and I can query via PostMan, but I don’t know how to implement the automation. What I need to achieve: Webhook to populate a drop-down in our gravity form (current available animals) with status = available Create an item in Monday when the form is submitted, linked to the selected value from the selected item(s) from the drop-down. I know general asks like this are frowned upon, but I’m just asking for a pointer to information. I’ll do the leg work to figure it out, I’m just hoping there is a kind developer out here that can point me in the right direction. I am SQL db developer in my day job, and I am limited to my free time to support our rescue. I receive no compensation for my time or effort and we are 100% volunteer run. If someone could

Hi all, Just wanted to share, in case anyone else has been stuck on this, that the current docs incorrectly state how to decode the JWT in " Authorization for Integration Recipes". In this segment it says the code can be decoded with the app’s Client Secret. However. this didn’t work for me - it worked when using the Signing Secret as usual 😊 Perhaps this could be updated in the docs? It will hopefully save others quite some time. Thanks!

We are trying to retrieveAll Team object but it is failing with query complexity issue. Query is below : { teams { id name picture_url users { birthday country_code created_at current_language email enabled encrypt_api_token id is_admin is_guest is_pending is_verified is_view_only join_date location mobile_phone name phone photo_original photo_small photo_thumb photo_thumb_small photo_tiny sign_up_product_kind time_zone_identifier title url utc_hours_diff } } } Getting error : {“errorDetail”:“{“errors”:[{“message”:“Query has complexity of 28013010, which exceeds max complexity of 5000000”}],“account_id”:11771408,“statusCode”:400}”} Currently instance is having sample data with 7 teams and 9 users on 30th of September we successfully got response with total 7

A few weeks back we announced the new value-created type in our SDK: This new type will track the time between when a user installs your application and when they get value from it. You will determine what actions are considered valuable. You can call the monday.execute() method with the valueCreatedForUser type each time the valuable action happens: monday.execute('valueCreatedForUser') To analyze the amount of time it takes users to get value from our apps, we need your application to use this type. After executing this method, you won’t see any immediate changes. We plan on exposing these insights to app developers and adding more telemetry about app usage in the future. To learn more about the value-created type, please see Value-created event best practices Happy building! 🛠️

Hello I’m trying to get through graphql the lookup values represented in a mirror column. The returned value is null, for which I asume lookup columns need to receive the parent id of the connected board in the query, but I’m not sure how to elaborate on that. { boards(ids: 3072864141) { items { id name column_values(ids: ["mirror"]) { value } } } }

Hi, I I have ran the following Python script and received a message: {“data”:{“add_file_to_column”:{“id”:“639126111”}},“account_id”:7384772} But in the item Files column the file is not displayed. Here is the script: import requests url = “https://api.monday.com/v2/file” payload={‘query’: ‘mutation ($file: File!) {add_file_to_column (file: $file, item_id: 1455154608, column_id: “files”) {id}}’} files=[ (‘variables[file]’,(‘Board_Subitems.txt’,open(‘C:\\MyData\\Monday\\Files\\Board_Subitems.txt’,‘rb’),‘text’)) ] headers = { ‘Authorization’: ‘XXX’, } response = requests.request(“POST”, url, headers=headers, data=payload, files=files) print(response.text) I would appreciate some help. Thanks!

Hi, I am looking for some help writing script for monday.com where I need to change multiple items & their connected column values. I have got to a point where I need support on writing and executing the script in monday.com. thank you

do we have pagination support both “page” and “limit” for Workspace, Group, Item, Column and Column Values in a single query (GraphQL)???

Hi, I am retrieving the json code from API successfully from the board selected but cannot manage to parse the data using PHP $responseContent = json_decode($data, true); Specifically, I get the below result from above: {“name”:“Subject Name”,“column_values”:[{“id”:“subitems”,“type”:“subtasks”,“text”:“”},{“id”:“email4”,“type”:“email”,“text”:“”},{“id”:“text8”,“type”:“text”,“text”:“”},{“id”:“long_text”,“type”:“long-text”,“text”:“”},{“id”:“person”,“type”:“multiple-person”,“text”:“John Doe”},{“id”:“status”,“type”:“color”,“text”:“New”},{“id”:“time_tracking”,“type”:“duration”,“text”:“1244:02:22”},{“id”:“creation_log”,“type”:“pulse-log”,“text”:“2022-08-22 13:08:10 UTC”},{“id”:“date”,“type”:“date”,“text”:“”},{“id”:“text5”,“type”:“text”,“text”:“”},{“id”:“requestor_email3”,“type”:“text”,“text”:“”},{“id”:“formula9”,“type”:“formula”,“text”:“”},{“id”:“files”,“type”:“file”,“text”:“”},{“id”:“item_id”,“type”:“pulse-id”,“text”:“3dffdf99”},{“id”:“dropdown”,“type”:“dropdown”,“text”:null

Is anyone aware of a way to update a single column with a new value for all items in a board, with a small number of GraphQL mutations? I don’t see anything suitable in the GraphQL API without having to make N mutations, one for each item in the board, which I’d like to avoid if possible. I wonder if anyone else has hit this problem and has come up with any creative solutions (Formula columns etc)? The create_column defaults option would be one option here, however it does not appear to work, and I see from GraphQL API: Hide columns (& general defaults) that it is recommended not to use it and “it is under revision at the moment”.