General

Does Monday.com provide option to query the database using SQL via ODBC connection or any other method. The accounting team wants to add SQL query to their Invoice Reconciliation and pull the Invoice Status from Monday.com. Business already has an Excel expert who will add SQL/code to the Excel file. From IT they want to know if it is possible to query Monday.com database and will we grant the query access?

Hi devs, is there a way to retrieve the item terminology thru API? Thanks.

Hi monday.com community! We are happy to share some great news! VLookup now supports formula columns, which can be used to connect formula type columns from one board to the next while keeping the automation functionalities. This means you can easily integrate data and acquire key insights across several boards, resulting in a more simplified and efficient workflow than ever before. We’ve put together a brief demo that will blow your mind to show you what’s possible with this fantastic new feature. Check it out and prepare to be blown away by the power of VLookup! To learn more, please feel free to send us an email at appsupport@jetpackapps.co. You can also refer to our documentation for additional information or simply install our app directly from the marketplace.

Hi there, I would like to set column settings during its creation (or after via an update). I can’t find any way to do this in the GraphQL API documentation. Do I miss something? Else, would it be possible to add a mutation parameter ? Something like “settings”: mutation { change_column_metadata (board_id:123456, column_type: dropdown, title: "My Dropdown", settings: "{\\"hide_footer\\":false,\\"labels\\":[{\\"id\\":1,\\"name\\":\\"test\\"},{\\"id\\":2,\\"name\\":\\"123\\"}]}") { id, settings_str } } Thanks in advance for your answers

Hello, I am trying to get access_token to make API calls on behalf of users into monday account. ( Following: OAuth and Permissions). I have got the auth_code but when I request access_token using (code, client_id, client_secret) I get cors error. CORS issue is from server side so what might be the issue? Here is my request sample code: const details = { code: params.code, client_id: CLIENT_ID, client_secret: CLIENT_SECRET } fetch(TOKEN_ENDPOINT, { method:'post', headers: { 'Content-Type': 'application/x-www-form-urlencoded' }, body: details }).then(async(res) => { const data = await res.json(); console.log("Data==>",data); }).catch(err => console.log("Err==>",err)) Please have a look. waiting for the response. Thanks!

Hi, I’ve had a workflow running on quite a simple query for a month or so, only just this week it’s starting to come back with an error: “Query has depth of 9, which exceeds max depth of 6 at line: 2865 called from: 2877 called from: 3190 called from: 2602 called from: 226 called from: 1246 called from: 2846 called from: 2883 called from: 3187 called from: 2602 called from: 226 called from: 1246” The API call is relatively simple; mutation { create_board (board_name: “xxx”, board_kind: public, template_id: 123456789, workspace_id: 1234567, folder_id: 12345678 ,board_owner_ids: [12345678,12345679]) { id name state }} Any ideas what am doing wrong? Or anything I can change to fix?

Hi there, I need a GraphQL for taking the activity log of the sub-items. I only found some examples for taking the activity logs of the (parent) items, but not for the subitems. In this example, I can specify the ids of the items (via ‘items_ids’), but it returns nothing if I enter the id of a subitem. Also it does not support something like ‘subitem_ids’. query { boards(ids: 1161879462) { activity_logs (item_ids: 1161879467){ created_at data } } } Is this supported by the GraphQL/api? If yes, how can this be done? Thanks. D. Mon

Hi, I’m a little bit confused about the app setting. I added a checkbox to my app view setting and in the code I added a listener to any user changes on setting. monday.listen("settings", res => { console.log(res.data); }); It’s work great of a single user. If user A change the setting checkbox to true, the app that runs for user A will get the event of the change. And user B won’t get any change, as I expected. But if user B will reload the page, the button will be load as true. If this is a global customize view for all the users, then why user B doesn’t get the event listener of the change? If the customize view is unique for each user, why user B settings change after reload? Thanks

We’re excited to announce the new monday tunnel! We’ll be moving away from using ngrok and localtunnel in our applications in favor of our own development server. What is changing? When setting up our starter apps, we will expose your local development server with our very own mondaytunnel. After running your application, you will receive a URL that will look similar to this: https://white-bullfrog-0.tunnel.monday.app Be sure to check out our example apps in our Integration, Views & Widgets guides.

