PhillippWhen requesting data for an entire Google Sheet, you apparently get A1:Z1000 which in my case gets my Livebook hosted on fly.io OOM killed. Fun thing is, most of the result structure has `null` values, because of reasons.
Requesting the data for a smaller range works, obviously. But how do I know the range of the data in the sheet? Like, how do I know the entire table is A1:F25 or so? It would be great if the API can tell me that. It kinda does, but it says the sheet has 26 columns and 1000 rows. Yeah, thanks for the useless info.
How come that the bigger the company, the shittier their APIs?
Requesting the data for a smaller range works, obviously. But how do I know the range of the data in the sheet? Like, how do I know the entire table is A1:F25 or so? It would be great if the API can tell me that. It kinda does, but it says the sheet has 26 columns and 1000 rows. Yeah, thanks for the useless info.
How come that the bigger the company, the shittier their APIs?
