# Solidgate

[Solidgate](https://solidgate.com//) 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:

```text
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](https://docs.solidgate.com/payments/integrate/access-to-api/#retrieve-your-credentials).

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:

```sh
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](https://api-docs.solidgate.com/api/retrieve-subscription-data) | 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](https://api-docs.solidgate.com/api/reports/retrieve-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](https://api-docs.solidgate.com/api/reports/retrieve-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](https://docs.solidgate.com/) | id | created_at | merge | Provides a detailed transaction-level breakdown of financial records |

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