API & Apps framework

Hey All, New here to the community and have been playing around with your " API Quickstart Tutorial - PHP". I have been able to get pretty far playing around with things I need but I have come up with a stumbling block and all of my searching in the community I can’t seem to find anything so here I am! I went ahead and did a copy and paste of your " Creating a new item using GraphQL variables" section and it worked great in my board but that was for the item name. How can I put a variable into a column_value value? Here’s the code (with token and everything after $responseContent = removed): $apiUrl = ‘https://api.monday.com/v2’; $headers = [‘Content-Type: application/json’, 'Authorization: ’ . $token]; $marketing = “Package A ($150)”; $query = ‘mutation ($myItemName: String!) { create_item (board_id:My Board_ID, item_name:$myItemName, column_values : “{"

Hello, I want to display a full-sized modal box with iframe inside when user clicks a button from my “card view” feature of application. Is it possible from monday js sdk? An example;

Hi All, I have created custom trigger to trigger my backend code when new update is created in source board. So, when user install the integration on his board I will receive the installation event in my subscriber endpoint which is defined in custom trigger endpoints so i will create a new record in my backend DB and store the recipe selected options, webhook id, integration id, subscription id …etc and create webhook using API endpoint on source board. So, when user create new update in source board, my code will be triggered and read the update to handle the event payload. When user remove the integration from his source board I will remove the webhook from board using remove webhook API. Everything working perfectly, but my issue when user install the integration more once same source board, Monday will add another “update was created” webhook on the same board, so I will get the event two times for same created update. If I checked in m

Hey, I’m trying to create a new Recipe: Custom Trigger → Create an item (The one without the field mapping). For the example let’s say I want to create the item with a name and a populated column “description”. The subscription works fine and I got the webhook address. My problem is with the “data” I’m trying to post… (I’m getting 200OK back so it’s not authorization issue). So - for “item name” and “description” column - how should my data in the POST look like? I’ve tried: { “trigger”: { “outputFields”: { “boardId”: 12345, “itemColumnValues”: {“item_name”: “title”, “description”: “desc”} } } } Thanks! 🙂

Hello everyone, everything good? I would like to change the status of some items on a particular board in batch, as needed. However I would like to know how I can identify all the ids of the items inside the board, to perform this action. Can anyone help me?

I’ve been working on an integration with the monday api and a portal we made for our clients so they can create tickets in our monday boards and track the progress on them. We ran into an issue where whenever we create an update to an item with a body containing a base64 encoded image over 50Kb in size the body shows completely empty on monday. Images smaller than this size show up perfectly fine. Is there something I might be doing wrong/missing?

Hello I am trying to extract data from my boards via an API. I managed to extract all the columns I have apart from the timeline. e.g. I am using the below to extract a date. {‘monday_id’: ‘date3’, ‘tol_id’:‘materials_in’, ‘is_date’:True, ‘is_person_id’:False }, I understand that a timeline has a ‘from’ and a ‘to’ but how do I extract the 2 dates and have it saved as a date in my database? {‘monday_id’: ‘timeline’, ‘tol_id’:‘time_start’, ‘is_date’:False, ‘is_person_id’:False }, Thank you

Hi, Last time I get this issue too when I tried to upload a new build: Unable to upload build.zip monday Apps & Developers Hi, I unable to upload my build since last night, I keep getting unknown error, may I know why?

Hello monday.com community, I am building an item view. I would like to display a custom dialog outside of the iframe, I wasn’t able to find a suitable function in the monday js sdk. I did notice that an existing app, pandadoc, is able to have a dialog outside of the iframe as shown in this webinar: New Features June 2021 | monday.com - YouTube

