API & Apps framework

Hi, We have to use the v1 API at the moment; yes, understand goes away soon. Does there exist an endpoint to retrieve the current user id / email, similar to other APIs, e.g., something such as https://api.monday.com/v1/me, e.g., Hubspot’s is https://api.hubapi.com/integrations/v1/me. We’re unable to find in the v1 Guide on Support or the v1 Docs on developer.monday.com. P.S. will eventually need for V2 and can’t locate corresponding GraphQL endpoint either. Thanks, James

Hello, I’m new to the API here, I’m testing a sample call to create items on a board - but when I call to the API I’m getting a message back stating “Group Not Found”. Here is the board I’m trying to add an item to: I’m trying to add it with the following query: mutation { create_item (board_id: 455625781, group_id: "leads", item_name: "King Arthor", column_values: "{\\"phone_number\\":\\"2182134567\\",\\"bike\\":\\"B01231231\\",\\"created_date\\":\\"2019-02-10\\"}") { id } } I’m getting back the error: { “error_code”: “ResourceNotFoundException”, “status_code”: 404, “error_message”: “Group not found”, “error_data”: { “group_id”: “leads”, “board_id”: 455625781 } } I’ve tried renaming the group to all lowercase - tried different groups on this board, many different things, but no matter what I do, I get the “group not found” error - please help!

I’m trying to create a new item in a board , and am passing a JSON object containing the column_values for several columns. I’m having luck with certain text columns. But others, The API returns the following error { "error_code": "InvalidColumnIdException", "status_code": 400, "error_message": "This column ID doesn't exist for the board", "error_data": { "column_id": "email" } I am getting the error even though the column ID does indeed exist in the board. { "id": "email", "text": "email@email.com", "title": "Email", "value": "{\\"email\\":\\"email@email.com\\",\\"text\\":\\"email@email.com\\",\\"changed_at\\":\\"2020-01-24T04:36:25.922Z\\"}" }, Any Insight? These are the variables that I am passing to the mutation. I can get this to work for the simple text field or a group of two text fields , but get the above error when passing the email column id. {"name" : "NewCo Insomnia", "group" : "groupID", "JSON": "{\\"text7\\": \\"ready 7\\" , \\"email\\

I need help connecting C # to APIV2 curl to POST data! How I do? any examples? Thanks in advance : )

Here is my code: #!./python36/bin/python3.6 import requests import json import sys, subprocess, datetime, json, math def querySprintDetails(api_key, board_id ): headers = {"Authorization" : api_key} monday_url = 'https://api.monday.com/v2' # store request body in a dict, including variables req_data = {"query" : "{boards(ids:%d) { \\ items { \\ id \\ name \\ column_values{title text} \\ group{title} \\ }\\ }}"%(board_id)} # make HTTP POST using requests r = requests.post(url=monday_url, json=req_data, headers=headers) if r.status_code != 200: # throw exception print('Status:', r.status_code) return -1 return r r = querySprintDetails( api_key, board_id ) When I run directly this works. Whereas when I try to sched

Hello, I try to use API v2 console with this request: mutation { change_column_value ( board_id: 493115024, item_id: 496948433, column_id: “email”, value: “{\\"email\\":\\"a.b@gmail.com\\",\\"text\\":\\"a.b@gmail.com\\"}”) { id } } The board exists and item exists - I used this query before: query { items_by_column_values (board_id: 493115024, column_id: “email”, column_value: “o@a.com”) { id } } received response: { “data”: { “items_by_column_values”: [ { “id”: “496948433” } ] }, “account_id”: 5856938 } So when I attempt to change the email value, I keep receiving internal server error 500. I researched the forum and tried many things. But any complex value requiring {} substructure returns me the error 500. What’s going on?

Hi, new user here, but I’ve searched and can’t find the answer. Can I change the order of boards within a folder? Each time I create a new board it pops up at the top, but actually I need them to add in order of importance. Is this possible to move boards within the folder? Thanks Lisa

How do I empty a people or person column? I can’t find any documentation (or forum posts) for this. Thanks in advance.

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 🙂