API & Apps framework

Is it possible to use variables in GraphQL syntax for column values in a mutation? In the example below, I am can use a variable for top level items like board_id and item name. I can’t embed a variable inside column_values for date and the url. I am doing this to allow someone on my team the bulk assign training assignments through the API Playground tool instead of running a Python script I created. Thanks Bruce Example 1 mutation addTraining($myBoardID: Int!, $myItemName: String) { bruceB: create_item( board_id: $myBoardID, item_name: $myItemName, column_values: “{ "status": {"label": "New"}, "status_11": {"label": "HP Mandatory Training"}, "link" : "www.test.com Title Here", "date4" : {"date" : "2023-05-31"}, "person": {"personsAndTeams" :[ {"id" : 11111111, "kind" : "person"}]} }” ) { id } cindi: create_item( board_id: $myBoardID, item_name: $myItemName, column_values: "{ \\"sta

I’ve got the OAuth flow working fine on my client app but I realized I’ve got the client secret in the client and that’s no good so I’m moving some logic to my backend. Currently I’m making the authorization request from the client and then sending the code to the backend. The backend makes the same exact token request as the client was making successfully but it gets returned with a 500 status, ‘Internal Service Error’. I’ve checked everything several times for typos and formatted the request different ways. So my guess is that the token request has to come from the same origin as the authorization request. Is this right?

curl --location ‘https://api.monday.com/v2/boards?limit=25’ –header ‘Authorization: API TOKEN HERE’ –header ‘Cookie: __cf_bm=2lMj7e480dZ0lsh_nOZ.9p6YV88QPB3Vg1i2ZtIe614-1681306537-0-ASaG9jUiKIKYFTdMOqJMZRipgN9wB1y8r4SvEB2eMC1UsQcYgQUbJ1+SA+FGt7lG7f7ppJuRLzh66IFtUsKzJT1NWOka1Mm7LBz2kVYaE9te’

On my developer setup i got data from mirrored column in text field And I got correct response but when i build my project and upload it that not working anymore. What am i doing wrong. Is there some setting I forgot about? Hope that someone can help me with that

Hi Everyone ! It’s been a year that I wanted to set colors for my groups with the API and I read several posts here requesting that feature and replies saying that “Ehh… sorry that’s not available”. 😉 And this morning, I wanted to check again and saw that the API documentation was updated with this sample code : *mutation {* * update_group (board_id: 12345678, group_id: "today", group_attribute: color, new_value: "red") { * * id* * } * *}* So… I was super happy and excited to try… I quickly wrote a piece of code to get the Groups properties of my Board dedicated to experimentations and parsed them to see how it looked. Turned out that the API sends me my groups colors in hexadecimal : string(285) "{"data":{"boards":[{"groupsapitests":[{"id":"xxx","title":"GRP1_GREEN","color":"#00c875","position":"256.0"},{"id":"xxx","title":"GRP2_BLUE","color":"#579bfc","position":"512.0"},{"id":"xxx",

Hello, I’d like to record my frustration at not being able to specify the original ‘creator’ of an update using the ‘create_update’ API muttation. For various reasons I have made an application design choice not to use automations in favour of using the GraphQL API. When moving an item from one board to another, I get all the ‘update’ attributes I need to potentially call the ‘create_update’ API mutation with the original creator id (and other attributes). I note that requests to add this feature is outstanding for a few years now. I appreciate you get deluged with such requests, but this trivial change to the API would be extremely powerful. I note also that there is an add on for Updates residing the the ‘Apps Marketplace’ that probably supports this, so this change must be viable. Please consider.

We just released a blog post that explains the ins and outs of adding analytics to your apps: SaaS App Analytics Guide It suggests some best practices, lists some metrics you can track, and walks you through the technical side of things. Check it out and let us know what you think! And of course, if you have any questions 🔮

Hello everyone, Recently I’ve been working on the external App that pushes data to the Monday board. For security reasons, we are not using API token, but instead, we are getting Access token from Monday with OAuth flow. To configure OAuth I created APP with some required scopes only. From the recent test, I’ve discovered that the issued access token always has access to the API. Steps to reproduce: Create APP, grant read board access, get token via OAuth flow (using client_id & client_secret) Use API to read data from GraphQL (with access token) Remove read scope access on Monday side/ refresh client_secret and signing secret Use API with the same access token from step 2 - API retrieves data Delete APP, use read API - still worked From the test, I see that the Access token is always valid, with a removed app and changed scope. It’s a big security concern for us, could you please advise on

Hi, a beginner here asking for API help. (ChatGPT has already brought me far but I’m still a bit stuck) I’m trying to update my Monday.com board according to changes in Google Sheets. My GoogleSheets is able to send out the following JSON string mutation request: { “query”: “mutation { change_column_value (board_id: 4353413926, item_id: 4353413947, column_id: "__", value: "{"text":"2521"}") { id } }” } Which I think is correctly formulated for the Monday.com API to receive. Board ID, Column ID, and Item ID have all been checked to be correct. API token is, I think, also correct (At least I’m not getting an error from the Google Sheets side). However, I’m not seeing the change requested by this string on Monday.com. On the individual board items, I’m not seeing any API requests in thei

I was trying to add an integration recipe in my app but i am not able to choose this when button clicked trigger any more, I only see button clicked which as a bit different language.

Hi there, I’m trying to create new columns relative to particular existing columns on the board, but it doesn’t appear at first glance that there is a position property to set on the existing mutations. In light of the recent updates to the group’s position arguments (relative to, position relative method), I think it would make sense to apply a similar approach to be able to create columns at a position relative to another given column. Is this type of functionality currently possible with the API? If not, should I create a separate feature request post for this?

When adding columns to a board through the WorkForms builder, Monday does not send any column created webhooks. Is this the intended behavior, or is it a potential bug?

Hello, I have a board with 4 groups, ~170 items, and some number of sub items. I’m attempting to pull the data from the sub item columns. I initially attempted the following query: query{ boards(ids:2596083107){ items{ id subitems{ id parent_item { id } column_values{ title text } } } } } This returned a complexity error: “Query has complexity of 24011020, which exceeds max complexity of 5000000” I attempted to get just the sub item data query{ boards(ids:2596083107){ subitems{ id parent_item column_values{ title text } } } } I was met with: “Field ‘subitems’ doesn’t exist on type ‘Board’” I went back to my original query and attempted to break it up into pieces based on group: query{ boards(ids:2596083107){ groups(ids: “new_group”){ items{

Hi, I hope this is the right place to post this question… We are using Webhooks integration: “When any column changes send a webhook”… We have a two-way application which sometimes updates the column data externally. But this then triggers the Monday Webhook - which sends the same data back to our original application - this is at least causing us to process unnecessary traffic - and I suppose could cause data sync issues on a slow network. Is there some way to have the webhook trigger like: “When any column is changed IN MONDAY ONLY send a webhook” (If we have to write a Monday app for this, can someone provide an outline of how?) Otherwise what is the sensible way for us to check in our external application that the column change was made IN MONDAY and not via API/Webhook…? I can see in the Webhook data when change is made in Monday contains the [previousValue] array… Would it be safe for us to check for the existence of this array

Hello, We have 3 field types each of which is pulling in options from different urls We use these field types in our recipe workflow but for each of these fields we are receiving api request to same endpoint of the first one to get mirror columns. when I inspect the reqeust that is sent to

After some experimenting and troubleshooting, I’ve determined that group_id must be a required argument in the create_item mutation. The example code here shows the mutation without that argument: Overview of GraphQL However, it was only after putting in a group_id like in the example from the documentation here that the 500 error went away: Items Can you please test and confirm if this is an issue, and if so, update the documentation?

According to the changelog, the position value on the create_group mutation was deprecated. However, there are a few issues when it comes to the documentation: The hyperlink on the changelog post links to itself. You have to navigate to the appropriate method on the group api page. The documentation states that position_relative_method argument behaves differently if there is relative_to argument as well. It appears to go above the relative_to group id with a before_at value, but if the relative_to argument is missing, it goes at the bottom of the board. This is counter-intuitive. You would expect this to go to the top of the board as you’re placing it

Running into errors when trying to create_item and it is giving a Parse error. Here’s the code: mutation ($boardId: Int!) { create_item ( board_id: $boardId, group_id: “topics”, item_name: “New item”, column_values: “{ "text0":"SKYLINE", "text5":"timbuktu" }” ) {id} } Here’s the error message { “errors”: [ { “message”: “Parse error on bad Unicode escape sequence: "{\\n \\\\\\"text0\\\\\\":\\\\\\"SKYLINE\\\\\\",\\n \\\\\\"text5\\\\\\":\\\\\\"timbuktu\\\\\\n }" (error) at [6, 26]”, “locations”: [ { “line”: 6, “column”: 26 } ] } ], “account_id”: 12345678 } Thanks in advance.

I have some columns in “board2” which are mirrored from “board1”. These are ‘text’, ‘number’, and ‘status’ columns. Is it possible to trigger an action in board2, when value/text inside any of these three column changes in board1? I tried using “When column changes” or “When status changes to something”, but I don’t see any mirror column reflecting in the dropdown in recipe sentence.

Hello Everyone, I’m currently working on using webhooks with a mirror and I’m encountering some difficulties. I have two boards, Test1 and Test2, and I’ve set up a mirrored field called “Status_Mirror” on Test1, which mirrors the “Status” field on Test2. I’ve also set up an integration that sends a webhook when any column changes. However, when I change the status in Test2 or the Status_Mirror in Test1, it doesn’t send a payload to my webhook. It only works when I change a non-mirrored column. I’m trying to avoid having to create three columns per board that I want to mirror and use the data from. My idea was to use the webhook to handle the moving of items to different groups. Currently, I need to link all the boards, have a link column, a mirror column, and a trigger column, just to move an item based on the mirror column’s status (which is echoed to the trigger column and the automation is done from there). If anyone has any knowledge or can offer any

Hello, I am trying to create a generic template for ETL jobs, every job essentially requires a dev to develop / test ETL sections and I want to create a simple template for this. The simplest idea I could think of was duplicating an epic and change the name of the epic. Subtasks can stay the same. When I try to do this, the epic gets created and I can see it on my sprint board but I cannot see the subtasks, even though I can see them on the epic page, can you help? Thank you

I am trying to extract data from monday.com from Qlik.I am struggling with pagination.So,Monday.com is Graphql based platform and Graphql supports cursor based pagination.Do Monday.com supports cursorbased pagenation?? For eg :below Query works. { boards(limit:10,page:1) { columns { id } } } When I try to add fields for cursorbased pagination,it shows below error message- “message”: “Field ‘pageInfo’ doesn’t exist on type ‘Board’” Query used is as follows- { boards(limit:10,page:1) { pageInfo{hasNextPage totalCount} columns { id } } } Kindly help with the pagenation.

Hi, Currently, I am trying to build an integration between monday.com and the external system. But I have a question regarding the built-in triggers of monday. When I am trying to log the data when specific events occur (For example: When the button is clicked) Monday triggers give events even if the button is not clicked. Is this normal behaviour? Is there any way to get the event data only if the trigger occurs? Is there any way to get the event data only if the trigger occuer? Example trigger log: {'payload': {'blockKind': 'action', 'blockMetadata': None, 'inboundFieldValues': {'boardId': 1180565737, 'itemId': 1180565821, 'sourceColumnId': 'button', 'targetColumnId': 'text_1', 'transformationType': {'title': 'to upper case', 'value': 'TO_UPPER_CASE', 'invalid': False}}, 'inputFields': {'boardId': 1180565737, 'itemId': 1180565821, 'sourceColumnId': 'button', 'targetColum

Hi everyone! I’m new to using Make.com to build integrations with monday. I have a scenario that rolls items up to another board. When an item is created in board X, a new item is created in board Y. I’m using a watch events webhook, triggered by a status change on monday. In order to prevent duplicates from being created in board Y, im trying to retrieve the data in board Y, and apply a filter to check if the item already exists. I’ve tried Execute Graph QL to find an item by column values, and have also tried the Search By Items Column’s values module in Make. The problem is: the bundle returns empty on the first few runs. It only finds the newly created item if i wait a few mins. For instance I added a Sleep module of 70s, and that gave it enough time to register the new item, find it and successfully avoid duplication. I’ve noticed this issue of data not registering right away in several othe

In one of our apps I’ve been trying to build an integration that would update the status of an (sub)item on a custom trigger. This is easy for normal items, but not subitems. For normal items you have a couple ways to do this: Use the pre-build action “change status” Create custom action with the recipe sentence input fields “Status Column” and “Status Column Value” These two options however don’t seem to account for subitems. I’ve created a custom “Subitem Status Column” field type that returns a columnId, however any column field other than “Status Column” is not usable with the “Status Column Value” field (I get a blank screen, screenshots). Even if you select the generic “Column” input field type with a constraint of allowed column types “Status” it is not possible. I assume the reason for this is that “Status Column Value” has a dependency on “Status Column”.