You can access the Dataset Join Preflight programmatically from your own applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in API & Integrations in Apify Console.

Python

JavaScript

CLI

OpenAPI

HTTP

MCP

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = {
9    "leftRecords": [
10        { "id": 1 },
11        { "id": 1 },
12        { "id": "1" },
13        { "id": 2 },
14        { "id": None },
15        {},
16    ],
17    "rightRecords": [
18        { "key": 1 },
19        { "key": 1 },
20        { "key": 1 },
21        { "key": "1" },
22        { "key": 3 },
23        { "key": True },
24    ],
25    "leftKey": "id",
26    "rightKey": "key",
27}
28
29# Run the Actor and wait for it to finish
30run = client.actor("l3digital/dataset-join-preflight").call(run_input=run_input)
31
32# Fetch and print Actor results from the run's dataset (if there are any)
33print(f"💾 Check your data here: https://console.apify.com/storage/datasets/{run.default_dataset_id}")
34for item in client.dataset(run.default_dataset_id).iterate_items():
35    print(item)
36
37# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Dataset Join Preflight API in Python

The Apify API client for Python is the official library that allows you to use Dataset Join Preflight API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

$pip install apify-client

Other API clients include:

Dataset Join Preflight API in JavaScript

Dataset Join Preflight API through CLI

Dataset Join Preflight OpenAPI definition

Dataset Join Preflight API

Dataset Join & Merge (VLOOKUP for Datasets)

nerolabs/dataset-join-merge

Returns two Apify datasets, files or Google Sheets by URL, or JSON arrays joined on key fields like SQL or VLOOKUP: left, inner, right, full and anti joins plus union, with CSV/Excel export, named-dataset append and webhook delivery. Agent-ready: pay per event (x402, MCP), per output row.

Adam Pearce

Dataset Delta — Added, Removed & Changed Records

orangepinlabs/dataset-delta

Compare two Apify datasets or track one dataset between runs. Emit only added, removed, and changed records with exact changed fields.

Orange Pin Labs

Dataset Transformer: Filter, Dedupe, JSON to CSV

humble-echidna/dataset-transform

Transform your Apify dataset or a CSV, JSON or JSONL file from a URL: filter rows, remove duplicates by any fields, sort, pick and rename fields, flatten nested JSON. Output to a dataset, plus an optional CSV or JSONL file (JSON to CSV in one step). Pay per output row.

Michael Costa

🧽 Dataset Deduplicator - Clean Any Scraped Dataset

that_red_bird/dataset-deduplicator

🧽 Upload any dataset — scraped rows, a RAG corpus, an export — and get back exact AND near-duplicates removed, plus a per-field data quality report. ✅ MinHash + LSH banding finds near-duplicate text at scale without O(n²) pairwise comparison.

mohamed alaya

Dataset Join and Enrichment

eager_vitamin/apify-dataset-join-enrichment

Join and enrich two Apify datasets by URL, ID, or another stable key with bounded, collision-safe output.

Lau Kuan Ee

Review Dataset Auditor

agentworkflowlab/review-dataset-auditor

Audit review Datasets for completeness, malformed fields, duplicate IDs, and duplicate content.

Agent Workflow Lab

Dataset JSON Flattener

starshaped_bullsnake/dataset-json-flattener

Flatten nested JSON objects into flat key/value rows using configurable dot notation, from inline JSON or an Apify Dataset.

Starshape Tools

Dataset Deduplicator & Cleaner

starshaped_bullsnake/dataset-deduplicator-cleaner

Remove duplicate rows from an Apify Dataset or inline JSON. Deduplicate by selected fields, trim strings, and write the cleaned rows to a new Dataset.

Starshape Tools

Games

lastnewgames/games

Ali Can

Dataset Deduplication & Merge Planner

quanmatrix/dataset-deduplication-merge-planner

Use this Actor to analyze dataset deduplication and merge and return decision-ready structured signals. Find duplicate groups in Apify datasets, quantify duplicate risk, and generate deterministic merge recommendations without mutating the source.