API & Apps framework

Hi, We are currently using Microsoft planner for internal measurements and progress of the team, we are also connected with Monday to provide reports to the management on the progress of each project. Right now we are duplicating our work by completing items on both platforms, appreciate if someone could share some insights on integrating Monday with planner Thanks, Pranith

Hi I was wondering is mondays.com can be used to fill in a job sheet in drobox? with the customers details? All details are entered onto a Monday’s calendar. Also manage a stock system, currently running in excel on 3 different tabs. I have engineers out on the road we assign them jobs via Mondays calendar feature. All the customer details are on the board. they mark the job competed and currently fill in and excel job sheet. document I was wondering if there is a way of when the engineer finishes the job, he can directly update the stock sheet to say what he has used? Is there anyone who can develop a system or recommend one? thanks in advance Alex

The duplicate command in the API is broken. I’m a full admin in my organisation but the api keeps returning the error: “User unauthorized to perform action”. The problem is that even though it returns an error, the duplicate action goes through and perform the action.

I’ve been using the API to send Mutations to Monday - these have been working well, but now these mutations are no longer running. I’ve not done anything with our API key, and that key still exists within our admin panel. There were a few small additions to items, but overall the items are the same. I checked my query, and even removed custom column modification on creation to just add items into the board to ensure use. No matter how I modify, this message keeps coming back: I’ve queried the board to ensure my ID’s are still relevant, and they are coming back correct… (sample query with successful data get of the board I’m trying to add to:) I have a message out to support to try and dig deeper as I’m thinking this could be API key related - but while I waited, I figured I’d post here to see if anyone has any insights.

Hi, I’m trying to query board for a specific column by column values, to see the costs of our use. data = ‘{“query”:“{items_by_column_values (board_id: XXXXXX, column_id: XXXX, column_value: 4 ) {id name }}”}’ The issue arises when I’m trying to query cloumn value by integer or float and not string. How can I query values that are integer or floats from a board? I’m using Python to do that if it matters. Thanks.

Hi guys, I just wanted to ask on how to get the latest replies the same way on how we get the updates. When I reply to the update, the reply is not showing. { updates(limit: 15) { id text_body body updated_at replies { body } item_id creator { id photo_thumb } } }

Testing queries at monday.com I’m unable to get past errors when trying to add column values via mutation. For example this query mutation ($columnValues: JSON!) { create_item (board_id: 123456789 , group_id: “topics” , item_name: “Item name” , column_values: $columnValues ) {id} } With these query variables { “columnValues”: “{"person":[{"id":12237196,"kind":"person"}]}” } Returns this error { “error_code”: “ColumnValueException”, “status_code”: 400, “error_message”: “change_column_value invalid value”, “error_data”: { “column_value”: “[{"id"=>12237196, "kind"=>"person"}]”, “column_type”: “MultiplePersonColumn” } } Simple text columns work but complex columns like people fail. The user id matches query users(king: non_guests) for example, also the id in the url in monday web interface. Do you know what am I missing?

Hello fellow humans, Here’s a basic snippet of C# that let’s you execute queries against the v2 API and return the response as JSON. For some this may be old hat, but it took me a good couple of hours of mucking about - so hopefully it can save someone else that time in the future! For convenience I’ve created a little helper class to encapsulate the call and return; using System; using System.Collections.Generic; using System.IO; using System.Net; using System.Threading.Tasks; namespace Monday.lib { public class MondayHelper { private const string MondayApiKey = "your-api-key-goes-here"; private const string MondayApiUrl = "https://api.monday.com/v2/"; /// <summary> /// Get a JSON response from the Monday.com V2 API. /// </summary> /// <param name="query">GraphQL Query to apply to the Monday.com production instance for Grange.</param> /// <returns>JSON response of query results.</returns> /// <remarks> /// Query must be i

Hi, We are importing a bunch of things from our previous PM tool, and that includes comments/updates. We have managed a script that loads all the items, and then all the comments linked to the right item, but it seems that the API chooses the Admin for the creator of all those updates. Is it possible to choose a user/creator for the updates created (or even better, a field identifying a creator for each update) in the current API?

