API & Apps framework

I’m running a query that pulls an entire board which contains about 400 items and 80 columns. i’m using a pretty blunt query: query2 = ‘{boards(ids:###) { name items { name group{title} created_at column_values{ title text } } } }’ It takes about 20 seconds for this to run, which is surprising given that this is just tabular text data. Is this normal latency? I would expect a much faster response on this (maybe 1s). I’ve seen a few (unaddressed) threads about performance of the API - is this an ongoing issue? Thank you

Hey all. I’ve been playing with the Monday API and have made a lot of progress towards getting it ready to be available in our system and a couple of other tools we use, however, I’ve hit a bit of a snag when it comes to adding files. I’ve been able to do everything else from adding items, updates, columns, boards and reading what I’ve needed, but adding files is what has finally broken me. I’m basing my code off of Uploading a file to monday.com, the hard way. The author is using NodeJS so I’ve tried to convert it as best I can. My code below: <cfset dataQuery = 'mutation($file:File!){add_file_to_column(file:$file,item_id:123456789,column_ID:"files"){id}}'> <cfset boundary = "xxxxxxxxxx"> <cfset upfile = "image1.png"> <cfset base64Sample = SAMPLE_BASE64_STRING> <cfset data = ""> <!--- Construct Query ---> <cfset data &= "--" & boundary & ""> <cfset data &= 'Content-Disposition: form-data; name="query";'> <cfset data

Hi all, please help if you can When making an API request call, we seem to have random data points not being brought through. If it was a whole row or column, we could try to find some sort of rule, but this is purely random. The boards in question are slightly complex in that they use Connected Columns, but I don’t see why that would be an issue. We’ve tried exporting the boards manually to Excel using the UI, and we are still missing some data points, not as many as with the API call, but still some. Is there anybody else who has experienced this or knows how to fix it? Best regards,

I have successfully built an app running on my local machine and using the loca.it tunnel. How do I now deploy this on to AWS as a Lamda function or Heroku etc?

Hi, Is there any way to search for items between range of dates while I have one date column in the board? Quite urgent 🙂 Many Thanks,

In the API Playground I can change a text column value for an item using: mutation{change_simple_column_value (board_id: XXXXXXXXXX, item_id: YYYYYYYYYY, column_id: "text", value: "NEW" ){id}} But when I replace the item_id with the id of a subitem I get: { "error_code": "ResourceNotFoundException", "status_code": 404, "error_message": "Item not found in board", "error_data": { "resource_type": "item", ... "error_reason": null } } I can’t find any reference to changing subitem values in the documentation, only (parent) item values. Do I need to pass a parent_id as well or…?

Hello, I started to learn how your API works and everything was fine until I tried to create a new column in a board. I quite litterally copy / pasted the code I found in the doc, put my board ID and my API Key. changed nothing else just to see if it was working but I got this message : “message”: “Parse error on "create_column" (IDENTIFIER) at [1, 1]” here is my code : let query = "create_column(board_id: "+boardID+", title:\\"Work Status\\", description:\\"This is my work status column\\", column_type:text){id}}" fetch ("https://api.monday.com/v2", { method: 'post', headers: { 'Content-Type': 'application/json', 'Authorization' : apikey }, body: JSON.stringify({ 'query' : query }) }) .then(res => res.json()) .then(res => console.log(JSON.stringify(res, null, 2))); } Do you know why this occurs ? Thank you and have a nice day 🙂

Is there any way to create user (person) using GraphQL? Currently I see only read-only query: https://api.developer.monday.com/docs/users-queries-1 Also, here https://api.developer.monday.com/docs/people is noted that I should use ID to set person to item value. So, how should I populate new users with name/email? Thanks for help.

Hello, when creating custom actions it looks like only the only option is for a POST request/webhook to be sent somewhere. Is it possible to instead have it trigger something in a custom app? Example… I have a board with items. I have a button field on this board. I have a custom app with an item view added for this board. When I click the button, open our app’s item view and send a message to it (ideally the same thing you’d send via the webhook) Then we can handle the message and do whatever we need to in the app. Is this possible or are webhooks the only way to work with custom actions currently? Thank you!

Hi, I am using the graphql API and I am facing an issue regarding security. I am using the API token linked to an account but I would like to restrict the access to some boards in a workspace. It seems to be something possible as mentioned in the documentation, but I cannot see anywhere an option to change the permissions of an account on some workspace’s boards. Did I miss something in the documentation? Thanks!

Hi there, Can anyone tell me what is wrong with my payload? I keep getting a 500 error back, which from my reading on the board, signifies a malformed request. I am not using Node.js or similar back end software. I am using an ETL software that allows for web requests. So I am really trying to find out what the issue is in terms of the structure of the request rather than the code that makes the request like I have seen in other posts. In the response back I have removed the urls for the content-security-policy because I am limited to a max of 20 urls in a post. Additionally, the beginning of the auhtorization key is x’d out. The key itself is fine. I just didn’t want to post it in the forum. Please assume there is no issue with the authorization key. If anyone could give me some pointers, I would be appreciative. Thanks! Payload: POST https://api.monday.com/v2/ Authorization: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxNTo

Hello, I made an integration recipe that triggers on status column changes Is there any way to exclude subitems from the recipe ? Thank you in advanced.

Hi, The widgets in the screenshot are added in the Doc. “Custom Calendar Widget” is our own custom developed widget, I can’t seem to find a way to enable the “Filter” feature in the widget (like the filter shown in Battery Widget), can you please advise on this?g-company.monday.com Thanks! Br YarHuoy

Can anyone recommend any Javascript Library or other tools for rendering the output of a GraphQL query? I realize that the map() and flatten() methods in Javascript can be helpful for transforming the JSON output of GraphQL into a table. But that can get a bit complex particularly when there are nested data structures and blank elements. Is there some existing tool or library which helps with this?

Is there any way to retrieve an Item Link (i.e. the URL to a given row) using the API?

I am trying to execute an API v2 query using Postman as discussed in this excellent video (see 42:30):

I have a problem with requests to api. I recive responces with HTML with Cloudflare code. How can i handle this problem? Here is screen from Postman

My challenge is very similar to this thread from @vprado: Working with API v2 and VBA - Parsing Mutation. I can query and create items using VBA , but what I’m attempting is to use variables to create subitems with column values populated. I was hoping someone would share an example of VBA code which uses variables to create subitem values, similar to how we can do it in Python here: https://support.monday.com/hc/en-us/articles/360013483119# In VBA, I’ve tried many different types of formatting, escaping "", double escaping the nested variables’ values \\" based on this thread: C# Create_Item with Column_Values leads to (500) Internal Server Error - #4 by Will It works fine in Python, where mutate is the final string including the variables which gets passed to the post request as json: query_msubitem = 'mutation ($StockCode: String!, $columnVals: JSON!) { create_subitem (parent_item_id: 2416200000, item_name:$StockCode, column_values:$columnVals) { id board { id } } }' vars = { 'Stoc

Hi Guys, I was checking the Integration guides and only found background actions (via the API), and I am looking for a way to implement the following search from external system: user perform search from Monday Board Column , pressing a button for example, than a rest call being made to external system (with some dependency input of another column) list of options are being populated into the target field in that board so the user can select. I know how to do #1, but I can’t find a way to do #2 . I know that I can implement it custom widget/board view (I think 🙂 ). any suggestions? live integration, live search with results to be select. Thanks Roi

I have an app that provides a board view and stores all data using the storage API. The implementation of this storage API by monday.com involves retrieving data from the server and can result in rate limit errors which are propagated back through the SDK’s storage API in the form of cryptic errors relating to Window.postMessage and a DOMException. How can an iframe based app protect against this? There seems to be no reliable way since the SDK doesn’t return the typical rate limit response information such as retryAfter.

Hi, Monday community I’m developer. I love programming and automation. I would like to make apps for the marketplace. I read the documentation and watched the video. But I still have a couple of questions. I found on site: The apps monetization allows your monday app to accept payments from users directly through monday Questions: Does Monday have fees for accepting payments? How Monday pays developers earned money? Thanks for attention!

Hi Looking for some help whilst trying to add subscribers to a board using Python and the Monday API. This is my code: boardSubscribers = [25501753, 25614799, 25614800] for i in boardSubscribers: groupNameMonth = calendar.month_name[month] print(groupNameMonth) boardName = f'{groupNameMonth} {year}' query = 'mutation ($boardName: String!, $boardSubscribers: Int!) {create_board (board_name: $boardName, board_kind: private, workspace_id: xxxxxx, board_subscriber_ids: $boardSubscribers) {id}}' vars = { 'boardName' : boardName, 'boardSubscribers' : i } data = {'query' : query, 'variables' : vars} r = requests.post(url=apiUrl, json=data, headers=headers) I am getting the following error … This is a test: {‘errors’: [{‘message’: ‘List dimension mismatch on variable $boardSubscribers and argument board_subscriber_ids (Int! / [Int])’, ‘locations’: [{‘line’: 1, ‘column’: 140}], ‘fields’: [‘mutation’, ‘create_board’, ‘board_subscriber_ids’]}], ‘account_id’: xxxxxxx} Traceback (

Hi, there! I can’t find any reference in docs for subfolder creation and listing through API. Can someone give me a clue if there is support for this feature yet?

Hi, I want to create a new item with column values already applied to it, but there is no proper example all around the internet to get information from. I have this code: query3 = 'mutation { create_item (board_id:1917614834, group_id: topics, item_name: Teszt2, column_values: "{\\"status\\":{\\"label\\":\\"Medium\\"}}}' data = {'query': query3} r = requests.post(url=apiUrl, json=data, headers=headers) # make request print(r.json()) But it says: {'errors': [{'message': 'Parse error on ":{" (STRING) at [1, 111]', 'locations': [{'line': 1, 'column': 111}]}], 'account_id': 10454884} I don’t know how to write the query line after column_values. Can you please help me with the correct code line for the query? I always get a Parse error, no matter what type of column I want to update.

Hello, When I run a query to return all boards, it also returns all the docs in my workspace. There seem to be no attributes that allow me to distinguish that a “board” is in fact a doc. How can I retrieve only the boards? Thanks 🙂