API & Apps framework

status column items_by_column_values query only works when value is a label and not an index value = status_label = "done" # query works value = status_index = 1 # query fails This query WORKS. query { items_by_column_values (board_id: 12345678, column_id: "status", column_value: "done") { id name column_values { id title value } } } These queries FAIL: (identical query, except the below column value) column_value: 1 column_value: "1" column_value: {"index": 1} column_value: {"index": "1"} column_value: '"{\\\\"index\\\\": 1}"' column_value: '"{\\\\"index\\\\": \\\\"1\\\\"}"' Is this a feature or a bug?

Hello, So I got everything set up in regards to Monday.com webhooks triggering and sending data to my app. The only issue I am having right now is - when a new item is created via the"New Item" button on a board, it is triggering the webhook w/ the default name it is given, which is “New Item”, instead of it being triggered once the item has been named after creation. Since there is no trigger for item name changes, we are unable to correct this without polling data straight from the API. Is there any way around this other than using the “+Add” button (Which waits until the item has been created/named before issuing a webhook trigger) We cannot gurantee everyone will use the +Add button every time so having it work via all avenues would be ideal. Thanks!

Hey Is there an API call that tells you how many items there would be in a particular query? For example I want to run a simple script to pull all items from a particular board, I have it paginated and embedded in a loop, how do I know how many pages I need to loop through? query test{ boards(ids: 000000000) { items(limit: 25 page: 1) { name column_values { title text } } } } Thanks

Currently I am trying to copy a board to Google Sheets and update it daily. I figured out how to delete rows and add rows, but am not sure what to do about updating rows. I see that an item has a last updated date for each column, but is there a master “item last updated” value that I can see? Otherwise it seems I would have to loop through each column and check it if was updated. If this is not available then I think I will just go ahead and delete all rows and then rewrite the board every time which is fine, but does not seem efficient. Thanks!

I’m trying to add a pulse to a group, all good but I want to insert a rating but regardless of how I try I can’t seem to do it: { “error_code”: “ColumnValueException”, “status_code”: 400, “error_message”: “change_column_value invalid value”, “error_data”: { “column_value”: “2”, “column_type”: “RatingColumn” } } I cannot find any documentation regarding types anywhere, the documentation is sadly very lacking.

Hello! I’m trying to query a specific status column on a board so that I can pull in it’s available status choices for a custom form. Is the columns {settings_str} the only way to do this? this is the format I get back: labels: {0: “Status 1”, 1: “Status 2”, 5: “Status 3”} My hope was to get an array back that would be easier to iterate through. Is the above format my only option or is there a better way to query what I’m looking for? any help would be greatly appreciated!

I am trying to connect my webhook up and have the challenge console logging on the lambda function, so I know it is not my gateway connection or my lambda function. What am I doing wrong in the return?! Below is the code. exports.handler = event => { console.log( {“challenge”: JSON.parse(event.body).challenge}); return event.body; };

Hi - Is there a limit to the number of status values that can exist for a specific status column?

Hi - Is there a way to query the v2 api for all existing status values in a specific status column?