Hi All, I am trying to send the Link type column value to Monday.com but it is giving an undefined error. The Web URL has some special characters as well other than a slash ‘/’. Example:- “{\\“url\\”:\\“https://monday.com/developers/v2#column-values-section-link\\\\",\\\\“text\\\\”:\\\\"go to monday API!\\”}” Everything is working fine if I remove the above thing from the whole query but not if I include it in my query. Thanks

Hey, any hints on how to get/query all items from a board? I have been able to use items_by_column_values to get items with a specific Column value, but how can I get all items without any filtering?

Attempting to push a record (item) to a board from an Excel DB using VBA. The script adds an item as intended from the try-it-yourself utility. (I built the script in the code and captured it from the function [strJSON] just to make sure it was identical.) The token (strToken) was taken from my account page, and was used in the utility as well. So, I am certain that there are no errors in the script, but just for clarity, here it is: mutation { create_item( board_id: XXXXXXX, group_id: “topics”, item_name: “My Company”, column_values: “{"text8":"Me","date4":{"date":"2019-11-10"}}”)} I cannot get it to rpocess the added item using VBA. My code is: Dim http As Object Set http = CreateObject("WinHttp.WinHttpRequest.5.1") http.Open "POST", strURL, False http.setRequestHeader "Content-Type", "application/json" http.setRequestHeader "Authorization", strToken http.Send strJSON PushToMondayPM = http.responseText strError = http.statusText Set http = Nothing The responseText is empty, and th

Hello, I use your API to generate a pulse when I move an email to a specific Outlook folder via a webhook. Everything works well but I would like to be able to send an email from my application to an update of this pulse in batch. And there the email does not arrive while if I send a mailbox, it works. Does the monday API block emails from batch? I’m sorry for my english

I’m an experienced developer but a Monday n00b. I asked Support whether there is an automation for: When an item moves to Group change status to something but they replied “no”. Can I do this using the API instead? Thanks Wayne

Good afternoon, Is it possible to fill Monday.com Form using the GET method? For example, name1=firstValue&name2=secondValue&name3=thirdValue appended to the end of the URL would fill in the approrpriate values. Thanks for reading!

Hi all, I’m trying to create items on my own board using garphql, axios and nodejs. for some reason when i try to send the columnValues i get the followong errMessage: errors: [ { message: 'Variable columnValues of type JSON! was provided invalid value', locations: [Array], value: null, problems: [Array] } ], and here is what i’m doing 🙂 const createItem = { query: ` mutation ($boardId: Int!, $groupId: String!, $itemName: String!) { create_item ( board_id: $boardId, group_id: $groupId, item_name: $itemName, ) { id } }`, variables: { boardId: +BOARD, groupId: "topics", itemName: `${title}`, } } axios.post(`${URL}`, createItem, { headers: { Authorization: `${KEY}` }

Hello I am trying to change a column value from c# application i make the following query string query = @“{”“query”“:”“mutation{change_column_value(item_id:456191942, board_id: 454686247, column_id: ““numbers””, value:”“”“123456"”“”){ name}}“”}"; But it seems something in my escaping of the string is not right and I get bad request! I am begging for some help! I have been struggling with that for two days. if someone has c# code to help me I will be so grateful.

I have a mutation that works perfectly via the graphql tool but cannot format the expression in C#. I tried many different approaches and I’m not looking for help in how to build a C# string with the following mutation. Thanks ahead of time for the help!! mutation { create_item ( board_id: 299576913 , group_id: “status32” , item_name: “Test Monday API V2-2” , column_values: “{"text5":"Chris", "site1": {"index":"2"}}”) { id } }

Hi there, I’ve been using the Monday API to automatically post updates to a board for several weeks now. One of the columns that I’m changing is a Date column. Starting yesterday, all of my requests to change columns of this type have returned 400 errors, with the message: { "error_code": "ColumnValueException", "status_code": 400, "error_message": "change_column_value invalid value", "error_data": { "column_value": "{\\"date\\"=>\\"2019-11-1\\", \\"time\\"=>\\"12:39:00\\"}", "column_type": "DateColumn" } } My query, obviously, does not have “=>” in it. My query looks like this: mutation { change_column_value( board_id: 12335234, item_id: 2312342341231, column_id: date, value: "{\\"date\\":\\"2019-11-1\\", \\"time\\":\\"12:39:00\\"}" ) { id name column_values { id text value } } } whi

A lot of my guest users are missing their view of shareable boards in their individual accounts. I have checked to make sure my guests are still subscribed to the boards which they are. Please look in to this asap.

I am using Powershell to generate a create a new item to a Existing sheet. The code I have generated that is being submittted, is generating the following error. StatusCode : 200 StatusDescription : OK Content : {“errors”:[{“message”:“Variable brand of type String! was provided invalid value”,“locations”:[{“line”:1,“column”:10}],“value”:null,“problems”:[{“path”:,“explanation”:“Expected value to not be null”… RawContent : HTTP/1.1 200 OK the code is as follows. (I have redacted some to protect the Innocent 😃 ) { " variables": { “cols”: { “prelim_die_lines_actual”: { “date”: “2019-11-27” }, “person”: “J J L”, “date5”: { “date”: “2019-11-22” }, “date60”: { “date”: “2020-01-12” }, “products_actual”: { “date”: “2019-10-10” }, “date2”: { “date”: “2019-11-22” }, “job__”: “63344”, “pog_approva_actual”: { “date”: “2019-11-07” }, “date8”: { “date”: “2019-12-30” }, “date52”: { “date”: “2019-12-19” }, “pog_submission_actual”: { “date”: “2019-

Hi, I keep getting error 500 when running my query. I tested the query several times on the “Try It Yourself” page, and what’s even weirder is that it worked a few days ago, but then stopped… import requests Headers = {“Authorization” : “[My_V2_Token]”} MondayURL = “monday.com | A new way of working” RequestData = {“query”:“query { boards (ids: [BoardID]) { items { name, column_values {id, text}}}}”} Request = requests.post(url=MondayURL, json=RequestData, headers=Headers) Request.status_code() 500 Any insights?

I am trying to get all tasks that have the “Status” column set to a specific value. – payload = {“query”: “{items_by_column_values(board_id: 226020274, column_id:"Status", column_value:"Done"){id name column_values{id value}}}”} r = requests.post(url_api, json=payload, headers=headers) print (r.text) – gets me : {“data”:{“items_by_column_values”:},“account_id”:XXXXXX} Where am i going wrong ? I am sure that the board id exists (tried with all my board_ids) and that the status column is that exact name

Hello there, I’m still new with Monday.com V2 API. Querying column_values is returning and duplicating the same exact first data retrieved for each column_values data on the entire query. I was trying to query column_values from each groups, but I had a problem: every single data from each column_values is the exact same as the first column_values retrieved. This is weird because when I tried the same query with GraphiQL service provided by Monday.com API it’s showing the data that’s supposed to be shown. My query: query($board_id: [Int]) { boards(ids: $board_id){ groups { id items(limit: 3, page: 1){ id name column_values{ id text } } } } } Data retrieved: (I’m getting the same data for each column_values) { "data": { "boards": [ { "groups": [ { "id": "new_group", "items": [ { "id": "430013349", "name

Hello! I have written the following mutation on the “try-it-yourself” page, and it works flawlessly. mutation { change_multiple_column_values(board_id: XXXXXXXXX, item_id: XXXXXXXXX, column_values: "{\\"text\\":\\"test1\\", \\"numbers7\\":\\"0\\", \\"date\\" : { \\"date\\" : \\"1955-10-28\\" }}") { id } } However, the next step in the process for me is to integrate this into Java code. I have managed to post the data with authentication and so on which works fine. However I struggle greatly with formatting the body correctly so that the above mentioned query gets executed. Could anyone kindly help me as I am at a loss how to actually format it correctly? At the moment the error code I get by the post is code 400. I have tried many different variations to no avail with my latest try being the following: String body = “{ "query" : mutation { change_multiple_column_values(board_id: XXXXXXXX, item_id: XXXXXXXX, column_values: {"text":"test1", "numbers7":"0", "date" : { "date" : "1