API & Apps framework

Hi, I’m looking if someone got this before me. I’d like to duplicate the table view in my custom board view and add some functions to extend the functionality of cells. I’ve checked on monday.com design system but can’t find their tables view that will allow me to reproduce that view. Did someone have some, library that solve that problem or got already some solution to that? Maybe I’ve checked in the wrong place. All code snippets/thoughts are welcome

Hello, I have been working with the Monday API for a while now. So far without any problems. But now I have a problem and do not get further. My Setup: 2 web pages on one website each a JS file calls the same php file 1 PHP file that performs a mutation The structure of the files JS file from page A (snippet) $.ajax({ url: "/mondayapi.php", //the page containing php script type: "post", //request type, data: { 'myBoardId': parseInt(board_id_bewerbungen), 'myItemId': mondayItemId, 'queryVariables': queryVariables, 'category': 'updateMonday' }, success: function (result) { let reslt_ojb = JSON.parse(result) console.log(reslt_ojb) if (reslt_ojb.hasOwnProperty('error_code')) { console.log('error') showToast('Daten konnten nicht aktualisiert werden', 'bg-danger') } else { showToast('Erfolgreich aktualisiert', 'bg-success') } } })

I’ve hit a wall with trying to get action via the support team so I’m trying here. The Date and Times for the Date columns are being returned from the api in the format: yyyy-mm-dd ##:## This is a big problem considering date/times standards have been around for over 20 years: https://www.rfc-editor.org/rfc/rfc3339en.wikipedia.org Monday.com is accepting (only) UTC values, then converting them in a mixture between UI and API (without the ability for the user to intercept it before then) to the loosey-goosey format above that is impossible to tell what it actually is without having to query further context, without the ability to intercept it. This is super strange and becomes a real issue when it is coupled by the next strange idea of Monday.com automatically changing your time zone on your profile to match your physical location. With no opt-out or opt-in ability. I set up integrations (webhook to a JS script) on a service account and then went overseas. I was setting different integ

Hello, monday.com community! As a Platinum partner of monday.com, we are excited to announce the beta launch of our new app,TimesheetsPRO (TSPRO). It helps teams plan and track time spent and derive meaningful insights on capacity and utilisation. Features Calendar View : This view allows users to plan their week in advanced by dragging and dropping the sub-items from the board. The task list can be filetred for each user via setup. Select the desired people and status column from sub-item level to show tasks assigned to individual user and also filter the tasks that are completed. Submit & Publish : Once the entry is created it goes into Submit stage whcih is tentative but still user has ability to ammend the date and time of entry. Publish allows users to solidify their timesheets and writes back the cummulative hrs to the sub-item numbers column (Use Setup) within the board. Reporting : The reporting view of TSPRO allows users to visualise the time spent in detailed manner. The

Is there a way to do a bulk update / mutate of data? Suppose I have a table and I want to mutate a lot of it. Do I need to do it cell-by-cell using a single mutate and change_column_values and a series of API requests? Is there a way to do it all in one request, just like how we can update a postgres table using one request?

I have searched and found pointers but nothing that really solves my issue. here is the workflow: We receive an email and it is automatically tagged in Gmail with a label. We identify a JOB-XXXXXX for the job number. We need to search all items to see if that item exists (it could be in multiple boards as we assign multiple instructors to a job) If the item is found then this email should be posted as an update. If it is not then it should be created as a new request in the pending jobs group of our main board. Challenges: We are able to get the emails and parse the data needed. we even geolocate the address for the address field but we are missing a board when we get boards returned. we are looking for a specific board_folder_id and for some reason one of our boards does not have the id, even though it is in a folder. this approach was used to minimize the boards we query down to just what is really needed. I have been able to get the items per board but so far that is where i stopp

I noticed that status columns are referenced by index, which is assigned based on status color. There was a previous post on this (Working with the Status Column), however it seems that the information is no longer available. How can I query which labels belong to which index in a column of type “status”?

I am submitting the following query to create a new board from a template to the GraphQL v2 api and I receive a timeout (504 Gateway Error), however the board still gets created in the UI. {"query": "mutation { create_board (board_name: \\\\"Shift Archive - February\\\\", workspace_id: ******* board_kind: public, template_id : 3812705305) { id }}"} The template contains no items, 1 group and ~15 cols (some linked). Any explanation or solution would be appreciated. Additionally: Running the same query in playground I get: TypeError: Failed to fetch at https://monday.com/nhp/_next/static/chunks/d310b1ebcb21564b607af0377ef0e1240c79bee0.8694d524636655406180.js:1:13258 at https://monday.com/nhp/_next/static/chunks/pages/_app-0ba1d264bacfd6165f7e.js:1:30601 at o (https://monday.com/nhp/_next/static/chunks/pages/_app-0ba1d264bacfd6165f7e.js:1:28839) at r (https://monday.com/nhp/_next/static/chunks/pages/homepage/developers/try-it-yourself-8490723fe5d5fea24532.js:1:117324)

Hi All, How to add when we clicked button in item so it sends webhook request after make it disable or apply some loading spinner icon on button till it processing webhook request once we get response from webhook then enable it. Could there is possibility to tweak this kind of logic in graphql ?

Hi, For Activity logs API for a subitem board { boards(ids: [{subitem_board_id}]) { activity_logs(limit: 100, page: 1) { id entity event data user_id created_at account_id } } } We are getting the parent details for a subitem for Delete_pulse and not for CREATE and UPDATE pulse { "data": { "boards": [ { "activity_logs": [ { "id": "#####", "entity": "pulse", "event": "update_column_value", "data": "{\\"board_id\\":#####,\\"group_id\\":\\"topics\\",\\"is_top_group\\":true,\\"pulse_id\\":#####,\\"pulse_name\\":\\"ac\\",\\"column_id\\":\\"status\\",\\"column_type\\":\\"color\\",\\"column_title\\":\\"Status\\",\\"value\\":{\\"label\\":{\\"index\\":1,\\"text\\":\\"Done\\",\\"style\\":{\\"color\\":\\"#00c875\\",\\"border\\":\\"#00B461\\",\\"var_name\\":\\"green-shadow\\"},\\"is_done\\":true},\\"post_id\\":null},\\"previous_value\\":null,\\"is_column_with_hide_p

I’m curios is there an option to upload my source code to extensions via Github/Gitlab actions? Looking for information about that.

Is there a way to retrieve the content of Monday Doc which is present in a item. File endpoint need a asset id where as the doc gives a doc_id. I tried the doc endpoint as well. But I think that is to retrieve a Monday doc from different section and not for this purpose. Please let me know if more details are required. Response from Monday Items Query files field. "{\\"files\\":[{\\"name\\":\\"XXXX\\",\\"fileId\\":\\"e8fb253b-a3e2-0102-89de-138592287d70\\",\\"isImage\\":\\"false\\",\\"fileType\\":\\"MONDAY_DOC\\",\\"objectId\\":3951130271,\\"createdAt\\":1673955784179,\\"createdBy\\":\\"XXXX\\",\\"linkToFile\\":\\"https://XXXX.monday.com/docs/3951130271\\"}]}" Tried Doc API with the Query taking the id from the above respose which gave an empty response. query { docs (ids: 3951130271, limit: 1) { id object_id settings created_by { id name } } }

Hello, I am trying to use the new feature and add a block menu to a Doc Action, but I don’t understand how to make it work. I marked the “Add Block Menu” checkbox and connected my app. I opened a doc and clicked on the “+” to add a new block, but the app does not appear on the options. When I’m adding the “Contextual Toolbar” feature it works fine and appears when I am marking a text. What am I missing? do I need to configure something in order to use this feature? Thank you!

Hi! I’m happy to announce VLOOKUP most impactful version yet! VLOOKUP now supports board templates which eliminate the manual work of linking newly created boards. For example - You can now auto-link a rate card board to a project template board so every time a new item is created or updated, it will pull the matching rate from the rate card board. How amazing is that? Here is a short demo. Check it out Auto Link at scale with monday.com board templates

Hello, I have an app with an Item View feature. Is it possible to automatically open up the to my Item View whenever a specific column on a board/item is changed? Another option… is it possible to open a custom modal when a specific column on a board/item is changed? I’m wanting to interact with my custom app when a specific column on a board/item is changed, but I’m not seeing a way to tie it all together. Any ideas? Thanks!

Hi Team, We could able to find most of the column types sample payload from the column type reference documentation provided here - https://api.developer.monday.com/docs/guide-to-changing-column-data Below are the column types for which there is no documentation: autonumber color-picker pulse-log pulse-id pulse-updated columns-battery team duration votes Can you please provide sample payload for this column types. Thank you. Regards, Prashanth

Is there any way we can get integration Details with integrationId or Recipe Id

Hi there. im trying to query a boards view. But i’m not able to manage this task. GraphQL is just new for me so i have to learn a lot. This data is which i want to get in my json is ->boards/1154902600/views/1336234 and only the data in the view 1336234 is interesting so not the whole board. Can anyone show me the right way how to set up my query??? thank you. Regards. D. Jurisic

Hi I’m having an issue while trying to create a webhook using your GraphQL endpoint. I don’t have problems creating the webhook using for example the change_column_value event as you can see, here I can get the webhook id in the response curl --location --request POST 'https://api.monday.com/v2' \\ --header 'Authorization: MY_API_KEY' \\ --header 'Content-Type: application/json' \\ --data-raw '{"query":"mutation { create_webhook (board_id: 3985754441, url: \\"https://<SUBDOMAIN>.pipedream.net\\", event: change_column_value) { id board_id } }"}' {"data":{"create_webhook":{"id":"164820786","board_id":3985754441}},"account_id":11028737} But when I try creating it with change_subitem_column_value event I get no webhook id at all. curl --location --request POST 'https://api.monday.com/v2' \\ --header 'Authorization: MY_API_KEY' \\ --header 'Content-Type: application/json' \\ --data-raw '{"query":"mutation { create_webhook (board_id: 3985754441, url: \\"https://<SUBDOMAIN>.pipe

On monday.com it’s possible to nest, by 1 level currently, folders in folders like this: But I can’t find where in the API I can retrieve this hierarchy information, or even basic information about the folder. The only thing I’ve found so far is: query { boards(workspace_ids: XXX) { name board_folder_id } docs(workspace_ids: XXX) { name doc_folder_id } } Which gives me a folder id but then how can I use that id to get basic folder info like the name or if it has a parent folder?

Hi, after reading the documentation and playing around with the request and response of OAuth2, I can’t seem to get the account’s ID from the oauth2 response. So suppose if a non-admin user installed my app and initiated oauth2, does it mean the access token can be used to Send Notification to all users within that monday.com account ? Could someone clarify more on this ?

Hello, I’m having a problem trying to pass JSON value to columnValues field when creating an item using monday.api() method. Attempt #1: monday.api(` mutation { create_item ( board_id: 0000000, group_id: "topics", item_name: "Hello", columnValues: "${JSON.stringify({people3: {personsAndTeams: [{id: 1111111, kind: 'person'}]}})}" ) { id } } `); Here is the error response I got: { "errors": [ { "message": "Parse error on \\":{\\" (STRING) at [7, 36]", "locations": [ { "line": 7, "column": 36 } ] } ], "account_id": 2222222 } Since the attempt #1 doesn’t work for me, I’ve tried the solution that I found in this community, but it still doesn’t work for me. Attempt #2: const body = { query: ` mutation($boardId: Int!, $groupId: String!, $itemName: String!, $columnValues: JSON!) { create

Hi there, I see that it is possible to have different columns for an item and sub-item as shown in this screenshot But when I query columns in a board, I am only getting columns at the item level. How do I get columns corresponding to the sub-items?

Hi all I’ve been trying to create a query for about 6 hours which I think is pretty straightforward. Given a certain board, find all the elements in which the State column is valued with “YES” and the Number column is greater than 3, but i am not finding solution. Can you give me a case study that I can study and understand? Unfortunately I’m not understanding much from the API documentation. Thank you

Hi, in similarity to this post: Rendering image url on updates of an item - graphql monday Apps & Developers Hey all, I am able to create new item and to push to it an update, in form of a string. While inserting the string, I include to the update an image’s url as well: [image] I wonder if there is a way to make the image to render, instead of showing the url itself? Regards :_) i’m now trying to create the same thing just with video. I’m attempting to push the following into the item updates: 1 \\n\\n<u>Attached video</u>:\\n <video src='${req.body.mediaLink}' controls />; and it works, besides the video itself, there’s no trace of it. The result : as you can see, everything’s included but the video, yet, when I am doing: 1 \\n\\n<u>Attached screenshot</u>:\\n <img src='${req.body.mediaLink}' />; it works and renders the image. any ideas?