API & Apps framework

Hi all I’m seeking assistance with updating a PowerBI query that integrates with the Monday.com API. , I need to update it to ensure it works with the latest API standards without changing the structure of the output, as all my PowerBI reports depend on it. Here is the query that worked previously: Content=Text.ToDate(“{”“query”“: “”{ boards (ids: 3796729499) { items { id name column_values { title text } parent_item {id} } } }”“}”) Source = Web.Contents(“https://api.monday.com/” & “v2”, [ Headers=[ #“Method”=“POST”, #“Content-Type”=“application/json”, #“Authorization”=“” ], Content=Text.ToBinary(“{”“query”“: “”{ boards (ids: “”) { items { id name column_values { title text } } } }”“}”) ] ), #“JSON” = Json.Document(Source,65001), data = JSON[data], boards = data[boards], boards1 = boards{0}, items = boards1[items], and Content=Text.ToDate(“{”“query”“: “”{ boards (ids: 3796729499) { items { id name column_values { title text } parent_item {id} } } }”“}”) Thank you so much

My locale is en-GB My browser timezone is Europe/London My MDC user timezone is set to (GMT+00:00) Edinburgh. When I save a date in a date column, we get the following happening… It is displayed as a Europe/London date “23 Jul, 12:00” It is accessible from graphQL as a value of { "date": "2024-07-23", "time": "11:00:00", ... } and text as 2024-07-23 12:00 When I change my MDC user timezone to (GMT-09:00) Alaska things start getting weird: It continues to be displayed as a Europe/London date “23 Jul, 12:00” though I’d expect “23 Jul, 03:00” It is now accessible from graphQL as a value of { "date": "2024-07-23", "time": "11:00:00", ... } but with a different text as 2024-07-23 03:00 Is this a bug or expected behaviour? Should the displayed date be based on the browser timezone, or the MDC user timezone? Also, when programmatically saving dates to date columns, should developers save the date in UTC+0 timezone and let MDC do the rest? Cc: @Matias.Monday

My Monday.com app is successfully authenticating users as described in the documentation. The resulting JWT token is passed to a .NET API application in the Authorization HTTP header. I’m having some trouble to decrypt the JWT token. When I look at the Monday.com app definition on the tab called ‘Basic Information’, there’s a ‘Signing Secret’ value. Is that signing secret used to sign the JWT token or not? Since the JWT token is not containing ‘iss’ (issuer) and ‘aud’ (audience) claims, I need to write some custom C# code to decrypt the JWT token in the .NET API.

Hi, I am building monday.com app using next js i ma getting below error .next/server/vendor-chunks/lib/worker.js when i import apps-sdk in server side. Can you please help me how do i reolve it

Anyone get this working in any way shape or form with Azure, Azure Data Factory, Azure SQL? I need to get data from azure to Monday in bulk or 1:1 I don’t care just automated. I could get the API to work in postman but never got azure to authenticate with my key.

I am not getting any view returned in api response other than form. As per documentation, kanban board, gantt view, timeline view etc are supported. Can you give me list of supported views?

Surfacing this here bc it was buried in another thread… Hi, I’m proceeding with OAuth testing. Not sure what the problem is but I get a response from the token service with the error {“error”:“invalid_request”,“error_description”:“Missing client_id param”} (log) ControllerMonday: sending request to get token with - {"client_id":"NNNNN","client_secret":"NNNNN","redirect_uri":"MY_REDIRECT_URI","code":"NNNN"} (log) ControllerMonday: token response, getting access token (log) ControllerMonday: token response, body is - {"error":"invalid_request","error_description":"Missing client_id param"} I’m receiving the redirect callback with the access code just fine. But, then I set all the values including “client_id” and calling https://auth.monday.com/oauth2/token and I get the response that “client_id” is missing… I had a similar error when I first started testing OAuth for Monday apps and it was because my app settings had changed and I had to redeploy the app so that my OAuth settings

I’m attempting to write an items_page query that will return names of location codes only where all instances of a location code are in billing status. In a simplified example, the desired result of my query would return CD34 and EF56 Location Name Location code Location Section Status AB12 AL1 AB12 1 in progress AB12 AL2 AB12 2 billing CD34 TN1 CD34 1 billing CD34 TN2 CD34 2 billing EF56 TN1 EF56 1 in progress EF56 TN2 EF56 2 in progress GH78 GA1 GH78 1 billing GH78 GA2 GH78 2 billing query GetAllInBillingLC { boards(ids: 1234567890) { items_page( query_params: {rules: [{column_id: "locationcode", compare_value: [Is left blank], operator: any_of}, {column_id: "status", compare_value: [2]}] } ) { cursor items { name } } } } This is an example of my best guess as to how to structure the query. It doesn’t have my real information since that’s

I’ve seen a number of posts asking the same thing, but want to know what is the definitive way of querying/updating columns across multiple boards that have the same COLUMN NAME, but because of changing circumstances during setup have different Column IDs? e.g. Column ‘My Column Name’ in board 1 had ColumnID ‘text_1’, but in board2 has ColumnID ‘text2’. We cannot rename ColumnID after creation. I cannot seem to pull ColumnName using the API. e.g. function fetchMondayData(boardId, limit) { const query = `{ boards(ids: ${boardId}) { items_page(limit: ${limit}) { items { id column_values { title text } } } } }`; the API always returns an error that ‘title’ doesn’t exist. I’m obviously not alone in wanting to create a function that queries and updates columns in multiple boards. So what is the solution if we can’t rely on ColumnID? I look forward to anyone’s help. Many thanks.

Hi there 👋, After 2 years of operation and thousands of users, we decided to stop pushing our monday.com Item tracking App in the Marketplace. It is too far away from our core business, and we don’t have the ressources to make the improvements it deserves in the future (and believe me, the potential is high). @dipro suggested that some of you could be interested to take it over. Do not hesitate to contact me if it is the case, I will be very happy to discuss it with you. Cheers!

I am running some API requests and keep getting this response (error message): "“GraphQL API is turned off temporarily” I started noticing this at around 11:40 BST and it is persisting both in API calls and the API Playground now, 10 mins later. Do we know what is going on and do others have the same issue?

Hi, new Monday dev here. My app is a Custom URL (IFRAME hosted) app. Just want to confirm that the only way to do authentication for this type of app is OAuth? (i.e. Seamless auth is obviously not an option in my use case, correct?) Along these same lines, just want to clarify the basic process I need to implement: Setup my WebHook for lifecycle events Configure my OAuth / Redirect URI settings Configure my scopes I need to request User installs/trial my app I will get a WebHook notification at this point, possibly with some basic user info User launches my app OAuth flow starts, user authorizes the scopes I request Once approved I get the user’s API token (store in my backend) The WebHook lifecycle events are the only integration requests I’ll get from Monday as my users manage my app’s install/delete/cancel/renew/subscribe/etc And, with the Monday SDK I’ll do auth/login/init using the user’s OAuth token. At that point, all requests I make via the initialized SDK will be for tha

Can I integrate the code that I build into the entire UI instead of just embedding it within the boards

Hi Gurus, I don’t know what has been updated from monday, but from today morning, my integration using monday API started hitting error saying that “HTTP header is larger than 8192 bytes”. It seems like it cannot handle the header more than 8KB. Anyone knows how to suppress or make monday API not returning header data? I tried in postman, and noticed that the custom parameter “content-security-policy” is quite large. Is there anyway to make API not returning this parameter? Thanks and Regards, Leo Li

We are planning out an app and are trying to do the following. I’m not certain whether it’s feasible or which method would be recommended. Here’s the flow: Monday admin authorizes/connects to MyApp Monday admin selects which “Boards” they want to use within MyApp. MyApp gets list of users from Monday and creates them in MyApp so each of those users have a separate Monday account Monday users view data fetched from MyApp’s API in a Monday widget (we’re trying decide based on which is possible): ** Widget embedded that gives user a link to login to MyApp and view info ** Widget that is an iframed view of MyApp info for that user ** Widget that is hosted through Monday code that would be similar to what we’d display in the iframe I’m very familiar with OAuth and have tested a good deal with the Monday’s GraphQL API and feel comfortable there, but the main thing I’m stuck on is how we can/should display info from our app to the Monday user, and how we can most seamlessly give access to t

Hi, new Monday app dev here. My app is hosted via Custom URL and I’m curious how I can find out what the current UX theme is for the user? My app supports themes but I need to somehow query the API (user preferences maybe? still learning/reading the docs) or possibly tap into some JS events from the parent frame/host? Thanks

Hi, I’m currently trying to make a feature react to a viewer in a specific way. The docs say: We pass an isViewOnly parameter in the sessionToken that you can decode to check if the user is view-only The issue is, I never receive the token from the viewer account. Something breaks even before that during this request As if certain permissions are missing. And instead I get this screen Am I missing something obvious here? P.S. this is a widget Thanks

I want to fetch the contents of the docs in the monday doc column using the api. Is it possible? Currently only able to fetch the workdocs in a workspace.

So i have created my first features as board view, did the build there and its working find…when i am trying to create second feature of integration it’s give me error "“failed to create new app feature”

Hi, I am using TextField from monday-ui-react-core in my next js app but i am getting error while building the app. Error is ReferenceError: document is not defined Pls help me in resolving above error I am using below versions Next js -14.1.4 Node - 20.14

Hi 👋 I would like to ask a question about Vibe components in Vite project with React and Typescript. When I try to render any component from monday-ui-react-core package, I receive this kind of error in IDE: 'Button' cannot be used as a JSX component. Its type '((VibeComponent<ButtonProps & RefAttributes<unknown>, unknown> & Partial<{ sizes: { readonly SMALL: "small"; readonly MEDIUM: "medium"; readonly LARGE: "large"; readonly XXS: "xxs"; readonly XS: "xs"; }; colors: typeof ButtonColor; kinds: typeof ButtonType; types: typeof ButtonInputType; inputTags: typeof ButtonInpu...' is not a valid JSX element type. Type 'VibeComponent<ButtonProps & RefAttributes<unknown>, unknown> & Partial<{ sizes: { readonly SMALL: "small"; readonly MEDIUM: "medium"; readonly LARGE: "large"; readonly XXS: "xxs"; readonly XS: "xs"; }; colors: typeof ButtonColor; kinds: typeof ButtonType; types: typeof ButtonInputType; inputTags: typeof ButtonInputT

Hi there. I want to build an app for monday.com, and would like to read the contents of Workdocs. I know I can get all docs via: query { docs { id name } } Then, get the blocks for a specific doc via: { docs(ids: "1528931161") { blocks { type content id } } } That works for “regular” Workdocs. It doesn’t work for Workdocs that are stored inside a board’s monday Doc column: There is some documentation about reading the mondy Doc column, but I’m struggling to understand how to read the docs’s blocks? Also, I’m wondering why does the api not return the workdocs that are stored inside boards, when I query for ALL workdocs. (the first query posted)

Hey fellas, how is it going? I’m trying to build a simple custom workflow block to use in a sentence to send an email when a button is clicked. I was able to setup a custom workflow block that I’m using in my recipe, and when I associate it with my button it gets triggered as expected. However, I’m not getting the expected data in my server-side app. I tried adding a number of combination of input fields but none seems to give me the email column value or the row id. How can I get the email address stored in a column that is selected by the user? Any help is appreciated.

Hey everyone! I have some data in Hivebrite that I would love to pull into Monday.com for some general reporting. Looks as if Zapier does not do this and I am wondering if anyone else has done this and how they were able to accomplish it. This would be my first time needing to pull from Hivebrite system.

Hello, I would like to ask you for advice as I’m trying to figure out the optimal app infrastructure. General requirements: The app is a fully client-side React TypeScript app (bootstrapped using Vite). The app has a few different features/entry points, e.g., board, item menu, multi-item menu. Different features have different views; however, they share similar functionalities, so logic and code are shared. I need full CI/CD support with dev/staging/prod environments. To my understanding, monday-code supports only server-side applications, so I have two options: Host the client-only app on some server and use URL builds for features. Each feature can be under its distinct URL path, e.g., <base-url>/board-feature, <base-url>/item-menu-feature. Implement my app as a full-stack app with a Node.js backend that only serves the client app, and then use monday-code to host the app. In that case, I can also use distinct URL paths for different features. In both cases, I need to