General

I have the following code for sending an API request from my Google App Script: function sendApiRequest(query) { var sendQuery = JSON.stringify(query); var options = { 'method' : 'post', 'headers' : { 'Content-Type': 'application/json', 'Authorization' : key }, 'payload' : sendQuery }; var response = UrlFetchApp.fetch(apiUrl, options); Logger.log(response); return parseResponse(response); } When I’m trying to send a mutation query in order to update an item, I’m using the following query: mutation { change_multiple_column_values (board_id: 20178755, item_id: 200819371, column_values: “{"status": {"index": 1}}”) { id } } The problem is that in the column_values: "{\\"status\\": {\\"index\\": 1}}") section I need to have double quotes wrapping my JSON.Stringfy values, which I’m just unable to make it happen. The JSON Stringfy process either add escape or remove the quotes.

Hi, I;m failing to get progress columns value. Here is what I did. Request Query: query { boards(ids:[5xxxxxxxxx], limit:1) { items { name group { id } column_values { id value text } } } } Response Data: … { “id”: “progress”, “value”: null, “text”: “” } …

What’s the best practice for securing custom views? The documentation obviously shows how to setup an application accessible via an ngrok URL, but I don’t see any reference to best practices for securing views. https://monday.com/developers/apps/quickstart-view Do we add authentication in the view? Pass data into the iFrame? Something else? Sorry if I am just missing something, but didn’t see anything links in the documentation for View security.

Hey everyone, I am new to Monday app. I want to build an application using monday.com could u please guide me in it?

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.

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 need

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

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" : "Ne

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

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.

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.

This is where you can share apps with the community and see the apps other developers have built! The apps shared here are provided by the community as use-at-your-own-risk and are not reviewed by monday.com. Before you post We encourage you to post your apps here for our community to use! We ask you to be considerate and make sure the app follows these guidelines: Is appropriate for this audience Adds value - no test or hello-world apps Uses appropriate language Does not violate privacy or security guidelines

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);