API & Apps framework

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

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 h

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

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

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

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 referen

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

Considering there is no retrieve workspaces option and we can only retrieve workspaces as part of boards. Is there any limit on the no. of boards for each workspace. If there is limit on the no. of boards per workspace that would help in retrieving all the workspaces with less number of iterations on the boards. Regards, Prashanth

We are using monday.com boards and we are adding columns to boards. As per the API documentation for [Create column](https://api.developer.monday.com/docs/columns-queries-1#create-a-column) there are 30 predefined types provided and user of the API can add new column of type from this 30 predefined types. What is the behavior on UI for same instance with same plan. Is the UI will also contains only this 30 predefined types or any addition to predefined types? If UI supports more types than predefined 30 types, is it possible to retrieve them in retrieve columns? If it is possible then how the types will be shown in retrieve response if it is not part of predefined type then how it will be handled while creating column value using API. Regards, Prashanth

Due to another team requiring us to populate data in SmartSheet, I am trying to come up with a way to copy the latest Update for an item into a text field for exporting to SmartSheet. Currently, the people on the team cut and paste the latest comment into a text column. At this time, we can use any 3rd party integration tools. I’ve confirmed I can query updates(limit: 1) {text_body} and pull the last update for any item. I’ve confirmed I can update a text field with a value. Is it possible to use GraphQL in one motion and query for the text_body from the Update and mutate copy the text to a custom column? While retrieving data Store item # and last update text_body to variables Update the custom text field with text_body (would actually like to concatenate with created_at) where item # is … Run until no more data is being retrieved -or- do it all in a single mutation query? Thanks!

We are using the Monday.com GraphQL APIs for our client implementation and currently we have objects like boards, groups, items etc. Wanted to know what is the frequency of the change in object and operations in Monday.com APIs. Also, how the version management is happening to support specific version of the monday.com GraphQL schema in the client implementation. Regards, Prashanth

I am trying to query to get a list of user_ids who have permission to access a Workspace. I dont see how this can be done. I dont see it in the workspace object or users. Is there a way to do it? thanks

i got this empty array but that item placed in my board 😒 please help me to solve this??? ‘items_by_column_values’ => array ( ),

Hello there, I successfully followed the api quickstart tutorial. However when I proceed the last PHP example, my new item is created, but four times. Why? Is it related to a specific board setting? Thanks Here is the code ($options and $board_id are defined earlier in the code) $headers = ['Content-Type: application/json', 'Authorization: ' . $options['api_key']]; $query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:'.$board_id.', item_name:$myItemName, column_values:$columnVals) { id } }'; $vars = ['myItemName' => 'Prospects1', 'columnVals' => json_encode([ 'email' => ['email'=>'zzzz@zz.fr', 'text'=>'zzzz@zz.fr'] ])]; $data = @file_get_contents($options['api_end_point'], false, stream_context_create([ 'http' => [ 'method' => 'POST', 'header' => $headers, 'content' => json_encode(['query' => $query,'variables'=>$vars]), ] ])); $responseContent = j