General

Here’s a basic snippet of PHP that lets me execute queries against the v2 API and return the data as JSON. I hope it can provide a leg up and save someone time as they get started. Just enter your own API key, change the URL to match yours, and put in your query. $token = '[Personal API Token]'; $tempUrl = "https://api.monday.com/v2/"; $query = ' { users{ id email name } }'; $headers = ['Content-Type: application/json', 'User-Agent: [MYTEAM] GraphQL Client', 'Authorization: ' . $token]; $data = @file_get_contents($tempUrl, false, stream_context_create([ 'http' => [ 'method' => 'POST', 'header' => $headers, 'content' => json_encode(['query' => $query]), ] ])); $tempContents = json_decode($data, true);

Getting error running below query for creating a many rows , I’ve a trial account. `{"errors":[{"message":"Query has complexity of 30001, which exceeds max complexity of 9966"}],"account_id":"######"}` mutation { create_item (board_id: $boardId, group_id: $groupId, item_name: \\"$itemName\\", column_values: $columnValues ) { id } } I can’t find how to calculate complexity for mutation. But for Query . Somebody help please.

Hi Team, Just curious to understand that how could we only call items based on their last updated date (for instance, get all items updated in the last 7 days). I didn’t see any information about the same in the documentation. Regards Saurabh

When I added some special character in the item_name then I got an error as the back response. When I remove them the item added successfully.

Hi Has anyone tried to integrate the UK Companies House API into a Monday board so that the correct companies details such as Registration Number and Address can populate fields to ensure consistency? Regards Dennis

Hello, What is the recommended way to update a board by deleting all the existing items and then replacing them by new ones? Do I need to delete every single one of them one-by-one and then adding them one-by-one ? Thank you

Hi @dipro, I’m developing a monday app for my company to import data into a board. I finished my first version and uploaded a build of the app and installed it so other people in my company can use it. But I’m running in to a problem… The app queries the graphql api using the following query: query getBoard($boardIds:[Int], $columnIds:[String]){ boards(ids: $boardIds) { name id description board_kind items { id name column_values(ids:$columnIds) { id text value additional_info } } } } And this query works fine when I use the app (I’m an admin) BUT if a user runs this, the API returns the following error: “Permission Denied! Your token doesn’t grant access to boards:read” The app is installed as view, so authentication is managed automatically The user running the query is owner of the board the app is running on, so no restrictions there. The app also has permissions set to “board:read” Is there anything else I should set?

Aloha, I am looking for a way to mass add/delete groups in a board using the api. Can someone give me an example of how this would look adding and deleting 5 groups. Thank you!!!

Hey, I’m using Monday V2 API for some internal automations, I’m modifying a tag through the API (after creating it) but I see the tag itself in the board only after refreshing or going through boards, it doesn’t work instantly like the other column types. Did anyone else experienced something similar? I doubt that it’s this way by design 🧐. Thanks.

Hi, I’m trying to post a date to a date column using NodeJS and axios. I’m using api v1 i supply a date string but i still get this error message: 'date_str is missing is there anything i’m not doing correctly ?

I’m using API v2 with an Excel query for basic analysis on a board that Monday formulas appear unable to accomplish. I have a people column that I am trying to compare with a voting column. I am looking to compare the users assigned via the people column with the list of users who have voted with the vote column. I am trying to use the API to gather a list of people who have voted with the vote column. But, I cannot seem to find a way to pull a list of users who have voted. My mind went to the formula column because it can be used to pull up this list. Unfortunately, it does not appear to be possible to pull formula information via the API. I’m looking forward to any suggestions you have.

