General

New App was released to market place, it’s SMS to board App. SMS is a quick and easy way to send reminders to board, ask for reviews and mobile customer support, and keep your boards up to date not only from forms or dashboard but also from mobile app without internet. The SMS-to-Board App was developed to provide a new Power-Up for creating an items and updates directly from Short Text Messages (SMS) to your Monday boards. We will generate and reserve a Phone numbers for your boards and only for your boards. You will receive the phone number by notification in your Monday account after installing the integration. You will be able to publish this phone number to your customers or members and they can send the Short-Text-Messages (SMS) directly from their phones to your boards numbers. When we receive the messages, we will create them as a new item in your boards. There is an ability to select the country code for your number. You can use this service for example to provide Mobile Cu

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?

A new app arrived in the marketplace, called Rollup Subitems. As you might guess from the name the app rolls up (or aggregates / summarizes) column values from the subitems into the parent item. And yes, we do know there is standard monday functionality to summarize subitems data into a parent item column. We build this app because: the standard solution adds a “mirror” column to the parent that can’t be used in other automations this standard mirror column can’t be used to hold the same information for parent items that does not have subitems On top of that we needed: filtering that allows us to summarize just the filtered subitems Red Amber Green (RAG) statuses where the user specifies what combination of statuses from subitems convert to Good, Bad and Ugly At Excellent Team we are committed to build monday.com integration apps to help our customers to achieve things that can’t be done with standard monday automations. Use cases for this app are all situations where you need to

TrackMy is a Universal parcel tracking monday app that can help track your package from UPS, FedEx, DHL, USPS, China Post and more so you can integrate and automate your e-commerce, shipping and procurement workflows. TrackMy was is out of beta and ready for your tracking needs - supporting 1000+ couriers worldwide. Top couriers you can track directly from your monday boards Fedex UPS DHL Aramex EMS Epacket USPS and many more TrackMy is free to try for up to 10 Tracking IDs a month and have subscription plans for up to 200 and up to 1000 Tracking IDs a month More info here: https://monday.com/marketplace/10000035

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.

Hi, I have connected via API with my board in which contains 600 row entries + 800 subtasks. I want to retrieve only the rows of course but since there is a timeout of 60 seconds, i am only able to retrieve 300 at a time. how can i run the script a 2nd time to retrieve rows 301-600 for example? is there a way i can filter the results so that i can limit the number in results, for example, I want all the ones where in column A = status 123? I use the below query query { boards (ids: 123456789) { name id items { name column_values{id type text }} }}';

Hello, I’ve built an app which takes excel data - manipulates it, and: creating an item if there is no item yet insert the column values if there is an item on the board. We are talking about huge amount of data that need to be insert (2500~ items) Here is the example of the integration: export async function post(boardId, project, token) { try { const mondayClient = initMondayClient() await mondayClient.setToken(token) for (let i = 0; i < 2500~; i++) { console.log('start of loop') const task = ... const taskId = ... const taskName = ... const itemId = await _getItemId(taskId, boardId, token) const columnValues = JSON.stringify({ .... }) if (!itemId) await deleyFunc(_createItem, 2000, boardId, columnValues, taskName, mondayClient, token) else await deleyFunc(_changeItem, 2000, boardId, itemId, columnValues, mondayClient, token) console.log('end of loop') } } catch (err) { console.

Hi there! I’m trying to find a way for users of the integration I’m developing to request insight into their data. I’d like them to contact me with their account ID, but I haven’t been able to find an easy way for users to find this information. For example, for user ID or board ID it’s the digits in the URL when going to profile or a board. Is there any place the Account ID is shown or do I have to refer them to the API playground to get it? Thanks for your help!

Hey, Im making an API call (can see below). sometimes it will return values and sometimes it will not. If I will wait I might get values back. didnt find any pattern… When querying the record itself, it finds it with the correct value in the status. The condition column type is a Select (which should support this functionality, according to the API docs). Is any one can assist me to understand why I do not see the relevant records always? Thanks! Eitan query ($boardId: Int!, $columnId: String!, $columnValue: String!){ items_by_column_values (board_id: $boardId, column_id: $columnId, column_value: $columnValue) { id name column_values{ title value id text additional_info type } } } Parameters: {“boardId”:XXXXXXX, “columnId”:“status1”, “columnValue”:“Ready For Review”}

Hi I am trying to change a field re people, I saw same samples and used them It doesn’t return any error but the field is not changed In the samples I saw in other cases the escape char was the issue, so I did it exactly as the sample but without any change mutation { change_multiple_column_values(item_id:3430694181, board_id:2741432713, column_values: “{"people1" : {"personsAndTeams":[{"id":19084131,"kind":"person"}]}}”) { id } } The response is fine, the board is not updated

Hi, everyone! So, I was querying the boards from our work account and I noticed that some boards are not showing up through the API although they exist and can be accessed through the UI. Yes, I am using pagination. I already specified the IDs from these boards in the query, but even like that the boards won’t show up. It’s like they don’t exist. Anyone know why this could be happening? Those boards where created by duplicating existing boards manually, could this have some impact?