Formatting for creating people, link, and number items (google app script)
I’m really struggling with syntax and formatting in google app script. As a baseline, this works for creating an item on a board:
const BASE_URL = 'https://api.monday.com/v2';
const dealBoardId = '5533299122'; //Deals board in the test workspace
function createMondayDeal() {
let query = 'mutation ($myItemName: String!, $columnVals: JSON!) { create_item (board_id:' + dealBoardId + ', item_name:$myItemName, column_values:$columnVals) { id } }';
let vars = {
"myItemName": "Hello, Best Deal!",
"columnVals": JSON.stringify({
"deal_stage" : {"label" : "New"},
"status9" : {"label" : "1"},
})
};
var response = UrlFetchApp.fetch("https://api.monday.com/v2", {
method: 'post',
headers: {
'Content-Type': 'application/json',
'Authorization': API_KEY,
'API-Version' : '2023-04'
},
payload: JSON.stringify({
'query': query,
'variables': JSON.stringify(vars)
})
})