Hi everybody, We are developing an App which returns a Status Column to its previous state without creating an infinite loop (can happen when an integration/automation changes status X to Y and another integration/automation changes status Y to X). We managed to do it as an integration because when we use the receipt as an integration Monday’s payload sends us the correct previousColumnValue (from the receipt action). However, when we use it as an automation (by checking the Enable to Publish option in the Workflow Blocks) we get the current status (not the previous). Are we missing something? or is it a potencial bug? Thanks.

Hi, This is about graphQl APIs which is returning HTTP 500 error when invalid or non-existing ID is passed in the query. For E.g. mutation { archive_item (item_id: 123) { id }} Here item_id is non-existing and it returns me below 500 error. {"error_message":"Internal server error","status_code":500} This is not same for all APIs. For retrieve groups if I provide invalid ID it return me empty array Query: query { boards (ids: 123) { groups (ids: topics){ id title color position deleted items {id}}}} Result: { "data": { "boards": [] }, "account_id": 11771408 } Is it possible to have consistent response in all the cases.

I have more than 6000 subitems on my monday.com board. How can I fetch the count of subitems in a one go using query.

I’m having trouble validating my URL for Webhooks. I am capturing the challenge token and writing it to a logs table in my MySQL DB so I know that I am receiving the challenge, however, the below script does not work. Any insight would be much appreciated! < script type=“text/javascript” > app.post(“/”, function (req, res) { console.log(JSON.stringify(req.body, 0, 2)); res.status(200).send(req.body); }) < /script >

Hi there, We recently got our application for monetization approved, and I am integrating the monetization SDK on our app - https://monday.com/marketplace/10000012 The SDK documentation says that I should be expecting a app_subscription object as response to the context query, but I am not getting it Here is the response to monday.context {"method":"get","type":"context","data":{"theme":"light","account":{"id":"7403972"},"user":{"id":"17067431","isAdmin":true,"isGuest":false,"isViewOnly":false,"countryCode":"IN","currentLanguage":"en","timeFormat":"12H","timeZoneOffset":5},"region":"use1","app":{"id":40223,"clientId":"9949c485aeae833d90caf2d0c56edb43"},"appVersion":{"id":10093649,"name":"Mind Mapping","status":"draft","type":"minor","versionData":{"major":1,"minor":6,"patch":0,"type":"minor"}},"boardIds":[],"viewMode":"fullscreen","editMode":true,"instanceId":-1,"instanceType":"board_view"},"requestId":"xke2t2e"} Here is the response to app_subscription and app_monetization_status qu

Hello, I have the following problem: I can create an activity for a Phone Call by doing this: { "query": "mutation { create_item (board_id: 1170030229, item_name: \\"Call answered from John Smith", column_values: \\"{\\\\\\"activity_owner\\\\\\":\\\\\\"user-email@test.com\\\\\\",\\\\\\"activity_type\\\\\\":\\\\\\"Phone call\\\\\\",\\\\\\"activity_status\\\\\\":\\\\\\"Done\\\\\\", \\\\\\"activity_start_time\\\\\\":{\\\\\\"date\\\\\\":\\\\\\"2023-02-23\\\\\\", \\\\\\"time\\\\\\":\\\\\\"21:43:00\\\\\\"}, \\\\\\"activity_end_time\\\\\\":{\\\\\\"date\\\\\\":\\\\\\"2023-02-23\\\\\\", \\\\\\"time\\\\\\":\\\\\\"21:45:00\\\\\\"}, \\\\\\"activity_item\\\\\\":{\\\\\\"linkedPulseIds\\\\\\":[ {\\\\\\"linkedPulseId\\\\\\":<ContactId>}]} }\\") { id }}" } The activity is created, I can see it in the board activities and all is well. But the problem goes when I go to the Emails & Activities section of my contact. The newly created activity appears nowhere there. Nonetheless if I create

Can i create item via Spring GraphQL? If can then please guide how to set schema and mutation query.

Hey there, I am using the GraphQL API and automating some updates instantly on specific items (ASAP I get them), I am curious about the rate limit of the the API as it says I have 10M complexity points per min. So, is there any way to get more than 10M points? My Monday.com setup looks like this: Board A: contains 3 groups Board B: contains 3 groups … Board N: contains 3 groups

