API & Apps framework

Hi all, I managed to get my first Automation working, including OAuth authorization. To keep track of tokens I need a database (probably MongoDB). My question is where will the service and the database run? Will monday.com host these in the future of do we need to have a VPS somewhere in the cloud to run Node.js and MongoDB?

I was following all the steps in the “Build Custom Triggers” tutorial: https://monday.com/developers/apps/custom-trigger. I followed all the steps in that tutorial, but in the “Call an action” part, it says to do a POST request to the subscriptionURL that is returned from the subscription for example in my case it would be: https://api-gw.monday.com/automations/apps-events/[a_number] However, I am getting a 401 unauthorized on that endpoint. The tutorial does not say to add an authorization header. If I add an authorization token to the header, the same error shows. How does that subscription endpoint should be called?

Hi, I did the quick start project which worked very well (thanks for the good tutorial). But I’m revisiting my work the next day and did npm run start which is putting my project on an IP address instead of Ngrok. Any tips to quickly generate a new ngrok link like the project does when you create it with npx @mondaydotcomorg/monday-cli scaffold run ./ quickstart-react?

Well, its known to everybody that Monday.com doesnt allow formulas in their recipes. Logical operations with formulas to change status and other options Pain point: Logical operations cannot be used to automatize some operations. Other things to consider: If cannot change any status, i cannot notify people, etc. so the formula itself is too limited like it is. Basic Example: Im storing in one board the last service kilometers of our vehicle fleet. Vehicle users are allowed to update the actual kilometers (number column) of each vehicle. With a formula column i was able to show a text message when we are 1000km closer to the next service. And thats all. I cannot do anymore. For more information on this request:

Hi, We are currently develop a Calendar App (very much like the default calendar, with some extra features) and I’m facing serious performance issue because I’m getting ALL the data without any filtering. I would like to filter the data based on specific date range (only display the data of current month / week) but it seems not possible based on this ticket Query Column Value by Range - #2 by Scott-monday.com Is there any other advise / work around for this issue? This is my query: query ($boardIds: [Int]) { boards (ids:$boardIds) { name items { id name group { color } column_values { id title text value } } groups { id } } } Br, YarHuoy

I am calling the monday api from an AWS lambda function using the node axios client. I am getting 500 responses from monday servers when uploading PDF files to an item. Request Info: 2020-12-30T06:34:39.597Z 8dab0df3-9f83-4ed2-8a0c-d4353f9f2bbc INFO { AcceptRanges: 'bytes', LastModified: 2020-12-30T06:34:36.000Z, ContentLength: 409600, ETag: '"16a3e0cfa739c02f46713efb57edab2d"', ContentType: 'application/pdf', Metadata: {}, Body: <Buffer 25 50 44 46 2d 31 2e 35 0a 25 d0 d4 c5 d8 0a 34 20 30 20 6f 62 6a 0a 3c 3c 0a 2f 54 79 70 65 20 2f 58 4f 62 6a 65 63 74 0a 2f 53 75 62 74 79 70 65 20 ... > } 2020-12-30T06:34:39.978Z 8dab0df3-9f83-4ed2-8a0c-d4353f9f2bbc INFO { url: 'https://api.monday.com/v2/file', method: 'post', data: FormData { _overheadLength: 287, _valueLength: 409719, _valuesToMeasure: [], writable: false, readable: true, dataSize: 0, maxD

Hello awesome Monday Community + Team, Currently facing an issue where I cannot update my Base URL, Authorization URL, or Redirect URLs. I get an infinite loading when trying to save the feature after a change, and, if it stops the infinite loading, it just makes the URL the original URL before I saved it. Is anyone else seeing issues with this? You’ll see above that I changed the

Hi Team, Happy Friday! I’m experiencing quite a strange issue while making a request for an item by ID whereby I receive a timeout error. Complexity seems to relatively small so I’m a little confused, but maybe I’m calculating complexity wrong? Furthermore, this request works 19/20 times but fails semi-regularly. Any help would be much appreciated 😄 Query: Response: Please do let me know if you need any further information, I shall look forward to hearing from

Which programming language/s will be most useful for developing apps on monday.com?

Hello All, I had a heck of a time getting started on this so hopefully this is helpful to someone… A couple notes: I put double brackets {{}} around everything you’d want to change/update for your specific use This probably won’t work as-is because its a bastardized version of my real script so its certainly not plug-and-play. I know my formatting is weird. the PHP below should be put on your server at the URI you specify in the Webhook on Monday when setting it up. <?php //return monday challenge echo file_get_contents('php://input'); // capture second response which should be JSON payload $php_event = json_decode(file_get_contents('php://input'), true)['event']; // init ini_set("log_errors", 1); ini_set('error_reporting', E_ALL); ini_set("error_log", "monday.log"); // this is an empty file you should create to monitor/debug your webhook // a function to dump large ar

I joined Monday.com few months back and I’m still struggling to build and setting up workflow that improves process. It looks easy enough to get started but once you put focus, you get lost easily and reach same place again and in the end, lose motivation. For example, word cloud and other sample recipe tells you about how to run a code. But being focused on functionality and how and why, it’s very difficult for me to build something. I have questions such as, → Suppose I am building, twillo integration then, I might want to provide API key or environment variable. Sometimes, every Monday user need to enter their credential or sometime just admin needs to setup while installing app (for example, for twillo api). how would I achieve that? → What really can be great is example app in multiple languages and what’s the learning curve and what does Monday recommend in which cases etc etc or partnering with some

Hey added the columns field to my board view settings but it’s not working - just displays the word columns and not clickable. Other settings field types work, including column.

Greetings everyone! I’m very new to Monday.com and GraphQL api system. My only requirement is to pull “All board names” available on my monday.com using c#, so I can eventually show them in a dropdown of my web application. I found this c# code on the forum but it is not working. I’ve generated the authentication token already, I just don’t know how to write query to pull public class MondayHelper { private const string MondayApiKey = "YourKey"; private const string MondayApiUrl = "https://api.monday.com/v2/"; /// <summary> /// Get a JSON response from the Monday.com V2 API. /// </summary> /// <param name="query">GraphQL Query to apply to the Monday.com production instance for Grange.</param> /// <returns>JSON response of query results

Hi guys, I’m kinda new to accessing APIs in general and I’m not really a coder. Nevertheless, I feel I must be close with this. Can anyone tell me how to fix my Power Query? It must be something super simple… API key redacted, of course. The Power Query editor errors saying “Token Comma Expected” and highlighting the colon after “boards (ids” in the following query: let Source = Web.Contents(“https://api.monday.com/v2/”, [Headers=[Authorization=“Bearer myapikey”, #“Method”=“GET”, #“Content-Type”=“application/json”]] { boards (ids:[000000000, 000000000]) { items { name id column_values{ text } } } } ), in Source

Hi I’m trying to send a mutation to create a new item on the board and populate all columns. Everything seems to work except for the “person” column. No errors in the response. request mutation { create_item (board_id: 505100819, group_id: "topics", item_name: "test_name", column_values:"{\\"person\\":{\\"id\\":12307363},\\"status\\":{\\"label\\":\\"Done\\"},\\"date4\\":{\\"date\\":\\"2019-06-03\\"}}") { id } } response { "data": { "create_item": { "id": "505328688" } }, "account_id": 5530601 } I’m kind of lost why is this not working

doing lots of other queries, but i’m having trouble formatting a change_multiple_column_values query. posting this json: {“query”:“mutation { change_multiple_column_values ( board_id: 655318672, item_id: 662694544, column_values: \\”{\\“date4\\”: {\\“date\\”: \\“2020-08-04\\”},\\“next_arr__days_7\\”: \\“9\\”,\\“property_id\\”: \\“1289\\”,\\“person\\”: {\\“id\\”: null},\\“numbers2\\”: \\“1.50\\”,\\“departing_rez\\”: \\“5146\\”,\\“status\\”: {\\“index\\”: 1}}\\“) { id } }”} returns: [errors] => Array ( [0] => stdClass Object ( [message] => Parse error on “: {” (STRING) at [9, 28] [locations] => Array ( [0] => stdClass Object ( [line] => 9 [column] => 28 ) ) ) ) putting the mutation text above on try it yourself doesn’t work UNLESS i remove the \\ from the \\" at the beginning and end of

we failed to insert record to Monday.com via api v2. got eror as: {“error_message”:“Internal server error”,“status_code”:500} for test push record below { “query”: “mutation{create_item( board_id: 154534478, group_id: "video_articles", item_name: "Test - Trump to Offer Optimistic Vision in State of the Union Address", column_values: {status:{index:15},status7:{index:19},status3:{index:15},person7:{id:10603717},article4:{index:13},eet_link:{url:"https://ntd.com/trump-to-offer-optimistic-vision-in-state-of-the-union-address_284634.html\\",text:\\"https://ntd.com/trump-to-offer-optimistic-vision-in-state-of-the-union-address_284634.html\\”}}) {\\n\\t\\tid\\n\\t\\tcolu

I am looking to create Power BI reports on the content of my Monday.com boards. I’ve developed a query that looks like this (among many other attempts): let Source= (Csv.Document (Web.Contents(“monday.com: Where Teams Get Work Done”, [ApiKeyName=“key”]))) in Source It returns the code from the website… but I can’t see any tablular data to pull. Can anyone help on what I might need to do?

Hi, I’m trying to create a pulse via Node.JS with axios. I started with the example that is on this forum and edited it for my needs but I can’t get my code to add the column values for the pulse. What am I doing wrong? // Packages const axios = require("axios"), fs = require("fs"); // Files const config = require("../config.json") // Code const body = { title: "Test bug", culprit: "util/testers/monday.js" } const current = new Date() let month = current.getMonth() + 1 if (month < 10) { month = `0${current.getMonth() + 1}` } const axiosBody = { query: ` mutation ($boardId: Int!, $groupId: String!, $itemName: String!, $columnValues: JSON) { create_item ( board_id: $boardId, group_id: $groupId, item_name: $itemName, column_values: $columnValues ) { id

Hi I’ve been looking over the GraphQL API for a while now and have been trying to find a way to update the status of an item. Can anyone point me in the right direction on how to update column values please? Thanks Scott

@rob Does General caster works with date given with a formula? My objectif is to put a deadline on a date calculated depending on the numbers of person working and the number of hours. I already have a column with the calculated date. I want to use general caster to import the value on a date column. When i try it gives me “ivalid date” Thank you very much! Best,

I have been testing the requests I have been sending both through Monday.com API tester and my own script and I run into the same issues, a 500 internal server error. I have been able to eliminate it as parse error. If it is a column validation error I am unsure where it is if it is there. mutation {change_multiple_column_values (board_id: *******, item_id: ******, column_values: {“ColumnID_1”: “Example Text”, “12345”, “Text_name1”: “No”, “text4”: " ", “status1”: {“label”: “Operating”}}) { id } } I am sending it as written below in a python script. Elsewhere in this script I have queried items so I know the API is working Mut2 = ' mutation ( $id: Int!, $columnVals: JSON!) {change_multiple_column_values (board_id: ********, item_id: $id, column_values: $columnVals) { id } }' vars = {'id' : ID, 'columnVals' : json.dumps(JSONdict)} dataUP = {'query' : Mut2,

Hi, I am trying to create a new item and set the columns values from the beginning to avoid changing the values in a separate API call. mutation { create_item( item_name: "Name", board_id: ID, group_id: "GROUP", column_values: "{\\"date\\": \\"2019-01-20\\" }" ) { id } } This gives me this error: "error_code": "ColumnValueException", "status_code": 400, "error_message": "change_column_value invalid value", "error_data": { "column_value": "2019-01-20", "column_type": "DateColumn" Any suggestions?

Hello, I’m looking for something in the documentation that would show me how to update the “name” of the item in a board. I don’t see this in the documentation. Could someone help or point me in the right direction?

Hello, So I got everything set up in regards to Monday.com webhooks triggering and sending data to my app. The only issue I am having right now is - when a new item is created via the"New Item" button on a board, it is triggering the webhook w/ the default name it is given, which is “New Item”, instead of it being triggered once the item has been named after creation. Since there is no trigger for item name changes, we are unable to correct this without polling data straight from the