G2
G2 is a peer-to-peer review platform for business software and services where users can share real-time reviews.
ingestr supports G2 as a source.
URI format
The URI format for G2 is as follows:
plaintext
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.
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
ingestr 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 ingestr ingest command.