Hey, My company implemented some sub-items connecting one item column from one board to another. The API retrieves the following: { “title”: “Contact”, “type”: “board-relation”, “text”: “”, “additional_info”: null, “id”: “link_to_item5”, “value”: “{"linkedPulseIds":[{"linkedPulseId":154982536}],"changed_at”: "2020-03-29T10:20:24.898Z"}" } Is there a method to connect or lookup from one board extraction to the other? Thanks

I’ve tried something like this: mutation { create_item (board_id: 123, group_id: "my_group", item_name: "Test Item", column_values: "{ \\"text_4\\" : \\"Line 1 Line 2\\" }" ) { id } } Or: mutation { create_item (board_id: 530995076, group_id: "new_group11081", item_name: "Melanie", column_values: "{ \\"text_4\\" : \\"Line 1\\nLine 2\\" }" ) { id } } Both of these result in HTTP 500 error in my program, on the “try it yourself” site, it results in “TypeError: NetworkError when attempting to fetch resource.”. Am I not allowed to insert line breaks into text column values?

I’d like to get the newest items from a group first and the documentation mentions the newest_first boolean under items. But I get this: “Field ‘items’ doesn’t accept argument ‘newest_first’” Am I stupid? Can anyone tell me what’s going wrorng? { boards(ids: 000000000) { groups(ids: “group_id”) { items(newest_first: true, limit: 1) { name } } } }

Is it possible to upload documents using the APIv2? Could not find this information in the documentation.

Hello I am new here. I tried to use the CURL example. Could you please tell me what is the expiration time? Thanks

Hi team, When creating groups through the API I don’s see a possibility to define the group color. Am I overlooking something or do I try to stretch the API too much 🙂

I am trying to utilize the Monday API for the purpose of seeing where our teams time tracking by two different tags (Tags, Type of Work). When I try an unfiltered look that collects columns groups and then attributes down to item column names, I am hit with the query complexity error and rightfully so. I would like to filter this query, but it doesn’t appear from the documentation in a manner that I believe would be best. My thought is that beyond filtering by board id (as I am already doing), I would like to query items created between a specific time range (e.g. 1 month). Is there a way to do that? From the documentation it looks like the only possible values are “limit”, “page”, “ids” and “newest_field”. Can anyone point me in the direction of how I can filter my query by date/time ranges or a good workaround to the complexity issue I’m facing? Here is my query: query { complexity { before after query } boards (ids: #########){ columns {

mutation { change_column_value (board_id: ###, item_id: ###, column_id: “contract”, value: “{"label" : "Confirmed"}”) { name } } Attempting to use postman after js code failed in a template literal. Any idea what is wrong here?

Hello there, I just tried this route with multiple boards and keep having the same issue. I have a 201 response code telling me eveyrhting worked fine. But the group is always missing int the targeted board. Support keeps telling me “we only offer limited support for API”. I am lost with this API route kind of not working… If anyone can help in here?Here is what I am doing, The request: curl --location --request POST 'https://api.monday.com/v1/boards/608119736/groups.json?api_key={{mykey}}' \\ --header 'Cookie: __cfduid=d2876a2b90aac34ec978a44a15004f0fc1590655189' \\ --form 'title=test title' The response: 201 CREATED { "pos": 0.0, "title": "ddd", "color": "#037f4c", "id": "ddd" }

Hi everybody, can somebody please tell me how to connect monday.com API with Postman. It´s my first use of an API. On Post-Method i´ve used the URL: “https://api.monday.com/v2/” For the “Authorization” Tab i´ve used the Type “Bearer Token” and the Token given in the Admin Section of Monday. In the “Headers” Tab i´ve used the Keys “Content-Type” and “Authorization” For the “Body” Tab i´ve used “GraphQL” and the example of monday like this: query { boards { items { id } } } Can somebody please tell me what i made wrong or where i made a mistake and help me to run the API? Best Regards, Michael

Hi @dipro See also my reply to the notifications thread. Do you think it is a good idea to give API access to the message centered at the top of the screen. I see them in green when I delete a board, or sometimes in red when there is something wrong with the platform. It would be a great feature to notify users form an app. It would be really great is we can use the button that says “Undo” in a custom message when we require an action from the user (e.g. redirect to a marketplace / shop) 🙂

I am trying to use a variable in the API to query a board using Python. I want to use the variable to replace the board id. I can successfully do a mutation using a variable for the board id, but I can’t get the query right. This one works: import requests import json apiKey = “**********************************************************” apiUrl = “https://api.monday.com/v2” headers = {“Authorization” : apiKey} query = ‘{boards (ids: 590638178) { name id description items { name column_values{title id type text } } } }’ data = {‘query’ : query} r = requests.post(url=apiUrl, json=data, headers=headers) # make request print(r.json()) Data returned: {‘data’: {‘boards’: [{‘name’: ‘M1-Weekly Schedule’, ‘id’: ‘**********’, ‘description’: ‘Board Owner: *******. Only **** can change data in Monday (dates etc). \\nView & Comment Access: All Management & Supervisors. \\n\\nFunction: MYOB Exo - Monday.com will only collect any new jobs “Pending Commencement” in MYOB Exo and place them in th

Hello there, I am trying to list items as explained in the title. Here is the query on which I still don’t get anything except a 200 OK - “No query string was present” message. "{\\"query\\":\\"{boards(ids:507039455){groups(ids:\\"duplicate_of_sso_extended__opt\\"){items}}}\\"}"

Hi folks - I’m attempting to create a notification via the API, using this query: mutation { create_notification ( user_id: 11227690, target_id: 373022691, target_type: Project, text: "This is a message" ) { id } } The user ID is my ID, and the target ID is an item ID for a board that I am the owner of. I get back this response: { "data": { "create_notification": { "id": "-1" } }, "account_id": 4751227 } No notification gets sent. I confirmed I can get notifications via automations, but nothing via the API. Any ideas?