General

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 🙂

After long war and blood shed I got it right For anyone out there want to know how to upload files using HttpRequest -C# BaseUrl = https://api.monday.com/v2/file public async Task<FileUploadResponse> UploadFile() { string filePath = @"C:\\Users\\XYZ\\Downloads\\Dummy\\001.docx"; string fileName = Path.GetFileName(filePath); HttpClient httpClient = new HttpClient(); httpClient.DefaultRequestHeaders.Add("Authorization", YOUR_TOKEN); httpClient.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("multipart/form-data")); MultipartFormDataContent form = new MultipartFormDataContent(); byte[] file_bytes = File.ReadAllBytes(filePath); string query = @"mutation ($file: File!) { add_file_to_column(file: $file, item_id: XXYYZZ, column_id: ""files"") {

I’d like to avoid a network request if a user is not of the correct minimum tier to create custom tags. I know that the developer tier, for example, is represented as free. Given that I’m not using a paid account, I’m wondering what the other tiers are definitively called. I’d imagine they’re standard pro enterprise but I’d like to make sure.

Hello, I have been developing an app that needs to store very long strings of data. I have implemented this by using the storage option offered in the monday sdk however, I have discovered that this data is stored in the board, not in the item. This is causing issues when moving items between boards, as when the item is moved, the data doesn’t come along with it. Is there currently anyway to store data in an item rather than the board? Or would I need to use a 3rd-party database in this circumstance? I thought about using a long text column for storage but the 2000 character limit would be an issue.

Suppose I have a rating column with a maximum rating of 4. Let’s query the column and its value. query { boards { columns (ids: "rating") { id title type settings_str } items { id column_values { title type value } } } } We would then get a response like { "boards":[ { "columns":[ { "id":"rating", "title":"Rating", "type":"rating", "settings_str":"{\\"limit\\":4}" } ], "items":[ { "id":"2379332173", "column_values":[ { "title":"Rating", "type":"rating", "value":"{\\"rating\\":4,\\"changed_at\\":\\"2022-03-06T07:37:27.144Z\\"}" } ] } ] } ] } So far, so good. We’ve got a limit of 4 and our current rating is 4, the maximum rating. However, what if we change the column’s settings such that the maxi

