API & Apps framework

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

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 something. Please let me know! Thank you. let Source = Web.Contents(https://api.monday.com/v2/updates.json?api_key=[Personal Token Here], [ que

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 me going is below: {"query":"mutation change_column_value($value: JSON!) {\\n change_column_value(board_id: {{36.board_id}}, item_id: {{36.id}}, column_id: \\"long_text6\\", value: $value) {\\n id\\n

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, res) => { console.log(req.body)

Hi all I am new to the API v2 and associated integrations, and need help getting my first integration to work…which I hope will also put all of the pieces of the puzzle together. I am using Monday and Integromat, but at the moment struggling to get the query to work in the Monday GraphQL sandbox. My use case: Use the create item mutation to populate multiple items on an established board, and their associated column values- which include multiple column types (including a tag column). For the tag column the tags don’t exist but I would like for them to be created automatically when the pulses on the board are added. The create items mutation will use variables to dynamically assign the column values in question. I have tried researching and reading every associated topic but just cant get past creating the item. Here is where I am at: { #declare column value variables $accountmgr = String! $accnumber = Integer! #create item mutation to populate existing board with pulses {mutation:($va

Hi, I have a problem with the graphQL API. I tried to create a new item and change a column value, but it’s not working for Date, checkbox and tag (but working for status and text). Here is my GraphQL code for tags: mutation { create_item (board_id: XXXX, group_id: “New”, item_name:“New”, column_values:“{"tags":[1669793, 1816394]}”) { id } } The error code is : { “error_code”: “ColumnValueException”, “status_code”: 400, “error_message”: “change_column_value invalid value”, “error_data”: { “column_value”: “[1669793, 1816394]”, “column_type”: “TagsColumn” } } Thanks a lot for any help !!

Hello, We just started working on an integration with Monday.com and there is something we can’t seem to figure out. Monday users access their workspace via a subdomain like mycompany.monday.com. Is there any way to find out that subdomain through the API? We need this information to be able to build URLs that would link back to the user’s board. If that’s not possible, is there any redirect system in place we could use? We need to be able to send our users back to their Monday workspace, and we also need the info to be able to create labels that differentiate between Monday workspaces if our users were to integrate with more than one workspace. Any help greatly appreciated, Denis

I am trying to pull email from GMail (Business) and create an item on a board with the contents of each message. To begin on this I’m just trying to create a new item on a board with test data in multiple columns. I found a previous message (now closed) that started to address this but the ending solution was not posted to the thread: Creating an item with columns populated What I have now is the following: mutation { create_item ( board_id: , group_id: “Incoming”, item_name: “NEW API created item”, column_values: “{ "Description":"Hello world", "email" :{"email":"test@test.com","text":"test@test.com"} }” ) { id } } It completes and creates an item, but the Description column is not populated. The previous message indicates that one has to use the numeric ID of the column instead of the “friendly” name, but I don’t know how to get it. What is the syntax for creating a new item and populating multiple fields, and how does one get the numeric ID for a column? Thanks,