Mark Silverberg

@laurenancona yes, the power of simple and powerful APIs! If using a SODA 2.1 endpoint, you can set $limit to the # of rows to get all data

@skram Heh, I thought about mentioning limits/URL params; char limit. What if # rows unknown? Maybe I’ll write a post w/more detail.

@laurenancona you can always just put a really big number :) there are also download endpoint in the UI which will guarantee you get em all

@skram ah! Deliberately avoided that, wasn’t sure if =IMPORTDATA function’d parse w/query str. Wonder if it’d error on Gsheets limit?

@laurenancona I'm no google sheets expert. Wouldn't use it for more than a hundred thousand rows anyway. Happy data'ing!

@skram I’d use R normally; lately interested in easier munging for regular folk. Thanks!