G2

G2 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:

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:

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.