Build the API in Google Script Editor

[@guidowalterpettinari8454]

Thank you for the tutorial! Very handy indeed :-)
For those interested in experimenting, here's the transcript of the Google Script:
function doGet(e) {
var spreadsheetId = 'INSERT HERE THE SPREADSHEET ID';
var sheetName = 'INSERT HERE THE SHEET NAME';
var sheet = SpreadsheetApp
.openById(spreadsheetId)
.getSheetByName(sheetName);
var results = sheet.getSheetValues(1, 1, sheet.getLastRow(), 1)
.reduce(function(a, b) {return a.concat(b);});
return ContentService.createTextOutput(
e.parameters.callback + '(' + JSON.stringify(results) + ')'
).setMimeType(ContentService.MimeType.JAVASCRIPT);
}
Hope it helps.
Cheers,
Guido

[@paulajonye9787]

Thanks man you really saved me a ton.

[@elabinnovations]

How to make API for uploading files to Google drive with base64 method?

[@oscarmejia8306]

How can I actually use this api for a project? I'm trying to do a get request from postman and can't get anything back. I've tried both /exec and executed link, and all types of OAuth set ups. Please help!

[@oscarmejia8306]

I fixed it by deploying the app lol. If you managed to read this though. I'd like to ask if there any security concerns regarding this? Since there is no oauth

[@JordanRhea]

You can totally create your own security for the API. I think OAuth might be difficult to implement, however, if you can get it to work I would love to see it!