API & Apps framework

I’m using C# ASP.NET with the monday.com API. I’ve been able to do queries and also I’m able to create an item. However, I’m having trouble creating an item with field values. I’ve seen various posts on the same issue but I can’t seem to get it right. Any help or ideas would be appreciated. I’ll share the code I’m using. First, I created a new class: public class MondayAPIClass { private const string MondayApiKey = "yourkey"; private const string MondayApiUrl = "https://api.monday.com/v2/"; public string QueryMonday(string query) { byte[] dataBytes = System.Text.Encoding.UTF8.GetBytes(query); HttpWebRequest request = (HttpWebRequest)WebRequest.Create(MondayApiUrl); request.ContentType = "application/json"; request.Method = "POST"; request.Headers.Add("Authorization", MondayApiKey); using (Stream requestBody = request.GetRequestStream()) { requestB

Hello, I have two boards: Customers and Jobs Customers includes all of my customers Jobs includes all of the jobs we’re working Jobs has a “Connect board” column that links to the Customers board. This column contains which Customer the Job is for. Customers can have many Jobs at any given time. What is the best way to pull the Jobs for a specific Customer? And can this be done in a single GraphQL query? I can find my customer like this (Ex. the customer name is Jill Mahomes): query { items_by_column_values (board_id: 123456789, column_id: "name", column_value: "Jill Mahomes") { id name, column_values { id, value, text } } } The “link to projects” field looks like this: { "id": "link_to_projects", "value": "{\\"linkedPulseIds\\":[{\\"linkedPulseId\\":1308587615},{\\"linkedPulseId\\":1308587623}]}", "text": "" } How do I then use the linkedPulseIds to pull my relate

Hello, I am using the SDK to upload an image to a column on a board, and I’m receiving a 500 error. I am passing the file through an HTML input which returns a File e.g: File: {name: 'sample.pdf', lastModified: 1653471602427, etc...} I am using the SDK as stated in this post: Announcement: Uploading files to monday.com has just become easier :) My code: const RESPONSE = await monday.api( ` mutation addFile($id: Int!, $file: File!) { add_file_to_column(item_id: $id, column_id: "files", file: $file) { id } } `, { variables: { id: parseInt(id), file, }, }, ); When I run the mutation I get a 500 POST error from the https://api.monday.com/v2 url. Hoping someone can help me understand what’s going wrong. Cheers!

Good day everyone, am trying to perform oauth authorisation in php as per this documentaion docs When I run the code below, it does not do anything $client_id = 'my-client-id goes here'; $client_secret ='my client secret goeshere'; $redirect_uri = 'http://example.com'; $scope ="me:read boards:read users:read"; $content = "client_id=$client_id&client_secret=$client_secret&scope=$scope"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://auth.monday.com/oauth2/authorize'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); curl_setopt($ch, CURLOPT_POST, 1); curl_setopt($ch, CURLOPT_POSTFIELDS, $content); $result = curl_exec($ch); curl_close($ch); var_dump($result);

Hello, For the project I am working on, I want to move a table of about 600 items (item data and amount of items can change) from an Umbraco database over to Monday.com, in which I am using C# and GraphQL, this process can be called multiple times and is a way to synchronize Institutions data to a group on a Monday.com board. I want every item to be unique by the Item name (there can only be one ‘Institutions 1’ and one ‘Institutions 2’). To achieve this I first create the columns with ‘create_column’ to match that of the institution Model (Country, YearEstablished, StaffCount etc…). Then I get all the items that exist currently using ‘items_by_multiple_column_values’ and check if there is an item with that ‘Item Name’, if there is an item I update the items data with ‘change_multiple_column_values’, if the item is not there I create the item with ‘create_item’. I am using C# async awaitable functions to ensure I get a result back before proceeding to the next API call. My problem is w

Hi Is it possible to delete all items from a board via a bulk delete or equivalent API call? Thanks

Hi team, We have created custom application with user authentication/authorization process. When we add integration into board it is ask for user authentication/authorization in monday.com When we click on Authorize we get following error And this error we got in terminal Please any one any solution why we got error in user authentication in code or anywhere. Please let us know if anyone face same error before. Thanks 🙂

I want to convert to HH:MM, but I always get HH:MM:SS Here’s my formula: TEXT({Duration (Decimal hours)}*3600,“HH:MM”) This is the result: What am I doing wrong?

