Forum Discussion
Connect to Web - CKAN missing rows
Hey all, I'm attempting to connect to web API data set: https://data.nsw.gov.au/data/api/3/action/datastore_search_sql?sql=SELECT%20*%20from%20%22945c6204-272a-4cad-8e33-dde791f5059a%22 Po...
The _links section in the result JSON gives you the pointer to the next chunk - standard "limit" and "offset" addressing.
Select a meaningful return set size (for example 1000) and then use the JSON for the next chunk, or use List.Generate to create all the individual URLs.