I use Google Spreadsheets as a "web service" to generate a JSON having the information to display in my website. It is OK to export a JSON file:
var url = 'spreadsheets.//list/1gRIVkL117xxG8m9nQRa--ChSsQOQvPqcAI4-0RTlPCg/' + id_spreadsheet + '/public/full?alt=json';
but I would like to do some ORDER/group operations in the backend, and to be able to export a JSON just thanks to the URL.
I understood there is a REST-API that allow me to do that but how do I export a filtered view?
A filtered view has
fvid= at the end of the URL. It is OK to pass this link to a friend and to see the view filtered, but it does not work when I want to export it via JSON. I have also seen there is some SQL technique to inject in the URL in order to do it (maybe) but I am looking for the simplest solution in my context.