Hi Team, We have multiple workspaces and multiple boards and when retrieving the boards all the board results is having board_folder_id as null. Is this expected? If not how we can create board within some folder. Please assist. Regards, Prashanth

My account is having issues with hitting rate limits, every 5 mins. I’ve run a simple script to return the usage every 5 seconds: complexity { after reset_in_x_seconds } WARNING: 05/01/2022 15:09:47 | Reset: 60 secs. | Avail: 100.00% | Remaining: 10000000 | Used: 0 WARNING: 05/01/2022 15:09:52 | Reset: 55 secs. | Avail: 99.50% | Remaining: 9950000 | Used: 50000 WARNING: 05/01/2022 15:09:57 | Reset: 50 secs. | Avail: 99.00% | Remaining: 9900000 | Used: 100000 WARNING: 05/01/2022 15:10:02 | Reset: 45 secs. | Avail: 42.49% | Remaining: 4248952 | Used: 5751048 WARNING: 05/01/2022 15:10:08 | Reset: 39 secs. | Avail: 0.23% | Remaining: 23166 | Used: 9976834 I’m not aware of anything on our account that runs every 5 minutes, nor a query / mutation that would consume 9,000,000 complexity in the span of 10 seconds. Additionally, I have functions / API calls that no longer return information as they hit limits. Seems as if something changed and now querying for subitems

Hello guys, and all experts! Please, as I´m not expert and just the key user to help the IT responsible to implement features in our system, sorry for the question. But is it possible to create API integrations with VISUALIZATOR type of USER instead of member user? Because we don´t have more capacity of users, for the IT developer , at the moment. thanks , Leandro

Hi there, I have an idea for Monday app that I want to build in order to improve Monday workflows and day-to-day use. I want to check if Monday dev team plan to solve it in the next future before start working on it. Do you know where I can find Monday roadmap and plans to the next future? Thank you very much.

We are using delete_item mutation to delete the item. However it is not giving any error when trying to delete same item again and again. We are expecting error while deleting the item which is already deleted. Regards, Prashanth

Hi Guys, I’m looking at overhauling many of the workflow processes within our company, and looking for recommendations on what the best option would be to tie everything together. Overview Late last year, I purchased a telephone answering service / call center that answers for close to 550 business accounts and has 15-20 remote agents along with 10-15 internal agents. It’s made up of 2 managers, 1 trainer, and 4-5 assistant managers. Pretty much the entire company is antiquated and needs to be rebuilt from the ground up, so earlier this year I setup Google Workspace and started integrating Monday.com Question What are some of the most popular frameworks, software platforms, etc that you guys have used on the front end to integrate w/ Monday? I’m referring to platforms like Wordpress…Laravel…Joomla…NodeJS…etc? Which web-based framework or platform (fullstack or hosted) would allow me to pipe data to/from Monday.com in the most practical, easy, and cost-effective manner? Functionality P

We need there to be trigger parity across the following areas: Custom automation recipes. Any column changes is missing (available for custom apps and webhooks) Webhook integration triggers. API Webhook creation Several webhook types (delete/archive) are not yet available to be created by API. (though sounds like its on its way). Custom app triggers Delete/archive items. “column changes” can now select subitem columns like webhooks and custom recipes but the boardId returned is not the boardId of the subitem (subitem board) but the board the recipe is added to. I’m trying to centralize all the known discrepancies so the Monday.com team can communicate to us what plans are in place for bringing parity.

Hi there, I’m trying to upload a file to an item in a board. I start by reading the file, byte byteArray; byteArray = File.ReadAllBytes(“c:\\template\\RPT-First.pptx”); var UploadFile = _MondayClient.addFile(new Monday.Client.Mutations.AddFile { ItemId = result[i].Id, ColumnId = “files”, File = byteArray }).Result; The AddFile task looks like this… var request = new GraphQLRequest { Query = @“mutation request($file:File! $itemId: Int! $columnId: String!) { add_file_to_column (file:$file, item_id:$itemId, column_id:$columnId) {id}}”, Variables = new { file = addFile.File, itemId = addFile.ItemId, columnId = addFile.ColumnId } }; I’ve used a similar method for creating new items, updating columns etc… all of my other mutations work without a problem. But in this case, it just turns and turns. No error whatsoever. Any help would be appreciated.

