API & Apps framework

Hi I need to extract BoardID name,itemID name and date created and date updated {“query”:"{ boards{ id name columns { title id type } groups { title id } items { id name group { id } column_values { id text value }}}} "} i use like above but i can find date column how to extract date with respet to item

Hello everyone I am building an integration app and would like to host it somewhere. But I’m not sure where this should be. Should I treat the app like a normal REST API built on node and express? Because that’s what I could comprehend. And in that case, should hosting services like Digital Ocean be good enough? This is my first app and I might not be making a lot of sense over here. So apologies for that. Highly appreciate any feedbacks. Thanks!

We’re working on improving our Glances app onboarding flow in Monday. Is it possible to know when an App was installed in monday? Or a way to know if it’s the current user’s first time to use the app? We’re trying to find a way to determine if the current monday user just installed the app so we can trigger certain things on our backend. We have the app webhooks installed, but I don’t know how reliable the timing is between when we get the actual “app installed” hook vs. when the user actually clicks the install button from the monday marketplace. Any ideas? Thanks!

i am trying to integrate from our git into monday and need to transfer the git’s ticket description into a long_text column. as the description can include markdown, it will include hashes and other special characters that seem to break the graphQL api (e.g. hashes are comments in graphql etc.) should be easy to fix if I knew the expected encoding for long_text api input strings. But could not find any. working in nodejs with raw data. First try (which works api wise but does not result in proper display of the texts): ` ${mutationName} : change_multiple_column_values( board_id: $boardid, item_id: 1273911846, column_values: "{ \\\\"name\\\\":\\\\"${gitlabIssue.title}\\\\", \\\\"text\\\\":\\\\"${gitlabIssue.title}\\\\", \\\\"long_text\\\\":\\\\"${encodeURIComponent(gitlabIssue.description)}\\\\" }" ) { id name } ` before I try all string encoding

Hi, Does the new version of the API (2023-10) include features to deactivate and delete users? Br, YH

Hello Monday.com dev forum! As the title suggests, I am trying to integrate Monday.com with Dialpad to send SMS Text messages. Only users at my current company will use it. My plan is to use Salesforce as both the integration endpoint as well as the database layer as that is where most of my experience is. The idea is that my workflow recipe will have an Authorization URL that is my Salesforce endpoint that will decode the JWT token and retrieve the userId, recipeId, and backToUrl. Then it will redirect to the Dialpad OAuth URL where the user will then login. Once they have successfully logged in, Dialpad will redirect to a different Salesforce endpoint where it will get the Dialpad API Key. The Salesforce endpoint will then save the userId+recipeId and API Key as a key value pair that can be accessed whenever the Workflow Recipe is fired. This seems like it would work in theory but I am running into some problems. When Dialpad succesfully authenticates and redirects to my endpoint, I

I am attempting to update a people column, with relevant teams to the user in the column. The mutation in the API playground appears to by syntactically correct, but returns a 500 error. I am very much a novice in this arena still and can’t seem to sort this out. The query is as follows: mutation { change_column_value( board_id: 11111111111111111 item_id: 22222222222 column_id: “multiple_person1” value: {personsAndTeams: [ {id: 12345, kind: “team”}, {id: 678910, kind: “team”}]} ) { id } } Any help would be appreciated.

I have a small JS page hosted on my own website that I have used to make an Item Feature. It works great in the feature “View Setup” page but when I actually install in on my board the title comes up but it’s blank. This is my first MDC app so it’s probably something trivial I don’t understand about the process. I have spent a few hours trying to understand this, re-reading the documentation, etc. -Doug

I am using an external service (Forms on Fire) to pull a list of Boards with their Groups into a table. I can pull a list of Boards and a separate list of Groups, but I need to have a field or column that links each board to its groups. Using GraphQL to query, then JSON path selector and response mapping to push the data into a table. The JSON response (when using the API playground or PostMan, etc.) returns each Board, with the groups and their properties underneath each board. However, once I parse this out into tables, I cannot access the Board Id in the Groups table. Has anyone tried something like this before? Thanks. JSON row Path Selector data.boards[].groups[] Query Below { “query”:“query {boards(limit:100) { name state id permissions groups { id title position color } }}” }

