Coming from SQL, basically what I want to achieve (although don't know if possible yet) is to query certain data using a pivot table and javascript API.
As you can see on this spreadsheet <https://docs.google.com/spreadsheets/d/1j3vUgUMgWKHt-ZLyZPfYWRTwRwTcqTc5Y9Z624DDQt8/edit?usp=sharing>, on "Product-Sale Pivot" I'm trying to keep track of something like a "shopping cart". Basically, all I want to do is querying for a single Sale (order) and with it, the products included on that specific order. I couldn't find a "query" function on the REST API reference... So I'm really stuck here Probably my approach is not the best, so if you have any better idea, please tell me! Thanks in advance. -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
