General

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 help, I would greatly appreciat

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', 'targetColumnId': 'text_1', 'transformationType': {'title': 'to upper case', 'value': 'TO_UPPER_CASE', 'invalid': False}}, 'rec

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 other scenarios i’ve worked on. And i’m wondering if anyone has any solutions or tips on this

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”. So the only way I can see how to implement this if I also create another custom field type “Subitem Status Column Value

Something bad is going on. I can’t give ppl discounts. The plan dropdown is empty and there’s hundreds of requests to: https://:account_slug.monday.com/apps_ms/apps_backoffice/apps/:app_id/plans Cc: @Matias.Monday @shaulgittelman

I am trying to connect a form from our website through Zapier. All the information comes through properly except the phone number. I have included an image of the error message that I keep getting about the “countryshortname”. I have tried turning the “flag” for the phone column on with no luck. I have attempted to place (phone9: in front of the information from Squarespace also with no luck. Any help will be appreciated.

My app is an integration that connects to an external view that displays particular items that are selected via a status column in the board. The status column has to have specifically named labels. Is there a way to package a column template with my app or otherwise publish a column template? The worst case scenario is the user having to set up the column manually because any mistake will mean the app doesn’t work.

Hi, based on a start date I used a formula to calculate a ‘follow up date’. With FORMAT_DATE I did the formating. But the column is not provided in den calendar view. I guess monday does not accept the formula as a date field. Any idea how I get the result of the formula into a date automatically? Cheers

Hi Team, I have tried using @Guichaguri (Guichaguri’s gists · GitHub) powerbi script to connect monday.com board data into powerbi except formula column duration every data is listed , so could you please help me how to import formula column duration board into powerbi using query. Thanks, Duken.

Hello there, First post in the developer section. I’m trying to figure out how to write a code in GraphQL for deleting subitems. I’m reading this description (Items) and I note this quote “Using this board ID and subitem ID you can apply any action to the subitem as you would to a regular item (i.e. archive it, delete, change column_values, etc).” and it’s not clear to me what syntax I’d have to use to delete (not to create) a sub item (not an item). Would it be something like this: mutation { delete_subitem (parent_item_id: 1234567, item_name: "subitem to be deleted") { id board { id } } } or something like this with the parent item id inserted somewhere? mutation { delete_item (item_id: 12345678) { id } }

Hi everyone, There is a new Shopify Integration app on the monday app marketplace. This integration between monday.com and Shopify allows businesses to streamline their e-commerce operations by syncing data and automating workflows between the two platforms. This integration can enable teams to efficiently manage orders, refunds, and customer data across both systems, reducing manual data entry and increasing accuracy. For example, orders from Shopify can be automatically created as items in monday.com, allowing teams to track their progress and manage fulfilment. More recipes will be added based on user feedback and request. Multiple Shopify stores can be connected with one monday.com account If you have a Shopify store, please try out the app by installing it from the marketplace.

From last 5 day we are getting error for Scheme query “Query has depth of 8, which exceeds max depth of 6.” It was working fine till now before last 5 days. Suddenly we are getting this error now. If we remove the levels schema validation is failing. Is there is any changes are done in end point for this? My query which working earlier is: query { mutation: __schema { mutationType { name kind fields { name …recursiveFrag1 args { name type { kind name ofType { kind name enumValues { name description } ofType { kind name } } enumValues { name description } } } } } } output__retrieve: __type(name: "Item") { name kind fields { name description ...recursiveFrag } } } fragment recursiveFrag on __Field { type { name kind ofType { kind name enumValues { name description } fields { name description type { name kind ofType { kind name } } } } fields { name description type { name kind ofType { kind name } } } inputFields { name description } enumValues { name description } }

Trying to programatically create subitems on a monday board with a phone number column. I’m formatting the phonenumber as per the API documentation but I’m getting ColumnValueExceptionwith phone numbers ClientError: GraphQL Error (Code: 200): {“response”:{“error_code”:“ColumnValueException”,“status_code”:200,“error_message”:“invalid value, please check our API documentation for the correct data structure for this column. https://api.developer.monday.com/docs/change-column-values",“error_data”:{“column_value”:"{"countryShortName"=>"GB", "phone"=>"+7777777777"}”,“column_type”:“PhoneColumn”},“status”:200,“headers”:{}},“request”:{“query”:“\\n mutation {\\n create_subitem (\\n parent_item_id: 3441762528, \\n item_name: "Test name",\\n column_values: "{\\"name\\":\\"Test name\\",\\"phone\\":{\\"countryShortName\\":\\"GB\\",\\"phone\\":\\"7777777777\\"},\\"email\\":{\\"text\\":\\"simon@keyzy.com\\",\\"ema

Hi I have a Workspace App I’m developing and when I push either a Major or a Minor update and try to update the app in either a test account or the account I’m developing in I get: {"error":"invalid_request","error_description":"Invalid client_id param"} when I inspect the page’s code. Any ideas for how to fix it? I’m only using the vanilla built in App Building Tool for a Workspace App, none of the code for it is custom so it has to be a monday.com setting somewhere or do I need to figure out how to build a custom bit of code of some sort?? I have multiple apps that I need to figure this issue out so they all update and work out of the gate, especially the one for the paying customer! Ideas? Guidance? Help? Sue

Does Monday.com provide option to query the database using SQL via ODBC connection or any other method. The accounting team wants to add SQL query to their Invoice Reconciliation and pull the Invoice Status from Monday.com. Business already has an Excel expert who will add SQL/code to the Excel file. From IT they want to know if it is possible to query Monday.com database and will we grant the query access?

Hi devs, is there a way to retrieve the item terminology thru API? Thanks.

Hi monday.com community! We are happy to share some great news! VLookup now supports formula columns, which can be used to connect formula type columns from one board to the next while keeping the automation functionalities. This means you can easily integrate data and acquire key insights across several boards, resulting in a more simplified and efficient workflow than ever before. We’ve put together a brief demo that will blow your mind to show you what’s possible with this fantastic new feature. Check it out and prepare to be blown away by the power of VLookup! To learn more, please feel free to send us an email at appsupport@jetpackapps.co. You can also refer to our documentation for additional information or simply install our app directly from the marketplace.

Hi there, I would like to set column settings during its creation (or after via an update). I can’t find any way to do this in the GraphQL API documentation. Do I miss something? Else, would it be possible to add a mutation parameter ? Something like “settings”: mutation { change_column_metadata (board_id:123456, column_type: dropdown, title: "My Dropdown", settings: "{\\"hide_footer\\":false,\\"labels\\":[{\\"id\\":1,\\"name\\":\\"test\\"},{\\"id\\":2,\\"name\\":\\"123\\"}]}") { id, settings_str } } Thanks in advance for your answers

Hello, I am trying to get access_token to make API calls on behalf of users into monday account. ( Following: OAuth and Permissions). I have got the auth_code but when I request access_token using (code, client_id, client_secret) I get cors error. CORS issue is from server side so what might be the issue? Here is my request sample code: const details = { code: params.code, client_id: CLIENT_ID, client_secret: CLIENT_SECRET } fetch(TOKEN_ENDPOINT, { method:'post', headers: { 'Content-Type': 'application/x-www-form-urlencoded' }, body: details }).then(async(res) => { const data = await res.json(); console.log("Data==>",data); }).catch(err => console.log("Err==>",err)) Please have a look. waiting for the response. Thanks!

Hi, I’ve had a workflow running on quite a simple query for a month or so, only just this week it’s starting to come back with an error: “Query has depth of 9, which exceeds max depth of 6 at line: 2865 called from: 2877 called from: 3190 called from: 2602 called from: 226 called from: 1246 called from: 2846 called from: 2883 called from: 3187 called from: 2602 called from: 226 called from: 1246” The API call is relatively simple; mutation { create_board (board_name: “xxx”, board_kind: public, template_id: 123456789, workspace_id: 1234567, folder_id: 12345678 ,board_owner_ids: [12345678,12345679]) { id name state }} Any ideas what am doing wrong? Or anything I can change to fix?

Hi there, I need a GraphQL for taking the activity log of the sub-items. I only found some examples for taking the activity logs of the (parent) items, but not for the subitems. In this example, I can specify the ids of the items (via ‘items_ids’), but it returns nothing if I enter the id of a subitem. Also it does not support something like ‘subitem_ids’. query { boards(ids: 1161879462) { activity_logs (item_ids: 1161879467){ created_at data } } } Is this supported by the GraphQL/api? If yes, how can this be done? Thanks. D. Mon