Pricing

$20.00 / 1,000 results

Try for free

Go to Apify Store

CSV Foreign-Key Import Gate

Try for free

Validate foreign-key relationships across multiple CSV files before import. Detect orphaned references, quarantine invalid rows, and export clean CSV files plus detailed validation reports.

Pricing

$20.00 / 1,000 results

Rating

0.0

(0)

Developer

bread kim

Actor stats

Bookmarked

Total users

Monthly active users

15 days ago

Last modified

Categories

You can access the CSV Foreign-Key Import Gate 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

$echo '{
<  "tables": [
<    {
<      "name": "accounts",
<      "csv": "id,name\\r\\n01,Ada\\r\\n01,Duplicate\\r\\n02,Lin\\r\\n",
<      "primaryKey": [
<        "id"
<      ],
<      "requiredColumns": [
<        "name"
<      ]
<    },
<    {
<      "name": "orders",
<      "csv": "id,account_id,note\\n10,01,child of duplicate\\n11,99,orphan\\n12,02,\\"accepted, link\\"\\n13,02,\\"multi\\nline\\"\\n",
<      "primaryKey": [
<        "id"
<      ],
<      "requiredColumns": [
<        "note"
<      ]
<    },
<    {
<      "name": "items",
<      "csv": "id,order_id,amount\\n100,10,-12.5\\n101,12,007\\n102,11,3\\n",
<      "primaryKey": [
<        "id"
<      ],
<      "requiredColumns": [
<        "amount"
<      ]
<    }
<  ],
<  "foreignKeys": [
<    {
<      "table": "orders",
<      "columns": [
<        "account_id"
<      ],
<      "referencesTable": "accounts",
<      "referencesColumns": [
<        "id"
<      ],
<      "nullable": false
<    },
<    {
<      "table": "items",
<      "columns": [
<        "order_id"
<      ],
<      "referencesTable": "orders",
<      "referencesColumns": [
<        "id"
<      ],
<      "nullable": false
<    }
<  ]
<}' |
<apify call bread-kim/csv-foreign-key-import-gate --silent --output-dataset

CSV Foreign Key & Referential Integrity Validator API through CLI

The Apify CLI is the official tool that allows you to use CSV Foreign-Key Import Gate locally, providing convenience functions and automatic retries on errors.

Install Apify CLI

Using installation script (macOS/Linux):

$curl -fsSL https://apify.com/install-cli.sh | bash

Using installation script (Windows):

$irm https://apify.com/install-cli.ps1 | iex

Using Homebrew:

$brew install apify-cli

Using npm:

$npm install -g apify-cli

Other API clients include:

CSV Foreign-Key Import Gate API in Python

CSV Foreign-Key Import Gate API in JavaScript

CSV Foreign-Key Import Gate OpenAPI definition

CSV Foreign-Key Import Gate API

CSV File to Dataset

lukaskrivka/csv-file-to-dataset

Upload a local or remote CSV/text file and convert it to Apify Dataset for further use.

Lukáš Křivka

190

JSON to CSV Converter

eloquent_mountain/json-to-csv-converter

JSON to CSV Converter. Effortlessly transform JSON data into CSV with our Apify actor. Handle nested structures, expand lists into rows, and customize separators and delimiters. Input via URL or paste JSON text. Ideal for data analysis and reporting!

Paco

Firestore Import

drobnikj/firestore-import

Imports dataset items to Firestone DB.

Jakub Drobník

Tiendanube / Nuvemshop Product & Store Scraper

lautarodelgado/tiendanube-scraper

Scrape Tiendanube (Nuvemshop in Brazil) stores: products, prices, variants, stock, installments, images and categories, plus public store contacts. Incremental mode returns only new or changed products. Spanish and Portuguese keywords work.

Lautaro Delgado

Excel to CSV Converter

web.harvester/excel-to-csv

Convert Excel files (XLSX, XLS, ODS) to CSV format. Extract all sheets or specific ones. Configurable delimiter, date formatting, skip empty rows. Batch processing multiple files. Optional JSON output to Dataset. Handles large files efficiently. Perfect for ETL pipelines.

Web Harvester

US Import Duty & Tariff Calculator (HTS + Origin)

tariffsapi/us-import-duty-tariff-calculator

Bulk-resolve HTS codes to the real effective US duty rate by country of origin. Stacks MFN base + Section 301, 232 and 122 into one landed rate. A hardened resolver, not a scraper.

TariffsAPI

Google Sheets Import & Export

cypherstone/google-sheets-import-export

Read a Google Sheet into a dataset (public sheets need no key) and write datasets or JSON back - append, replace, or upsert - using a service account, with no interactive OAuth and automatic rate-limit retries.

Jeff Ralston

Dataset Transformer - Filter, Dedupe, Merge & Export CSV

seemuapps/dataset-transformer

Filter, deduplicate, merge, sort, rename and flatten Apify datasets from any scraper, then export clean rows to a dataset, CSV or JSON file.

Seemu Scraping

Date Format Normalizer

avqelle/date-format-normalizer

Normalize messy date strings into clean ISO 8601 or custom date formats. Handles common date formats, relative dates, multilingual inputs, timezone conversion, and returns clear error results for unparseable dates.

Avqelle Labs

Facebook Events Scraper - Search, City, Page & Event Details

topapi/facebook-events-scraper

Scrape public Facebook events by keyword, city, Page or event URL for $2.40 per 1,000: name, dates, venue, address, plus counts on city feeds. Event URLs and keyword search add coordinates, tickets, hosts and description; city and Page lists get them for $0.0018 more. Monitor mode. No login.