为云而生的MongoDB Atlas
复制***** Export the events from the sheet to a MongoDB Database via Stitch****/
function exportEventsToMongoDB()
{var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
var sheet = spreadsheet.getSheetByName("Data");
var headerRows = 1; // Number ofrowsof header info (to skip)
var range = sheet.getDataRange(); // determine the range of populated data
var numRows = range.getNumRows(); // get the number ofrowsin the range
var data = range.getValues(); // get the actual data in an array data[row][column]
Logger.log(JSON.stringify(data));
for (var i=headerRows; i<numRows; i++)
{var date_updated = Utilities.formatDate(new Date(data[i][5]), "GMT", "yyyy-MM-dd");
// Make a POST request with form data.
var formData = {location: data[i][0],
links: data[i][1],
hospital: data[i][2],
available_bed: data[i][3],
number: data[i][4],
date: date_updated,
commentes: data[i][6],
type: data[i][7]};
var options = {method : post,payload : formData};
if (true) {// Call the API from MongoDB Atlas
var insertID = UrlFetchApp.fetch(https://<<MongoDB Stitch API endpoint>>-mejsg/service/GetCOVID19Data/incoming_webhook/webhook0, options);
}
1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.
THE END
