API & Apps framework

Does an app’s API access token expire if a customer’s app trial has ended? This is for an app integration that a customer wanted to trial in the marketplace.

Hi Darshan Hiranandani, I hope you’re doing well! I’m currently working on enhancing the security measures for our app to protect user data from vulnerabilities and potential breaches. As someone who might have experience or insights in this area, I would greatly appreciate your advice and suggestions.

Hey team, I’m Darshan Hiranandani, I have a question regarding our app development process. I’m curious about the possibility of integrating third-party services or APIs into our app. This could potentially enhance functionality and provide additional features for our users. What are your thoughts on this? Have you had any experience with integrating external services or APIs into apps before? I’d love to hear your suggestions and insights on how we can approach this aspect of our development.

Hi, We are going to implement monetization on our app, offering both standard and premium plans. I have some questions I would like to clarify. When a user installs the app, it will be under a 14-day trial period. What will be the data for the renewal date? We need this information to calculate how many days are left in the trial period. If the renewal date does not mark the end of the trial period, I guess we can’t rely on the “days_left” data right? Do you have any suggestions? query { app_subscription { billing_period days_left is_trial plan_id renewal_date } } Thanks. Br, YarHuoy

Hello Monday, Here is what I try to accomplish, the platform that I have used so far, and the obstacles that I have encountered, wondering if people know any alternative solutions here: Goal: I want to develop a form featuring dropdown questions that are capable of dynamically fetching data from various boards. Progress: I have used Retool, an integration platform that allows you to query data from different baords through Monday’s GraphQL API. Despite its functional compatibility with our requirements, Retool’s pricing model, especially concerning unlimited external user access, has rendered it an impractical choice for our use case. Question: I’m currently looking for alternative platforms that can offer seamless integration with Monday, enabling the creation of similarly functional form. Or does Monday form provide functions that support dynamic data fetching?

