General

Hello Anyone here can help get the column name from the settings and assign it on the const? Right now if you pull up the basic const textcopy = settings.textcopy; it would return the column ID is is possible to get the column name and assign it to another const? Thanks in Advance.

Can you execute “add_file_to_column” and “create_item” in the same mutation? If so does anyone have an example mutation? The goal is to upload a file to a column within the newly created item.

Hi, (Pardon if this has been raised before but as far as i can search, can’t find a similar posting so here goes…) I’m having a problem with create_item mutation. It works on localhost (tried PHP7.2 and PHP7.4) and returns a proper id but when we are running it in our test env server (cpanel with apache + PHP7.2.32), only “null” is returned. I’m starting to doubt that it is code related and perhaps related to PHP setup? Maybe we missed a prerequisite somewhere. Any help would be appreciated (Thanks in advance) I tried logging the returned JSON to compare [redacted some info]: LOCALHOST: Array ( [myItemName] => ignoreme1235 [columnVals] => {"numbers4":"1","status_1":{"label":"XXX"},"package":{"label":"XXX"},"task_date_1":{"date":"2020-07-31"},"client_name5":"ignoreme1235","client_name50":"ignoreme1235","phone":{"phone":"","countryShortName":"US"},"mobile_phone":{"phone":"","countryShortName":"US"},"primary03":null,"busine

Hello, I am having the same issue as here : API v2 - change people column error 500 - #5 by scumbletest But while no one answers my questions, I am trying with a new thread hoping someone will stop-by here 😉 Issue: Mutation for column value change with people column type returns a 500 issue. Here is my code: { “query”: "mutation {\\n change_column_value(board_id: 657972484, item_id: 627338655, column_id: “person”, value: "{“personsAndTeams”:[{“id”:11161799,“kind”:“person”}]} “) {\\n id\\n} }” } Thanks in advance for your help,

Hi All I’m using below code to upload file to monday.com with VB.NET Dim client2 = New RestClient(“https://api.monday.com/v2/file”) Dim request2 = New RestRequest(Method.POST) request2.AddHeader(“Authorization”, “XXXXXXX”) request2.AddHeader(“Content-Type”, “multipart/form-data”) request2.AddFile(“variables[file]”, “C:/test.txt”) request2.AddParameter(“query”, “mutation($file: File!) {add_file_to_column(file: $file,item_id:XXXXXXXX,column_id:”“files”“) {id}}”) Dim response2 As IRestResponse = client2.Execute(request2) I received an error {“error_message”:“Unsupported query”,“status_code”:400} I tried with escape "\\ and that gave the same error with VB.NET.

Hi! I just started the quickstart guide and wanted to start querying right away, but instantly hit a wall with GraphQL. BTW I love graphql and use it for my own projects and was excited to see that graphql querying and mutations are allowed. When running monday.api(`query { users { id, name } }`).then((res) => {console.log(res)}) I get: Error: Graphql validation errors It said I didn’t need a token but I tried a token anyway I’ve tried monday.setToken('apiKey') and I get errors: ["Not Authenticated"] I also tried monday.api(query, {token: "apiKey"}).then((res) => console.log(res)) and I get the same error: errors: ["Not Authenticated"] I tested my token in monday.com and it works great. I can query just fine.

Hi there. I’m using https://api.monday.com/v2 to create items from my VB.NET code. I was managed to do that without any problem. Now I need to upload some files to monday.com using APIs. I found this article Accessing and upload files using the GraphQL API. But couldn’t find any VB.NET or C# examples for add_file_to_column. Can somebody share a VB.NET or C# code sample for the add_file_to_column API call? Thanks in advance. Din

Is there any existing monday apps that we can allow the use of SAP to integrate with monday.com?

Hi! I am hoping someone has done something similar as I am having trouble. I have a client I am supporting to move from Podio to Monday.com. I am getting stuck on what’s the best way to pull the attachments and files in Podio to then attach them to the proper item in Monday. Any ideas or suggestions would be great!!!

Can you update link to columns through API v2? It would be nice if there were automation’s that if column values were empty, we could provide notification at a minimum. Thoughts? Doable now or is there a potential timeline for functionality like this. When I started with the Monday product; I would have thought it was a more mature platform. Don’t get me wrong there are a lot of great features, but there is lots of typical features that are still non-existent. Automation’s need to be beefed up as quickly as possible. Thanks…

simple query: { “query”: “{items(limit:50000){ name state board {id} group {title} column_values { title text } }}” } mentioned below is the error. I don’t see this when I query with lower limits like 1000. Is there any max cap till which I can query?? <html> monday.com is having some technical issues @font-face { font-family: Roboto; font-style: normal; font-weight: 300; src: local("Roboto Light"), local("Roboto-Light"), url(data:font/woff2;base64,d09GMgABAAAAACmQAA4AAAAAURgAACk5AAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAGoFOG5JCHDYGYACHDBEMCvRE3SMLg1oAATYCJAOHMAQgBYJ8ByAbpkIF7Ng0sHEA9uDsckZF2RRNBP9fEjgZQ6rxe01YhItQqVQqtbZKo6NSLXshCcvuamYvk1vBgLu/bcUlFh3Hac1oktcuX/oxUb\\ .......and so on

Hi everyone! 👋 I want to create drop down with default options, I have tried with defaults option but it is not working. Would anyone be able to help me out? 😁 Steps to reproduce Embed the SDK in an app Call mutation { create_column(board_id: <bordId>, title: "DropDown 3", column_type: dropdown, defaults: "{\\"labels\\":[\\"My label\\"]}") { id } } See the request fails Only create column without any default label Expected behavior There should be new column with default value which passed in default labels. Cheers!

I have tried to code in google script editor and i am not able to what is the issue is the query the code is pasted below. function makeAPICall(key, query) { var url = “api.monday.com/v2”; var options = { “method” : “post”, “headers” : {“Authorization” : key,}, “payload” : JSON.stringify({“query” : query}), “contentType” : “application/json” }; //Logger.log(options); var response = UrlFetchApp.fetch(url,options); Logger.log("API results: " + response.getContentText()); //return response; } function getValueMonday(){ var mondayAPIkey = “xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx”; var boardID = 457712781; var query = “mutation{create_item(board_id:457712781, item_name:‘name’){id}}”; var worked = makeAPICall(mondayAPIkey, query); Logger.log("Pulse ID returned was " + worked); } Th

Was trying to isolate an issue with Multiple column changes so limited to testing a single text column change in monday.com mutation {change_column_value (board_id: xxxxxx, item_id: xxxxxx, column_id:"waterbody_1" value:"{\\"testing\\"}") {id} } I still get the error { "error_message": "Internal server error", "status_code": 500 } Is there a way to get more details on the 500 error?

Hi! I have automated (or am attempting to create items in a board) using a Powershell script. The item name is based off of data from a SQL Server query. It so far works perfectly well, except for the fact that accents (é,è,à, etc) cause trouble when sending the webrequest. $url = “https://api.monday.com/v2/” $hdr = @{} $hdr.Add(“Authorization” , “Secret_key!”) $hdr.Add(“Content-Type”,“application/json; charset=utf-8") ###This mutation will NOT work: item_name = é $bodytxt ={“query”:“mutation{create_item(board_id:1234,item_name:"é "){id}}”}’ ###This mutation will work just fine: item_name = e $bodytxt ={“query”:“mutation{create_item(board_id:1234,item_name:"é "){id}}”}’ $response = Invoke-WebRequest -Uri $url -Headers

Good morning, i am trying the api v2 from “the try it yourself” editor, sending this mutation: mutation { change_multiple_column_values (board_id: xxxx, item_id: xxxxx, column_values: “{"stato": {"label": "Working on it"},"timeline":{"from":"2019-06-03","to":"2019-06-07"},"data":{"date":"2019-06-03"},"persone":{"personsAndTeams":[{"id":xxxxx,"kind":"person"}]}}”) { id } } i get back an internal server error code 500, if i remove this part: ,\\"persone\\":{\\"personsAndTeams\\":[{\\"id\\":xxxxx,\\"kind\\":\\"person\\"}]} then it work fine. where is the mistake? thanks

Hi all, Im looking to integrate Monday’s API with wordpress. The aim is when a monday item is created in a board copy the ID of the item. Move over to wordpress place the ID into a wordpress post and when the user saves that post as a draft it updates the status of monday based on the Monday ID. I have a rough idea on how to do this but does anyone have some good solutions to tackle this? Currently working with GraphQL and Gatsby to work with API. Thanks all, Ben

Hi I am trying to create a new item with values through the API, but it returns a 500 error. The columns is of a text type. I am following instructions from the API Reference. Did I get something wrong? Thanks.

Hi all, we perform some queries and mutations using Monday SDK on Node.js in an app installed on Firebase. We are experiencing extreme slowness. A simple webhook request -> Monday query -> some calculations -> Monday mutation can take several seconds (sometimes more than 10 seconds) from when the user changes a value in a board using his browser and sees the changes. In our logs we see that a single query can take 2 or 3 seconds to retrieve a result. Any hints on how to improve speed? Thanks for your help.

I’m running into an interesting issue while performing heavy queries. If the call takes longer than 60 seconds, I get one of two responses from the server. Both are errors, and both are in HTML body. One is a general 504 timeout warning. The second one is returned the page text below. After watching the timing, this happens at exactly the 60 second mark, so the timeout seems to be 60 seconds from the server. I’m not seeing this mentioned anywhere on the documentation. –returned page

Dear Monday Community, Is there a need for a simple & robust backup solution for Monday.com? My company has built an easy & secure backup solution for Podio.com that syncs their data to a readable format in Google Drive. This transparent approach has received lots of praise from the Podio community and we’re keen to do the same for Monday.com. Our users use our backup tool for 3 main reasons: Extra level of disaster recovery Extra restoration capabilities (>30 days) Business continuity during service outages We believe that an independent backup solution would add e

Hi, Not sure this post belongs here… I have a board that collects manufacturing data https://view.monday.com/206785215-09de7b40656ee79c5947f16457a580cb I would like to create a dashboard that automatically shows: Total Meters and total KG for - yesterday, last week, last month This cannot be done using dashboards, as dashboard don’t support automatically filtering the data (by day, week month) or showing data from “yesterday” so, my question is, how can i create a custom automation that creates such a a dashboard? thanks

I have an app with a trigger “When column change” and a custom action. The action is NOT triggered when an item is duplicated. Is this expected behavior?

As the title suggests, I am unable to get a formula column value using v2 APIs. The code I am using is as follows : Is there something I am missing?

this is similar to Define group color during group create so i suspect the answer is the same. i need to be able to set the position when i create a group (and the color too). currently new groups pick a random color and are created on TOP of the board. something like mutation { create_group ( board_id:xxxxx, group_name: "New Board", **position: xxxxx, color: xxxxx**) { id } } or much BETTER, add a mutation for update_group that allows those to be set. that way we could set color and position on an existing group (or freshly created one) without needing to delete and recreate a group.