Extracting TTB Alcohol Label Approvals Past the 1,000 Result Cap

说明与用途

自动化提取TTB COLA记录的配方，绕过1,000条记录限制，获取申请人信息和标签图像。

问题

Automated extraction of TTB COLA records is hindered by session limits, mandatory filters, and a hard 1,000‑record server truncation.

结果

The recipe enables complete, programmatic retrieval of TTB COLA records, including applicant metadata and label images, while bypassing the 1,000‑record server truncation by chunking queries.

工作流

• 1. Install apify-client and obtain an API key.
• 2. Construct a JSON payload with mode=search, optional filters (permitId, classTypeCode, originCode), dateCompletedFrom/To, includeApplicantDetails, includeLabelImages, and maxItems.
• 3. Call the actor via ApifyClient, passing the payload.
• 4. Retrieve the default dataset from the run result.
• 5. Iterate over items, extracting ttbId, brandName, applicantName, status, and labelImages URLs.
• 6. Store or process the data as needed.
• 7. Repeat with smaller date windows or additional filters to avoid the 1,000‑record limit.

证据

TTB forces a mandatory "Date Completed" window. The TTB backend rejects queries without a completed date range or queries spanning longer than 15 years.

来源

TTB's public registry enforces a hard limit of 1,000 records per search result window, paginated in chunks of 20 records.

来源

The TTB COLA Registry Scraper interfaces directly with the TTB public registry endpoint over HTTP without browser automation overhead.

来源