General

Hi all, I was using the api in bubble.io and can’t seem to edit the column values within the call. Here is the POST call {“query”:“mutation { create_item (board_id: 3188858191, group_id: “topics”, item_name: “”, column_values: “{“what_is_your_first_name_” : “value”}” ,) {id, name, column_values {id, title, value}}}” } if i remove the column_values section it works fine and if I make a separate call just to change an existing items columns, that works too but I can’t seem to get it to function when making a create_item call. error message: “message”: “Parse error on “what_is_your_first_name_” (STRING) at [1, 99]”, “locations”: [ { “line”: 1, “column”: 99 } ]

Hi, I am using the below query to retrieve all the updates, the below query throws an error as well as response. Is this an expected behavior? { updates(page: 12, limit: 100) { assets { created_at file_extension file_size id name uploaded_by{ birthday } original_geometry public_url url url_thumbnail } } }

Hi all, definitely not a developer here just trying to learn more about the API as I have a meeting coming up with several developers and don’t want to appear a total idiot… Just wondering if somebody can share with me or point me to a list of all the column types available via the API? (Create, update, read). I have seen “it’s in the API docs” posted in several support threads but despite searching for quite some time can’t find it anywhere. I’m hoping some kind person out there can point me in the right direction. Cheers, Patrick

Choice Number: 3896 Pay Load: { “query”: “mutation ($boardId: Int!, $companyName: String!, $columnVals: JSON! ) {create_item (board_id: $boardId, item_name: $companyName, column_values: $columnVals) {id}}”, “variables”: {“boardId”:2364371628, “companyName”:““test23LastOne””, “columnVals”: “{“phone”:”“7169084086"”,“text”:““test23LastOne””, “text4”:““test23LastOne””, “long_text”:““test23LastOne””, “status4”:“Website Form”,“email”:{“text":""test23LastOne@test.com” “,“email”:""test23LastOne@test.com” “}}”} } Url: https://api.monday.com/v2 Webhook Id: 10 Webhook Name: MarketoToMonday Request Type: http_post Step ID: 3630 Source: Marketo Flow Action Response: {“errors”:[{“message”:“No query string was present”}],“account_id”:6562763} Person ID: 3238884 Response Code: 200 Here is my code: { "query": "mutation ($boardId: Int!, $companyName: String!, $columnVals: JSON! ) {create_item (board_id: $boardId, item_name: $companyName, column_values: $columnVals) {id}}

Hello everyone ! I’m looking for a solution to this problem : I want to read directly in a number column a value from a Json file while knowing the associated key of this Value. Exemple : My API call > https://api.snowtrace.io/api?module=account&action=tokenbalance&contractaddress=0x....&address=0x....&tag=latest&apikey=MyKey The API return : {“status”:“1”,“message”:“OK”,“result”:"19043221718329235974770 »} And I want to fill my number column with the value associated to result key. Then I need to make an automation to refresh value on demand. Is it possible to build this kind of parsing tool directly in monday table column ? Thanks in advance for your help. Regards

let’s say I have a board like below, I want to update the Status column based on the item id. I want to update the text of Customer Status column if a matched item id was found. In this case, the text ‘Active’ will be change to ‘Inactive’. How to do it python? I tried: query = ‘mutation ($columnVals: JSON!) { create_item (board_id:1234, item_name:12345, column_values:$columnVals) { id } }’ vars = { ‘columnVals’ : json.dumps({ ‘status3’ : {‘text’ : ‘Inactive’} }) } data = {‘query’ : query, ‘variables’ : vars} r = requests.post(url=apiUrl, json=data, headers=headers) jsondata = r.json() print(jsondata) board item info: “boards”: [ { “name”: “myboard”, “id”: “1234”, “description”: “”, “items”: [ { “name”: “12345”, “id”: “1234567”, “column_values”: [ { “title”: “Subitems”, “id”: “subitems”, “type”: “subtasks”, “text”: “02342” }, { “title”: “Customer Status”, “id”: “status3”, “type”: “color”, “text”: “Active Customer” }] } ] } ]