Good afternoon, I’m having a problem with a subitem update, my idea is to update the status column of the subitems, I’m doing a query after creating the subitems. My query to get the ids of the subitems: 'query($itemId: [Int]){ Items (ids: $itemId) { Column_values ​​{ Id Text Value } } }' The answer: ‘{ LinkedPulseIds: [ { linkedPulseId: 1400012779 }, { linkedPulseId: 1400012848 }, { linkedPulseId: 1400012918 }, { linkedPulseId: 1400012997 }, { linkedPulseId: 1400013068 }, { linkedPulseId: 1400013123 }, { linkedPulseId: 1400013255 }, { linkedPulseId: 1400013310 }, { linkedPulseId: 1400013366 }, { linkedPulseId: 1400013404 }, { linkedPulseId: 1400013480 } ] }’ Right after that I try to mutate with the ids: ‘mutation($value: JSON!, $idColumn: String!) {change_column_value( board_id:1249559661 Column_id: $idColumn item_id: $idSubitem value: $value)

I’m trying to upload an image to a monday update using the add_file_to_update mutation. I’ve referenced the following posts: Announcement: Uploading files to monday.com has just become easier :) Upload File using API and python and requests ( add_file_to_column) With the help of those posts, I have the following code: My code import requests import os def add_file_to_update(update_id): api_key = os.environ.get("MONDAY_API_KEY") headers = {"Authorization" : api_key} apiUrl = "https://api.monday.com/v2/file"

I’m wondering how your dropdown menus are implemented. I’m looking for a way to save the state of a dropdown in a board, then hydrate that state back into the dropdown on page load using jquery. With a regular HTML dropdown I would do something similar to in this codepen: Is there a way to populate a dropdown from data stored in a board?

I am using the following query to get all column values for a board: let jobsQuery = { boards (ids: ${cfg.jobBoardId}) { items { id name column_values { id title value } } } }; It’s running in NodeJS. It’s working great, returning all the items. I’d like to narrow the search to only return items that have a particular column set to a particular value. Based on the current dataset returned, it’s the data in ‘name’ that should be used to narrow the search. I tried the following: let jobsQuery = { boards (ids: ${cfg.jobBoardId}) { items (names: ${cfg.jobName}) { id name column_values { id title value } } } }; But that didn’t work, it just returns an empty list. What would I need to update my query to, so as to return the same data structure and columns, but only the subset that match name === cfg.jobName

Hi All, according to this guide we can move a group to another board. I want to know how can I do this with the API ? I checked the API docs but couldn’t find the matching API function. Thanks.

Can we use automations to generate workspace template folders? ie A) We’ve made a pretty great chunk of boards/dashboards that live in a folder B) We can get users to generate these manually using Add Template OR C) We get users to enter an automation to create these on the fly as items get moved, people get assigned, etc. Data from the item goes into the folder name and various fields within the boards. eg A) Could be used for sales pipelines; sales person moves item to won > folder is create in a different workspace automatically called X project (name of item) > value of deal gets moved to project value and spread to finance boards and dashboards > project brief gets added as first group before predetermined structure > etc etc. Any ideas?

Hello, I’m trying to figure out how to properly query board data. Specifically column values. Is there another way to specify what columns you want to limit your query to? All I see currently is IDs…and those seem be very interesting in the return. I’m getting weird responses back (i.e. Text7, number45, timeline_1, timeline, dup__of_resource_name, etc.). These aren’t the same in each board I’m querying, even though the titles of the columns are very consistent. So while my boards “look” the same, I can’t filter/query them consistently to get the data I need to the above. If I could query by title (which seems that those could be made consistent) it would really help… Any ideas on how to modify this? Is there a way to do this? Am I missing something?

I want to be able to query data directly from my database so that once a form is entered on my website its posted to my database and the latest lead information is then dumped to our CRM board in Monday.com. I cant seem to find a solution to help with this anywhere. I’ve read through the Python API tutorial but everything seems more geared towards pulling data from Monday as opposed to pushing data to Monday. Any help with this would be great.

Hi - I’m new to Monday and am trying to use SyncHub.IO to query my data using PowerBI. It works great to have the Monday.com data in a relational format. My issue is around the text column in ColumnValue table. I’m trying to use the text column to identify the status of items. I get a highly usable set of values most of the time. However it appears a null value in text has multiple meanings - an item that has not been started yet and an item that was deleted. Do I have that correct? I need to know what has not been started vs. what is has been deleted. I looked at the IsDeleted field that that doesn’t seem to help. Thanks

