API & Apps framework

Hello, Prefacing this by saying I am by no means a developer at all - but I am trying my best to learn what I can to create custom, workable solutions for my organization. I’m looking to create a very simple item view app that simply displays the contents of a link column as an iframe. Any preliminary guidance on how to approach such a thing? I’ve created simple item views where I’ve just been able to embed the static website I would like (in my use case, an online form). However, I would like the item view to display dynamic links specific to the item. Any guidance on how to create an app on how to do this? Happy to even just get some articles I can read to learn about how to start. Essentially, the app will need to be able to read the monday.com item data and display the link column’s content as the iframe src. Thank you in advance!

Hi all, I was able to insert trigger “Every time period” to my recipe. But it works on day, week and month, just as described here.monday apps framework I need to make synchronization more often, by hours or even by minutes. How can I do it? Best Regards, Sergey.

the two queries in the documentation for clearing the week and hour columns are no longer valid. mutation { change_multiple_column_values(item_id:2973227073, board_id:2973227049, column_values: "{\\"week0\\":{ \\"week\\": {\\"startDate\\" : \\"\\", \\"endDate\\" : \\"\\"}}}") { id } } mutation { change_multiple_column_values(item_id: 2973227073, board_id: 2973227049, column_values: "{\\"hour\\" : {\\"hour\\" : \\"\\", \\"minute\\" : \\"\\"}}") { id } } both have changed to the following: mutation { change_multiple_column_values(item_id: 2973227073, board_id: 2973227049, column_values: "{\\"columnid\\" : {}}") { id } }

Hi everybody, Is there any working Python example of custom app authentication? There is a Node example, but I cannot make it work on Python. monday apps framework My Python code (powered by Flask and PyJWT) import jwt ... @app.route('/auth', methods=['GET']) def auth(): args = request.args token = args['token'] data = jwt.decode(token, MY_CLIENT_SECRET, algorithms=['HS256', 'SHA256', 'RSASSA', 'HMAC']) return Response() # just a stub for now So I’m getting error “Signature verification failed” when decode the token (jwt.decode method). What am I do wrong? Best regards, Sergey.

When I’m passing data to the platform, I won’t always know the country that corresponds to the phone number I have. Frequently, even, I won’t have that information available when I need to make a request for mutation. I can pass an empty string for countryShortName so the API doesn’t complain. Since the country isn’t known, it’s understandable that a flag is unable to be displayed. To make life a bit more manageable, what is, then, the default display for the phone number? For my account, based in the United States, I see xxx xxx xxxx. Is this the default for all users across the platform or is this based on the given user’s country_code off the User object? Additionally, if anyone else has dealt with this and has a decent workaround, I’m all ears!

Hi devs, I’ve created a recipe with dynamic mapping and want to trigger it now. I want to trigger the recipe with data from other software and update monday according to the dynamic values set by the user. When triggering it, it returns: <Response [200]> - {‘success’: True}’ Although that sounds good, it does not create an item in monday. I added more screenshots below. I feel like it has something to do with how I structure the json data that I return to monday. I tried a lot of options, but can’t seem to get it right. Extra context: for some reason it never calls the field definitions URL. Might also be part of the issue. Thanks in advance for the help. If anything needs clarification, please let me know.

I have a very simple query: query { items_by_column_values(board_id: 111111111, column_id: "status9", column_value: "Completed") { id name } } Which returns exactly 1000 records, but that is not everything. So I thought I would add a limit and paging. But using Limit:500, Page: 3 is completely empty. Same with a Limit of 100 and Page 11… It seems as though items_by_column_values is hard-coded to a maximum of 1000 items… Anyone have thoughts on how to get the remaining records?? *These missing records do show up if I search by Name instead of Status. And when I look at the detail, their status9 value is indeed showing Completed. So I am not sure what my next-steps should be…

Hi there I do see a large number of these errors I get a ChangeColumnValueError when trying to change a number column to -5. What do I do wrong here? I also notice a custom exception ItemLinkMaxLocksExceeded. Under which condition does this ItemLinkMaxLocksExceeded error occur?

Hello, I am looking for a way to change the column values for multiple items using the same mutation. I use change_column_value to do this for one item at a time, but the number of items I have on my board make this process inefficient. How can this process be done iteratively? If possible, where can I find an example of it?