when we trying to retrieve sub item(board id is of subitem board) we observed first subitem has parent_item id as null in this query { boards(ids:[1234]){ items { id, name, subitems{ id name } parent_item { id } } } }

I want to pull all board Ids and corresponding ItemIds and its columns.I have list of BoardIds with me.So when I try to loop below query through list of board Ids its giving result for the first board id of the loop takes and showing same data for all the board Ids. Query- { boards(ids: $(vboardsId)) { id name columns { title id type } groups { title id } items { id name group { id } column_values { id text title value }}}} Where - $(vboardsId) variable of for loop which providing board Ids Is it so once we hit the query ,api takes some time to refresh or something as I have traced the loop and boardId its working fine but result is same for all

Hi devs, is this policy correct? https://developer.monday.com/apps/changelog/clarification-on-retry-policies-for-webhooks-and-custom-actions As far as I can see in our tests, when a non-200 HTTP status is returned, monday retries every 30 secs for 10 times, then stops.

Hi all, I am trying to get column IDs on GAS (google apps script) with the code below. But I am getting an error with below. Could you please help me out? Thank you! function getBoardDataClicked() { // This function is run when the “Get Board Data” button is clicked const boardId = getBoardId() // Get board-specific group data from Monday.com and set it to sheet: const boardName = getAndSetData(boardId, ‘groups’, ‘A6’) // Get board-specific column data from Monday.com and set it to sheet: getAndSetData(boardId, ‘columns’, ‘D6’) // Set board name to sheet: setboardName(boardName) // Redetermine column widths: autoResizeColumns() } function getAndSetData(boardId, type, startCellAddress) { // This function gets board-specific data from Monday.com and set it to sheet. // The type of the retrieved data is specified by the “type” parameter. // “startCellAddress” determines the location in which the data is to be pasted on the sheet. // Make HTTP request: const resData = getData(boardId, ty

Hi, How to know if user is a viewer on board/dashboard view (client side- react) when app is loading? Basically I would like to display a proper “missing permissions” message instead of the app display, in case it’s a viewer. Code sample will be great. Thanks Roi

I wondering there is how to delete workspace using Monday developer’s API’s.

I’m striving to retrieve the corresponding boardId of a mirrored column when multiple boards and items are connected. The query I use is: { boards(ids: 3184598220) { columns { id title type settings_str } items(ids: 3184598225) { created_at email group { id title } parent_item { id } subitems { id } column_values { id type text value additional_info } } } } I know I need to cycle multiple times thru board.columns and board.items.column_values properties. { "data": { "boards": [ { "columns": [ { "id": "name", "title": "Name", "type": "name", "settings_str": "{}" }, { "id": "person", "title": "Person", "type": "multiple-person", "settings_str": "{}" },

We have tried creating subitem for item which has more than 350 files , not able to create sub item for it , is there any limitation to create sub item? We are getting response as null, please advice if this is expected reposne { “data”: { “create_subitem”: null }, “account_id”: 11771408 }

Our app is released to marketplace and it’s a communications and collaborations real-time chat messaging tool, and we are ready for your feedbacks. The App functions like mention someone, emojis, notifications, add items to the text messages and preview the items. We are working to release new features like voice messages and send images. And send notification for the mentioned users if they are offline and more features. We build it because when we were managing our team, we often needed to communicate within monday.com to point out items and send quick feedback, hence the idea to build an internal communication app that supports some Monday features like notifications, and item previews. You can test it on your account by installing it from marketplace: Install Let’s Chat App Here is the app on our website: Elastic Day - Let’s Chat App The credit card is not required to use it, we have a free plan. Also the personal information, account details or items are not store in our end. We a

It may be that I’m misusing this method, but it seems as though monday.set('settings', params) doesn’t behave as it should. No matter the value I pass in, the settings remain the same. I’d expect it to update one or more settings based on what I pass in as an argument, but that’s not the case. Would anyone happen to know if this method is broken, or if I’m just not using it correctly? This is the method I’m referring to and I’ve added some screenshots that will hopefully provide additional clarity.

Hi, I want to create app that would change the background of the text editor used to send email on the CRM. But, the app is inside an iframe, and I can’t manage to edit the CSS. I tried all the types of applications. How can I do it? wanted css added: .ql-editor{ background-color: red; } example source code: take monday example: welcome-apps/apps/quickstart-react/src at master · mondaycom/welcome-apps · GitHub replace only index.js with: import React from "react"; import {createRoot} from "react-dom/client"; import "./index.css"; import App from "./App"; import * as serviceWorker from "./serviceWorker"; const root = createRoot(document.getElementById("root")); root.render(<App />); document.addEventListener('DOMContentLoaded', (event) => { const collection = document.getElementsByClassName(".ql-editor"); for (let i = 0; i < collection.length; i++) { collection[i].style.backgroundColor = "red"; }; }); // If you want your app to work offline and load fa

Introducing Toolkit, a bundle of apps to designed to address various needs on monday.com built by the experienced folks at Kolaai, a monday.com partner. At the moment, the app contains only one app, that is Copy and Paste. With Copy and Paste, you can copy data from anywhere (eg. Excel, Google Sheets, Word etc) and paste them directly into your monday.com columns. No more manually entry of large data. This will absolutely save you tons of time! Here are some of the features of the app: Update existing column values Create new or update items in specific group or across various groups Create new or update sub-items Copy and paste different date formats into both date and timeline column Copy and paste data with preferred separators for example, semicolons, commas or even your own custom separator Select and item to start pasting from Replace existing values with empty values And so much more … Here is a short demo on how the app works. You can see the different pricin

it would be nice to have the column type listed with the column ID in developer mode in the column heading menu. I know right now we can go to “change column type” to see the column type but not all column types show this menu item. Plus its another click. The value from board.column.type would be preferred.

Does anybody have an hosted javascript example of some simple code for developing a custom action along with the appropriate definitions of the feature?

I understand that the administrator functionality has the ability to download data from all workspaces in the form of a zip file. There is a task that requires periodic backups of data from all workspaces on-premises, and it is cumbersome to go into the administrator’s account and download the data every time. If the function exists as an API, I think the efficiency of the work can be increased a lot, so I wonder if the function exists as an API. If this function does not exist as an API, I would like to ask if there is a way to solve the above task with an API. (After checking the API, there is an indicator called Complexity, and if this indicator exceeds 5000000, data cannot be imported. I am asking because I think the complexity will be very high to import data from all workspaces.)

What does “Visualization type= milestone” specifies ? How to differentiate between planned and actual timelines?? When I try to run below query,I got values for timeline as a single field ,not as two different fields? {boards(ids: 1123282008) { items { id subitems { id } column_values { id value } }}} How to pull these fields?

I had a look at the Multiple Accounts section here but I couldn’t find info on this. Here is the scenario: -Say we have an app called app1. -User X is part of foo.monday.com. They authorize app1. They’re able to make API calls and get the info they need. -User X is now added to another account/subdomain: bar.monday.com. They authorize app1 in this new instance. A couple of questions: Question is: will the new access token generated after authorizing app1 be valid for API calls done on bar.monday.com only? OR will the new access token be valid for both foo.monday.com AND bar.monday.com? If it’s the latter, will the first access token generated become invalid? Thanks

Hi All, Im new in this world and i need to : From one board, extract a initial load. Then, in a daily load, i need to get the updated or new records from last load using update and create date field . I was reading a lot of post about it, but i didnt get the solution yet. Any clue about it? Regards

I am creating a custom field type in my integration that derives values from a remote options url. The payload for the remote options field looks like this { recipeId: 30019598123, integrationId: 72966189123, automationId: 72966189123, pageRequestData: {}, dependencyData: null } . This is insufficient for my use case as my application need to know which user has triggered the custom field. I have tried to use the dependencies but that seems to require a manual user input. Is it possible to automatically add a userId value to the payload that is sent to the remote options url?