Hello, first time here! I’m starting to figure out how to update and get information from Monday boards on a Excel sheet using VBA. Checking out the API documentation, my first attempt was to retrieve the name of a specific board, but the name won’t appear on the response text from the html. This is what I have so far: Public Pass As Variant Sub monday() Dim monday As New MSXML2.ServerXMLHTTP60 Dim response As Variant Dim status As Variant Dim query As String query = " { ""query"" : ""{boards(ids: xxxxx){views{name}}}""} " With monday .Open "POST", myurl , False .SetRequestHeader "Content-Type", "application/json" .SetRequestHeader "Accept", "application/json" .SetRequestHeader "Authorization", mytoken .Send query response = .ResponseText status = .status & " | " & .StatusText MsgBox response MsgBox status End With End Sub

Hi, The API documentation illustrates how to duplicate a board with structure only by setting duplicate_type: duplicate_board_with_structure. I need to duplicate the board along with its items and I can’t find in the documentation what value I’d use for duplicate_type: Does anyone know? Thanks!

Hello! I’ve been trying to work with API v2 and VBA. So far I’ve been able do connect to the server and query board fields and values. I’m now trying to creating items and changing column values using mutation, but haven’t had success yet. Hope someone could show me the way. My general code is: Public Pass As Variant Sub monday() Dim monday As New MSXML2.ServerXMLHTTP60 Dim response As Variant Dim status As Variant Dim query As String query = query With monday .Open "POST", myurl , False .SetRequestHeader "Content-Type", "application/json" .SetRequestHeader "Accept", "application/json" .SetRequestHeader "Authorization", mytoken .Send query response = .ResponseText status = .status & " | " & .StatusText End With MsgBox response MsgBox status End Sub When trying to change the columns values, I’ve tried querying the mutation in two different ways,

Hi community, I’m attempting to write a simple app to display information in an Item View. I started with the app described in the Quickstart guide and have compiled and run this little ‘hello world’ without problem. I’m now trying to access the ItemId of the Item that the Item View is connected to. I can access the “context” with something like this monday.listen("context", res => { // do something with res.data } but this just seems to store global app properties, not the ItemId that this is an Item View of. I haven’t been able to find much documentation about developing Item Views, I think they’re pretty new so a lot of the official documentation doesn’t mention them at all (like the Quickstart guide). They are listed

In my company we are MuleSoft partners. They provide an integration platform that has nearly 300 connectors available for integrating and interconnecting applications and more. These connectors are exposed through the marketplace that is Anypoint Exchange. At this time we want to create the Moday.com MuleSoft Connector to be available for free on Anypoint Exchange and offer this capability to the developer community and all MuleSoft customers globally. This development has no cost for you or economic benefit for us beyond the marketing that we can obtain. We will need to use their API and the monday.com logo. After finishing the development, the connector will be evaluated by MuleSoft, published in the marketplace and we will be doing some webinars to explain the advantages of using the connector and its ease. To advance to a second step we need to receive the go-ah

I have activated “Developer Mode” in my account. I found phone number column name is 1_phone95 Using webhook, I receive pulseId which is row id(i guess). webhook doesn’t send all column values. So i try to read 1_phone95 column values by the following code snippet $query = ‘query { pulse (ids: 1339686138) { column_values { id type } } }’; But i get the following error: {“errors”:[{“message”:“Field ‘pulse’ doesn’t exist on type ‘Query’”,“locations”:[{“line”:1,“column”:9}],“fields”:[“query”,“pulse”]}],“account_id”:8374454} Now my question is, how do i read all columns or a single column(1_phone95) value? Is it by pulseId or is there are any further technique? I am highly interested to study query in detail. May i have study/documentation

Hi I am trying to download images from a board using a fetch api (axios in this instance) I have a bearer token and have got the url where monday is storing the images e.g. https://.monday.com/protected_static/64xxx81/resources/208xxx328/5XrhMb3TtAgiyFZUKARvsRx0vwhbpp9GGcW9J5nHN6W5QyQDKfWEOvK6IuuLXskzFjYc9Fa4Wn5adyTSAETv1tWDkRJl6JraXqaF.jpg - but I am still unauthorized. What am I doing wrong? Many thanks Gary