Hello, I’m trying to mutate subitem column by using change_column_value `mutation { change_column_value (board_id: ***, item_id: ***, column_id: ***, value:"{\\\\"clear_all\\\\": true}") { id } }` it works for regular items, but for subitems I’m getting the following error: error_message: ‘Item not found in board’

The openSettings works fine but it isn’t defined yet. Typescript developer would be annoyed

This is my query. This used to work like charm. But now its not working anymore. For example, If I wanted to create a column with title "User Name" it should create a column with id "user_name", but which is not.

I have wonder why this query has occurred Parse Error? And i wonder what should I do to operate as create Item? [ My GraphQL Query ] mutation { create_item (board_id: ${boardId}, group_id: ${groupId}, item_name: ${itemName}, column_values: "{\\"___5\\":\\"\\uC708(\\uC8FC)\\"}" ) { id board { id name } group { id title } } } [ Error Code ] { "errors": [ { "message": "Parse error on \\"(\\" (LPAREN) at [2, 149]", "locations": [ { "line": 2, "column": 149 } ] } ], "account_id": 8736257 }

Hi, Im trying to get the contents of a MONDAY_DOC through the monday api. When querying for an element with a doc in a monday workdoc column the response contains the workdoc as: {'id': 'meeting_notes', 'text': 'https://xxx.monday.com/docs/4215703239', 'title': 'Descripccion', 'value': '{"files":[{"name":"Descripccion","fileId":"3267629f-3238-5671-0ab3-96151724245f","isImage":"false","fileType":"MONDAY_DOC","objectId":4215703239,"createdAt":1680010727352,"createdBy":"12345678","linkToFile":"https://xxx.monday.com/docs/4215703239"}]}'} yet when I try to use the objectID on the docs query { docs (ids:4215703239) { id object_id blocks { id type content } } } it returns an empty list of docs, but when crating the workdoc on the monday dashboard it displays a diferent document id wich will return the contents of the doc properly. How can I get this id from the API ?

I want to create item which have text column with special characters. [attach my query] mutation { create_item (board_id:$board_id, group_id: $group_id, item_name: $item_name, column_values: "{\\",\\"___9\\":\\"<hello><World!>\\"}}") { id } } The query works fine, but it doesn’t print out the value I want on the screen. It shows like this.(There’s no value in column.) These symptoms do not occur only in <>. These symptoms also occur in other special characters. How can i handling special characters?

Hi, I am trying to use the API to create a new item on an existing board, populated with column values. I can successfully create the item without column values, but as soon as I try to add them I get errors. let query ='mutation { create_item (board_id: [boardid], group_id: [groupid], item_name: "Just put those column values in please", column_values: \\"{ \\"long_text\\": {\\"text\\":\\"Testing testing\\" }}\\") { id }}' const response = await fetch('https://api.monday.com/v2/', { method: 'POST', headers: { 'Content-Type': 'application/json', 'Authorization': process.env.GATSBY_MONDAY_TOKEN, }, body: JSON.stringify({ query: query }) }) current error is: “Parse error on ": " (STRING) at [1, 153]”, but I have played around with so many different variations of escaping quotes, different fields, etc. that I have gotten different variations on that error. I can successfully pass column values using graphQL from Postman, just not from my JS code (in

Hello, I use monday API from a while now, and suddenly an error has appears (on the 29/03) after days of good work. I have test many possibility of queries but I can’t figured it out. There is my query : $query = 'mutation { create_item ( board_id: 409788845, group_id: "topics", item_name: "TEST MODULE", column_values: "{ \\"texte5\\" : \\"test tex\\", \\"texte\\" : \\"Dev\\", \\"person\\" : \\"2556545674\\", \\"connecter_les_tableaux7\\" : {\\"item_ids\\" : [14564564960]}, \\"date\\" : {\\"date\\" : \\"2023-03-30\\", \\"time\\" : \\"08:49:02\\"}, \\"date6\\" : {\\"date\\" : \\"2023-03-30\\", \\"time\\" : \\"10:25:00\\"}, \\"chiffres\\" : \\"1.6\\", \\"chiffres0\\" : \\"372847239\\" }") { id } }'; This return me this error :