General

With the following command: mutation request($boardId:Int! $itemId:Int $columnValues:JSON! $createLabelsIfMissing:Boolean!) { change_multiple_column_values (board_id: $boardId, item_id: $itemId, column_values: $columnValues, create_labels_if_missing: $createLabelsIfMissing) { id }} -and valid values- I got the following response: {“error_code”:“RecordInvalidException”,“status_code”:422,“error_message”:“Validation failed: user cant subscribe to a pulse without being exposed to it”,“error_data”:{“error_data”:“Validation failed: user cant subscribe to a pulse without being exposed to it”}} In other words, a message about subscribing to a pulse, while the request was to change multiple column values. How do I deal with such error messages? I recorded the response headers, here is a selection: Name Value Transfer-Encoding [ “chunked” ] Connection [ “keep-alive” ] x-request-id [ “832ffcbd-d134-9f8c-ad90-b86c1ea1cdb1” ] x-runtime [ “0.222076” ] x-envoy-upstream-service-tim

I’m trying to upload a file to a column using the monday api through node app. I took an example from github and modified the query to upload to a column. I get this error when I run the program. { error_message: ‘Unsupported query’, status_code: 400 } I can’t tell what the issue is with the query to monday or if there’s another issue in the code. The code I used is posted below. /// those are the main dependecies you’ll need to have installed in this example; const fs = require(‘fs’); const fetch = require(‘node-fetch’); /// Replace with your actual API Key const API_KEY= “XXXXXXXXXXXX”; /// Notice the /file/ endpoint - only this endpoint will support variables in this type of call const url = ‘https://api.monday.com/v2/file’; /// This is your mutation query - can also be adapted to send files to file columns instead const query = ‘mutation add_file($file: File!, $itemId: Int!) {add_file_to_column(item_id: $itemId, column_id: 'file', file: $file) {id}}’ /// These are the variables you

Hi: I downloaded and successfully ran the quick start integration . . . for a while. I added some console.log lines and the token stop working. I removed those lines, change the signing secret, nothing works. This is the displayed error: [nodemon] 2.0.7 [nodemon] to restart at any time, enter rs [nodemon] watching path(s): .env src/**/* [nodemon] watching extensions: js,mjs,json [nodemon] starting node ./src/app.js listening at localhost:8302 || tunnel: https://monday-integration-100000055.loca.lt JsonWebTokenError: invalid signature at /media/luisgabrielmendezbarreiro/LGMBData/Developments/NodeJS/quickstart-integrations/node_modules/jsonwebtoken/verify.js:133:19 at getSecret (/media/luisgabrielmendezbarreiro/LGMBData/Developments/NodeJS/quickstart-integrations/node_modules/jsonwebtoken/verify.js:90:14) at Object.module.exports [as verify] (/media/luisgabrielmendezbarreiro/LGMBData/Developments/NodeJS/quickstart-integrations/node_modules/jsonwebtoken/verify.js:94:10) at authenticatio

We have a board in our organisation that is invisible throught Graph QL. When I perform a query through API with board ID this board is not listed. If I use the browser I can see the board ID in the URL and I can reach the board via dashboard. The url looks like this : “boards/1296605043” Any idea of how I can fix that pretty annoying behaviour? My “list boards” query looks like this : { boards { name id } }

Hello Monday Community! I am currently running into some interesting behavior with an integration recipe that hits a custom URL whenever a status updates to a specific value on one of my boards. Even after the endpoint returns a 200 success response, the automation continue to trigger every minute on the minute. I do remember reading that this is the behavior for the next 30 minutes in the case of a request failure, however the request does not fail. One thing to note is that the request also does not currently return a value with the successful response. I currently have a work-around in place, so my work is not impacted. I am more curious to see if this is a know behavior amongst y’all. 🤠 Thank you for your time! Andrew

Hey All, New here to the community and have been playing around with your " API Quickstart Tutorial - PHP". I have been able to get pretty far playing around with things I need but I have come up with a stumbling block and all of my searching in the community I can’t seem to find anything so here I am! I went ahead and did a copy and paste of your " Creating a new item using GraphQL variables" section and it worked great in my board but that was for the item name. How can I put a variable into a column_value value? Here’s the code (with token and everything after $responseContent = removed): $apiUrl = ‘https://api.monday.com/v2’; $headers = [‘Content-Type: application/json’, 'Authorization: ’ . $token]; $marketing = “Package A ($150)”; $query = ‘mutation ($myItemName: String!) { create_item (board_id:My Board_ID, item_name:$myItemName, column_values : “{"title":$myItemName}”) { id } }’; $vars = [‘myItemName’ => $marketing]; $data = @file_get_contents($apiUrl, false, stream_context

Hello, I want to display a full-sized modal box with iframe inside when user clicks a button from my “card view” feature of application. Is it possible from monday js sdk? An example; Thanks!

Hi All, I have created custom trigger to trigger my backend code when new update is created in source board. So, when user install the integration on his board I will receive the installation event in my subscriber endpoint which is defined in custom trigger endpoints so i will create a new record in my backend DB and store the recipe selected options, webhook id, integration id, subscription id …etc and create webhook using API endpoint on source board. So, when user create new update in source board, my code will be triggered and read the update to handle the event payload. When user remove the integration from his source board I will remove the webhook from board using remove webhook API. Everything working perfectly, but my issue when user install the integration more once same source board, Monday will add another “update was created” webhook on the same board, so I will get the event two times for same created update. If I checked in my backend DB about this board is stored or no

Hey, I’m trying to create a new Recipe: Custom Trigger → Create an item (The one without the field mapping). For the example let’s say I want to create the item with a name and a populated column “description”. The subscription works fine and I got the webhook address. My problem is with the “data” I’m trying to post… (I’m getting 200OK back so it’s not authorization issue). So - for “item name” and “description” column - how should my data in the POST look like? I’ve tried: { “trigger”: { “outputFields”: { “boardId”: 12345, “itemColumnValues”: {“item_name”: “title”, “description”: “desc”} } } } Thanks! 🙂

Hello everyone, everything good? I would like to change the status of some items on a particular board in batch, as needed. However I would like to know how I can identify all the ids of the items inside the board, to perform this action. Can anyone help me?

I’ve been working on an integration with the monday api and a portal we made for our clients so they can create tickets in our monday boards and track the progress on them. We ran into an issue where whenever we create an update to an item with a body containing a base64 encoded image over 50Kb in size the body shows completely empty on monday. Images smaller than this size show up perfectly fine. Is there something I might be doing wrong/missing?

Hello I am trying to extract data from my boards via an API. I managed to extract all the columns I have apart from the timeline. e.g. I am using the below to extract a date. {‘monday_id’: ‘date3’, ‘tol_id’:‘materials_in’, ‘is_date’:True, ‘is_person_id’:False }, I understand that a timeline has a ‘from’ and a ‘to’ but how do I extract the 2 dates and have it saved as a date in my database? {‘monday_id’: ‘timeline’, ‘tol_id’:‘time_start’, ‘is_date’:False, ‘is_person_id’:False }, Thank you

Hi, Last time I get this issue too when I tried to upload a new build: Unable to upload build.zip monday Apps & Developers Hi, I unable to upload my build since last night, I keep getting unknown error, may I know why? [image] But it was resolve after 1-2 days without changing anything on our side And now I’m getting this related error again (the same build.zip was uploaded successfully few days ago), is there any where I can check what is the exact issue that block me from uploading my build? Or is there a page can we check if Monday.com service is down or something? Br, YarHuoy

Hello monday.com community, I am building an item view. I would like to display a custom dialog outside of the iframe, I wasn’t able to find a suitable function in the monday js sdk. I did notice that an existing app, pandadoc, is able to have a dialog outside of the iframe as shown in this webinar: New Features June 2021 | monday.com - YouTube

