API & Apps framework

As we are developing an front-end APP, we are in need of knowing the database limit to store the item details. Could you please confirm the below points? App Database limit to store the data Is it possible to store the objects or array of values for a key? Example: monday.storage.instance.setItem('domain', {name: "xxx",api_key:"yyy"}).then(res => { console.log("setItem.......",res); });

I am trying to create a python script that reads an XML file and imports the data to Monday.com Board. I have the XML scraper built, now i need to learn the API side… I have this example working without the 2 “Text” fields, After i added the 2 text fields I get a ‘error_code’: ‘ColumnValueException’, Can someone please help me understand why this error is happening? even chatGPT agree’s it should work but isnt… MY CODE BELOW Creating a new item with column values populated apiKey = "apikey here" apiUrl = "https://api.monday.com/v2" headers = {"Authorization": apiKey} query5 = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:3716595122, item_name:$myItemName, column_values:$columnVals) { id } }' vars = { 'myItemName': 'Item 1', 'columnVals': json.dumps({ 'status': {'label': 'Working on it'}, 'date4': {'date': '2022-12-31'}, 'text': {'text': 'text here'}, 'text1': {'text': 'text here'} }) } data = {'query': query5,

I’m using the Graphql API to update Monday - but it behaves inconsistently and doesn’t always perform the update. I’ve noticed in my log, that in some calls to the change_column_value mutation, it returns undefined - I think these are the cases where it doesn’t save the change, but it’s all very inconsistent - because if I call it again, it does save. What are the cases where change_column_value returns undefined? Should I add logic that will repeat the update until it doesn’t return undefined? Here’s the graphql: mutation ($id: Int!,$value:JSON!,$board:Int!,$column_id:String!) { change_column_value( item_id:$id column_id:$column_id, board_id:$board, value:$value ) { id name, column_values(ids:[$column_id]){ id value } } } Here’s a link to my code on github:github.com I would love to hear from you

I am storing a data using storage api, it is working fine on same session, but as soon as I refresh the web page I am not getting the saved data using storage api. Can you please help me over here? Thank you

Hi, May I know is that possible for us to create the same feature like: by using this provided feature? Thanks! Br, YarHuoy

Hi, Wonder what I am doing wrong. I am reading the JWT token in C# and all I get is: {“accountId”:xxxxxxxx"userId":xxxxxxxx,“aud”:“http://xxx”,“exp”:1671813626,“iat”:1671813326}} According to Choosing an authentication method, I should get a shortLivedToken field. Blockquote When you decode the JWT token, you will see a shortLivedToken field. This is an API token that is valid for 1 minute and can be used to authenticate against the monday.com API.

Hi all, So i’m trying to implement the OAuth workflow with monday. I did all the steps in the doc, but somehow, whenever my application calls the redirect towards the /authorize endpoint, after I authorize the application in the web interface, I get a : {"error":"server_error","error_description":"Internal server error","state": ... My request is to this URL: https://auth.monday.com/oauth2/authorize?client_id=MY_CLIENT_ID&state=MY_STATE So to debug this in order to see if my app’s request was the problem, I copied the suggested URL in the app OAuth section (app framework) which is just the previous URl without the state query param. I still get redirected to the web interface where I allow the monday integration its needed scopes. But after this, when my configured single redirect URL gets call, the request query contains the internal server error. What am I missing ?

Hi, I’m currently trying to duplicate a group with 34 items through the graphQL API. So far so good, the API is easy to use & the request schema helps a lot. I encounter the following problem: I successfully duplicate a group with the following mutation query: mutation { duplicate_group (board_id: ${boardId}, group_id: ${groupId}, add_to_top: true) { id } } The group is duplicated in monday & visible. However, not all items of the group are present in the duplicated group. The number varies. Sometimes I get 15/34, other times I get 18/34… I suspect this might be because my whole custom action exceeds the query complexity limit (it performs more than 1 query). But, I would expect in this case that monday returns a status code 429, this is not the case. Anybody knows why my item are not all created ? Thanks in advance!

Had a look through the documentation but I’m not too sure if this is possible, am I able to use GraphQL to add a new view to a selected board?

I’d like to request assistance. I’ve already created the template as a solution pack by creating the app on my account, but I encountered the issue of the connect board column. 4 connected board columns that add new boards to the template automatically every time the template is used. Roadmap: link to epics Epics: link to sprint management Sprint management: link to bugs queue, link to metadata Does anyone else have this problem, or does anyone know how to solve it? Regards,

I’ve been trying to create a custom automation with trigger every second/minute. What I’m wondering is whether there’s some way to know what action user choose?, so I can pass data to webhook. And Can I catch or create a webhook event to know whenever this trigger run? so I don’t need to use setInterval()

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