API & Apps framework

I am new to GraphQL. Does anyone know how to set up queries (or have any examples) using visual studio VB.net.

hi, I want to upload the file to the comment from API. but I am getting an Internal server error. below is my mution code and screen shot. I have even tried forgist.github.com still getting the “internal server error”. also can’t understand what is “var boundary = “xxxxxxxxxx”;” need your help… thanks in advance mutation ($file: File!) { add_file_to_update (update_id: 808129739, file: $file) { id } } Please see the image.

When using the items_by_column_values to return a set of pulses the state on each item does not match the state of the item within the board. To reproduce create new board add item archive item query board using items_by_column_values see archived item has state = “active” { items_by_column_values(board_id: x column_id: "text", column_value: "X") { id name, state } }

If you’ve ever tried to GET the values of a status column or PUT new values in, you’ve probably noticed that a number value is used to identify the different status labels. We’ve made this quick key to help you map those numbers to the corresponding label colors in your account: Edited July 2020- Alex: The link below will provide the new updated Status column colors by index, including the 10 new colors added recently: https://view.monday.com/471878000-13f8e67ced7f0463687b9694f8044fac

Hi All, I am having some trouble getting the ‘Updates’ data I am after. API v1 I am able to use this endpoint - “https://api.monday.com:443/v1/updates.json?api_key=<API_TOKEN>” to return Update data that includes, amongst other fields, ‘update_id’, ‘pulse_id’, ‘pulse_name’, ‘created_at’, ‘body_text’, ‘posted_by’, and ‘replies’. API v2 I believe I need to use the following query - query { updates ( limit: 100 ) { body id } } - but I can not figure out how to set up this query to return all of the data that API v1 returns. Any help on this would be appreciated I am fairly new to the API v2 so I may be missing something obvious! It would also be good to understand how long Monday.com are planning on maintaining the API v1! Thanks, James

Hi, guys! I’m trying to get the items created in the last 30 days of a specific board by calling Monday API in Google Sheets using Google Apps Script. The code to call the API and parse JSON is not a problem. I’ve done that before and it was successful. The problem is filtering the data by a date range. What I’ve already tried: I’ve used items_by_column_values and that would work perfectly if the argument column_value accepted a time period in GraphQL. But sadly it only accepts one value. I’ve tried this query: query { boards (ids: 157244624) { items(limit: 1000, newest_first: true) { name } } } That’d work because I’d get the newest items of a specific board. But I saw in a post that the argument newest_first in items doesn’t work when nested in boards 😕 I saw in another post that I could add a date range in my end (Google Apps Script) , but I don’t know how to do that. Can anybody help me with sample code in Javascript / Google Apps Script or a link where I can study t

