Advertisement
Guest User

Untitled

a guest
Dec 9th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. function doGet() {
  2.  
  3. //get the data from the spreadsheet into a multidimensional array
  4. var data = SpreadsheetApp.getActiveSheet().getDataRange().getValues();
  5.  
  6. //take the first row of header information and save it into its own array
  7. var header = data.shift();
  8.  
  9. //create an empty array to store our objects after we build them
  10. var apiData = [];
  11.  
  12. data.forEach(function(row) {
  13. //create an empty object
  14. var eachObj = {};
  15.  
  16. for(var i = 0; i < header.length; i++) {
  17. //match the keys and values
  18. eachObj[header[i]] = row[i];
  19. }
  20. //add this object to the array
  21. apiData.push(eachObj);
  22.  
  23. });
  24.  
  25. //return the array of objects as JSON
  26. return ContentService.createTextOutput(JSON.stringify(apiData)).setMimeType(ContentService.MimeType.JSON);
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement