API & Apps framework

I’m trying to get ALL items in a board by column values, using pagination. This is the query im using in the API Playground: { items_by_multiple_column_values(board_id: board_id, limit: 500, page: 1, column_id: "column_id", column_values: "column_value") { id name column_values { id title value } } } In the UI, I can see that there are 1000+ items in my board. However, when I use this query, only page 1 and 2 contain 500 items. Page 3 does not return any items. I have tried setting the limit to something smaller, but it seems that Monday never returns more than 1000 items. Is there something I’m missing in my query that is causing this issue?

Hello! Any plans to have Boards search by name to API? Any workaround which does not require pulling all boards and search names?

Hi, We want to sync the data between Monday and ExactOnline. We are planning to build a custom trigger in Monday, I would like to know, is it possible for us to develop the integration setup like Salesforce?Support Somethings like the screen below, to fill in some data (to link them up) after the user clicks on the recipe: Br, YarHuoy

Hi, I am wondering how I can setup an integration connection view/page like the examples below I cant seem to find any reference in the developer documentation that points to how this can be done. I am setting up a feature integration recipe and I will like use this view to help users connect to a third party application.

Hi Inside items Im trying to get the text field of id:“pm” inside “column_values” by searching a name but this is not possible, tried also Items By Multiple Column Values and Items By Column Values but could not search name to get the text attached to it. Can you guide me how the call should look like?

In my custom actions, I receive the following fields in my payload: "blockMetadata": null, "integrationId": 139037958, "recipeId": 30072284, "forceNoCharge": false 1 . What should the blockMetadata contain? 2 . I understand that integrationId is the unique Id of the integration, as set by the user in his board. 3 . But what about recipeId? Reading the documentation, it should correspond to the unique Id of the “trigger > action” recipe I’ve published, but how can I find the corresponding recipe in the Developers > Recipes section? 4 . And finally, what’s the forceNoCharge field? Thanks.

Im creating a outreach machine in monday.com and the last issue I am running into is figuring out a way to stop a Item from entering the automation if a item with the same email is already going through it. I have a database set up that copies every item that goes into it and before the item goes into the automation I want it to cross check the database to make sure emails have not already been sent to the email on file. Does anyone have an Idea on how I can accomplish this?

Hi, I’m using python (moncli) to read items from a specific board. I created the following code. It works good for most of the items, and returns the releavnt columns’ values, but for some reason for 3 items I get the following error message. See attached. The code fails in the “status” row, when I try to get the column values. It works if I remove that row. I have no idea what is the error’s source in those specific items and how to fix it. Please your urgent help- I’m trying to figure it out for almost 2 weeks… Thanks

Hello, I am looking for a way bulk upload thousands of images into the file column of an existing board. Each image belongs to one of the 600 items in my board (some items have up to 5), and I wish to upload every image in the file column of its own respective item. How can I achieve this? Will using the Monday API help, or is there a source elsewhere that solves the issue? Thanks.

Hi, Is there any API that can let us delete our custom recipe in the board by passing in WebhookId programmatically? Br, YarHuoy

Hey there! I’ve a really bad time wrapping my head around this… I’m trying to change a column value from a post request. It’s formed as follows: var query = `mutation change_column_value($board_id: Int!, $item_id: Int!, $column_id: String!, $value: String!) { change_column_value(board_id: $board_id, item_id: $item_id, column_id: $column_id, value: $value) {id}}` And these are my variables: var board_id = 3395274995; var item_id = req.body.eventId; var column_id = "text71"; var value = "Test"; And I’m getting this response: 'Type mismatch on variable $value and argument value (String! / JSON!)' I just don’t get it, column_id is a String and that seems to work perfectly but the value throws an error. The field is a simple text field, so it should be of type String or am I missing something?

Hi everyone, We are relatively new to using Monday.com and I’ve been in charge of setting up boards, automations, and integrations for our organization. I really love the functionality of the “My Work” dashboard and the flexibility other custom dashboards give, but Dashboards are limited to 20 boards connected and “My Work” shows items I’m collaborating on and not “responsible” for. We have around 70-100 active boards at any given time, so I can’t pull all the information I need. This got me looking into API and Google Sheets connectivity. Here’s my question in a nutshell: How could I code a Google Apps Script to automatically send an API request to search every board in our main workspace, and organize a list of all items that have “X” person in a column titled “responsible”? In other words, create a google sheet version of “My Work” but filter it based on items I’m not just mentioned in as a collaborator/teammate etc. but solely as responsible. If this isn’t possible or it’s too comp

I get this error in my “Car Overview” board. I would like to install some integrations that I made for a client. But when I go to the production board in my clients Monday I get this error. I checked, and I am an owner on the board and also an admin. Is there a problem with Monday or am I doing something wrong?

Hi Im trying for the first time to have a call using your API but getting Not Authenticated error when using postman, i’ve tried the try it yourself and it did work using my token but on postman it just doesn’t work What can be the problem?

apiKey = “MySecretKey” apiUrl = “https://api.monday.com/v2” headers = {“Authorization” : apiKey} ######## query5 = ‘mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:myBoard_ID, item_name:$myItemName, column_values:$columnVals) { id } }’ vars = { ‘myItemName’ : billingAddressVariable, #works as is, variable ‘columnVals’ : json.dumps({ 'WorkID : {‘value’ : workIDVariable}, #does not work, variable ‘Ticket#’ : {‘text’ : ticketNumberVariable}, #does not work, variable ‘status’ : {‘label’ : 'Working on it '}, #works as is; constant ‘date4’ : {‘date’ : dueDateVariable} #works as is; variable }) } data = {‘query’ : query5, ‘variables’ : vars} r = requests.post(url=apiUrl, json=data, headers=headers) # make request print(r.json()) No errors, date and status columns fill no problem, same with myItemName. This is but one of many attempted formats of implementation. Nothing changes. Ticket# and WorkID refuse to fill. I am using official docs as far as I am able.

Hello, I have big delay’s between a post and a get request, around 3-5 minutes. This happens only with “items_by_column_values” query and not the normal “query”. Is there such a option in default “query” where I can fetch the data by a specific value? If anyone had this same Issue how did you manage to work around It? Thank you, any advice is much appreciated!

Hello, It is very simple to get access to the token from an integration. We can “destruct” the token from the session: const { shortLivedToken } = req.session. From front-end apps, I am using mondaySdk in order to make API calls. Is it possible to get access to the token from front-end apps, or change it? Thanks!

I am trying to use the monday js sdk to check if the widget view is in fullscreen mode or if the settings bar is open. This is the code that I am using right now monday.get("context").then(console.log) It seems like “viewMode” is always “widget” and “editMode” is always “false” Is there a way to detect the state of the dashboard widget? I found that opening the “fullscreen settings mode” by clicking the full screen button does make the “viewMode” change to “fullscreen”, however the settings button does not give this behavior.

We’ve made three changes to add more actions to the workspaces object, including a new field and mutation! You can now query the workspaces object, rather than nesting it within a boards query. You can also use the new created_at field to return the creation date of a workspace. Lastly, we’ve added a new mutation that allows you to delete a workspace. You can find all of the details about these updates and functionality updates in our workspaces doc!

Hi! I’m new in this forum. I was able to send rows from a Google Sheet via e-mail, using the Javascript sendEmail() function. The aforementioned Google Sheet is linked to a Google Form. In the sheet, under the column "Recursive_Requests ", there are 2 options to send data. I would want that: if you select "send_every_day " option, the request is sent by e-mail every day; if you select "send_every_monday ", the request remains in the sheet, BUT it is sent only every Monday; if you select "No ", no changes are made. Any help would be appreciated! Code used: function sendEmail() { var orderData = getData(); var body = getEmailText(orderData); MailApp.sendEmail({ to: "email@example.com", cc: "anotheremail@example.com", subject: "Today's orders", body: body }); } function getEmailText(orderData) { var text = ""; orderData.forEach(function(order) { text = text + order.department + "\\n" + order.request + "\\n-----------------------\\n\\n"; }); return

For the life of me, I can’t get a mutate_column_value to work. I’ve tried about every possible way that I found in the docs and the community but nothing seems to work. This is how it looks right now: "query":"mutation{ change_column_value (item_id: 123456789, board_id: 11223344, column_id: \\"text21\\", value: \\"test\\") { id } }" And this is the Server reply: { error_message: "809: unexpected token at 'test'", status_code: 500 } I probably am missing something completely obvious but I’m on this for a felt eternity, so if anybody can tell me my mistake, that would be extremely helpful.

Hi all, Did anybody see this error code earlier? {"error_code":"ChangeColumnValueError","status_code":400,"error_message":"CustomExceptions::ItemLinkMaxLocksExceeded","error_data":{"error_reason":"automations.history.failed_trigger_details.error_reason.change_column_value_failed"}} Any suggestions how to prevent this one? What will happen if I retry the operation (change_column_value) on receiving this error?

I found the api documentation, but there is no activity api. Can someone please guide me, thanks

Hello Guys! I’m a Data Engineer and while developing an ETL that automates the ingestion of a few boards to a S3 Bucket (in parquet) I’m running into 504 Gateway Timeout issues while consuming the Monday GraphQL API. This is the query that i’m currently running, and the self.board_id is the id of the board: query { boards (ids: """+self.board_id+""" ){ name description columns{ title } items{ id name column_values{ id text } created_at state updated_at } } } While trying to implement pagination into the query above (to avoid the query timeout issue) I ran into the other issue that I don’t have an automatic way of knowing how many pages I’ll need to extract for the few boards that I’m consuming. Also, this error (504 Gateway Timeout) doesn’t happen everyday, it usually happens a few times a week, but works on the other days. B

There is a thread about the issue using your own API key, once you leave the company and your account is deactivated - someone must generate new API key and update the old one. Is there a way to use some sort of the service account not tightly-coupled to any user to avoid those API key rotations upon leaving the company ? From the official doc It looks like there is no other way as to bind your own creds, but still worth asking since I wasn’t able to find any answer. My use-case is an automation (daily job) that will create new items for the marketing team to review.