API & Apps framework

I’m interested in doing a sweep over all data items of interest in a periodic manner. In order to be efficient, I only want to scan items that were created / updated since my last run. I’m not seen this possible on most (maybe even all) types of GraphQL queries. Any tips before I basically replicate some of the data on my side and manage this? (which will be very silly since I’ll need to count how many results I have and offset my request with a page number, far from ideal).

Hi There, I’m trying to implement the example in the quickstart guide to learn how to build a custom integration: https://monday.com/developers/apps/quickstart-integration I followed every step. At the end, I’m able to add this integration to a board. The field selection is ok. But the endpoint is never called when the text is modified. If I make a postman request to the ngrok server, I can see it, it works well. I tried with another endpoint from one of our servers, but the result is the same: the enpoint is never called. I tried with the “item added” trigger => same problem. What could I miss?

Hi, sorry with this basics questions, but i need help. Im dealing with creating the Monday.com suggested integration to detect a text change in one text column and put his content in another text column. Im having two questions: I was able to create it following all the steps, but the created recipe doesnt allow me to select and change the target text column (i have followed all the previous steps). What s this all about? Why i have to run the app from a local server? Again, i was able to to this but like a robot, not understanding anything. The steps mentioned an number 2, they are needed to do on every app i build??? (probably i will not be able to built anything but i ll try 😃 😃 :smiley) I’m starting from far behind give me a chance please thanks

Hi community! let’s see if you can solve my problems. I’m trying to create a pulse with post http from java and i recieve that error message: “No query string was present” I’m sending a String : String data = “‘mutation’ { ‘create_item’(board_id: xxx, group_id: ‘topics’, item_name: ‘Api created’) {id}}”; And content type application/graphql If anyone can help me please! Thank you!

Hi - I am kinda new to GraphQL and I am trying to write a code that will update a column in my board with data from a .csv file saved to my drive. I tried running the code but get this error message: TypeError: not all arguments converted during string formatting Code: for index, row in dataframe.iterrows(): Availability = str(row[‘Availability’]).replace(“,”, “”) item_id = str(row[‘ID’]) mutation = ‘’’ mutation { change_column_value(board_id: 309020018, item_id: 309020024, column_id: “Availability”, value: “"500"”) { id } } ‘’’ % (item_id) print(mutation) result = client.execute(mutation) print (result) I would love any feedback that can be provided! Thanks!

Hello there, Question are you able to edit generating the ID Number. Example ID number generated by monday.com 623677836 9 Digits generated. But I want to decrease the digit number to 5 like 62367. Or even maybe be able to include some letters like YX623. Is that possible?

Hello, Is it possible to use the V2 API to make queries based on a text search? For instance, fetching all the Items that have “mytext” in their name. I would like to be able to do that for several entities, namely Items, Users, Boards, Groups… Is such a thing possible and if yes, how? Thanks

Hi, I am using Monday API v2 service to develop an integration service.I am struck on how to develop following two triggers. 1.Trigger when item moved from a group. 2.Trigger when item updated. Please suggest a way if possible to implement these through the API v2.I could not found any solution in the documentation.

Hello, We are currently using API v2 to update certain statuses on one of our boards. We face a certain issue where one or more of the columns are updated, and reflected for once but then revert back to previous value on the board. The change from the previous value to updated value is present in Activity Log, however, this unexpected revert back to previous value is not present in Activity Log. In our case this happens randomly, and also we only find it to happen when there are two or more calls simultaneously to monday.com API v2 to update an item’s different columns. If someone can help resolve/understand this behavior, it would be great. Thanks!

We are relatively new to Monday.com use. We are trying to create a means to save, edit and track patients within our medical practice. We are involved in Clinical Trials, where we need to develop a means of tracking the patients from their application to enroll, to gathering med records from their providers, to enroll them in study, carry out procedures (stem cells in this case), and tracking their progress with questionnaires, imaging studies, laboratory blood work (in some), and their diary of changes noted. We are a bit lost in development of the individual headings, entries, etc. If there is someone in the Western MT area that provide tutorial help in development, or some location who is willing to share their utilization of Monday.com capabilities, we would be most interested. The program appears to have the full project management capabilities needed, but need that help in making it easier to use and still track (with ticklers if possible) the steps from starting to a 1 year f

Can someone post an example code of how to track the status of completed task ?

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