Convert Google Sheet into JSON Web App

[@CodeWithCurt]

Google Apps Script Code in Video Below:
function doGet() {
var content = getSheetData();
var contentObject = {GoogleSheetData: content}
return ContentService.createTextOutput(JSON.stringify(contentObject) ).setMimeType(ContentService.MimeType.JSON);
}
function getSheetData() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var dataSheet = ss.getSheetByName('DATA');
var dataRange = dataSheet.getDataRange();
var dataValues = dataRange.getValues();
return dataValues;
}

[@abdullahquhtani4247]

I hope you can take this script steps further to be able to filter data with multiple criteria then post data to add, edit and delete data. Thank you 🙏

[@machodge2021]

Thank you so much @Code With Curt. Script code provided by you is usefull ! And yes I am saying this after trying lots of codes named under title "export to JSON" on UA-cam.

[@yesiamsumit]

How can I filter data from the entire sheet's data? For each request, I don't want the entire sheet in json form, only specific parts of it.

[@franciscogomes]

Excelent tutorial! That's really works like a charm! Thank you so much!

[@franbermejo]

it is the best explanation for google sheet to JSON, thanks for the code! regards!

[@wmn2011]

Work ?

[@muhammedaadhil5645]

A person who is learning to code like me..we .don't know how to use the JSON and what are its functionalities. I would like to see a demo on how to utilize this JSON function and its output. Thank you.

[@kensleylewis]

nice stuff - but what can we do with json data coming into postman, at that point?

[@tazulislam2698]

Sir , How will I utilize this JSON in html table? please! make video on this topic. Thanks!

[@diegognoatto590]

Cors error accessing from fetch on vscode. did i do something wrong?

[@purushothamangempuraj177]

This helped me! Thanks

[@TechWithGar]

thank you so much : )

[@ashokgtm]

do it also export values like 0.000000000123232 like 18 decimals values.

[@SunilKumar-ob6vs]

Sir how to convert this data into html table pls i need this is in my peoject pls

[@eslamaboalo]

Not Work

[@adam4designss]

where from you get the script

[@CodeWithCurt]

There is a link in the description for the code.

[@bumpersmith]

Sorry but this did not make any since to me.

[@abdullahquhtani4247]

At the end of your video, you said if you have any questions or comment , leave it below the video!!
I asked a question BUT you didn’t answer. 😤

[@Adam-pz4oe]

so whats the point if anyone can go to this google sheet and mess with it lol

[@gabrielcasanova2024]

.

[@androidapp3898]

function doGet (){
var content = getSheetData();
var contentObject = {GoogleSheetData: content}
return ContentService.createTextOutput(JSON. stringify(contentobject) ). sethineType (ContentServich .Minetype .JSON);
}
function getSheetData() {
var ss= SpreadsheetApp.getActiveSpreadsheet();
var dataSheet = ss.getSheetByName ('DATA');
var dataRange = dataSheet.getDataRange():
var dataValues = dataRange.getValues();
return datavalues;
}