Hi there, I had finished a script that does the following retrieves active tenants, leases, and properties, and then iterates over the active leases to create or update main items and subitems in Monday.com. This worked great before the API update and I’m working at updating it to get it working again. My question is for Sub Items. I have this function for getting the ID of existing sub items def get_existing_subitem_id(parent_item_id, subitem_name): query = f’‘’ {{ items(ids: {parent_item_id}) {{ subitems {{ id name }} }} }} ‘’’ response = send_graphql_request(query, {}) items = response.get("data", {}).get("items", []) if items: subitems = items[0].get("subitems", []) if subitems: for item in subitems: if item["name"] == subitem_name: return item["id"] return None how would I change this to work with the latest API version I don’t think this is correct def get_existing_subitem_id(parent_item_id, subitem_name): query = f’‘’ {{ items(ids:

On a board I am working with, the items are grouped by what I assume is a widget, a top level grouping. In the api, how can I find out what the name of that widget is when I query and get all the items. I want to find that Carlos belongs to MISC METALS. I am able to get Carlos, how do I find MISC METALS?

I want to query all items that have been updated since a given date. e.g. updated_at > X. Is that possible? If so, how?

I changed the request according to the changes of your new version ( 2023-10 ) I previously searched by “item_id” column and now I get an error This is one-to-one function of a certain row, what is the best practice way to find that row now? I was able to create a copy of the column and convert it to text and thus find, but I feel that this is not the best solution Thanks in advance

Hi, Im trying to build my own automation, how can i controll this text in my recipe? and mysecond question, why when i choose a field its not looks the same in the message? where the first part come from? Thank you!

Hi Folks, I connect to the Monday.com api from Alteryx. I get all the first 500 records with issue but having trouble with the next 500 by using next_items_page. By using the cursor from the first 500 records, the query works well in API playground. However, when I use the same query in Alteryx, I just keep getting error messages. When I try to query with Content-Type = “application/json”, I receive an error message for DownloadHeaders: HTTP/1.1 500 Internal Server Error Date: Fri, 16 Feb 2024 16:46:42 GMT Content-Type: text/html Transfer-Encoding: chunked Connection: keep-alive x-request-id: 1b0d73bf-b731-99b8-b1a0-0308cc78235e x-runtime: 8.957594 x-envoy-upstream-service-time:… When I try to query without Content-Type = “application/json”, I manage to get through with DownloadHeaders return “HTTP.1.1 200 OK” but I receive an error message for the DownloadData, {“errors”:[{“message”:“No query string was present”}],“account_id”:12345678} Like I previously mentioned, the query works p

I am stuck trying to understand how custom triggers work. I think im missing a step in the flow. I am creating both custom triggers and actions. So here we go: 1st step: create the trigger with input and output fields. 2nd step: create the action with input and output fieds. 3rd step: connect both trigger and action in the resource->models tab. 4th step: subscribe the board to the integration. 5th step: this is the one i am missing. When the trigger get triggered, it should call a endpoint in my backend passing me the info that triggered the action. Instead, the documentation says that I have to call an endpoint (WebhookURL) when i want it to fire. This question make sense? Thanks in advance for seeing this! Please consider that i already have a working app with multiple custom actions working just fine, so i dont think it is a configuration related question, but a workflow one.

Hi All, We are evaluating Monday as a possible new platform to replace our current PMO solution, and I’m trying to test out the API. I was able to generate an API key using an admin account and attempted to connect to the API using the simple example code provided in the documentation. import requests import json apiKey = "NotMyRealAPIKey" headers = {"Authorization" : apiKey, "API-Version" : "2023-04"} query2 = 'query { boards (limit:1) {id name} }' data = {'query' : query2} r = requests.post(url=apiUrl, json=data, headers=headers) However I was surprised to immediately get an error when running this: Exception has occurred: SSLError HTTPSConnectionPool(host=‘api.monday.com’, port=443): Max retries exceeded with url: /v2 (Caused by SSLError(SSLCertVerificationError(1, ‘[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self signed certificate in certificate chain (_ssl.c:1108)’))) ssl.SSLCertVerificationError: [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: sel

Hi, I want to send a webhook from my server, i defined a webhook and the json file: const webhookUrl = ‘wwwww’; const yourToken = ‘ttttt’; const payloadData = { authorization: yourToken, payload: { blockKind: ‘action’, inboundFieldValues: { itemId: 1401819003, boardId: 1401818805, text: ‘ABC123’, columnId: ‘description’ }, inputFields: { itemId: 1401819003, boardId: 1401818805, text: ‘ABC123’, columnId: ‘description’ }, recipeId: 30211924, integrationId: 86765949 } }; I recieve the webhook on Make, but in the server i get the error: [0] Error sending webhook: SyntaxError: Unexpected token A in JSON at position 0 [0] at JSON.parse () [0] at parseJSONFromBytes (node:internal/deps/undici/undici:6498:19) [0] at successSteps (node:internal/deps/undici/undici:6472:27) [0] at node:internal/deps/undici/undici:1145:60 [0] at node:internal/process/task_queues:140:7 [0] at AsyncResource.runInAsyncScope (node:async_hooks:204:9) [0] at AsyncResource.runMicrotask (node:i

I am running a script for grab some data from the api. However, not all the data is coming through. Particularly for the connected_board columns. The data only comes over if I return one record by id at a time. This would be inefficient to loop through each item by row id. Example 1 graphQL: query { boards(ids:%s) { name id groups{ title items(limit:5, page:1){ name column_values{ title id text } } } } } This returns: Example 2 graphQL with ID: query { boards(ids:%s) { name id groups{ title items(ids:%s){ name column_values{ title id text } } } } } How can I get the column values to come though in example 1? For the second example the same item with the same pulse id comes up in multiple groups. How is that possible when the board only shows the record in one group? Thanks for the assistants!

I am trying to create new fields with specific id in every boards. It turns out that I am not able to create fields with same id even if it is on another board. Also, even after permanently deleting the field I am not able to create a field with that name. is there any solution to this two issues?

I was going through documentation of monetization in apps. Here the info regarding days validity is missing in case of monthly subscription. See the dash in the last line. Can we please get this fixed. Thanks

Hello, I know that you can add webhooks to a board to see when new changes are made, but is there a way to add listeners for a workspace? Thank you

The documentation here - API reference mentions that subscription object will be part of the context response. But I am not getting that data for my app. As a result I am not able to check whether a company is in trial phase or not for my app. Please help in this regard ASAP, as my app is live on marketplace.

Hey guys, i am confused, need help. I have developed a feature, npm dev run, copy the url to a new build, publish it, and it works right… , but every time i need to change the code, i have to create a new version of the app, then a new publish it, just for testing?? I feel this is not correct. I should not have to make an app “live” just to be able to test it right? What i am doing wrong?

My error message : ‘Type mismatch on variable $board_id and argument board_id (Int! / ID!)’ const createItem = async (payload) => { const { board_id, item_name, column_values } = payload; const query = gql` mutation CreateItem($board_id: Int!, $item_name: String!, $column_values: JSON!) { create_item(board_id: $board_id, item_name: $item_name, column_values: $column_values) { id } } `; const variables = { board_id, item_name, column_values: JSON.stringify(column_values), }; const { data } = await mondayApi.post('', { query, variables }); logger.info({ function: 'createItem', message: 'Create item - Monday', data, }); return data.create_item; };

Error: “errors”:[{“extensions”:{“argumentName”:“column_values”,“code”:“variableMismatch”,“errorMessage”:“List dimension mismatch”,“typeName”:“String!”,“variableName”:“value”} Here is my code snippet - I am trying to migrate my existing code to the new api. const getItemId = async (payload) => { const { board_id, column, value } = payload; const query = gql` query GetItems($board_id: ID!, $column: String!, $value: String!) { items_page_by_column_values(limit: 50, board_id: $board_id, columns:[{column_id: $column, column_values: $value}]) { id } } `; const variables = { board_id, column, value, }; const { data } = await mondayApi.post('', { query, variables }); logger.info({ function: 'getItemId', message: 'Get item id - Monday', data, }); return data?.data?.items_page_by_column_values?.[0]?.id; };

Hi, In older Monday accounts the “Main Workspace” has id null (like specified in docs) while in newer accounts the id is a true number(which contradicts the docs). As a result, the API is now inconsistent. For instance, the query below returns: the boards of the main workspace in older account nothing in newer accounts. This makes it hard to develop reliable programs for developers. What is the future planned behavior for this? Please also suggest a way developpers can reliably point to the Main Workspace. Thanks { boards(workspace_ids: null) { ...boardFragment } } fragment boardFragment on Board { id name description type state board_kind board_folder_id items_count permissions updated_at workspace { ...workspaceFragment } top_group { id } } fragment workspaceFragment on Workspace { id name }

Hi, this is a two part question. Part 1: We have a board that is managed strictly through the API. Long story shot - the product teams use Monday, the engineering teams use Jira, our script connects Jira epics to Monday items and displays their aggregated story points. Problem is we have a lot of engineering teams and the Monday board is at +500 items. For what I am currently doing I don’t need specific items so I do a bulk retrieval from a group. But I have no idea of how many items are actually on the board, just that its more than 500. I know its more than 500 because we keep logs of uploads and I also run a cleanup script to make sure there are no duplicates or link issues and that script only returns 500 items. Its been returning 500 for 2 weeks now despite the main script adding new items. So is there an API way to return a count of group items? Part two is I don’t understand the cursor property. I assume its like a startAt and limit combination but I don’t see where I would put

Hi, I’m working on an application that identifies formulas columns on a board and listens to changes in formulas. I’m able to get information from the context via monday.listen(“context”), but I don’t get any callbacks on this callback, even after modifying a formula column on the board. monday.listen("events", (res) => { console.log(`*** now it seems the events has changed:`, res.data); }) I was initially running the app in Preview mode with the tunnel, and I thought maybe it was due to this. So I created a new build of the app, upload it, and then loaded the app on my board. Even after I install the app and make changes to the formula column, I cannot see anything printed in the console. Could you please help with this issue. Many thanks.