API & Apps framework

I don’t think I am doing anything to complex. I have a board that I want to bring in to Power BI. The board has a few columns that are native to that board. I can get the data from those columns no problem. The issue lies when I am trying to get the data from a lookup table and a few mirror columns that pertain to the lookup. I have followed a few other posts on the forum but noting is working like it should. I have a few screen shots below to maybe help explain what I am working with. Main Board:

Hello, I am using the below call to pull out activity log data between 1/2/2021 and 12/14/2022. The call works, but the issue I am having trouble with is the response stops at 9525 items returned and only covers dates between May 2022 and December 2022. I can use the specific item ID of an item that is older than May 2022 and get it’s data which should be included in my paginated call. Any ideas what I could be doing wrong? No errors are being stated in the final response received from the paginated response too, the last call is simply a blank response.

I’m trying to access the Monday API docs, but everything under the API Reference section is showing up with a 404 error.GraphQL API For example, Items page

In trail version, api response for SALES CRM is not getting

Hi, i try to send a simple request, i want to get all the items changed since date 01/12/23. how can i write it? if i write date4 intead of last_updated its working fine. i tried this but i get an error: query { boards (ids:xxxxxxxxx) { items_page (limit: 100, query_params: {rules: {column_id: “last_updated”, compare_value: [“2023-12-01”, “2024-12-31”], operator:between}}) { cursor items { id name updated_at column_values { id text } group { title id color } } } } } Where can i see all the possible operators? if i want to take all the items changed since some date (and not between dates as i wrote before).

I am integrating monday.com with aws apigateway with a python lambda authorizer. My problem is my python code seems to be enable to decode the jwt token coming from monday.com using the signing key. I’ve tried many libraries but it’s all the same thing the signature verification always fails.

Before I could query items by ID like this: { boards(ids: 1303312611) { items(ids:5820698515) { id name column_values(ids: “person”) { value text } } } } Now we have to use items_page as parent to query items. If I just add items_page to the query as below, I get an error saying items doesn’t have an argument called ids. You also can’t use ids as a filter column I think. So how can I query with items_page an item by ID? { boards(ids: 1303312611) { items_page(limit: 1) { items(ids:5820698515) { id name column_values(ids: “person”) { value text } } } } }

I’m in the process of migrating my old Power BI API code to the new version. However, a significant challenge arises as Monday.com has imposed an API limit allowing the retrieval of no more than 500 rows at a time. This limitation is frustrating because I aim for the new API to dynamically capture all rows, regardless of whether there are 500 or 2000 rows in my board. Is there a dynamic solution to overcome this restriction?

We’re having an issue with a widget we’re developing. We’re building a widget to show a view of all of our approaching deadlines for our active projects. The widget is consuming about 30+ boards. We’re using the settings panel to select which column represents the delivery date for each connected board because they aren’t always consistent. When I test the widget, the settings load fine, but when anyone else tests the widget it just comes in as an empty object. What users get in the dev console: What I get in the

Hi, Im facing something really weird during my api / ui tests. im getting all subitems from a board by board id and get a list of subitems. when trying updating them by change_multiple_column_value im getting success message on each, but I can’t see some of them in the UI although I got them via api. when trying access it by ui (paste the item id) Im getting message : This subitem is either deleted or belongs to a deleted board/group" how that can be happens? note - the state for each rule is active.

