Solidgate
Solidgate is a one-stop payment processing platform that ensures seamless online purchases and streamlined payment infrastructure.
ingestr 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:
ingestr ingestr 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:
subscriptions
: Provides a comprehensive view of customer subscriptions, including subscription IDs, statuses, and key timestamps such as creation, update, and expiration dates.apm_orders
: 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
: Provides detailed information on orders processed via card payments, including transaction data, payment status, and customer details.financial_entries
: Provides a detailed transaction-level breakdown of financial records.
Use these as --source-table
parameter in the ingestr ingest
command.