The important info you need to know are your Airtable App ID, the name of the table you want to access, and the Key ID tied to your airtable username. Having never worked with custom sourcing before, I found this thread on the Airtable forum useful: Before that, it was pulling all the data, but just not showing it correctly in the preview, which led to me not knowing to fix the command after the Pagination command. Only then was it possible to tell the query to open all of them. The issue was not so much the exact phrasing, but rather that after editing the original "Source" code that only pulled 100 records to a Pagination code, I needed to hit "Refresh Preview" so that the full set of paginated data segments appeared. The second, where HasError = TRUE, returns a an error with Reason: DataSource.Error and message "Web.Contents failed to get contents from ' /&offset=itr8lU9BsHcWViibW/recUWbGV3DLz7DPS6' (404): Not Found"Ĭan anyone illuminate what error I'm making in my use of this Pagination code?Įach /?api_key=")) else Json.Document(Web.Contents(""&Last_Key)), // retrieve results per call The result in the query editor looks like this:Įach of these records is a table, the first consisting of HasError = FALSE and a record containing my first hundred rows. Json.Document(Web.Contents("/&offset="&Last_Key, "]])), // retrieve results per callĬounter = +1 // internal counter Pagination = List.Skip(List.Generate( () =>, // Start ValueĮach null, // Condition under which the next execution will happenĮach <1 then "" else otherwise null, // determine the LastKey for the next execution Here's the formula as I've typed it into the Advanced Editor (substituting, , and for my particular IDs: I've tried applying that formula to my data, but something is going wrong. I've searched around and found a single formula that keeps getting re-posted to circumvent the 100-record limit. Airtable will only let an API pull data from 100 records at a time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |