General

I’ve been looking at the Files column type, and see that for external files hosted in say Google Drive, Box, Dropbox or Sharepoint, the files are described by a stringified version of the structure below: { "files": [ { "name": "Book.xlsx", "fileId": "c42b3230-42b3-42b3-42b3-9d6f7b2a081b", "fileType": "ONE_DRIVE", "createdAt": 1234, "createdBy": "456", "linkToFile": "https://someinstance-my.sharepoint.com/:x:/g/personal/username_someinstance_onmicrosoft_com/PlkJXFVMWpEV2cVApxt_H_EB6GH1viK96wa1-rEqGKjmpw" }, ... ] } 👉 What mutation would be required to add a file from an external provider such as Google Drive, Box, Dropbox or Sharepoint to a column? This is not the normal “upload a file” mutation as described here by:

Hello, I’ve been working on trying to pull hours from the Time Tracking column that I’ve added to a board via the Activity Log API. I added some hours yesterday and verified that it showed up in the API call. Today, however, those activities are not in the activity log and - for context - the query to pull the maximum number of activities across all the boards in our environment. Also, I’m using API version 2024-04. Is this an issue anyone else has experienced or a known bug? Here’s the python code/query I was working with: import requests import json import pandas as pd from datetime import datetime, timedelta apiKey = myapikey apiUrl = “https://api.monday.com/v2” headers = {“Authorization”: apiKey, “API_Version”: ‘2024-04’} activity_log_query = ‘{ boards (limit: 1000) {id activity_logs {data entity event id user_id created_at} }}’ activity_log_data = {‘query

Hello, I am having trouble pulling column values from my boards. I am trying to use the below query, but I keep getting the error “Field ‘items’ doesn’t exist on type ‘Board’”. I’ve tried to shift this around and mess with the syntax with no luck. { “query”: “{ boards(ids: 1234567890) { items(limit: 50) { column_values(ids: [“text”, “date_1”]) { title value } } } }}” }

Hello, is there anyway to add validation on DropDown components as you can on TextField ones?style.monday.com

Hello, For the past few days, I’ve been encountering an error when attempting to activate an integration locally: FetchError: request to https://api.monday.com/v2 failed, reason: unable to verify the first certificate at ClientRequest.emit (node:events:513:28) at TLSSocket.socketErrorListener (node:_http_client:490:9) at TLSSocket.emit (node:events:513:28) at emitErrorNT (node:internal/streams/destroy:151:8) at emitErrorCloseNT (node:internal/streams/destroy:116:3) at processTicksAndRejections (node:internal/process/task_queues:82:21) { type: 'system', errno: 'UNABLE_TO_VERIFY_LEAF_SIGNATURE', code: 'UNABLE_TO_VERIFY_LEAF_SIGNATURE' } Anyone have any idea into what might be causing this issue? Thank you.

In my app, I have set up the sdk with the right token, I can make other query, however When I try to upload a file to a column on a board, it hits an internal server error. my code as following: const file = await fetch('/images/test.pdf').then(r => r.arrayBuffer()); console.log(file) const query = mutation {add_file_to_column (item_id: 1844256842, column_id: "files", file: ${file}) {id}} try{ const response = await monday.api(query) console.log(24, response) }catch(e){ console.log(e) } error message as follow

Hello team, I have this very basic structure: mutation createSubItem($parent_item_id: ID!, $item_name: String!, $columnValues: JSON) {create_subitem ( parent_item_id: $parent_item_id, item_name: $item_name, column_values: $columnValues) { id }} with the following variables: {"parent_item_id":<CORRECT_PARENT_ITEM_ID>, "item_name":"Item name string", "columnValues": "{\\"status\\": \\"Requested\\" , \\"people__1\\" : {\\"personsAndTeams\\":[{\\"id\\":5344389,\\"kind\\":\\"person\\"}]}}" } If I take out the PEOPLE’s section of my column_values, everything works, except for obviously no people’s assignment is happening. However, running the above code, I get the following error: { "error_message": "invalid value - unable to assign person with id: <PERSON'S ID>. Please check our API documentation for the correct data structure fo

Hello, According to this forum post, one of the activities tracked by the Activity Log is create_update, but when I make an Activity Log query on my board, the create_update event never appears, even though updates have been made on the board. I can see other events, including update_column_value, add_owner, create_pulse, and many others but I cannot see create_update. Thank you!

Hi! I’m quite new to developing with monday API and I run into the following case: How is it possible, to read all status or tags, that can be set in a column? Explanation: I want to to a mutation, which sets a specific status. Therefore I need to know the ID of the status. Is there any way to retrieve this information for all status at once? As for tags: I got all global tags, that are available in my monday, but not all of them can be used in my column. How can I get only those, that can be used in my column? We don’t use board tags. Best regards Anke

When querying data from a board, I get the following error message “This app is currently blocked from API usage”. Does anyone know what might be causing this?

Hi, I am able to search monday column values via API which were updated Today. This is working fine. Now i want to add a filter. Only retrieve those updated values which were updated today AND matches a status, How to add this filter? Also How to increase the limit in column values? Currently only 25 column values are coming via API.

As far as I have read in the documentation for the Apps Framework I cannot find an easy way to test the App Lifecycle Events listed here. I am aware of the mock subscription API call you can make in an account to set up a mock subscription but how would I test these webhooks? I have set up the URL in my app configuration and setup an endpoint in my app to receive the webhooks. However when creating a mock subscription it doesn’t send anything to my endpoint. I have tested the endpoint otherwise and it is receiving other requests ok. Maybe there just isn’t a way to actual test these requests coming from monday without actually installing the app in another account? Is that the only solution? Any help is appreciated here!

The Monetization webhooks differentiate between app_subscription_renewal_attempt_failed and app_subscription_renewal_failed. Does the app_subscription_renewal_failed webhook mean that the subscription is cancelled altogether? Or will there be other attempts to charge the customer for renewal?

Through some rigorous trail and error trying to implement async/await functionality, I’ve found that it’s incredibly difficult due to unpredictable “race conditions”. I’ve instead turned to using a batch operation instead. A good example of this can be seen here (create multiple items). I’ve been successful with incorporating this methodology to create multiple groups. Due to scripting in python, in order to pass the data through correctly, it has to be very carefully formatted. def post_request(data, url=apiUrl, headers=headers, timeout=timeout): try: response = requests.post(url=url, headers=headers, data=json.dumps(data), timeout=timeout) except Exception as e: print(e) def create_group_payload(zip_vars: zip): cnt = 0 payload = "mutatio

Hello Community! I have a problem. I want to connect my IDE with my running monday app on monday.com I am trying to write my very first monday app. As an inspiration I took example app for doc actions “Capitalizer”. What I want to do is to connect my VS Code with my test app which is running in iframe. Exact same as Dipro’s Quickstart guide But I don’t know how to configure my IDE to do so. I was searching for solution, but I didn’t find. Or I missed topic. Thanks in advance for a help. Regards, Paweł

I have a board with several views. I have one view that has filters to show the items that I want. I’m trying to figure out how to make the query so that it will return all the items in that view. The following query will return the names of all the view, and it will return all the items on the board, though the people who set up the board aren’t programmers, and apparently don’t know how to name fields, and so I’m honestly not sure how to pull the exact fields that I want yet. { query: boards(ids: 111111111111) { name views { id name } items_page { items { name column_values { id text } } } } }

Hello, searched on the forum and couldn’t a good topic/old post for my question. I’m using a postman flow to collect data from our reporting system to monday. I got it to work just fine. My question is there another way to format create item column fields? Doing it now needing to escape all " makes it hard to read and maintain. Lucky I have only 5 columns to handla but if it comes up to 10+ columns it’s going to be hard to read and maintain. any plans to change the API ?

Hello, We started to get error in “Search Items in the Board by Column Values” module on Make now. Do you know what could be the reason since we didn’t change anything recently. We need urgent help please. [200] [{"message":"GraphQL API is turned off temporarily","locations":[{"line":1,"column":2}],"path":["items_page_by_column_values"]}]

I was suggested to look into the python async await functionality to help speed up a tool I am building that makes thousands of api requests. I understand I will likely run into some limits that monday.com sets, but my example below is only making 41 small post requests, so I shouldn’t be hitting any limitations. Below I have three functions. Not explicitly shown in the main function, I have a list of tuples that contain (board id, column name, column type, defualt values) - col_func_vars. The default values are used when making status columns. Because I am still new to using async/await I have two different methods. One actually uses parallelism and the other, sequential. Running the code using the sequential method, everything works and it takes ~23 seconds. Running the code with parallelism, most of the columns are created and it takes ~10 seconds, but then I run into a server error: aioh

I’m trying to update a subitem status via the api in C#, I’ve gotten the mutation working in the developer playground but when I try to run in my app the api returns a 500 error or a no query string error, below gives a 500 “{"mutation": "{change_column_value(board_id: 6338856281,item_id: 6409465343, column_id: status, value:"{"label": "Manual Attention"}){id}}}"}” {"query": "mutation {change_column_value(board_id: 6338856281,item_id: subitemId, column_id: status,"value": {label: "Manual Attention"}){id}}"} I’ve also tried the below but it gives the error “No Query string was present” “{"mutation": "{change_column_value(board_id: 6338856281,item_id: 6409465343, column_id: status, value:{label: Manual Attention}){id}}}"}” The mutation that works in the developer playground is mutation {change_column_value(board_id: 6338856281,item_id: 6409465343, column_id: “status”,value: “{"label": "Manual Attention"}”) {id}} Is anyone able to advise

I remember reading about some requirements for marketplace apps. Something about needing to remove customer data after 10 days, and not moving customer data out of monday (or making it publicly viewable?) unless the customer (admin?) agrees. I just cannot find this page anymore. I’d love to know what these constraints and requirements were. Cheers.

I’m trying to go through the Quickstart Integrations guide here: Quickstart guide. I initially hit a roadblock on step 3: Set up your dev environment. I was getting errors and it was not returning a URL when I ran the scaffolding command. So instead I looked in the forums and some people suggested downloading the files from the Github repo, so I did that. I ran the command to install the monday.com/apps-cli globally. When I run any mapps command, even mapps help, I get the following:

Hi, is there a way to retrieve the dashboard as is possibile to do with the boards? I checked the docs and the forum but i dind’t find anything. With the query { boards(limit: 1000) { id name type __typename team_subscribers { id name __typename } } } i can retrieve Bords ( and portfolio, templates ) ,subboards, documents. No dashboard was retrieved. Is there a way to retrieve the dashboards? I’d like to check if all the teams are able to view the right dashboards and the dashboards are connected to the right boards. Thank you very much Davide

Hello, I am using the Audit Log API to track the timestamp of when a user’s role has been changed. The response can be filtered by user_id which is the id of the admin who made the change. Is there any way to filter out the response by affected_user_id (the user who’s role was changed)? If not, is it at all possible to, given a user, get the timestamp(s) of when their role was changed by an admin Thank you

Hi Team, I have developed an App to export to PPT from a group or multi-selection of an item and submitted, I received the below reply, not sure how it is applicable to other feature sections and comments or suggestions would be a great help. here is the feature demo https://www.youtube.com/watch?v=5LOn-q8e-JA Hey, I hope this message finds you well. My name is xxxxxx, and I am a member of the app review team at monday.com Marketplace. We have taken the time to review your app [Export to PPT], and we appreciate the effort you have put into it. We have noticed that some of the required features, such as integration recipe, board view, item view, dashboard widget, workspace template, and doc action, are currently unavailable on your app. However, we believe that your app has the