API & Apps framework

Hello, I am building a dashboard app. I came across an issue with the monday API limits that I wonder what is the best approach to solve it: In one of the features (filtering option), I need to get all possible names (value) in a specific text column. The issue is that the board contains around of 4500~ items. From my understanding, I need to reach the items first in order to get the names in the text column. The issue is the API not allowing me to reach so much data at once because there are so many items. What should I do in order to get all the names in the text column without the api crashing? Thanks!

My checkbox column is always getting ticked even though I am setting up as false when I created the item. Please see the mutation query below; the column name is Premier Deal (Check). mutation { create_item (board_id: 3081121074, group_id: “topics”, item_name: “Test Account Atul (111111)”,column_values: “{"check":{"checked": "false"},"text":"GBP","link" : {"url" : "https://inkglobal--inkuat.my.salesforce.com/lightning/r/Opportunity/0060C00000A1Wxu/view\\”, "text" : "https://inkglobal--inkuat.my.salesforce.com/lightning/r/Opportunity/0060C00000A1Wxu/view\\"},\\"link_to_client_database\\" : {"item_ids" : [3134536039]},"numbers4":"1208.00","timeline" : {"from" : "2022-07-01 00:00:00", "to" : "2023-06-01 00:00:00"},"text7":"0060C00000A1WxuQAF","text8":"Test Thompson","text2":"easyJet Navigator;","text_1":"*****@ink-global.com","text_2":"8805984864","numbers":"1208.00"}") { id group{id title} board{id name} }}

I’m looking to build an integration into monday sales crm. When I look at the api documentation it talks about boards but not customers. I’m hoping I’m just looking in the wrong spot. Can someone point me in the right direction for the monday sales crm api docs. We are looking to push customer activity logs into monday (e.g. they made a call).

Hello, I came across something odd that I hope there is a fix for. I am trying to retrieve items using Items_by_column_values. Apparently, in order to use this method the board permission must be “View all items on the board” (or be a board owner) That means that if I’m trying to query the items by using Items_by_column_values, and the board permission is on “View only items that are assigned to users or created by them in any “People” column”, I’m receiving back error code: UserUnauthroizedException. Every other methods that I’ve checked (retrieve items by board, mutations etc.) are working great. only the Items_by_column_values and items_by_multiple_column_values giving back an error. Any ideas? Thanks!

Hi Guys, I’m quite new to Monday.com. I was asking for a real-life example of how to read data from an integration and display it in a view. If anyone has got an example or any other real-life examples. I would appreciate it- thanks in advance

Hi there! I’m making an Monday app which needs to take data from a dropdown field. I found where i can create it, but i can’t find a place where i would populate this dropdown field with the board data. I found an old discussion here that shows a url where it would use to fetch the dropdown options, but as you can see on the image below, this url field isn’t available anymore. Can you help me? Thanks!

Hello, everyone! I’m writing a script to collect timetracking data for team members. Our timezone is UTC-3 Is there any documentation about this topic (the timezone of the time_tracking columns)? When the data is requested, some datetime fields seems to be corrected (UTC-3), but others are in UTC.

API stopped returning “text” field for “board_relation” columns Our code depends on these values. Change happened recently but I cannot tell when exactly. This renders our app unusable for all customers. Example: query: query { boards(ids:[985577909]) { items(ids:[1210966010]) { column_values(ids:["connect_boards10", connect_boards9, connect_boards6]) { id type text } } } } result { "data": { "boards": [ { "items": [ { "column_values": [ { "id": "connect_boards10", "type": "board-relation", "text": "" }, { "id": "connect_boards9", "type": "board-relation", "text": "" }, { "id": "connect_boards6", "type": "board-relation", "text": "" } ] } ]

Trying to find out if there is away to update a file that has been uploaded to a column. Is that possible? I looked into deleting the files but if I want to do that it appears I need to delete or clear out all the files. Which I do not want to do. It won’t work for our workflow. (How to remove / delete file from item via API) If I could update the file, then I’d be alright. But deleting them all is a no go. Is there a way to update files?

Hello, I am working on an API integration where I am using the API to create subItems and I need to add an update to one of the sub items. Is this possible via the API?

I make an API request to Monday to get all items with a specified email, if there are no matching items, I add a new item to a Monday board via our API and then shortly after (< 1 minute), I make a subsequent request via the API to get the column values of the item just created in the previous API call and the response doesn’t contain the item. If I wait a few minutes, then send the same API request, then the previously created item and it’s values are returned. So, I’m thinking that either the server isn’t updated by the time I make the second API request or the response is being cached. I tried sending the second request with ‘cache-control: no-store’ header hoping that it would get me the freshest result from the Monday board bu that didn’t seem to work and the result still did not contain the newly created item. The use case for this workflow is to prevent duplicate items from being added to the board so I would like to know if there is anything that I can do either through code

Now I can use this to get all users: {“query”: "query { users () … What can I do after the change described here:monday API docs

Having this issue on multiple boards and multiple connect-board ‘board-relation’ columns. Not sure when it became a problem. Per https://api.developer.monday.com/docs/connect#reading-the-connect-boards-column - the API should return the data.

Is there a way to filter boards by folder_id in a single query? Something like this query { board { board_folder_id (ids: 123456) …

First off, I need more customizability for a form which will create items in a Monday board so I am wanting to create my own in react. I am wondering if it would be best to create my own web app and use Mondays API to send data to a Monday Board OR if it is possible to add this react code to a Monday App so the form is hosted on Monday. If the ladder is the best route when I am creating an app I am unsure if this is considered an integration or board view. Also do you guys have open source code for your current integrated form? I would love to have a nice boiler plate to build off.

I was creating monday.com app, I just wanted to know how long does it take the app review process.

I just started with the SDK and needed some testing app to play with the SDK options. So I created a test app based on Vue v3.0 to use as a Board Views or Item Views. (I know @amit.lzkpa made simple app, but he used Vue 2.0) Hopefully other people will benefit from it as much as I did. Link: GitHub - kulaone/monday-vue

None of the components in the library - https://style.monday.com/ seem to match the look and feel of the normal monday.com tables and board views: I want to create a table like this. Maybe I am missing something I want my app to be able to work with data in tables like this, but I don’t want the user to have to create the table on their own. I’m a complete beginner and might be misunderstanding some of the functionality that is available to developers. Any ideas/suggestions?

Hello, I have scoured posts about the subject yet cannot find a suitable answer. I am trying to create items using the API in C# with already populated columns. I can, using the following query, make items with no information other than the title : "{\\"query\\":\\"mutation{ create_item(board_id: XXXXXXXXXX, group_id: XXXXX, item_name: XXXX){ id} }\\"}" However, adding column_values returns the Internal Server Error, even if it is empty. I have tried the following methods, just to show a few (None of them have worked of course) : "{\\"query\\":\\"mutation{ create_item(board_id: XXXXXXXXXX, group_id: XXXXX, item_name: XXXX, column_values: \\"{}\\"){ id} }\\"}" "{\\"query\\":\\"mutation{ create_item(board_id: XXXXXXXXXX, group_id: XXXXX, item_name: XXXX, column_values: \\"{\\"text\\":\\"151\\",\\"numbers\\":\\"1\\"}\\"){ id} }\\"}" {\\"query\\":\\"mutation{ create_item(board_id: XXXXXXXXXX, group_id: XXXXX, item_name: XXXX, column_values: "{\\"status\\": {\\"label\\":\\"Sign-Up\\"}}"){

Hi, What is max archived items per board? I made query. It returned 300 so I imply it is 1000 query { items_by_column_values (board_id: 829428879, limit: 700, page: 2, column_id: “pozice_ve_skladu”, column_value: “Skript mění RSV2”, state:archived) { id name state } }

Is there a way with the API to create new column of type Color and add the labels in the creation? I know there is no way to add labels via API after the column is created.

Hi, There are some integrations in the marketplace that I would like to develop and offer for free. Is there a policy prohibiting developers from publishing existing integrations? Those integrations hadn’t been developed by Monday.

When querying a board for its column values, like so: we get an error like this: but only when the board we’re querying is our biggest, most complex board. (We are having to archive the data every 2 months or else we exceed the limit for number of connected items.) If we use an identical query for a smaller board, it works perfectly fine. Please can we have a fix for this? These queries were working perfectly fine a month ago and now suddenly its overwhelming for the API. Many thanks

Hello. Can anyone help me with this one? I have this creation of item via c#. da is the date column id dueDate is “2022-08-16” string query = "{"query" : "mutation { create_item (board_id: " + boardId + “, group_id: \\"” + groupId + “\\" , item_name: \\"” + name + “\\", column_values: {\\"” + da + “\\": {text: \\"” + dueDate + “\\"}}) { id } }"}”; But respond an error which is {“errors”:[{“message”:“Parse error on "date" (STRING) at [1, 125]”,“locations”:[{“line”:1,“column”:125}]}],“account_id”:7398594}

When I receive a webhook http callback, these parameters in the header host = ****** user-agent = node-fetch/1.0 content-length = 363 accept = */* accept-encoding = gzip,deflate content-type = application/json newrelic = eyJ2IjpbMCwxXSwiZCI6eyJ0eSI6IkFwcCIsImFjIjoiMjUzODI0IiwiYXAiOiIxOTgyOTY3NDMiLCJ0eCI6IjZhMjJjMGM4YzFiYjdjNDgiLCJ0ciI6IjdmY2YyMzBlN2I1YTliNTQxYTk4MTI1NzBjODMyNzg1IiwicHIiOjAuODM5MDc5LCJzYSI6ZmFsc2UsInRpIjoxNjU5NTk3MzE4NzU0LCJ0ayI6IjE3Mjg3NTUifX0= traceparent = 00-7fcf230e7b5a9b541a9812570c832785-d3a43e2274bdb079-00 tracestate = 1728755@nr=0-0-253824-198296743-d3a43e2274bdb079-6a22c0c8c1bb7c48-0-0.839079-1659597318754 x-forwarded-for = **** x-forwarded-proto = https What does newrelic mean? I decode that { "v": [ 0, 1 ], "d": { "ty": "App", "ac": "253824", "ap": "198296743", "tx": "8f6059ef0b16099d", "tr": "ddbc2cd76d3d025dfebe3ab1de594808", "pr": 0.519519, "sa": false, "ti": 1659599249631, "tk": "1728755" } } Can any