I’m trying to find all the items assigned to a user. When I query a board, I get this response: query { items { name column_values { id value } } } ... "column_values": [ { "id": "person", "value": "{\\"personsAndTeams\\":[{\\"id\\":14983475,\\"kind\\":\\"person\\"}]}" }, ... But when I try and run this query to get the items by user, I get no response: query { items_by_column_values (board_id: 643168050, column_id: "person", column_value: "{\\"personsAndTeams\\":[{\\"id\\":14983475,\\"kind\\":\\"person\\"}]}") { id name column_values { id, title, value } } }

Hey, My monday account started to behave weird, and on the day of the contest submission… 😬 The board, not only my board view, is not loading some times (in another account of mine everything works) and things on the monday side are not displayed properly. See here. Others experience it too? Help by the monday team would be highly appreciated. Best, Ronen

Hey, There are many use cases where item views added by apps would have a much better and more feature rich UX if they can occupy more screen space than the current right sided drawer, which is very limited in size. My specific use case is using eazyform to edit an existing item, so I’d like to be able to display eazyform in the same way I display it in eazyform’s board view, including the ability to edit the structure of the form for items. Would be nice to have a generic expand button that expands the item view drawer to take on the entire board view space, and then a collapse button to go back to the regular drawer size. A similar more specific feature request has been upvoted 10 times, but this will solve it for all item views. @Ben , @dipro is this on the roadmap? Thanks, Ronen

Hi, as an administrator I should be able to see all boards, right? With this query I only get the boards I have subscribed to. boards { id name } I haven’t found a way to do this on monday.com either?

Is there a way to add the user id to the Create Item mutation so when a new item is created via the v2 API it shows up on the CREATION LOG column with the user specified in the query/mutation. In the v1 API when a new pulse was created you had the option of sending a user id with what ever user you wanted.

I’ve scoured the forums for every suggestion on how to use the create_item manipulation and adding column values, but the column values never seem to update. I currently have a group that has a column called “Submission ID”. Here is my python code that is trying to create an item and populate it with a column value: headers = build_auth_header() column_data = {"Submission ID": "Test"} board = XXXXXXXXX group = 'topics' item_name = 'TEST' query = (""" mutation ($name: String!, $board: Int!, $group: String!, $columns: JSON!) { create_item (board_id: $board, group_id: $group, item_name: $name, column_values: $columns) { id } } """) graph_var = { "board": board, "group": group, "name": item_name, "columns": json.dumps(column_data) } response = requests.post('https://api.monday.com/v2/', json={"query": query, "variables": graph_var},

I have a custom integration which was developed and tested using port 8080. All working well and I have setup on a vm with node server. Attempting to implement ssl to secure the traffic and all updates are then failing. Initial intention was to use Cloudfront LB to provide the secure certificate. and translate to port 80 behind the firewall. This was not working for me, so I have then tried to implement a self signed certificate in the code base. All attempts to use tls/ssl from the monday integration donot seem to run in the app. e.g. log statements dont fire. If I disable the middleware jwt and use a postman post. I get a successful exection of the code. But calls from monday Dont seem to get there. I dont believe its a firewall issue as I have configured for all incoming traffic. The cloud front approach I could see the post arrive, but I didnt get a successful update. (this may be a different networking issue) That is all background. Question. Is the correct approach to bu

Hi there, I’m trying to create task and define status of the task, but it is not easy to understand how to properly do this. My query: mutation {create_item (board_id: 377902169, group_id: "new_group18793", item_name: "new item", column_values: "{"status": "Search Active"}") {id}} This query failed with error: [{"message":"Parse error on \\": \\" (STRING) at [1, 117]","locations":[{"line":1,"column":117}]}] I’ve also tried this query: mutation {create_item (board_id: 377902169, group_id: "new_group18793", item_name: "new item", column_values: {status: "Search Active"}) {id}} And this query fails with 500 status code and message “We’re currently experiencing some technical issues which our developers are working hard to resolve” (but the status page shows there are no incidents…) So, the question is how I can set the correct value for columns for a new task? Thank you!

Monday.com is a wonderful platform and it has the potential to grow even more but the current state of it’s API can have very serious negative consequences on it’s adoption by developers. The developers at Monday.com can’t implement every feature, just like the developers at Google or Apple. Imagine Google trying to create every app on the app by itself. It is impossible. That is why companies create APIs and make them available for developers to be able to create applications on their platform. Monday.com claims to be a Work OS, and the beauty about OS’s are that, they are highly extendable. We enjoy using our computers because of the flexibility of the OS that has made developers to create different applications on that. In my current view, Monday.com is striving to be an opposite of what an OS is supposed to be. For users, it’s mostly great but for developers, it’s just terrible. I’m currently developing an application and the number of times that I have encountered problems withi

Hi all! I am curious how others are publishing their builds(wether it is from a custom URL or by upload). I’m wondering because I am having problems running opening my Monday App on accounts other than my own and Im worried that the fact that my builds are published via upload may be causing the issue. Thanks!

How in the world do I upload a file using the example PHP code format: $update_id = "XXXXXX"; $query = " mutation { add_file_to_update (update_id: ".$update_id.", $file: !File) { id } }"; $data = @file_get_contents($endpoint.'file', false, stream_context_create([ 'http' => [ 'method' => 'POST', 'header' => $endpoint_headers_file, 'content' => json_encode(['query' => $query]), ] ]));

When using the API Playground GraphiQL interface, it seems like it supports the ability (like the default GraphiQL from Apollo) to have multiple queries in the editor, then choose which one to run. It doesn’t work though and gives the error "An operation name is required" even though I have specified operation names for each query/mutation.

Hello, monday.com community. I am trying to get the name of a column given its id and board id. My code is query($boardId: [Int], $columnId: [String]) { boards(ids:$boardId){ columns(ids:[$columnId]){ title } } } const variables = { boardId, columnId }; const response = await mondayClient.api(query, { variables }); I am facing the following error { [0] errors: [ [0] { [0] message: 'List dimension mismatch on variable $columnId and argument ids ([[String]]! / [String])', [0] locations: [Array], [0] fields: [Array] [0] } [0] ], [0] } Would appreciate any help. Thank You!!.

Hi all! 🙂 I went through the Quick Start and installed my starter app. The app isn’t showing in Safari but is working fine in Chrome. I don’t have any extra content blockers running in Safari. When the window loads in Safari, I get this error in the console 7 times: Unrecognized Content-Security-Policy directive 'worker-src'. Followed by 3 401s, for : https://...cdn...chunk.css https://...cdn...chunk.js https://...cdn...chunk.js Any ideas if there’s anything I can do on my side to make this work in Safari? I don’t typically write in React and am not super familiar with working with service workers.

Hey there, I added both the DEV and PROD Redirect URLs in the Redirect URLs field on the OAuth & Permissions page within my Monday App and kept getting the following error on the /oauth2/token call: Data: { “error”: “invalid_grant”, “error_description”: “Authorization code and redirect_uri mismatch” } I found this curious because in the field it says “If you pass a redirect_uri in an OAuth request, it must exactly match one of the URLs you enter here”, and within the /authorize endpoint request body, you pass the redirect_uri parameter only if you have multiple Redirect URLs listed in the field above (else it defaults to the first configured URL in the list). Once I removed one of the Redirect URLs from the list (now only having 1), it started working again. The only thing I can think of here is that the Multiple Redirect URLs Logic is broken. Let me know what you find!

Those past days, regularly, the integrations from our listed App (QR Code Item Tracking) disappear: You can not find see them in the integration center anymore It doesn’t trigger the actions already configured In the developer backend, I can’t even see any recipe See that is action here: recipes not listed anymore - YouTube It was resolve yesterday, then, today, it failed again. I’m worried about that, because many customers are using this App. Is it a known issue? @VladMonday @amir