API & Apps framework

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?

I have create and application on the development center, then I have create a feature on the section of Board multi items menu but, when a select 3 items and go to my application I am only receiving a sessionToken in the request. I do not see a way to make a API call to retrieve the 3 selected items I have. How can I get my batch or context information with the items I had selected in order to execute my actions on those ids?? I am using API calls, no SDK at the moment. Please advise. Ronald

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.

If I use an ID column in the following query then it gives me an error. All other columns are fine. I do not have any other unique feature in the board to search by, only ID. How do I fix the error? { items_page_by_column_values( board_id: XXX columns: [{column_id: “item_id”, column_values: “YYY”}] ) { cursor items { name column_values(ids: “status”) { value text } } } } This is the error that I get: { “error_code”: “UnsupportedItemsByColumnValueQuery”, “status_code”: 200, “error_message”: “Column of type pulse-id is not yet supported as a filter”, “error_data”: { “column_id”: “item_id”, “column_type”: “pulse-id” } }

Hi, I have been trying to implement an automation integration in which i need to integrate my application to monday.com through an OAuth flow. From the monday dev console configuration, I have set up an “Authorization URL” which points to the authorize url of our application’s outh flow. Our application is hosted on, say, Server 1. I have created an application by downloading the integration template for nodejs and hosted it on Server2. When I try using the automation template and click on use template, the browser redirects to the Server1 oauth url, e.g. https://dev1.server1.com/oauth/authorize with a redirect uri set to an endpoint on server2, e.g. https://server2.com/automation/oauth/ - this endpoint basically receives the Auth code returned from server1 and hits the /token endpoint on server1 and get the access token. I need to now redirect back to the backToUrl that was received in the token sent by monday.com initially. But while doing so, I receive a CORS error. In short, what I

I didn’t understand this error. It used to be normal, but now it says “Type mismatch on variable $boardId and argument board_id (Int!/ID!)”. I don’t understand that my boardId is already an integer

I’m trying to update items in C# via api calls, but my query is not working, it returns a 500 Internal Server Error, Version: 1.1, but it works in the play ground: {“query”: “mutation {change_multiple_column_values(item_id: 5720531888, board_id: 5720522778, column_values: “{"name":"Name changed","people":{"personsAndTeams":[{"id":"42575577","kind":"person"}]},"status":{"index":1},"numbers":"10"}” ){id} }”} This the mutation that works in the play ground the exact mutation, which is not working it code, the values and format are all the same so they are correct: mutation worksHere {change_multiple_column_values(item_id: 5720531888, board_id: 5720522778, column_values: “{"name":"Name changed","people":{"personsAndTeams":[{"id":"42575577","kind":"person"}]},"status":{"index":1},"numbers":"10"}” ){id} } By the way, I am able to udpate the board in code, add_users_to_board or delete_subscribers_from_board and that works, including updating description and board name. Looking forward t

Hi, everyone! I am starting out using the API, and I am having difficulty with a simple script. I am trying to retrieve column values from a board and I keep getting an error: Cannot query field “items” on type “board”. Is this to do with permissions? Or is my script incorrectly formatted? query{ boards (ids: XXXX){ items { column_values (ids: "status", "text" { title text } } } } Thanks for any help!

Im using column_values to get all columns from a specific pulseId and I’m not getting the first column “Contacts”. All other columns are retrieved. What am I doing wrong? { items(ids: 4218053704) { column_values { column { id title } id type value } } }

Hi - I am trying to create an app so that I can use it to share with other users as a template. However, when I go to choose a workspace, nothing is showing up in the dropdown. Can anyone please help <3

Hi. I improved the souce code from Guilherme Chaguri to add a Recursive Function to get all the data from the Monday board via API 2024-01. I use this function for my work. and are happy to share it for everyone to use. Download this function code from my post in Guichaguri’s Github. gist.github.com

Hello, We submitted some apps for monetization about two weeks ago but got no answer yet. Last time we got a response in a couple of days. I tried to reach out to Shaul but he never replied. Is everything ok? Should I re-submit the forms? Please help