Hi, I just had a script which used to work fine last week. But recently I started getting an exceeded complexity error, even when the board has not increased in size and the query itself is the same. Maybe there is some changes I am not aware of? Saw the last update about users queries, but I think mine should not be affected by that. My error is: ERROR:root:Error when parsing the response: {"errors":[{"message":"Query has complexity of 29026535, which exceeds max complexity of 5000000"}],"account_id":XXXX} and query: query get_query {boards (ids: XXXX) { name, groups {id, title} columns {id, title, type,} items (limit: 100, page:1) { id, created_at, name, state, updated_at, board { id, name }, column_values { id, text, title, value },

Hi All, I’m trying to pull info from Monday and display a list of job numbers and connected clients. When I query the board I’m using: boards (ids: 111) { items { id name column_values { id text title } } } } The results to show: { "data": { "boards": [ { "items": [ { "id": "project_number", "name": "project name", "column_values": [ { "id": "subitems", "text": "", "title": "Subitems" }, { "id": "connect_boards", "text": "Client Name", "title": "Client" }, { "id": "rep", "text": "11586", "title": "Job No" }, { "id": "timeline", "text": "2022-02-24 - 2022-02-24", "title": "Project Co

I’m trying to upload files from an IOS app I am making. No matter how I approach the GQL POST to /v2/file upload, I get 400 “Unsupported query”. When researching this issue I found this other community post which resolved the issue by updating their postman. So following that lead I have tried making the gql request using 3 different frameworks: using apollo-ios graphql client manually building the gql request using urlsession manually building the gql request using alamo fire. For all of those approaches everyone has the same result of 400 “Unsupported query”. Are there any ways for me to get more debug information on this error, so that I can get a more specific idea of what I need to address? Any help with debugging or exploring this problem would be greatly appreciated!

There is no retrieve subitems GraphQL API, we can retrieve subitems using retrieve item. Also, there is no pagination support for subitems. It is always retrieve all the subitems. Considering this, Is there any limit on the number of subitems for each item in the board? Regards, Prashanth

URL: https://jetbrains-league.monday.com/v2 Request example: POST /v2 HTTP/1.1 Host: jetbrains-league.monday.com Authorization: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx Accept: application/json Content-Type: application/json {"query": "{ boards(){id name description state workspace {id name} board_kind}}"}

We are currently looking for query column to get all the available columns in the board with metadata to enable user to provide those column values while creating the item. Our flow is as below: Retrieve column Retrieve column definition Create item along with column_values where we wanted to allow user can provide value based on the column definition. Currently the type we are getting from retrieve columns is not matching with [Column Type Reference](https://api.developer.monday.com/docs/guide-to-changing-column-data) provided in API documentation. For example type name is there and there is no Column Type Reference for name. Also, if type is color then there is no Column Type Reference for color, similarly for others. Is there any way to retrieve each column type definition for say if the column is color there retrieving definition of the color type? Regards, Prashanth

Currently there is no direct retrieve support for workspaces in the GraphQL API. We can retrieve workspaces only using retrieve boards. Is there any way user can get the workspace id in the monday.com application UI? Regards, Prashanth

Hello! I am running what I believe to be a simple mutation and I cannot get it to work, I keep getting { “error_message”: “Internal server error”, “status_code”: 500 }. I have tried both the change_multiple_column_values and change_column_value approaches. Searching the forums, I have seen folks say this can be caused by a malformed request string but I am unable to see that. Help is appreciated. mutation { change_multiple_column_values( board_id: 2588471113, item_id: 2643558945, column_values: "{\\"connect_boards30\\":{\\"item_ids\\":\\"2643558944\\"}}" ) { id } } This is generated programmatically from this: let mutation = `mutation { change_multiple_column_values( board_id: 2588471113, item_id: ${createdSubItemId}, column_values: ${JSON.stringify(updatedColumnValues)} ) { id } }` Of note: My board_id references a sub_items board if that makes a difference. I have tried the query both in my code and directly on the Monday.com

Currently there is no GraphQL API to retrieve groups. The retrieve groups only possible with retrieve boards. Also, there is not pagination support for groups when retrieving groups using boards. Is there any limit on number of groups for each board? Regards, Prashanth