API & Apps framework

Hi, i need to get data by API from specific date, i read this post that monday can get data using items_by_column_value by specifying board_id, column_id, and column_value. But i cannot use ‘created_at’ or ‘updated_at’ column, based on this example we can use ‘date’ From documentation, the result are shown but weird, what is this ‘date’ parameter refer to? is it ‘created_at’, ‘updated_at’ or something else? because it shows result outside the specified date

Hi, I have been struggling with this API, it could just be me but I don’t find the docs very useful. I find the use of $ in variables names (within the examples) odd (in python context) and am not sure if they have any significance, I removed them and got different errors so I’m guessing they have. I am attempting to get particular dashboard columns updated. This was the attempt (I cant see anything to mark text as code so apologies if this isn’t formatted as expected. import requests import json apiKey = “value” apiUrl = “https://api.monday.com/v2” headers = {“Authorization” : apiKey} query5 = ‘mutation ($myItemName: String!, columnVals: JSON!) { create_item (board_id:BOARDID, item_name:$myItemName, column_values:$columnVals) { id } }’ vars = { ‘$myItemName’ : ‘Test’, ‘$columnVals’ : json.dumps({ ‘text0’: ‘Title’, ‘text’: ‘Company’, ‘status’: ‘Customer’, ‘status5’: ‘High’, ‘phone’: ‘01234567890’, ‘email’: ‘Test@mail.com’, ‘date’: {‘date’ : ‘2020-08-27’}, ‘text4’: ‘Lots of notes’ })

Anyone else having any issues clearing a file column? I’m using the correct syntax but keep getting a 500 error, bot via my app and the monday playground. If I use an incorrect item_id or board_id I correctly get a 404. The 500 seems to only happen when the request is correct. Example: mutation($board_id: Int!, $item_id: Int!, $column_id: String!, $value: JSON!) { change_column_value(board_id: $board_id, item_id: $item_id, column_id: $column_id, value: $value) { id } } vars: { "board_id":10XXXXXX, "item_id":10XXXXXX, "column_id":"my_file_column", "value":"{\\"clear_all\\": true}" } Any ideas? FYI - I’m trying to clear a file column on a sub item.

Good afternoon/evening. I have a script that executes a “for” loop and posts a series of values to a Link column on one of my boards based on the name of the item and some additional logic. The links are uploading perfectly and everything works as intended… until I close the desktop app, open the board in a different browser, navigate away from the board, or attempt to open the board on another user’s computer. Then it’s like the links were never added - they don’t even show up in the activity log. Has anyone else had this happen?

I signed up for the announcement video but didn’t receive the link! Will there be a post with the results?

Does someone mind explaining the general flow of authenticating user’s when they open my Monday App view on their board? I understand the OAuth2.0 process of retrieving user unique API keys and have that implemented. When the user authorizes my app, I store their key in a database to use later. The problem I am having and can not find any documentation for is how to get the userID when my application loads, so I can get their API key and not send them through the OAuth2 process again.

I have a dashboard in which I am creating new items with a Python script. The group I am creating items in has columns I would like to be populated with data as soon as an item is created. This is an example of how i’d like one of the columns to look after creating the item (This was done manually): "column_values": [ { "id": "status_2", "title": "Who has the ball", "text": "Customer", "value": "{\\"index\\":7,\\"post_id\\":null,\\"changed_at\\":\\"2021-02-17T09:16:52.085Z\\"}", "type": "color", "additional_info": "{\\"label\\":\\"Customer\\",\\"color\\":\\"#fdab3d\\",\\"changed_at\\":\\"2021-02-17T09:16:52.085Z\\"}" }, This is the code, which is obviously not working: query = 'mutation ($myItemName: String!, $columnVals: JSON!) ' \\ '{ create_item (board_id:%s, group_id:"%s", ' \\ 'item_name:$myItemName, column_values:$columnVals) { id } }' % ( board_id, group_id) data = {'query': query, 'variab

We would like to listen to events in our app and send data to our backend wich in response will update the board data through monday api So i saw the integrations feature, but i want a simple - when item created send request to api. This intergration is always the same and should not be changed or defined by the user. is this possible? If i use monday.listen(“events”) through the board view, will it listen to events if the board view is closed? When we mutate data through monday api, will the user see live changes without the need to refresh?

Hi I am having trouble completing the setup of a Custom Connector from Microsoft PowerApps to monday.com. My problem is that I get a Response of (200) "“message”: “No query string was present”. I have tested that I can access the API by running a test through postman and I get a good response and data back. So I know I can connect. I have then setup the Customer Connector as follows: GENERAL TAB Scheme = HTTPS Host = api.monday.com Base URL = /v2 SECURITY TAB Authentication Type = API Key Parameter Label = API Key Parameter Names = Authorization Parameter Location = Header Definition Tab I have supplied a screen shot for this I have setup the expected Response as “account_id”, “id” and "name’ which are all part of the basic query I have defaulted in the body of the request and also in the postman test (which works fine). It looks like something is not quite right with the Custom Connector as monday.com responses consistently says there is no Query but you can see the query being sen

Hi, I have a requirement to call a third party web service (SOAP) as part of the custom action. I can see that URL can be given “Run URL” for Custom Action. Can i call web service using this “Run URL”? Regards, Ranjit Kumar Vemuri

Hi, I’m developing an application and want to restrict editing of specific column for all users, but with the ability to update such a column using my app. there is a way to achieve this? Methods that use seamless authentication (including monday.api and monday.storage ) offer capabilities that are scoped based on the permissions of the logged in user and the scopes you have configured in your app. I could see in the sdk documentation that the seamless authentication respects the permissions of the logged in user, but there is a way to do such an action using the server-side? Thanks in advance.

I’ve created an Excel workbook using VBA to update monday using API v2. Currently, I have my own API token as a constant in the VBA project. I want to be able to have other people use the workbook. Obviously, having my token as a constant is not optimal. The other possibility I see is to have the user paste their token into the sheet. I don’t like that they would either have to paste their token every time they opened the workbook or allow them to save it with the token. My preference would be that the fact that they are logged in on monday would allow them access to the API. Any ideas?

Hi I am having trouble following the quickstart as on this page. After I run npx @mondaydotcomorg/monday-cli scaffold run ./ quickstart-react I get the following error message in my console. Anyone familiar with this issue and how to resolve it? Thank you.

I’m using the items_by_column_values query, and I’m querying text/date column on my board without any issues, but when I try to query the auto number column, the results set is empty. I’ve tried with prefix and without, auto number by group/board, nothing seems to work.

Wondering if there’s anything wrong with my query in trying to pull users from the v2 API or if it’s a Google Apps Script issue. I keep getting “No query string was present” as my response when executing this code.

Dear Monday-Community, I´m neewbie in working with the Monday-APIv2 so far. Therefore I will ask my newbie question as well 😉 I´m working for a company where we are already working with about 5 Monday-Accounts. For my further project I would like to show up each boards per User on our own Website. We have already all that Users SignedUp on our own Website. Next step should be to generate the API-Token for every User, so that each User will have his own API-Token which will refer to his Boards when LoggingIn to our Website. My Question: Where can I generate the API-Tokens for each User? So far I have only find this Option for my Monday-Admin-Account but not for the other Users. Thank you in advance and have a nice day! Max

I built an API with the DOMO developers studio and it worked great, bringing in Monday boards, items, etc into DOMO. On Labor Day, it stopped working with the error that I had an invalid API Token. So, I generated a new one in Monday Admin, but I get the same error. I cannot connect to Monday. I reached out to DOMO and they have the same problem - their API will not connect. How can I fix this? Has anybody seen this problem before?

I am new to monday.com, but have been asked to extract some details so that it can be reported on from within Power BI. I am using Postman to initially workout what I can get returned. This is working for most of our board using the query: query { boards (ids: {{boardId}} ) { id name items { name id updated_at group { title id } columns: column_values { title text } } } } However, I am having issues with a board with subitems. It returns some subitems within column_values (as a comma separated list, causing me more issues as we have commas in the text!) but some of the fields are not returned at all. From the image the [owner], [start date], [end date], [Approved budget], and [Forcast Spend] are not being returned. Thanks in advance for any assistance.

I followed the OAuth Implementation guide & have my local server & ngrok tunnel running. Problem is when I click on the OAuth button, I get “invalid_request” - “Invalid client_id param” error even though I defined the client_id, client_secret & redirect_uri vars with the correct values ( ✔️✔️✔️ to be certain ). What could the issue be? *sorry for reposting…I accidentally deleted my previous post description 🤦🏼‍♀️ Edit: In addition to the problem described above 👆, I can’t perform a query / mutation using GraphQL. Doing so yields a 401 Unauthorized error. So yeah…sorta just stuck here since I can’t read / write to the board & idk how to resolve the issues I’m encountering with OAuth AND GraphQL. Here’s my code: useEffect(() => { monday.setToken(process.env.REACT_APP_API_TOKEN); monday.listen("settings", (res) => { setSettings(res.data); }); monday.listen(

Trying to access the documentation to begin upgrading our PHP application to GraphQL, and the API docs for v2 appear to be down Thanks!

Hello, the following site used to have documentation about the API but it shows empty for me https://monday.com/developers/v2 Perhaps there is some rendering issue? Clicking on “Documentation” does nothing for me.

Hello! I was wondering if there was going to be another apps competition in the near future?

Hi, I am new to Monday apps and have been going through the components on https://style.monday.com/ and trying to familiarize myself with some of them. I attempted to use the LinearProgressBar and had some difficulty getting it to work. I will add my code and what the output looks like below. import logo from './logo.svg'; import './App.css'; //Import monday sdk and UI module import mondaySdk from "monday-sdk-js"; import "monday-ui-react-core/dist/main.css" import "monday-ui-react-core/dist/main.js" //Import UI elements from monday import LinearProgressBar from "monday-ui-react-core/dist/LinearProgressBar.js" import Loader from "monday-ui-react-core/dist/Loader.js" //Import Charts from vis import '../node_modules/react-vis/dist/style.css'; import {XYPlot, LineSeries, VerticalGridLines, HorizontalGridLines, XAxis, YAxis} from 'react-vis'; //Create monday sdk instance const monday = mondaySdk(); /* const color = monday.color; const colors = monday.colors; */ function App() { con

I created a Monday app. Now that my trial is over, I’m being asked to pay $39/month to continue using Monday. Is there such a thing as a developer/test Monday account? The Apple Developer Program, for example, cost only $8.25/month.

Hi, I’m investigating the GitHub - mondaycom/monday-sdk-js: Node.js and JavaScript SDK for developing over the monday.com platform What is the maximum size of data we can store under, one board? Do you have any limitations here? Cheers,