API & Apps framework

Hi, I am using monday’s JS SDK to do api calls. Should I have a concern to maintain rate limit errors or does the SDK mange these rate limiting problems on behalf of me? Thanks

Looking at the new app_subscriptions_operations API (App subscription operations) One thing that doesn’t stand out as obvious to me is the subscription period. It seems tied to the billing period. Does this mean if someone is billed yearly, it only resets yearly? Or does it reset at the monthly period of the year?

Hi, we developed an app that integrates with the monday.com API via oauth. From my understanding it looks like there are processes. One is that they install their application in their tenant, but a second step they have to give permissions to to our app to access data. If the user installs from the market place, I assume the app is installed there and then they are directed to my app to sign up and go through the oauth process? If the user starts from my application, do I have to send them to the install link to do the install, and then have them give access through the oauth process? Also, the market place submission form doenst seem to be working, I filled out all the fields and it says I have to fill out all required fields. I doubled and trippled check. Thank you, Marty

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: mutation { add_file_to_column ( item_id: 1234567890, column_id: "files", file: YOUR_FILE ) { id } } or curl --location 'https://api.monday.com/v2/file' \\ --header 'API-Version: 2024

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’: activity_log_query} activity_log_request = requests.post(url=apiUrl, json=activity_log_data, headers=headers) activity_log =

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 for this column. https://developer.monday.com/api-reference/docs/change-column-values", "error_code": "ColumnValueException", "error_data":

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 = "mutation {" for board_id, group_name in zip_vars: x = f""" complexity {{ query before after }} createGroup{cnt}: create_group (board_id: {bo

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: aiohttp.client_exceptions.ClientResponseError: 500, message='Internal Server Error', url=URL('https:

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 me what I’m doing wrong when trying to get this int

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: