General

Hello, I need help with my Python code where I am retrieving element information from all boards specified in a table named: df_boards_norm. But i run into a problem that in some boards there are more then 500 items (and i have a limit of 500, I cant change this part), and the cursor then is not null. I need somehow to check if the cursor is not null to run the code again with the same board id where it left of, but if it comes on null, run other boards like normal. Thie is my part of the code: pulse_1 = pd.DataFrame() for i in range(len(df_boards_norm)): q_pulses = ( "{boards(ids:" + df_boards_norm.loc[i, "id"] + "){items_page (limit:500){cursor items{id name column_values (types: time_tracking){value}}}}}" ) data_pulses = {"query": q_pulses} r_pulses = requests.post(url=apiUrl, json=data_pulses, headers=headers) pulses_json = r_pulses.json() df_pulses_norm = pd.json_normalize( pulses_json['data']['boards'][0]['items_page'],

I’d need a solution to send a weekly summary of all the items+subitems with “Done” status to a certain channel in Slack 🫣 The basic Slack integration only supports item status (no subitems…) and the nature of the automation is kinda flooding the Slack channel (every Done status sends the message), as there’s no way to “summarize” the statuses. So, I though if the API could be the solution here 🙂 I could be terribly wrong, but please bare with me. Is there something like that already available/examples somewhere?

Whenever we add a app’s item view to a board, we’re getting the error “Sorry for the inconvenience, we couldn’t create the Widget”. This seems to be a recent error (last couple of days.) It doesn’t happen with standard item views (like Item Card), but it seems to happen only with app item views (I tried a couple of apps, including DocuGen.) Although the errors is displayed, the item view is added successfully and it doesn’t seem like there is any impact on the usability of the app’s item view. Does anyone know the reason for this error?

Good afternoon, I’m trying to create an application using a node.js integration in which when the status changes, it sends a confirmation message to the user using monday.execute , for example. However, I’m struggling to establish the connection and would appreciate any help. Thanks, everyone.

Hi, I want to search my board by item names using items_page_by_column_values Grapql query. When I run the following query it returns empty result even though the item is on the board as active. items_page_by_column_values(board_id:12345678, columns:[{column_id: "name", column_values: ["Task"]}]){ items{ id } } Here is my board view: As you see there are items including “Task” keyword but the api does not mange to find them. How can I retrieve my items searching by the item name leveraging the API? Thanks.

We submitted an application that got denied because it isn’t a monday.com application thats integrated using the monday.com framework. The approach we took was using oAuth and the API, but it’s standalone. With this, my though is to build a monday.com application that integrates with our application (that lives externally). My though would be when a column is updated, post to “our application”. Would this be the correct approach to glue or application from monday,.com to our application so we can have a listing in the market place? Thanks!

I am using make.com to create subitems in a monday board. The query itself is fine and working. In this specific scenario, I am listing items in a group (around 200 items) and creating a subitem for each item. Each time, the 33rd operation fails, due to API cmplexity issues. It’s quite strange as I have done similar things in the past with no problem at all. Here’s the error: [200] [“Complexity budget exhausted, query cost 30001 budget remaining 9967 out of 1000000 reset in 0 seconds”] [ Error Code: complexityBudgetExhausted ] Here’s the api call: mutation { create_subitem( parent_item_id: {{7.id}} item_name: “test” column_values: “{"text": "0db9d56361", "email": {"email":"{{7.mappable_column_values.email.email}}","text":"{{7.mappable_column_values.email.text}}"}}” ) { id } } Does anyone no what might be the issue? Thank you in advance!

Hi All not sure what went wrong below query working fine some time before { boards{ id name columns { title id type } groups { title id } items { id name group { id } column_values { id text value }}}} today i was testing data it says “message”: “Field ‘items’ doesn’t exist on type ‘Board’”, can you please help me how to find who made changes …because this query working fine i think 2 months before ,

Has anyone tried integrating Monday with ServiceNow? We manage all of our request in SN and use Monday to track projects and product reporting for our PMO, so we want to be able to link the two applications to avoid duplication.

I’m trying to update columns on monday via make and I receive a 500 error, 809 “unexpected token” - no idea what this means. I know the error is coming from Monday Here are a few images of the error and the input:

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!