US DOL H-1B & PERM Tech Hiring & Salary Intent

NEWAPI27 reads the U.S. Department of Labor Office of Foreign Labor Certification (OFLC) public LCA and PERM case disclosure XLSX files. It is a case determination research tool. An application or certification does not indicate an open job, an actual hire, or an issued visa. LCA includes H-1B, H-1B1 and E-3; it is not exclusively H-1B.

Sources and coverage

The Actor discovers links on the official OFLC performance page, validates the DOL host and disclosure filename, then reads exactly one cumulative file. It supports the verified FY2025 and FY2026 record layouts. As of October 25, 2026, the latest FY2026 publication is Q3 (determinations through June 30, 2026). FY2025 LCA quarters and PERM Q4 are linked on the same page. Published quarters change; an unavailable selection produces a clear error instead of unrelated data.

The FY2026 Q3 LCA layout and PERM layout define the mapped fields. The corresponding FY2025 Q4 layouts are also checked. DOL data is employer-provided and may be incomplete or contain errors.

Input

Property	Meaning	Default
program	LCA or PERM	LCA
fiscalYear	2025 or 2026 federal fiscal year	2026
quarter	Cumulative published quarter; omit for latest within year	latest published
decisionDateFrom, decisionDateTo	Inclusive YYYY-MM-DD	none
socCode	SOC prefix, for example 15-; clear to include all occupations	15-
caseStatus	Exact DOL status; All includes denied and withdrawn	Certified
worksiteState	Two-letter state	none
jobTitle	Case-insensitive substring	none
minOfferedWage, minWageUnit	Compare native reported wage only to the same Hour, Week, Bi-Weekly, Month or Year unit	none
maxResults	Unique case cap, 1–1,000	10
maxCostUsd	At $0.006 per case, 0.006–6	0.06

Example: {"program":"PERM","fiscalYear":2026,"quarter":3,"socCode":"15-","worksiteState":"CA","maxResults":10,"maxCostUsd":0.06}.

Output and price

One default Dataset item represents one unique case in the selected cumulative file. Apify provides JSON and CSV Dataset exports. Each item includes case number, program, employer, job title, SOC, prevailing and offered wage, each wage unit, first or primary worksite city/state, case status, decision date, original source filename and URL, file SHA-256, fiscal year and observation time. PERM prevailing_wage is null because the mapped FY2025/FY2026 PERM disclosure does not include the PWD wage amount. No wage is silently annualized. The minimum wage filter matches only the same original unit. Blank source fields remain null; a missing case number, status or decision date is skipped.

Pay per event: the apify-default-dataset-item primary event must be configured at $0.006 per item in Apify Console. 1,000 items cost $6 in case events, subject to the user's result and spend caps. A platform synthetic start event, if active, is shown separately in Apify. The Actor does not charge for no-result or failed source downloads. Billing happens only for dataset items written. Re-running a query in a separate run produces a new paid dataset; within one run a case number is emitted once.

Data handling and limitations

The input XLSX is downloaded with HTTP error, timeout and 340 MB limits; openpyxl reads rows in read-only mode. Large downloads can dominate run time. The default stops after 10 cases, so it is designed to finish within five minutes on a healthy DOL connection; tight filters can scan far more of a million-row sheet, and runs stop at 270 seconds. DOL's cumulative files already retain each case's most recent determination within the fiscal-year snapshot. One selected file is processed per run to avoid reprocessing previous cumulative quarters. File SHA-256 and case number preserve provenance.

Some official files publish named employer contacts and email addresses. They are deliberately excluded from this product. Only allowlisted business and case fields are emitted; adding newly published columns does not add personal fields to output.

Run summary: NEWAPI27_RUN_SUMMARY in the default key-value store. Source access failures raise an error and record a failed summary. These records are administrative signals, not verified current hiring opportunities.