Monday to Google Sheets Board Download - Query no longer working

Hello there @jholdstock and welcome to the community!

I hope you like it here 💪

It looks like this part of the script is just reading a response you get.

What is the exact query you are using and what response do you get from it?

Looking forward to hearing from you 🙂

Cheers,
Matias

Hey @Matias.Monday, thanks for the reply!

So below is the full script, with the API etc removed. Let me know if you need anything else. I am not a developer so my knowledge is sadly quite limited here.

function downloadMondayBoard() {
var apiKey = “xxxxx”;
var boardId = “xxxxxxx”;

var url = “https://api.monday.com/v2”;

var options = {
method: “POST”,
headers: {
“Authorization”: apiKey,
“Content-Type”: “application/json”
},
payload: JSON.stringify({
query: "query { boards(ids: " + boardId + “) { name, items { id, name, column_values { title, text } } } }”
})
};

var response = UrlFetchApp.fetch(url, options);
var data = JSON.parse(response.getContentText());

var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();

// Clear existing data
sheet.clearContents();

// Write headers
var headers = [“Item ID”, “Item Name”];
data.data.boards[0].items[0].column_values.forEach(function(column) {
headers.push(column.title);
});
sheet.appendRow(headers);

// Write item data
data.data.boards[0].items.forEach(function(item) {
var rowData = [item.id, item.name];
item.column_values.forEach(function(column) {
rowData.push(column.text);
});
sheet.appendRow(rowData);
});
}

Hello again @jholdstock,

You are using a deprecated query boards -> items

Instead you need to use boards -> items -> items_page as explained here.

I hope that helps 😁

Cheers,
Matias