API & Apps framework

I joined Monday.com few months back and I’m still struggling to build and setting up workflow that improves process. It looks easy enough to get started but once you put focus, you get lost easily and reach same place again and in the end, lose motivation. For example, word cloud and other sample recipe tells you about how to run a code. But being focused on functionality and how and why, it’s very difficult for me to build something. I have questions such as, → Suppose I am building, twillo integration then, I might want to provide API key or environment variable. Sometimes, every Monday user need to enter their credential or sometime just admin needs to setup while installing app (for example, for twillo api). how would I achieve that? → What really can be great is example app in multiple languages and what’s the learning curve and what does Monday recommend in which cases etc etc or partnering with some content creator to build app from scratch. → Are there any video tutorials th

Greetings everyone! I’m very new to Monday.com and GraphQL api system. My only requirement is to pull “All board names” available on my monday.com using c#, so I can eventually show them in a dropdown of my web application. I found this c# code on the forum but it is not working. I’ve generated the authentication token already, I just don’t know how to write query to pull public class MondayHelper { private const string MondayApiKey = "YourKey"; 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 in JSON, /// e.g. = "{\\"query\\": \\"{boards(ids: 1234) {id name}}\\"}" //

Hey added the columns field to my board view settings but it’s not working - just displays the word columns and not clickable. Other settings field types work, including column.

