Re: How to do filtering/queries in v4

2017-02-03 Thread Jānis Taranda
"The Sheets API v4 does not currently have a direct equivalent for the Sheets API v3 structured queries. However, you can retrieve the relevant data and sort through it as needed in your application." -> https://developers.google.com/sheets/api/guides/migration :(( On Thursday, February 2, 2017

How to do filtering/queries in v4

2017-02-02 Thread Jānis Taranda
I collect a lot of daily data from remote source and insert it into google sheet. However, the fetched remote data can be the same for some time, so I don't want to insert same Row in my sheet. As coming from SQL background, I'm thinking of something like "alreadyExists = Select * from xx where