API & Apps framework

Hi, Community. I’m currently trying to import the data of some boards into databricks. All of them have the same structure, and I wanted to get all the columns (if possible). Is there a way to make only one request and get the data of all the boards? I’ll put down here the script of the first step, which is the one we define the boards’ ID. %python apiKey = "censored" ## API Key apiUrl = "https://api.monday.com/v2" headers = {"Authorization" : apiKey} query = '''query { boards(ids:[1272092066,1615564124]) { items { id name column_values { title text } } } }''' data = {'query' : query} r = requests.post(url=apiUrl, json=data, headers=headers) # make request data = r.json() I tried putting the IDs separated by commas, but at the end it only got the data of one of these boards. Am I missing something? To be honest, I’ve never worked with APIs, so all of this is really new to me. I couldn’t find a part on the documentation that specified this type of integra

Hello, I am trying to get a all the items on Monday from an item value. I have tried multiple ways on Postman, but i keep getting error “500Internal Server Error”. Now i don’t know what mistake i am doing in making API Call. Below is the Monday Board screenshot. I am trying to get all the value in Item 5 column. Below is the my body on Postman Below is the query query { items_by_column_values ( board_id: 1730769393, column_id: "text", column_value: "Text" ) { id } }

hi there. first of all i want to say im not a 100% sure that my title is really whats happening, but im fairly convinced. im building an integration app in a node.js backend, once a month i need to make changes in the account, make customize pdfs and excels and upload everything to a cloud etc… my point is its a long process and my token seems to expired. the reason im not sure is because something else is happening that i can’t really explain, i get the first request from monday’ after the trigger and everything is working fine. but midway during the process, after no response is being given back to monday’s servers, i get another request that triggers everything again, with a new shortLivedToken. Up until now i’ve dealt with that by using global variables and invoking res.end() and end the process if i was already in the middle of one, but now i need to make another monday api request at the end of the process and im getting “{ errors: [ ‘Not Authenticated’ ] }” back. i couldn’t find

There is this private board somewhere in our org that is throwing an error every time I try to query it through graphQL. I notice that other private boards are automatically excluded from a query, but this specific board is not. Myself and another admin cant even find this board anywhere on our workspaces, so we don’t even know how to troubleshoot it. I simply want to query all our boards and get their columns, but as soon as the query reaches this private board, it throws the error that I am not authorized to get any information from that board. So, I am wondering: how I can exclude this board from my query? Why cannot I see this board on any of our workspaces? If I don’t have board permissions to look at it as an admin, how do I find it to make changes? As a note, I came in as a dev to work on this after leadership had a chance to play around, so this private board is something leftover from testing.

