Solidgate

Solidgate is a one-stop payment processing platform that ensures seamless online purchases and streamlined payment infrastructure.

omniload supports Solidgate as a source.

URI format

The URI format for Solidgate is as follows:

solidgate://?public_key=<your-public-key>&secret_key=<your-secret-key>

URI parameters:

• public_key: The public API key used to identify the account.

• secret_key: The secret API key used to authenticate requests to the Solidgate API.

Setting up a Solidgate Integration

Solidgate requires a few steps to set up an integration. Please follow the guide.

Once you complete the guide, you should have public_key and secret_key, here’s a sample command that ingests data from Solidgate into a DuckDB database:

omniload omniload ingest \
--source-uri "solidgate://?public_key=api_pk_test&secret_key=api_sk_test" \
--source-table "apm-orders" \
--dest-uri "duckdb:///solidgate.db" \
--dest-table "dest.apmorders"

The result of this command will be a table in the Solidgate.duckdb database with JSON columns.

Tables

Solidgate source allows ingesting the following sources into separate tables:

Table	PK	Inc Key	Inc Strategy	Details
subscriptions	id	updated_at	merge	Provides a comprehensive view of customer subscriptions, including subscription IDs, statuses, and key timestamps such as creation, update, and expiration dates
apm_orders	order_id	updated_at	merge	Provides essential information for anti-fraud purposes, including order IDs, transaction statuses, amounts, currencies, and payment methods, along with crucial customer details such as email addresses
card_orders	order_id	updated_at	merge	Provides detailed information on orders processed via card payments, including transaction data, payment status, and customer details
financial_entries	id	created_at	merge	Provides a detailed transaction-level breakdown of financial records

Use these as --source-table parameter in the omniload ingest command.