Welcome to the new monday developer community
-
Recently active
Hello, we use Monday and Clockify and I am trying to automate the following processes (always from monday to Clockify) : When a board is created → create a client When a group is created within a board → create a project linked to client When an item is created inside a group → create a task in appropriate project I tried with the following : Zapier : but it has problems discriminating between board and sub-items creation (?) Webhooks : has no way to handle board creation events Integromat : works on a recurrence basis not on a per event basis, lacks some access to board properties and Clockify clients’ and projects’ properties So i am considering making this through PHP and the API but i need to handle board creation event’s in order to avoid to parse all our boards structure every minute… Any insight about where to start from ?
Hi, It is possible to create a link without http(s) but its impossible to update it without http(s). That is confusing. Is http(s) mandatory? If so the documentation should say so and it shouldn’t allow a link creation without it. Also is it possible to get something more explicit than a 500 error on that type of errors? I lost like 2 hours on it 😢 Cheers
I have been able to successfully us the “Try it Yourself” to create both query and mutation graphQL statements. Whenever I try to take these over to Postman and use the API, I contunually have issues…“query not found” Here is the latest: Try it Yourself Request: mutation {change_multiple_column_values( board_id: 312587506, item_id: 544770494, column_values: “{"date4": {"date":"2020-03-01"}}” ) { id } } Try it Yourself Result: { “data”: { “change_multiple_column_values”: { “id”: “544770494” } }, “account_id”: 4567162 } Postman request: URL: https://api.monday.com/v2/ Methid: Post Body: { “mutation”:“{change_multiple_column_values(board_id: 312587506, item_id: 544770494, column_values: {"date4":{"date":"2020-03-01"}}) { id } }” } Postman Reponse: { “errors”: [ { “message”: “No query string was present” } ], “account_id”: 4567162 } I have been able to get this to work with query instead of mutate, but at a loss why it does not recognize that there is graphQL string.
You can now also query the activity log via the Api. Unfortunately I can’t find any documentation about which fields I can query. Do you have more information? Thanks!
Hello! Is there a way to format the text of an update (bold, italic, bullets, etc.) when using the APIv2? Thank you for your answer!
I try to follow the example, but get this error: { “errors”: [ { “message”: “Unexpected end of document”, “locations”: } ], “account_id”: 3010465 } I attach a screenshot.
Hi, We are currently using Microsoft planner for internal measurements and progress of the team, we are also connected with Monday to provide reports to the management on the progress of each project. Right now we are duplicating our work by completing items on both platforms, appreciate if someone could share some insights on integrating Monday with planner Thanks, Pranith
Hi I was wondering is mondays.com can be used to fill in a job sheet in drobox? with the customers details? All details are entered onto a Monday’s calendar. Also manage a stock system, currently running in excel on 3 different tabs. I have engineers out on the road we assign them jobs via Mondays calendar feature. All the customer details are on the board. they mark the job competed and currently fill in and excel job sheet. document I was wondering if there is a way of when the engineer finishes the job, he can directly update the stock sheet to say what he has used? Is there anyone who can develop a system or recommend one? thanks in advance Alex
The duplicate command in the API is broken. I’m a full admin in my organisation but the api keeps returning the error: “User unauthorized to perform action”. The problem is that even though it returns an error, the duplicate action goes through and perform the action.
I’ve been using the API to send Mutations to Monday - these have been working well, but now these mutations are no longer running. I’ve not done anything with our API key, and that key still exists within our admin panel. There were a few small additions to items, but overall the items are the same. I checked my query, and even removed custom column modification on creation to just add items into the board to ensure use. No matter how I modify, this message keeps coming back: I’ve queried the board to ensure my ID’s are still relevant, and they are coming back correct… (sample query with successful data get of the board I’m trying to add to:) I have a message out to support to try and dig deeper as I’m thinking this could be API key related - but while I waited, I figured I’d post here to see if anyone has any insights.
Hi, I’m trying to query board for a specific column by column values, to see the costs of our use. data = ‘{“query”:“{items_by_column_values (board_id: XXXXXX, column_id: XXXX, column_value: 4 ) {id name }}”}’ The issue arises when I’m trying to query cloumn value by integer or float and not string. How can I query values that are integer or floats from a board? I’m using Python to do that if it matters. Thanks.
Hi guys, I just wanted to ask on how to get the latest replies the same way on how we get the updates. When I reply to the update, the reply is not showing. { updates(limit: 15) { id text_body body updated_at replies { body } item_id creator { id photo_thumb } } }
Testing queries at monday.com I’m unable to get past errors when trying to add column values via mutation. For example this query mutation ($columnValues: JSON!) { create_item (board_id: 123456789 , group_id: “topics” , item_name: “Item name” , column_values: $columnValues ) {id} } With these query variables { “columnValues”: “{"person":[{"id":12237196,"kind":"person"}]}” } Returns this error { “error_code”: “ColumnValueException”, “status_code”: 400, “error_message”: “change_column_value invalid value”, “error_data”: { “column_value”: “[{"id"=>12237196, "kind"=>"person"}]”, “column_type”: “MultiplePersonColumn” } } Simple text columns work but complex columns like people fail. The user id matches query users(king: non_guests) for example, also the id in the url in monday web interface. Do you know what am I missing?
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> /// <remarks> /// Query must be i
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 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
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.