Hi, I use API calls to make entries in Monday from a source that generates data. After checking this source I can see it sends me exactly one Webhook. I make one Monday call with this data, and therefore expect one entry at a Monday Board. It has been like this, 1:1 for months. Suddenly in the last few days however, one API call into Monday is resulting in two identical entries in Monday. Is this a known glitch in Monday? Is there a cure? Anyone have any info on this? I am not sure how to debug Monday, but anyway, just curious for any with experience with this. Thanks

Can someone tell me why I might be getting an “undefined” promise (the promise state is fulfilled) when I execute the example code from the API documentation? I am assuming it has to do with user rights. I am an admin but it seems like there may be separate controls for what my code can do. Running this script from a server while logged on, in a seperate tab, to MDC. <HTML> <head> <script src="https://cdn.jsdelivr.net/npm/monday-sdk-js/dist/main.js"></script> <script> const monday = window.mondaySdk() monday.api(`{ users { id, name } }`).then(res => { alert(res); }); </script> </head> <body> </body> </HTML>

Hello, In 2023-10 there is this change: “Type changed: All IDs now use the ID type, not Int.” This page says: Migration guide - 2023-10 Version 2023-10 has some type changes to improve the consistency of our GraphQL API. Specifically, we aligned our schema so all fields representing numerical IDs now use the ID type. As a return value, it’s expressed as a string. When used in an argument (input), it accepts either string or integer values. If your app is strongly typed, your code may throw an error when this type changes because your application will expect an integer but receive a string. To solve this, please review your API calls to check if you use any affected fields. Then, ensure your code accepts both integer and string values. Note: Even though you could convert the strings to integers, we don’t recommend it, as the structure of these IDs may change in the future. The problem is that the column_values JSON string only accepts Int type and gives ColumnValueException if it is

Hi monday devs. We receive daily support request from users reporting that they receive the following error message when they run a General Caster integration: Your automation has failed due to a resource not being found. We discovered that this error is returned by monday when the app is not installed on the workspace where the integration is running on. By design, even if an app (like General Caster, featuring custom integrations) is not installed in a workspace, the user can add and set an integration up in his boards, but when he runs it the error is returned. So if you don’t want to change this behavior and keep showing an app available in the workspace where it’s not installed on, please change the error message with something like: The app is not installed in this workspace. Please enable it in the admin area. cc @Matias.Monday

Hi, I noted there is a change in the API, and I am no longer able to retrieve mirrored values through the webhooks text step as it returns me a warning instead of the actual values. How can I return the mirrored values of Item IDs from the item that I am querying from? Thank you.

Hey, We have a date column, which is connected to our Google Calendar. When an event created manually it is automatically created in Google Calendar. But if we create an event via API it will not sync with our Calendar until we manually change the date column. How can we make it work?

I want to create a board in monday which is similar to the image below. Its basically a high level table with different columns, each with specific computation of hours which is coming from another source table. For example, under the column ‘Capacity’, it will compute all capacity hours from the source table then show it on its respective month - from Jan to Dec. I had a play around with the GraphQL API and basically has a rough idea on how to do it, but it will be outside monday - that is using jquery, Datatables and probably other JS library/plugins. My worry is that if I do it that way, will I still be able to integrate it with monday.com (e.g. create dashboards out of it)? Or is creating a custom app the better approach for this? If it’s the latter, could you please give me some pointers/guidance on where to start? I’ve read some articles about creating monday apps, the monday SDK but is still lost at this point. Any input would be greatly appreciated. Thank you

mutation_query = f"“” mutation {{ change_multiple_column_values( board_id: “{board_id}”, column_values: ‘{{“{column_id}”:“{column_value}”, “ids”: {json.dumps(item_ids)}}}’ ) {{ id }} }} “”"