Hello, I am trying to run api requests to pull a boards items into a google sheet, and want to see how I can structure the request to return data similar to exporting the data as an excel file, meaning each item is in a single row and the column titles in row 1 (header row). Is this possible to do?

Hi, I’m working on a Monday app that returns data from another app every 24 hours. Everything is going well so far, but when I try to create the recipe and click on ‘Item’, it returns ‘Failed to load fields’. I am receiving 3 POST requests when I click on ‘item’, so it’s very likely that I’m not returning the right data. I’m receiving this in the POST request (changed the numbers): {‘payload’: {‘side’: ‘source’, ‘recipeId’: 12345678, ‘integrationId’: 12345678, ‘dependencyData’: {‘fieldTypeId’: 12345678}}} I followed all steps of this article At the ‘Call your trigger’ part, it says I need to return: { “trigger”: { “outputFields”: { ///values of all output fields, which were configured for your custom trigger “myEntity”: { “field1” : “Hello world!”, “field2” : “This is another field” } } } } My code looks like this. I tried it with normal ‘return data’ as well (and 100 other tries haha) Field type: Workflow block Recipe: Help would be greatly appreciated!

Two issues I could use advice on: Longtext Column. I am updating column with string and can type returns/new lines manually in the field but inserting them via the API always fails. Can Someone point me in the right direction to keeping the formatting? I have tried both Return and New Line. Best Practices with subitems. I tried following these steps - Step 1: Read CSV Data to add to board convert to paragraphs(rows). Step 2: Repeat thru Rows Step 3: create_Item using Board ID with about 5 column_values using some row info of CSV Step 4: create_subitem using Parent Item ID with about 10 column_values using rest of row info of CSV Step 5: End Repeat This process always fails on the 2nd loop of Step 4 no matter the column_values. If I change step 4 from create_subitem with column_values to create_subitem using Parent Item ID eliminating the column_values option, add another step of change_multiple_column_values changing the Board to Subitem board it does not fail. Any idea why th

Hi, I am trying to fetch a few options for a custom field from a C# endpoint. I know that the response expected is an array of key-value pairs which should have tile & value. The problem is that it seems that monday can not parse the return string as 1) it is include in quotes as it comes from a C# end point and 2) it contains escaped characters in order to includes quotes. I don’t get any error in my recipe but the list is always empty. I have tried with various combinations for escapes characters but I haven’t found a working solution . Just as an example this is one the return string the endpoint returns in one of my tries. “"[{\\"title\\":\\"to_upper_case\\",\\"value\\":\\"TO_UPPER_CASE\\"},{\\"title\\":\\"to_lower_case\\",\\"value\\":\\"TO_LOWER_CASE\\"}]"” Any help will be really appreciated. Thanks in advance.

I’m inquiring for interest in starting a community developed sdk in typescript intended for nodejs use. (as the current javascript sdk provides about zero additional value on the server-side beside being a wrapper for node-fetch) Some objectives include: Native TypeScript, transpiled to a node package. ESM first (CommonJS is going the way of the dodo). exceptions for http errors, graphql api errors, proprietary monday.com errors (including possibly error normalization since what comes from monday is erratic) Built in retry for complexity limits. Built in retry for socket resets, etc. methods for all mutations, including typed & parsed responses. methods for common queries, including typed & parsed outputs, built in pagination. utility methods for creating JSON values for column mutations utility methods for converting indexes to labels and vice versa. types for monday graphql objects (boards, items, updates, columns, column_values, etc.) types for parsed settings_str types for

I’m going nuts and it doesn’t seem like I am the only one here having issues figuring out why I can’t create items with multiple items and how to format the mutation. I was able to get this to work for 2 items through a ton of attempts but have no idea why mutation {create_item (board_id:3639551233, item_name:“test02”, column_values: “{\\“date\\”: \\“2019-02-06\\”,\\“long_text\\”: \\“Hello world this is a really long note\\”}” ){id}} I have no idea why this doesn’t work if the above code works: mutation {create_item (board_id:3639551233, item_name:“test666”, column_values: “{\\“date\\”: \\“2019-02-06\\”,\\“long_text\\”: \\“Hello world this is a really long note\\”,\\“text4\\” :\\“Saint Nick\\”}” ){id}} I would really appreciate help understanding this. Also is subitem and columns the same format? if not can I see example of this as well? Thank you.

Is there a secret to getting a non-approved app installed on an enterprise account? Yesterday I was trying to help a custom load a test version (non-approved by monday) of an app on their account. The screen came up to approve the install. But the install button was greyed out. I’ve done this many times on pro accounts. So, I’m assuming that there is an enterprise setting that prevents this. Does anyone have a solution?

Hi! As developers, we are building an App to be part of the Monday’s Marketplace. We found some performance requirements to be answered. We suspect that some questions can be answered by a performance test. The App is entirely built on Monday, no external services or servers. Have anyone conducted a performance test before or knows how to proceed? Thanks a lot!!

I’m looking to create an item containing user details inside one board, then I want to connect that item to another item in a different board inside its column. I’ve tried to guess a solution but this gives me an error: "mutation ($itemId: Int!, $boardId: Int!, $column_values: JSON!) { change_multiple_column_values (item_id:$itemId, board_id:$boardId, column_values: $column_values) { id } }"; { error_code: ‘ColumnValueException’, status_code: 200, error_message: ‘Link to item column value structure invalid’, error_data: {} } The only way I’ve found something that can help is via this link, but the documentation has been down forever. https://monday.com/developers/v2#column-values-section-itemlink

We are trying to retrieve items using items query as below: query { items(page: 1 limit: 50) { name id } } We are getting below error: { "error_code": "ResolverCallsExceeded", "status_code": 429, "error_message": "Call limit exceeded for Resolvers::Pulses", "error_data": { "error_reason": "automations.history.failed_trigger_details.error_reason.api_rate_limit" } } The frequency of the error is higher than the success case. Can anyone suggest is there any way to avoid this issue if not at least any possibility to reduce the frequency of the error. Regards, Prashanth

Hello, I am trying to create a new item in one of my boards. I will make the API call from JavaScript according to the documentation but I have tried multiple ways using Postman and I keep getting error “500 Internal Server Error”. Now i don’t know what mistake I am doing as no explanation is given… Any help is appreciated. Thank you!

Hello, We are currently looking to build a dashboard widget that allows for the the user to search for a value, then display information based off that search. The other part of this is that we would like to filter the table widget’s and the corresponding boards inside the table widgets to this value. The idea being that we display surface layer information, then the user can look at the boards for more specific information. Currently to accomplish this we have to manually go to the Quick Filter and individually set each board to be that value. With up to 6-8 boards in the dashboard, this can be quite troublesome, especially when wanting to search a few times in a row. I have tried to use monday.get to be able to see these filters, then in turn use monday.set to set them programmatically but was unsuccessful. Was hoping to get some help with how I could accomplish this. I would be happy to programmatically set each board to be the new filter or to just set it once for the dashboard, wh

Hello, I am building an application to discover plans used inside monday.com. I saw that you provide different plans: individual, basic, standard, pro, enterprise. monday.com pricing and plans It’s great that API enables to get them. The Plan “Tier” field returns to me “free” | “standard” | “enterprise” etc. My question is: Is there a way to know if my plan covers the different monday.com products like monday crm, monday projects, monday marketer, monday dev? Maybe the “version” field in Plan is what I’m looking for, but the api only returns a number. And the documentation doesn’t mention what the plan version number might mean

Hi all! Join us on Wednesday, December 7th, at 11:00 AM EST for a webinar on Monetization in the Apps Marketplace! In the session, I will be covering everything you need to successfully monetize on monday. Please complete this short registration form if you would like to attend. I hope to see you there!

I am trying to update a ticket column. I am getting a 200 response for the code below but it does not reflect on the ticket itself. What gives? apiUrl = "https://api.monday.com/v2" headers = {"Authorization" : apiKey} query= 'mutation {change_simple_column_value(item_id: 3601557877, board_id: 3543199429, column_id: "Triage Score", value: "99") }' data = {'query' : query} r = requests.post(url=apiUrl, json=data, headers=headers)

Hi, I have used the following API connection in power query for one of our boards successfully: let Key = “xx”, Board = “xx”, 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, updated_at, group { title }, columns: column_values { title, text } } } }””}”) ] ), 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]) ) )) in #“Monday” Now when I try and change the board to another one with the same query it times out. Is there some difference in the boards or the query to make th