I take advantage of Google Spreadsheets as a “net service” to generate a JSON having the knowledge to show in my web site. It’s OK to export a JSON file:
var url = 'spreadsheets.//checklist/1gRIVkL117xxG8m9nQRa--ChSsQOQvPqcAI4-0RTlPCg/' + id_spreadsheet + '/public/full?alt=json';
however I want to do some ORDER/group operations within the backend, and to have the ability to export a JSON simply due to the URL.
I understood there’s a REST-API that enable me to do this however how do I export a filtered view?
A filtered view has
fvid= on the finish of the URL. It’s OK to go this hyperlink to a good friend and to see the view filtered, but it surely doesn’t work after I need to export it by way of JSON. I’ve additionally seen there’s some SQL approach to inject within the URL in an effort to do it (possibly) however I’m on the lookout for the best answer in my context.