# G2

[G2](https://www.g2.com/) is a peer-to-peer review platform for business software and services where users can share real-time reviews.

omniload supports G2 as a source.

## URI format

The URI format for G2 is as follows:

```text
g2://?api_token=<api-token-here>
```

URI parameters:

- `api_token`: The API token used for authentication with the G2 API v2.

The URI is used to connect to the G2 API for extracting data.

## Setting up a G2 integration

G2 requires an API token to access the v2 API. You can obtain one from the [G2 Developer Portal](https://data.g2.com/api/v2/docs/index.html).

Once you have your API token, you can use it in the URI. Let's say your API token is `my-g2-token`. Here's a sample command that will copy the data from G2 into a DuckDB database:

```sh
omniload ingest --source-uri 'g2://?api_token=my-g2-token' --source-table 'reviews' --dest-uri duckdb:///g2.duckdb --dest-table 'dest.reviews'
```

The result of this command will be a table in the `g2.duckdb` database.

## Tables

G2 source allows ingesting the following resources into separate tables:

| Table | PK | Inc Key | Inc Strategy | Details |
|-------|----|---------|--------------|---------|
| products | id | - | replace | Browse all G2 products |
| my_products | id | - | replace | Products owned by current account |
| vendors | id | updated_at | merge | List of vendors |
| categories | id | updated_at | merge | List of categories |
| category_features | id | updated_at | merge | Category product features grouped by category |
| product_features | id | updated_at | merge | Product features grouped by product |
| buyer_intent | id | - | replace | Buyer intent interactions per product |
| competitors | id | - | replace | Competitors per product |
| discussions | id | - | replace | Discussions per product |
| downloads | id | updated_at | merge | Downloads per product |
| integration_reviews | id | updated_at | merge | Integration reviews per product |
| questions | id | updated_at | merge | List of questions |
| reviews | id | updated_at | merge | Reviews per product |
| screenshots | id | updated_at | merge | List of screenshots |
| videos | id | updated_at | merge | Videos per product |

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