Good afternoon, I’m having a problem with a subitem update, my idea is to update the status column of the subitems, I’m doing a query after creating the subitems. My query to get the ids of the subitems: 'query($itemId: [Int]){ Items (ids: $itemId) { Column_values ​​{ Id Text Value } } }' The answer: ‘{ LinkedPulseIds: [ { linkedPulseId: 1400012779 }, { linkedPulseId: 1400012848 }, { linkedPulseId: 1400012918 }, { linkedPulseId: 1400012997 }, { linkedPulseId: 1400013068 }, { linkedPulseId: 1400013123 }, { linkedPulseId: 1400013255 }, { linkedPulseId: 1400013310 }, { linkedPulseId: 1400013366 }, { linkedPulseId: 1400013404 }, { linkedPulseId: 1400013480 } ] }’ Right after that I try to mutate with the ids: ‘mutation($value: JSON!, $idColumn: String!) {change_column_value( board_id:1249559661 Column_id: $idColumn item_id: $idSubitem value: $value) {id}}’ The answer : ‘{ Error_code: ‘ResourceNotFoundException’, Status_code: 404, Error_message: ‘Item not fou

I’m trying to upload an image to a monday update using the add_file_to_update mutation. I’ve referenced the following posts: Announcement: Uploading files to monday.com has just become easier :) Upload File using API and python and requests ( add_file_to_column) With the help of those posts, I have the following code: My code import requests import os def add_file_to_update(update_id): api_key = os.environ.get("MONDAY_API_KEY") headers = {"Authorization" : api_key} apiUrl = "https://api.monday.com/v2/file" mutate_query = 'mutation ($updateId: Int!, $file: File!) { add_file_to_update (update_id: $updateId, file: $file) { id } }' vars = { 'updateId' : int(update_id), } add_file = {'query' : mutate_query, 'variables' : vars} dir_path = os.path.dirname(os.path.realpath(__file__)) files = [('variables[file]',('image.png',open(dir_path+'/image.png','rb'),'image/png'))] r = requests.post(url=apiUrl, json=add_file, files=files, headers=heade

I’m wondering how your dropdown menus are implemented. I’m looking for a way to save the state of a dropdown in a board, then hydrate that state back into the dropdown on page load using jquery. With a regular HTML dropdown I would do something similar to in this codepen: Is there a way to populate a dropdown from data stored in a board?

I am using the following query to get all column values for a board: let jobsQuery = { boards (ids: ${cfg.jobBoardId}) { items { id name column_values { id title value } } } }; It’s running in NodeJS. It’s working great, returning all the items. I’d like to narrow the search to only return items that have a particular column set to a particular value. Based on the current dataset returned, it’s the data in ‘name’ that should be used to narrow the search. I tried the following: let jobsQuery = { boards (ids: ${cfg.jobBoardId}) { items (names: ${cfg.jobName}) { id name column_values { id title value } } } }; But that didn’t work, it just returns an empty list. What would I need to update my query to, so as to return the same data structure and columns, but only the subset that match name === cfg.jobName?

Hi All, according to this guide we can move a group to another board. I want to know how can I do this with the API ? I checked the API docs but couldn’t find the matching API function. Thanks.

Can we use automations to generate workspace template folders? ie A) We’ve made a pretty great chunk of boards/dashboards that live in a folder B) We can get users to generate these manually using Add Template OR C) We get users to enter an automation to create these on the fly as items get moved, people get assigned, etc. Data from the item goes into the folder name and various fields within the boards. eg A) Could be used for sales pipelines; sales person moves item to won > folder is create in a different workspace automatically called X project (name of item) > value of deal gets moved to project value and spread to finance boards and dashboards > project brief gets added as first group before predetermined structure > etc etc. Any ideas?

Hello, I’m trying to figure out how to properly query board data. Specifically column values. Is there another way to specify what columns you want to limit your query to? All I see currently is IDs…and those seem be very interesting in the return. I’m getting weird responses back (i.e. Text7, number45, timeline_1, timeline, dup__of_resource_name, etc.). These aren’t the same in each board I’m querying, even though the titles of the columns are very consistent. So while my boards “look” the same, I can’t filter/query them consistently to get the data I need to the above. If I could query by title (which seems that those could be made consistent) it would really help… Any ideas on how to modify this? Is there a way to do this? Am I missing something?

I want to be able to query data directly from my database so that once a form is entered on my website its posted to my database and the latest lead information is then dumped to our CRM board in Monday.com. I cant seem to find a solution to help with this anywhere. I’ve read through the Python API tutorial but everything seems more geared towards pulling data from Monday as opposed to pushing data to Monday. Any help with this would be great.

Hi - I’m new to Monday and am trying to use SyncHub.IO to query my data using PowerBI. It works great to have the Monday.com data in a relational format. My issue is around the text column in ColumnValue table. I’m trying to use the text column to identify the status of items. I get a highly usable set of values most of the time. However it appears a null value in text has multiple meanings - an item that has not been started yet and an item that was deleted. Do I have that correct? I need to know what has not been started vs. what is has been deleted. I looked at the IsDeleted field that that doesn’t seem to help. Thanks

Hello, first time here! I’m starting to figure out how to update and get information from Monday boards on a Excel sheet using VBA. Checking out the API documentation, my first attempt was to retrieve the name of a specific board, but the name won’t appear on the response text from the html. This is what I have so far: Public Pass As Variant Sub monday() Dim monday As New MSXML2.ServerXMLHTTP60 Dim response As Variant Dim status As Variant Dim query As String query = " { ""query"" : ""{boards(ids: xxxxx){views{name}}}""} " With monday .Open "POST", myurl , False .SetRequestHeader "Content-Type", "application/json" .SetRequestHeader "Accept", "application/json" .SetRequestHeader "Authorization", mytoken .Send query response = .ResponseText status = .status & " | " & .StatusText MsgBox response MsgBox status End With End Sub For the response text I’m getting: {“data”:{“boards”

Hi, The API documentation illustrates how to duplicate a board with structure only by setting duplicate_type: duplicate_board_with_structure. I need to duplicate the board along with its items and I can’t find in the documentation what value I’d use for duplicate_type: Does anyone know? Thanks!