Hi, I´m trying to get complete values from a board (using API v2), o get message using the API Playground with the code bellow (i got the message: “SyntaxError: Unexpected token < in JSON at position 0”, can you help me? { boards(ids: 1123411782) { id name items(limit: 32) { id group { id title } name created_at column_values { id title text } } } }

When item is created on the board, it takes about 30s for the item to be returned by items_by_multiple_column_values call. Delay makes it difficult/impossible to use to reflect current status of the board. Is that long delay expected? Can it be reduced to maybe 1 or 2 seconds? Steps to reproduce (always): Create item A on the board. Run items_by_multiple_column_values. New item A is not returned by the call - I was expecting the item to be returned, because it is present on the board. Wait about 30 seconds. Call items_by_multiple_column_values again, and item A is returned as expected.

Hi there, I am trying to simply retrieve a list of items for a given board that currently has no items (using the API). I get the following message: Complexity budget exhausted, query cost 3700020 budget remaining 999960 out of 1000000 reset in 60 seconds Does this number seem wayyyy too high to simply get a list of items? Could someone please get me in touch with support so I can follow up with my specific situation? Much appreciated, Harry

Hi, Is there a way I can get the order of the status label? I tried this query: `query { boards(ids: 1720999724) { columns { settings_str title type } } }` and this is what I get from the settings_str : which doesn’t include the information that I wanted. I would expect the results will return in the correct order which is : “Level 0” > “Level 1” > “Level 2” > “Level 3” May I know which graphQL can I use to get this result? Br, YarHuoy

Hi, I’m trying to use the monday API to update an item based on an update to a GitHub issue (i.e. if a label is added to a GitHub issue, add it to list of labels in its corresponding Monday item). I’m getting a 200 from the call, but I’m not seeing the changes reflected in Monday. The fetch call: const targetBoardId = 111111; const targetItemId = 22222; const updateItemResp = await fetch('https://<enterprise_domain>.monday.com/v2', { method: 'post', headers: { 'Content-Type': 'application/json', Authorization: shortLivedToken // This is all within an integration recipe, so grabbing auth from there }, body: JSON.stringify({ query: 'mutation ($targetBoardId:Int!, $targetItemId:Int!, $newColumnValues:JSON!) { change_multiple_column_values(item_id: $targetItemId, board_id: $targetBoardId, column_values: $newColumnValues) { id } }', variables: JSON.stringify({ targetBoardId, targetItemId, newColumnValues: JSON.stringify(columnValues), }),

Hi, I was trying to use my app after being on vacation for a while, and something seems to have broken down during that time. When I call the webhook URL now, nothing seems to be happening (checked all the info in the app, everything seems to be in order). Tried refreshing the webhooks (unsubscribe, re-subscribe), but still no go. Is there any easy way of testing the webhook url / app connection, just so I can rule this out as the source of the problem? Thanks.

Hello. I know that I do something wrong in syntax, but don’t know where. I’m using the curl in windows command line. This request for curl works perfectly: -d “{"query": "mutation {change_column_value(board_id: 1692786470, item_id: 1692853617, column_id: “_____12”, value: “\\"871\\"”) {id}}"}” I’m also needed to change the “date” column. This command I have checked at “API Playground”, it’s work: mutation { change_column_value(board_id: 1692786470, item_id: 1692853617, column_id: “____”, value: “{"date": "2021-09-01"}”) { id }} but I can’t transfer it for curl (same us first request)…

I can’t figure out how to structure my json obj to update/create a tag based on the GraphQL documentation… show: { tag_name: showAbbr }, show is the column id, showAbbr is a string

Hi, I am trying to connect via curl but if I do it from the command line I get an error: curl: (60) SSL certificate problem: unable to get local issuer certificate using the same command but in https://reqbin.com/curl it works perfect, I don’t know much about this topic, can I get some help please?. I’m using curl like this curl -X POST -H “Content-Type:application/json” -H “Authorization:TOKEN” -d ‘{“query”:“{ boards (ids: xxxxxxxxxx){name views{name}}}”}’ “https://api.monday.com/v2” if I use -k or --insecure I only get a empty pair of curly braces. I appreciate any help. Regards, Javier

Hello Monday community, I have a small GraphQL query as below: { vat_quarterly: boards(ids: 684144642) { groups(ids: "topics") { ...NumberDateFields2 } } } fragment NumberDateFields2 on Group { items { column_values(ids: ["numbers", "date72", "mirror66"]) { text } } } The result I retrieve is as below(just a small snippet): { "column_values": [ { "text": "Courtney Stretton" }, { "text": "2021-08-31" }, { "text": "1" } ] } } Now, the column ID mirror66 is actually a user’s name. In my Graph QL query I had added mirror66 at the end, but it appeared first in the result set for each row. Is there a way to achieve more definitive results, like the result order to match the columns order that the system was requested with? So, here result shou

Hi, I need to use a URL for the App BaseUrl that includes a port # (ex: https://www.example.com:3000). It doesn’t seem to be working, and I’m wondering if this is actually possible on Monday. Thanks.

I have a question about app triggers, I can put a value inside a sub-item as a trigger. Example: A status within a sub-item triggers an app/integration trigger. If so, how exactly do I do it? Thanks in advance!

Hi Team, We are facing some issues with the AUTH setup in our application. We want to integrate the authorization in our app where a user can have multiple accounts where he can login through just like email(phone burner_auth_url in our case) screenshot attached We tried for this and created the code for the front end page, also tried to integrate through the authorization url in our app We are stuck as to how to integrate this react page in our app so that it gets displayed when the user adds any recipe to the board also the user has already an account setup so that he can choose from drop down if he wants to add another account We want to display this page inside monday.com account itself If anyone can help with this issue it would be great

Program…no-code? Looks like a “contradictio in terminis”, but is it? The difference is how you program, using code like JavaScript, NodeJS, Angular etc. or connecting dots (modules) with arrows (connections). In both no-code and apps the logic to do something has to be designed, developed, tested and supported. Monday.com, as any other platform I know, can’t do anything we (as users) come up with. There are times you need to rely on an external system to do things for you. That’s why we have API’s. The same monday.com API can be used in Intergomat / Zapier or monday (marketplace) apps. So, what is the difference. Security; when using no-code platforms you have to approve the connection between them and monday.com. The same is true for apps (you have to approve the scope). The difference is that no-code platforms store your credentials (whether in a token or through another mechanism). Well developed monday.com apps do not store these credentials or tokens as they get a “60 second to u

I’m querying all boards in our account and I am only getting 25 boards returned. Many of the boards I’m looking for are not included. Here is my query: monday.api( `query { complexity{ query } boards() { id name owner { id name } } }` ) I’ve tried removing the complexity code block thinking that might be the issue but with no success.

Hi Devs, The built in Monday recurring trigger has only boarId & schedulerConfig as input values and no output values. https://apps.developer.monday.com/docs/monday-trigger-blocks#recurring I have a couple of questions. How can I build a monday trigger combining a schedlerConfig & status like this - “Every time period if status is something ?” similar to this Gmail integration How to get itemValues as output from this trigger? Thanks.

Hi folks. I am new to Monday.com and have a question about the API. I have been using the API Playground, and have been able to run commands from it, but the commands are mostly for internal Monday stuff - like adding items, workspace, etc. I am new to using API and I am wondering, as an example, can I pull data from www.openweathermap.org using their free API token, then displaying a Widget on my dashboard that shows the weather information? If anyone can help me figure this out, I can then figure out how to pull data from other resources (like a database) using this procedure. Thank you!

Taking the code from here:style.monday.com <TextField placeholder={text("Placeholder", "default placeholder")} debounceRate={number("Debounce Rate (see console log)", 0)} iconsNames={{ primary: "Primary Icon - could be any icon" }} iconName={text("Primary Icon Name", "fa-circle")} secondaryIconName={text("Secondary Icon Name", "")} validation={select( "Validation State", { None: null, Error: { status: "error", text: "error" }, Success: { status: "success", text: "success" }, Assist: { status: "", text: "assist text" } }, { status: "", text: "assist text" } )} id="Knobs" disabled={boolean("Disabled", false)} readonly={boolean("Readonly", true)} size={select( "Size", { Small: TextField.sizes.SMALL, Medium: TextField.sizes.MEDIUM, Large: TextField.sizes.LARGE }, TextField.sizes.MEDIUM )} clearOnIconClick={bool

Currently, when creating a new status label using the label indexes, they label disappears after a refresh or a navigation to another board and back to the original board. Only the labels that are created manually on the board remain. The rest just disappears. Here is a video showing the above described problem.

Hi, One of the users of our Analytics and Reports monday app is reporting that they get an error response to the OAuth authorization request, like { “error_code”: “UserUnauthroizedException”, “status_code”: 403, “error_message”: “User unauthorized to perform action”, “error_data”: {} } So instead of being redirected to an appropriate error page (“You need to install the app first” etc.) the error response comes through to the requesting app (ours). I can’t reproduce the error. In which situations could this error happen? Is there a problem with the users privileges or maybe something wrong with our app or the monday API? Thanks for your help!

Hi We are using Mind Map a lot to identify Scope / Areas / Actions to be taken… and then we need to retype it all in monday.com to make it happen - assign to someone, ect… Is there anyway we could have a mind map “view” and have items added into the main table? That would be great! thanks