API & Apps framework

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> /// <r

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

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}`, cr

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

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

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

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:

Linked page contains example functions using Go language to interact with API. Using Monday.com API With Go

I would like to drop the Monday API full technical documentation into Dreamfactory, using Swagger to then automatically expose and make available all of the endpoints. Is it possible to get the documentation? For both the V1 and V2 APIS?

Hi, In order to create graphQL queries dynamically I use the __type schema query in order to retrieve all the fields of the given entity. Some of the ‘metadata’ about the schema is not correct and fields are not describes as they should be. For example, when I query on Item entity I get that Subscribers field’s kind is NON_NULL when it should be OBJECT { “name”: “subscribers”, “description”: “The pulses’s subscribers.”, “deprecationReason”: null, “type”: { “name”: null, “description”: null, “kind”: “NON_NULL” } } The process of building dynamically query becomes much harder because you can’t expect how the field should look like and which fields to ask.

Hello! New to the community so this may just be a simple fix, but I’m trying to use the Power Query Editor in Power BI to pull in information from multiple boards within Monday.com. I’ve been able to successfully use the API v1, but it is very cumbersome since I’m pulling from multiple boards and I would like to get API v2 working. I’ve used the developer tool to test my query and I know it pulls the info I want: query { boards (ids:000000000) { items { name id column_values{ text } } } } But when I go into the advanced editor of my Power Query, and put in the following code it errors out. I’ve tried using the curl command and post command, but I might be missing som

Hey there, I’m a non dev, and just wanted to post this as I’ve spent the last 3-4 days on and off working out how to get the v2 API working with my automations in Integromat and thought some other non devs might like to do the same. While we wait for Integromat and Zapier to update their options for the new API v2, you can use standard HTTP modules in both Integromat (and Zapier (untested)) to simply push the data in yourself. I’m not a dev. I’ve never written a line of code in my life, but with the monday dev docs, and some mucking around in Integromat, I now have multiple mutations happening, with all sorts of column data types that you could not do with v1. Developer Docs v2 Finding Column ID’s I’ll attach a couple of screenshots in the post below, but the key piece of code that got m

Does anyone know how to correctly call Monday’s API to use the change_multiple_column_values mutation using Python? I’m running into an issue with the fact that the entire mutation call is required to be encapsulated in a string, combined with the backslash requirements of the API call. There is no way that I can find in Python to provide the appropriate string with ONLY ONE backslash as documented. For example, the following, converted to a complete string in Python, would either result in no backslashes altogether, or two backslashes (to force the backslash with an escape), either of which are then rejected by the API server when packaged into the JSON object and sent via requests: mutation { change_multiple_column_values (board_id: 12345678, item_id: 0987654321, column_values: "{\\"text\\": \\"My Text Here\\"}") { id } } Thanks for the help! B

I am using Zapier to create a new Monday pulse everytime a specific action happens in my CRM. The problem is that zapier only allows access to the pulse title so all my data is dumped in the title. I have created a node.js script that parses out the desired information and then mutates multiple column values you move that data into the appropriate column. I can’t for the life of me get it to work and the documentation is not helping. Any help would be appreciated. Here is my index.js file: const express = require(‘express’) const path = require(‘path’) const bodyParser = require(‘body-parser’) const PORT = process.env.PORT || 5000 const updateMultipleColumnValues = require("./updateMultipleColumnValue").updateMultipleColumnValue; const app = express(); app.use( bodyParser.json()); app.use(bodyParser.urlencoded({extended: true})); app.set('views', path.join(__dirname, 'views')); app.set('view engine', 'ejs'); app.post('/', (req,