General

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

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!