The API documentation indicates that both the ISO 3166-1 alpha-2 code and the full country name are required in order to update a column with type Country. While it’s not necessarily difficult to map between the two if one only has one or the other, I wanted to test its requirements and drill down into edge cases. In doing so, it seems that the country name is not strictly required to have a value and is only required for its property to be present. That is, the column will update, and do so correctly, based entirely on the code. For example, all of the following mutations update a country column with United States as the visible value and a U.S. flag within the column. mutation ($itemId: Int!, $boardId: Int!) { change_multiple_column_values ( item_id: $itemId, board_id: $boardId, column_values: "{ \\"country_1\\": { \\"countryCode\\": \\"US\\", \\"countryName\\": \\"United States\\" }}" ) { id } } mutation ($itemId: Int!, $boardId: Int!) { change_multiple_c

Good morning, I’m developing an API in Node.js that will be integrated with a company system. The API needs to perform queries against our Monday task boards. I’m having problems performing API queries, I used the example codes from the documentation to perform the queries but it’s not working, after that I tried several other ways, using several other NPM modules and I still can’t perform the queries. The only method that worked to perform the queries was using the ‘https’ module, but I am not able to process the query result, which should basically convert the JSON result into an object. Below is the query already tested on the PlayGround of the Monday API: { boards(ids: 447377089) { name state board_folder_id items { id name column_values { title text } } } } API query code per example from Monday’s documentation: const fetch = require(‘node-fetch’); let query = “query {\\n boards(ids: 447377089) {\\n name\\n state\\n board_folder_id\\n items {\\n id\\n name\\n column_values {\\n t

Hello I am having a few problems formatting a json string for a C# query I am making @"{""query"": ""query { items_by_multiple_column_values (board_id: 1234, column_id: \\""text0\\"", column_values: [\\""something,something_else\\""] ) {id}"" }"; Here is a little example of the string. I have tried formatting it with JsonConvert.SerializeObject to no avail. Any help would be much appreciated.

I’m working on error handling and want to be sure I’m covering some bases to provide more suitable user-facing error messaging. In doing so, I’ve noticed what appears to be some inconsistency in how the API responds to mutations on text inputs. Namely, I’ve compared three mutations: create_workspace create_board create_item Sample input (length: 256): abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuv Create a workspace The workspace is created given the sample input with no error response (200 nor non-200). However, the workspace’s name is silently truncated to 255 characters. Create a board The board is unable to be created, throwing a CreateBoardException (400). { "error_code": "CreateBoardException", "status_code": 400, "error_message": "Failed to create board", "e

Hello, I’m making a dashboard widget for the Lessonly developers badge. I’m trying to add a setting that lets the user select which column they want the widget to read from. I’ve created a board with a locations column (EDIT: the pictured board is called Widget Test): And I’ve added a columns field to the view settings, the configuration (don’t think its important but I’ll picture it just in case): Yet, when I go to preview the settings display this: Which I don’t understand, since the board has a locations column, and the view setting accepts Location as its column type. Anyway, if I click the Add Column → Add to Board, nothing happens, and my console displays this error message (similarly unsure if it is relevant): I’d be grateful for any assistance, thanks.

Hi, I want to get all the Board IDs via API my account sees on monday.com. However some of them are missing. I have an API-key, and I use the query: ‘query {boards () { name id }}’ I got around 25 IDs back, but my Workspaces got far more than that. What could be the problem?

In the error code docs, the UserUnauthorizedException is misspelled as UserUnauthroizedException. This misspelling is also present in the error_code when the API returns an error corresponding to that exception. It looks like it’s been that way for a good bit judging by past posts that mention the error with the misspelling (dating back to October 2020). Is this intended to remain in the event that it breaks others’ flow(s)? Not that I can’t just check for either spelling on my end.

Hi, When retrieving Hour column via API, the text field of column_values is always formatted in 12h format. I would expect it to be formatted based on configured format. Example API response, where hour column is configured to 24h format and hour_1 to 12h format: { "id": "hour", "text": "05:00 AM", "value": "{\\"hour\\":5,\\"minute\\":0,\\"changed_at\\":\\"2021-12-12T22:09:27.203Z\\"}" }, { "id": "hour_1", "text": "12:00 PM", "value": "{\\"hour\\":12,\\"minute\\":0,\\"changed_at\\":\\"2022-03-05T15:02:04.517Z\\"}" } Would it be possible to get text value formatted based on configured format? Thanks, Lubos

Does anyone have an example on how to parse the following response using C#? I was able to just Json My end goal is to get the json string into a list to create a file with. Thank you for any assistance! { "activity_logs": [ { "data": "{\\"board_id\\":2165785546,\\"group_id\\":\\"new_group2051\\",\\"is_top_group\\":false,\\"pulse_id\\":2165787062,\\"pulse_name\\":\\"Tyler\\",\\"column_id\\":\\"email_address\\",\\"column_type\\":\\"email\\",\\"column_title\\":\\"Email Address\\",\\"value\\":{\\"column_settings\\":{\\"includePulseInSubject\\":true,\\"ccPulse\\":true,\\"bccList\\":\\"\\"}},\\"previous_value\\":{\\"email\\":\\"tyler@email.com\\",\\"text\\":\\"tyler@email.com\\",\\"changed_at\\":\\"2022-02-15T21:18:48.297Z\\",\\"column_settings\\":{\\"includePulseInSubject\\":true,\\"ccPulse\\":true,\\"bccList\\":\\"\\"}},\\"is_column_with_hide_permissions\\":false,\\"previous_textual_value\\":\\"tyler@email.com\\"}" }, { "data": "{\\"board_id\\":2165785546,\\"grou

What would be the GraphQL syntax to retrieve all data in my account - boards, IDs, items, subitems, anything else in the account?

I am trying to list by API the apps installed in my Monday account. Looking at the network, I see the call to the backend is: https://slug.monday.com/apps with the cookie as the authentication method. This works great for me. Now I am trying to do the same on behalf of an app. I created an app, and gave it all permissions at Set Up Permission Scopes. I can’t get any response using the app token I got. What I tried to do instead, is running the graphql at https://api.monday.com/v2/ with the query: query { apps { created_at } } but then I got: { "errors": [ { "message": "Permission Denied! Your token doesn't grant access to apps:read" } ], } When trying to add apps:read to the consent link, I get: {"error":"invalid_scope","error_description":"Invalid scope param"} Is there any other way to list the apps?

I am trying to load a board including the subitems to the excel from Monday. I’ve used the following code to do so and recieved the following error: Code: [ Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“Bearer " & Key ], Content=Text.ToBinary(”{““query””: ““query { boards(ids: " & Board & “) { items { name, updated_at, group { title }, columns: column_values { title, text } subitems { name } } } }””}”) ] ), Data = Table.FromList(Json.Document(Source)[data][boards]{0}[items], Record.FieldValues, {“Title”, “UpdatedAt”, “Group”, “Columns”}), #“Monday” = Table.FromRecords(Table.TransformRows(Data, each List.Accumulate([Columns], [ Title = [Title], UpdateDate = [UpdatedAt], Group = [Group][title] ], (state, current) => Record.AddField(state, current[title], current[text]) ) )) Error: DataFormat.Error: There were more columns in the result than expected. Details: Count=4 Thank you in advance.