General

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,

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!

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,

I was successful using the “try it” feature of the api docs to perform a mutation using variables. Now I’m trying to convert that syntax into a curl command. Even when putting data in a file (then referencing with @filename) in the curl command, the amount of escaping and quoting is driving me bonkers. All I ever get is a “400 Bad Request” in the headers, nothing to indicate what’s invalid. I’ve seen some sample updates with curl, but none with variables. Can someone post a working example please? Thanks!

Hi, How can I read dropdown labels? I only get ids. I use query like this: query { items (ids: PULSE_ID) { column_values (ids: "dropdown") { value } } }

I’ve come into an issue recently in which group title’s are the same regardless of the different boards they’re on even though on https://monday.com they’re different. Just a bit of an example: On https://monday.com we would have two boards that look something like this: Board 1 Groups { Monday 18th November Tuesday 19th November Wednesday 20th November Thursday 21st November Friday 22nd November } Board 2 Groups { Monday 25th November Tuesday 26th November Wednesday 27th November Thursday 28th November Friday 29th November } When retrieving the API data using GQL, Board 2’s group titles would be the same of that of Board 1’s. GQL Query

Hello, i’m working on synchronisation script beetween Monday and our businees internal solution. I want to get some private or shared boards datas via API, but the api is limited to admin users. How can permit a user to acces to monday with api, but without give the power of god ?

I need help connecting C # to APIV2 curl to read data! How I do? any examples? Thanks in advance : )

Can we get an example?

Anyone know how to subscribe users to a pulse item or mentione a user to know that new pulse was created. I tried create_notification and it notificate on monday but don’t send a notification email ( i have been activated the preferences email notifications). Thank you !

Hey all, I am trying to write a small program to query a board, return all items that have a certain flagged value, compare the data to an external source(probably a mySQL database), and finally return the data it finds from the database to the monday board item that matches the extracted values. Structured it will look like this: fetch monday data restructure data that is fetched use restructured data to perform a query in mySQL return the queried data update the monday board item based on id of data I have been working on some code, but I am not the most familiar with node.js or even javascript itself. This is what I have so far: const { GraphQLClient } = require('graphql-request'); var mysql = require('mysql'); //Create connection called 'client' that connects to Monday.com's API const client = new GraphQLClient('https://api.monday.com/v2/', { headers: { 'Content-Type': 'applicat

Hello, I am looking to create a new type of column for my company. I want to use a high level board to make tasks and in the pulse name include a hashtag like #revenue. Then set up some code that recognizes the hashtag and creates a relationship with every smaller task that has that exact tag in the tags column. I want this so I can see numerically how many smaller tasks are out there related to my big task. So If my big task is make 100k in revenue and I assign work to departments they can use the tag column and mark their smaller tasks with the #revenue tag, which allows me to look at my big tag and see ok 0/11 tasks connected to this one have been completed. As they mark the smaller tasks done my bigger task will update showing a task completed like 1/11…2/11…3/11… and so on. Any idea how to start this? Thanks, Ryan