Hi guys, I’m kinda new to accessing APIs in general and I’m not really a coder. Nevertheless, I feel I must be close with this. Can anyone tell me how to fix my Power Query? It must be something super simple… API key redacted, of course. The Power Query editor errors saying “Token Comma Expected” and highlighting the colon after “boards (ids” in the following query: let Source = Web.Contents(“https://api.monday.com/v2/”, [Headers=[Authorization=“Bearer myapikey”, #“Method”=“GET”, #“Content-Type”=“application/json”]] { boards (ids:[000000000, 000000000]) { items { name id column_values{ text } } } } ), in Source

Hi I’m trying to send a mutation to create a new item on the board and populate all columns. Everything seems to work except for the “person” column. No errors in the response. request mutation { create_item (board_id: 505100819, group_id: "topics", item_name: "test_name", column_values:"{\\"person\\":{\\"id\\":12307363},\\"status\\":{\\"label\\":\\"Done\\"},\\"date4\\":{\\"date\\":\\"2019-06-03\\"}}") { id } } response { "data": { "create_item": { "id": "505328688" } }, "account_id": 5530601 } I’m kind of lost why is this not working

doing lots of other queries, but i’m having trouble formatting a change_multiple_column_values query. posting this json: {“query”:“mutation { change_multiple_column_values ( board_id: 655318672, item_id: 662694544, column_values: \\”{\\“date4\\”: {\\“date\\”: \\“2020-08-04\\”},\\“next_arr__days_7\\”: \\“9\\”,\\“property_id\\”: \\“1289\\”,\\“person\\”: {\\“id\\”: null},\\“numbers2\\”: \\“1.50\\”,\\“departing_rez\\”: \\“5146\\”,\\“status\\”: {\\“index\\”: 1}}\\“) { id } }”} returns: [errors] => Array ( [0] => stdClass Object ( [message] => Parse error on “: {” (STRING) at [9, 28] [locations] => Array ( [0] => stdClass Object ( [line] => 9 [column] => 28 ) ) ) ) putting the mutation text above on try it yourself doesn’t work UNLESS i remove the \\ from the \\" at the beginning and end of the column_values. so this does not work: mutation { change_multiple_column_values ( board_id: 655318672, item_id: 662694544,

we failed to insert record to Monday.com via api v2. got eror as: {“error_message”:“Internal server error”,“status_code”:500} for test push record below { “query”: “mutation{create_item( board_id: 154534478, group_id: "video_articles", item_name: "Test - Trump to Offer Optimistic Vision in State of the Union Address", column_values: {status:{index:15},status7:{index:19},status3:{index:15},person7:{id:10603717},article4:{index:13},eet_link:{url:"https://ntd.com/trump-to-offer-optimistic-vision-in-state-of-the-union-address_284634.html\\",text:\\"https://ntd.com/trump-to-offer-optimistic-vision-in-state-of-the-union-address_284634.html\\”}}) {\\n\\t\\tid\\n\\t\\tcolumn_values {\\n\\t\\t\\tid\\n\\t\\t\\ttitle\\n\\t\\t\\tvalue\\n\\t\\t}}}" }

I am looking to create Power BI reports on the content of my Monday.com boards. I’ve developed a query that looks like this (among many other attempts): let Source= (Csv.Document (Web.Contents(“monday.com: Where Teams Get Work Done”, [ApiKeyName=“key”]))) in Source It returns the code from the website… but I can’t see any tablular data to pull. Can anyone help on what I might need to do?

Hi, I’m trying to create a pulse via Node.JS with axios. I started with the example that is on this forum and edited it for my needs but I can’t get my code to add the column values for the pulse. What am I doing wrong? // Packages const axios = require("axios"), fs = require("fs"); // Files const config = require("../config.json") // Code const body = { title: "Test bug", culprit: "util/testers/monday.js" } const current = new Date() let month = current.getMonth() + 1 if (month < 10) { month = `0${current.getMonth() + 1}` } const axiosBody = { query: ` mutation ($boardId: Int!, $groupId: String!, $itemName: String!, $columnValues: JSON) { create_item ( board_id: $boardId, group_id: $groupId, item_name: $itemName, column_values: $columnValues ) { id }

Hi I’ve been looking over the GraphQL API for a while now and have been trying to find a way to update the status of an item. Can anyone point me in the right direction on how to update column values please? Thanks Scott

@rob Does General caster works with date given with a formula? My objectif is to put a deadline on a date calculated depending on the numbers of person working and the number of hours. I already have a column with the calculated date. I want to use general caster to import the value on a date column. When i try it gives me “ivalid date” Thank you very much! Best,

I have been testing the requests I have been sending both through Monday.com API tester and my own script and I run into the same issues, a 500 internal server error. I have been able to eliminate it as parse error. If it is a column validation error I am unsure where it is if it is there. mutation {change_multiple_column_values (board_id: *******, item_id: ******, column_values: {“ColumnID_1”: “Example Text”, “12345”, “Text_name1”: “No”, “text4”: " ", “status1”: {“label”: “Operating”}}) { id } } I am sending it as written below in a python script. Elsewhere in this script I have queried items so I know the API is working Mut2 = ' mutation ( $id: Int!, $columnVals: JSON!) {change_multiple_column_values (board_id: ********, item_id: $id, column_values: $columnVals) { id } }' vars = {'id' : ID, 'columnVals' : json.dumps(JSONdict)} dataUP = {'query' : Mut2, 'variables' : vars} Req = requests.post(url=apiUrl, json=dataUP, headers=headers

Hi, I am trying to create a new item and set the columns values from the beginning to avoid changing the values in a separate API call. mutation { create_item( item_name: "Name", board_id: ID, group_id: "GROUP", column_values: "{\\"date\\": \\"2019-01-20\\" }" ) { id } } This gives me this error: "error_code": "ColumnValueException", "status_code": 400, "error_message": "change_column_value invalid value", "error_data": { "column_value": "2019-01-20", "column_type": "DateColumn" Any suggestions?

Hello, I’m looking for something in the documentation that would show me how to update the “name” of the item in a board. I don’t see this in the documentation. Could someone help or point me in the right direction?

status column items_by_column_values query only works when value is a label and not an index value = status_label = "done" # query works value = status_index = 1 # query fails This query WORKS. query { items_by_column_values (board_id: 12345678, column_id: "status", column_value: "done") { id name column_values { id title value } } } These queries FAIL: (identical query, except the below column value) column_value: 1 column_value: "1" column_value: {"index": 1} column_value: {"index": "1"} column_value: '"{\\\\"index\\\\": 1}"' column_value: '"{\\\\"index\\\\": \\\\"1\\\\"}"' Is this a feature or a bug?

Hello, So I got everything set up in regards to Monday.com webhooks triggering and sending data to my app. The only issue I am having right now is - when a new item is created via the"New Item" button on a board, it is triggering the webhook w/ the default name it is given, which is “New Item”, instead of it being triggered once the item has been named after creation. Since there is no trigger for item name changes, we are unable to correct this without polling data straight from the API. Is there any way around this other than using the “+Add” button (Which waits until the item has been created/named before issuing a webhook trigger) We cannot gurantee everyone will use the +Add button every time so having it work via all avenues would be ideal. Thanks!

Hey Is there an API call that tells you how many items there would be in a particular query? For example I want to run a simple script to pull all items from a particular board, I have it paginated and embedded in a loop, how do I know how many pages I need to loop through? query test{ boards(ids: 000000000) { items(limit: 25 page: 1) { name column_values { title text } } } } Thanks

Currently I am trying to copy a board to Google Sheets and update it daily. I figured out how to delete rows and add rows, but am not sure what to do about updating rows. I see that an item has a last updated date for each column, but is there a master “item last updated” value that I can see? Otherwise it seems I would have to loop through each column and check it if was updated. If this is not available then I think I will just go ahead and delete all rows and then rewrite the board every time which is fine, but does not seem efficient. Thanks!

Hello! I’m trying to query a specific status column on a board so that I can pull in it’s available status choices for a custom form. Is the columns {settings_str} the only way to do this? this is the format I get back: labels: {0: “Status 1”, 1: “Status 2”, 5: “Status 3”} My hope was to get an array back that would be easier to iterate through. Is the above format my only option or is there a better way to query what I’m looking for? any help would be greatly appreciated!

Hi - Is there a limit to the number of status values that can exist for a specific status column?

I am trying to connect my webhook up and have the challenge console logging on the lambda function, so I know it is not my gateway connection or my lambda function. What am I doing wrong in the return?! Below is the code. exports.handler = event => { console.log( {“challenge”: JSON.parse(event.body).challenge}); return event.body; };

I’m trying to add a pulse to a group, all good but I want to insert a rating but regardless of how I try I can’t seem to do it: { “error_code”: “ColumnValueException”, “status_code”: 400, “error_message”: “change_column_value invalid value”, “error_data”: { “column_value”: “2”, “column_type”: “RatingColumn” } } I cannot find any documentation regarding types anywhere, the documentation is sadly very lacking.

Hi - Is there a way to query the v2 api for all existing status values in a specific status column?

I’m trying to find all the items assigned to a user. When I query a board, I get this response: query { items { name column_values { id value } } } ... "column_values": [ { "id": "person", "value": "{\\"personsAndTeams\\":[{\\"id\\":14983475,\\"kind\\":\\"person\\"}]}" }, ... But when I try and run this query to get the items by user, I get no response: query { items_by_column_values (board_id: 643168050, column_id: "person", column_value: "{\\"personsAndTeams\\":[{\\"id\\":14983475,\\"kind\\":\\"person\\"}]}") { id name column_values { id, title, value } } }

Hey, My monday account started to behave weird, and on the day of the contest submission… 😬 The board, not only my board view, is not loading some times (in another account of mine everything works) and things on the monday side are not displayed properly. See here. Others experience it too? Help by the monday team would be highly appreciated. Best, Ronen