Hi, Here my query : mutation { change_multiple_column_values(item_id: 5272151240, board_id: 5264554251, column_values: “{"texte08":"'"}”,create_labels_if_missing: true) { id } } And i have an error : Parse error on “"” (error) at I use json_encode in php for encode string and seem monday api dont need to encode quote, how can i do ? Thank you

Hi there, I have created a code that can change the column values of clients name in the board, I want to put the code that i have created in monday.com so that i can use it later for automations , how to do that? Is there any way i can use that

hey, I’m creating new item through API and Im trying to add data to the dropdown column of label that not exist Im making this call on the Monday playground and the api call returns “200” but it’s not update only the dropdown column what am I doing wrong ? mutation { create_item (board_id: 4948663627, group_id: “topics”, item_name: “new item”, column_values: “{"name":{"name":"mondayTaskFeatureRequest.product"},"date4":{"date":"1993-08-27"},"text":"mondayTaskFeatureRequest.featureDescription","text5":"mondayTaskFeatureRequest.featureImpact","text2":"mondayTaskFeatureRequest.userId","dropdown4":"mondayTaskFeatureRequest.featureImpact", "dropdown4":{"text":"textt", "create_labels_if_missing": "true"}}”) { id } }

Hello, I am trying to use the new items_page_by_column_values, but keep getting the error “Field ‘items_page_by_column_values’ doesn’t exist on type ‘Query’” Here is the code used to make the request in Python: apiKey = os.environ['MONDAY_TOKEN'] apiUrl = "https://api.monday.com/v2" headers = {"Authorization" : apiKey} query1 = '{items_page_by_column_values (board_id: 123123123, columns: [ {column_id: "name" }]) { items }}' data1={'query' : query1} r1 = requests.post(url=apiUrl, json=data1, headers=headers) # make request print(r1.json()) Im assuming maybe Im using incorrect API version? Im really not sure. Any help would be appreciated. Thank you

I don’t think this is possible, but does anybody know of a workaround to query for a specific workspace by name? My only workaround is to create some sort of list storing all the names of all the existing workspaces and then checking with that to see if there is an existing workspace with a name.

When will monday.com provide a way for us to report back success/failure of queued operations, as the developer guidance recommends we queue events to handle API complexity limits? There are multiple strategies to work around the limitations, but every one of them has drawbacks. Reduced processing speed (retries), the risk of treating an event as duplicate that isn’t because the user repeated an action, increasing the likelihood an event never gets handled (retries). We continue to deal with customer issues related to queued events having to be reported as “success” to prevent retries - and then failing for some unrelated reason. Has anyone had good success with hashing the integration event body (or at lest inputFields) to create some form of idempotency? I’m just baffled that the trigger ID can be sent in webhooks but not the workflow action blocks.

query = f"“” mutation {{ change_column_value (board_id: {board_id}, item_id: {item_id}, column_id: {column_id}, value: “{client_name}”) {{ id }} }} “”" response = requests.post( “https://api.monday.com/v2/”, json={“query”: query}, headers=HEADERS ) if response.status_code == 200: print( f"API Response (Status Code: {response.status_code}):\\n{response.json()}" ) # Print the API response for debugging data = response.json() print( f"Update response for item {item_id} on board {board_id}: {data}" ) # Print the update response for debugging else: print("Bad Request: ", response.status_code) this giving me 500 status code

Hi I am doing some work in the dev playground and am getting a circular error. If I try this query: { boards(ids: 4036050693) { groups (ids:"Q3 2023 Engineering Squads") { title id items { id name } } } } I get an error response indicating it is a deprecated field. (Which we were told was going to happen) "extensions": { "warnings": [ { "message": "Replaced by Group.items_page in 2023-10", "locations": [ { "line": 6, "column": 7 } ], However, when I change the query to this: { boards(ids: 4036050693) { groups (ids:"Q3 2023 Engineering Squads") { title id items_page { id name } } } } I get an error message that reads the items_page is not available for this version of the API. { "errors": [ { "message": "Field 'items_page' doesn't exist on type 'Group'", "locati