Hi, Trying unsuccessfully to upload a file to an existing column following the API docs, but I receive a Bad Request error without too much information regarding what is bad. I’m working with Python, first I generate a request data: req_data = “”“mutation{ add_file_to_column(item_id: %s, column_id: “%s”, $file: “%s”) { id } }”“” % (item_id, column_id, self.to_base_64(fpath)) The file path is opened and then converted to a base64 string, this is the final request: mutation { add_file_to_column( item_id: 724825528 column_id: “Files” $file: “LHByb2plY3RfbmFtZSxncm91cAowLGJhdHJ1LAoxLGJpc2Vhc2ssCjIsY2JjZGFpcnlpbCwKMyxjY2JvdHRsZXJzdXMsCjQsY2Nici1wcm9kLAo1LGNjbGliZXJ0eXVzLAo2LGNjdHJhZG14LAo3LGRpYWdlb2FyLAo4LGRpYWdlb2JlbmVsdXgsCjksZGlhZ2VvaW4sCjEwLGRpYWdlb2l0LAoxMSxkaWFnZW9rZSwKMTIsZGlhZ2VvbXgsCjEzLGRpYWdlb25nLAoxNCxkaWFnZW9ub3JkaWNzLAoxNSxkaWFnZW9ydSwKMTYsZ3NrbnosCjE3LGluYmV2Y2ksCjE4LGluYmV2bmwsCjE5LGluYmV2dHJhZG14LAoyMCxtb25kZWxlemRtaXVzLAoyMSxuZXN0bGVpbCwKMjIscG5nanAsCjIzLHJpbmllbHNlbnVz

Hi, Is it possible to return meaningful person data via a query? I’m new to monday and may be attempting to handle this in the wrong manner. In a simple query the data brought back as part of the payload within column_values is something like the following: “{”“personsAndTeams”“:[{”“id”“:16491444,”“kind”“:”“person”“}],”“changed_at”“:”“2020-10-06T15:04:20.130Z”“}” This is not much good in my use-case which is reporting: I want a name or email address rather than an id. Is it possible to write the query such that it returns a more useful value, or can this id be used in an additional query to return either the specific user in each case, or a list of users that could then be ‘matched’ using the id as a key?

Hi Just wondering if there’s an API for duplicating / cloning an Item? Like we can do from the UI I can’t seem to find any reference in the API

Is there any demand for full duplication of a board using the V2 API? I would like to create boards (out of templates) from my Wordpress site and then assign users and guests to the newly created boards. Any ideas?

Hello All, I am using this small code in M query (power BI) to extract data out of monday board. But when i try to schedule a refresh in power BI platform it says “not authenticated”. Can any one help me to find a way to add authentication in the code or how can i login to this https://api.monday.com/v2 so that power BI can authenticate itself. Any help will be appreciated. here is the code. let Key = “api token”, Board = “board id”, Source = Web.Contents( “https://api.monday.com/v2”, [ Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“Bearer " & Key ], Content=Text.ToBinary(”{““query””: ““query { boards(ids: " & Board & “) { items { name, columns: column_values { title, text } } } }””}”) ] ), //Line 19 converts the data inside “data → board-> items” to a table with the column names “Title”, “Updated At”, “Group”, “Columns” Data = Table.FromList(Json.Document(Source)[data][boards]{0}[items], Record.FieldValues, {“Title”, “Columns”}), #“Ex

Hello everyone, I was trying to create a new Monday integration to my app and I had some issues after I finished with the OAuth process (my integration doesn’t need the user to enter any particular board_Id on any other data I get access to it from the token). As I confirmed my integration I was getting this error on this particular request ( when I pressed on the “Add to board” button), I hope you guys could help me out, Thanks a-lot!

Hello all, Is there any way to get the information (name, email address) of account administrators from within an app? I’d like to know if using the SDK I can know who the admins are, and it seems I can’t get that from the API (the schema doesn’t describe anything related for neither user nor account unless I’m missing something). Is it possible?

Hi All I developed a board view app which works perfectly when a full member of the board uses it. However, it doesn’t work when a guest or viewer is logged in. The issue seems to be that a call to the api via the Sdk doesn’t return any data when A viewer or a guest is logged in to the parent monday web app. This is consistent with the response from the API playground (although via the Sdk, I get a more cryptic error message m, but the status code is the same: 403). My question is: how are board view / widget apps supposed to be built so they can access board data even when a guest is logged in? This is one of the main reasons why we chose Monday: the ability to expose bespoke content to external parties. Thanks Jaacquees

So it seems once you’ve uploaded your icon once it cannot be changed anymore. I’ve tried everything, change the filename, resolution, saving again with a different description. here’s a screenshot, I’d love from the dev team can help 🙋‍♂️

Hey Builders! I want to congratulate the winners of the first ever monday Apps challenge that just finished. You can see all of the amazing winners in the gallery: monday Apps Challenge: Dream it, build it: Build any app you can dream of and drive away in a Tesla X - Devpost The results were amazing and we want to keep the momentum going so we launched a new monday Apps challenge that is open until the end of November:monday.com Apps Marketplace Challenge: solutions for teams This challenge is focused on helping teams work better and has 5 main categories: CRM, Software Development, Marketing & Creative, Construction & Field Workers, Wild Card. The winning app will get a Tesla X and the two runner up will win a Tesla 3 each! In addition to that, in each category we are giving 2 Macbook Pro for the top apps in that category. Looking forward to see all of the mazing things you will build, good Luck!

Hi, I have two accounts on Monday.com: Account 1 and Account 2 I’ve created an Application in Account 1 and invited the Account 2 as a Collaborator. Then I’ve installed the app in Account 1 and I can see it from Account 2. So, when trying to do the OAuth using Account 2 credentials I get the following: { “message”: "Error while authenticating: {"error":"invalid_grant","error_description":"App not available for user"} " } What could be the issue? Really stuck Thanks in advance

Hi there 👋 When I read the doc here, I’m expecting to get: token_type scope access token expires_in refresh_token in response to: https://auth.monday.com/oauth2/token But expires_in and refresh_token are missing in the response (everything goes well, I don’t have any error or problem). Does it mean that the tokens are now valid without any expiration date (the doc mentionned 30 days)? For me, it would make sense, as the integration can be removed by the user in Monday.

Hi ! I’m looking for monday’s 0Auth client ID in order to set up correctly the Panel control security section of our company’s Gsuite. I can’t find this code/number anywhere and monday’s helping center have told me they can’t get back to me before 2 business days. Any luck that one of you guys know the Monday’s 0Auth client ID please ? Thanks.

I’m using the GraphQL API and I’m not sure if the issue I’m facing is due to an error or a mistake on my side. I’m trying to get all groups and items on a particular board. While the query works in general, it has a complexity that doesn’t make sense to me. The query complexity seems to assume I potentially parse all items in the account, not only the ones in the specified board. Here is my query: { boards(ids: 123456789) { groups{ title items(limit:100) { name column_values(ids: [“firsti_d”, “second_id”]) { text } } } } } Running the query with different limits on “items” gives the same result, but with vastly different complexity, making me hit the rate limit really quickly, although the board is rather small. A workaround might be a limit in groups, but that doesn’t seem to exist?

Hey there, Looks like there was an api change today or recently where providing true and not “true” for checkbox column “checked” property stopped working when using a boolean and not a string. If anybody else experienced the same issue, here the fix: { checked: "true" } // instead of { checked: true } Cheers, Ronen Eazyform

Hey, i’m using the monday sdk in a server env with my own personal token and when calling items_by_column_values immediately after create_item it doesn’t find the created item. If I “sleep” a few seconds between create_item and items_by_column_values then it finds the item. I need this to work for my unit tests, without sleeping - what’s the solution? Will calling the monday api not via the monday sdk solve the problem? Thanks, Ronen

Hey there, I just noticed that the developer account has a complexity limit of 1,000,000 instead of 10,000,000 for a regular account. This really limits me development and testing wise. Any chance to increase that limit to at least a regular’s account limit? Thanks, Ronen

Hi all I would like to share a simple repo for making Vue based Monday apps. It is a very simple app (simpler than the Vue CLI starter). An ngrok tunnel is automatically setup and url copied to clipboard if turned on. Feel free to fork, update as your wish. GitHub

Hi! I’m trying to update a checkbox column but if I send the checked value as false it still checks the column: mutation { change_multiple_column_values(item_id:295524638,board_id:287994487,column_values: "{\\"check\\": {\\"checked\\": \\"false\\"}}"){ id } } Any advice?