Hello Monday API Community, I’m currently working on a project where I need to retrieve the contents of all columns of a specific item, including various field types such as mirror and connected boards. My current approach involves making at least three separate API queries, but I’m wondering if there’s a more efficient way to accomplish this. First Query: I start with a basic query to fetch the dataset, like so: query { items (ids: XXXXXXX) { name, column_values { column { id title } id type text value } } } However, this returns null or empty values for mirrored or connected fields. Second Query: To retrieve mirrored field values, I use: query { items (ids:XXXXXXXXX) { column_values { ... on MirrorValue { id display_value text value }

I currently have several Formula columns that are using REPLACE(REGEXEXTRACT()) to pull strings from a long-form Text column. I want to use the results of these formulas to trigger automations which will move the Items to different Groups. Example: The long-form Text column is a mirror of the content of an incoming email that triggered the creation of the item. The email contains text such as: Brand: TH Region: NA Company: TH_USKS The brand, region, and company are a variable number of characters. The Formula column for Brand, for example, uses the formula REPLACE(REGEXEXTRACT({Email Content}, “Brand: [^\\s]+”), 1, 7, “”) → this would return “TH” for the above example. Since I am not able to use Formula columns within Automations, I am attempting to use General Caster to perform the formulas and cast the results to Text columns which can be used in Automations. It seems that General Caster does not support REGEXEXTRACT(). I don’t think

Has anyone attempted to develop an API or devise a method for exporting Monday.com activity logs in bulk for subsequent importation into Power BI for analysis? If so, I would greatly appreciate it if you could share the approach you took to achieve this. Thank you!

🚨Attention all developers! 🚨 On Jan 15, the 2023-07 API version will be deprecated. Any API request with version header 2023-07 will use 2023-10, and any request with no version header will use version 2024-1. You must take action before this deadline so your app’s features remain available for your valued customers. If you fail to implement the necessary changes for the new API version, your app may break and certain features may become inaccessible. We want to prevent disruption and ensure smooth experiences for both you and your users. As of now, you have 12 days to implement these changes. The clock is ticking, so please allocate the necessary resources and prioritize this update. We strongly recommend taking immediate action to avoid any inconvenience or potential negative impact on your apps’ functionality. If you have already started implementing the changes for the

Does anyone know a quick way to query for an item’s name using the item’s itemId and the boardId it exists in?

Hello, I can’t wrap my head around the new API syntax needed. I am just wanting to query the item by id and return its column values… The following syntax worked fine on the old API. {user: boards(ids: ‘id_here’) { items (ids: [‘id_here’]) { name id column_values { id title value text } } }'; I can’t seem to get a valid column_values query going now… I’ve looked through the docs and they don’t make sense to me… I think I am doing it right but just get errors back. Can someone please translate that old query above into a new, working format ? I know this is kind of lazy to ask like this but it’s really doing my head in… Thanks.

I’m migrating some code to the new 2023-10 api format, and the complexity of a query increated from 15049 to 354652 (more than 20 times) - this renders the integration useless, as my complexity budget is only 1m - meaning I can run this query twice a minute - and I need more than that. The query is a simple query of a single item with it’s sub items (has 4 sub items) Here’s the original query: query ($id: Int!) { complexity{ query } boards(ids: [2673923561]) { id name board_folder_id board_kind items(ids: [$id]) { id name column_values{ id title value } subitems { name id column_values { id title value } } } } } And here’s the same query after migrating it to the 2023-10 api structure - which costs 354652: query ($id:

I am using itemIds listener in my board view, as soon as i click on new task button, I get listener and in data I get itemIds, but one of the item id is ( -10 ), why am i getting such id, and is there any way of validating that a itemId is an actual valid item id, not any other number or string? or is there any way of removing that add task button from my board view. Example of itemIds listener data when clicked on add new task: [“itemId”, “anotherItemId”, …, -10 ] refer this image:

import requests import json class MondayClient: def __init__(self, api_key): self.api_url = "https://api.monday.com/v2" self.headers = {"Authorization": api_key} def make_request(self, query): data = json.dumps({'query': query}) response = requests.post(self.api_url, headers=self.headers, data=data) return response.json() def create_item(self, board_id, item_name): query = f''' mutation {{ create_item (board_id: {board_id}, item_name: "{item_name}") {{ id }} }} ''' return self.make_request(query) def change_item_name(self, board_id, item_id, new_name): query = f''' mutation {{ change_column_value (board_id: {board_id}, item_id: {item_id}, column_id: "name", value: "{{\\\\"text\\\\": \\\\"{new_name}\\\\"}}") {{ id }} }} ''' return self.make_request(query)

Hi, I’m on migration of a lot of powerby using API Monday.com. And during my debugging and query’s rebuild (thanks a lot @hbouk ) i see that board_relation send data only if a query param is parsed. I have the same result with api playground Blockquote boards(ids:xxxxx) { items_page(limit: 100 query_params: {rules: [{column_id: “board_relation”, compare_value: , operator:is_not_empty}]} ) { cursor items { id name updated_at group { title } column_values { id text … on StatusValue { text } … on MirrorValue { display_value } … on FormulaValue { value } … on BoardRelationValue { display_value } column { title type } Res

Hello everyone, I’ve recently joined Monday.com dev community, and I cannot figure out one important issue: In order to use SDK I need to initialize access token through mapps init command So, I’ve tried multiple options (local/global/with different access rights), and always getting the same log: INFO: ‘.mappsrc’ created (by the way with -l key .mappsrc is even automatically added to .gitignore) But the problem is, I don’t see the ‘.mappsrc’ file anywhere, as well as as soon as I try to use any feature (i.e. tunnel), I’m getting this error: Access token is missing, please run: “mapps init” What could be the issue? SDK added globally, as well as added to the project itself. Tried with template app as well as with react/next apps - same story all the time Dependencies: “@mondaycom/apps-sdk”: “^2.0.0” Also, to avoid asking another question

I’ve found that a duplicated board creates the groups within the duplicate with the same group Id’s. When querying both boards it can’t tell the difference between the groups due to identical ID’s. I just find it odd that the ID’s are identical when typically an ID is unique. Has anyone else run into this? I’m relatively new working with this API, so forgive me if I’m missing something obvious.

Hi, We are observing complexity issue with board graphQL api with minimal response properties and a limit of 10 records only. Is this an expected behavior?

Hello, I am trying to use the create_item webhook in my code. I have set up webhook validation and am successfully receiving the webhook payload. However, the problem arises as soon as I click on New Item to create an item on the board; the webhook gets triggered, but it provides empty columnValues . This is webhook payload I’m recieving. { "event": { "app": "monday", "type": "create_pulse", "triggerTime": "2024-01-07T05:37:32.618Z", "subscriptionId": 3189290, "userId": 53812717, "originalTriggerUuid": null, "boardId": 18356535, "pulseId": 1836594, "pulseName": "hello", "groupId": "topics", "groupName": "Group Title", "groupColor": "#579bfc", "isTopGroup": true, "columnValues": {}, "triggerUuid": "ksjjshosajsosasnas" // } } Is there any way after I fill every column value then only create_item

Hi, Predefine column values for a customer into a column. So when they click a button, values from that column are used to generate an action. I.e. status column with “run test 1” “run test2” Any way to add this to custom features?