In order to implement a "
browse categories" button, the schedule page had to call the api, get the categories json, and display as needed. But the api call was running into CORS errors, since the schedule page was hosted on a different subdomain.
From observing the network traffic using Chrome/Firefox Inspect > Network tab at
https://ourwebsite.org/listen/
- got Categories.
So, trying various methods from
to circumvent the CORS errors.
Since the schedule page is on github pages,
But that page talks about requests going to an api on github pages, but ours is the opposite situation. So, decided to host the json locally, updating it using a google apps script once a day using a time-based trigger.
const githubtoken = 'github_pat_ABABABABABUxj4xsUKeW0909090909090909098';
const tempfolderid = '1pAABCABCABCABCrD8w';
const uploaderemail = 'OurID@users.noreply.github.com';
const apiurl = 'https://ourwebsite.org/api/public/find?col=audiocategories&qry=%7B%22isDeleted%22%3Afalse%7D&order=%7B%7D&limit=1000';
// a wrapper for an automated github commit call using github REST API
// to save a particular json file to a github repo hosting a
// github pages website.
// pushjsontogithub() is called with a timed trigger every day,
// in case the data is updated.
const tempfolder = DriveApp.getFolderById(tempfolderid);
function pushjsontogithub() {
var jsontextoutput = UrlFetchApp.fetch(apiurl).getContentText();
//delete previous copies of the file if any
var files = tempfolder.getFilesByName("audiocategories.json");
while (files.hasNext()) {
files.next().setTrashed(true);
}
tempfolder.createFile("audiocategories.json", jsontextoutput, "text/plain");
doUpload(jsontextoutput, "program/data/audiocategories.json", githubtoken );
}
function getshavalue(shafilename){
var files = tempfolder.getFilesByName(shafilename);
if (files.hasNext()) {
var file = files.next();
var shavalue = file.getBlob().getDataAsString();
return shavalue;
}
return '';
}
function doUpload(file_git, expfilename, token) {
var shafilename = 'shahash-' + expfilename.substr(3) + '.txt';
var shavalue = getshavalue(shafilename);
//var file = DriveApp.getFileById(expfilename);
//var file_git = file.getBlob().getDataAsString();
var data_git = {
'sha': shavalue,
'message': 'updating ' + expfilename,
'content': Utilities.base64Encode(file_git),
'committer': {
'name': 'uploadJSONtoGithub',
'email': uploaderemail
}
};
var data_string_git = JSON.stringify(data_git);
var options = {
'method': 'PUT',
'payload': data_string_git,
'headers': {
'Content-Type': 'application/json',
'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/76.0.3809.132 YaBrowser/19.9.3.314 Yowser/2.5 Safari/537.36',
'Authorization': 'token ' + token
}
};
var url = 'https://api.github.com/repos/SSSMC-web/schedule.sssmc/contents/' + expfilename;
var response = UrlFetchApp.fetch(url, options);
var p_git = JSON.parse(response.getContentText());
Logger.log("Done.");
var shablob = Utilities.newBlob(p_git.content.sha, 'text/plain', shafilename);
// delete all copies of shafilename if they exist
var files = tempfolder.getFilesByName(shafilename);
while (files.hasNext()) {
files.next().setTrashed(true);
}
// and then create shafilename
tempfolder.createFile(shablob);
}
