hey everybody,
i am trying to pull data from google sheet as json output ,
this is the script that i am using :
function doGet(e){
// Change Spread Sheet url
var ss = SpreadsheetApp.openByUrl(“https://docs.google.com/spreadsheets/d/1MjI5Id1bd7Qgff6QNdM0gKDRWPsPfulu7Ae9hbd1QOM/edit?folder=0AAaqaREJRTQ8Uk9PVA#gid=0”);
// Sheet Name, Chnage Sheet1 to Users in Spread Sheet. Or any other name as you wish
var sheet = ss.getSheetByName(“NewsSheet”);
return getNews(sheet);
}
function getNews(sheet){
var jo = {};
var dataArray = [];
// collecting data from 2nd Row , 1st column to last row and last column
var rows = sheet.getRange(2,1,sheet.getLastRow()-1, sheet.getLastColumn()).getValues();
for(var i = 0, l= rows.length; i<l ; i++){
var dataRow = rows[i];
var record = {};
record[‘News’] = dataRow[0];
// record[‘name’] = dataRow[1];
dataArray.push(record);
}
jo.NewsTicker = dataArray;
var result = JSON.stringify(jo);
return ContentService.createTextOutput(result).setMimeType(ContentService.MimeType.JSON);
}
this is tha data that i am trying to pull :
this is the output that i am getting while configure the data base :
{
“entries”: [
{
“NewsTicker”: [
{
“News”: “Test1”
},
{
“News”: “Test3”
},
{
“News”: “Test4”
},
{
“News”: “Test5”
}
]
}
],
“number”: 1,
“processed”: [
[
[],
[],
[],
[]
]
],
“messages”: [
“Processing 1 results into 1 potential columns”,
“Processing Result with Data Root NewsTicker”,
“DataRoot is an array”,
“Processing 0”,
“Processing 1”,
“Processing 2”,
“Processing 3”,
“Consolidating entries”,
“There are 4 entries in total”
]
}
Plz Help
Best Regarsd