Trustvox
Connect your Trustvox review platform to your data warehouse. Sync product opinions, ratings, questions, seller reviews, and store data to BigQuery, Redshift, PostgreSQL, Databricks, and more.
Using the Erathos platform
When selecting Trustvox as a new connector on the Erathos platform, you will need to name your connection and fill in the following form:
Token — your Trustvox API token, used to authenticate all requests to the Trustvox API
Store URL — the URL of your Trustvox store, used to identify which store's data to extract
Admin Email — the administrator email associated with your Trustvox account
Store ID — the numeric identifier of your store in Trustvox
With this connection created you can seamlessly move your Trustvox data to your BigQuery, Redshift or PostgreSQL data warehouse.
How to find my token?
Log in to your Trustvox account at https://app.trustvox.com.br and go to the account/admin settings area. Under the API or integrations section, generate or copy your API token. This token is sent as a Bearer credential in the Authorization header of every request, alongside the Accept: application/vnd.trustvox.com; version=1 header that selects the API version.
You will also need your store URL, the admin email for the account, and your store ID — these identify which store's opinions, orders, products, and reviews will be extracted.
Paste the token into the Token field on the Erathos platform, fill in the Store URL, Admin Email and Store ID fields, and click Save and close to complete the setup.
Endpoints and fields
opinions
Sync type availability: Full-refresh
id
text
rate
integer
text
text
product
json
client
json
recommends
text
upvotes_count
integer
downvotes_count
integer
created_at
timestamp
order
json
photos
json
survey
json
orders
Sync type availability: Full-refresh
id
integer
order_id
text
tags
json
client
json
delivery_date
date
state
text
review_url
text
store_review_url
text
store_review
json
created_at
timestamp
items
json
product_by_code
Sync type availability: Full-refresh
Child of products
tags
json
product_id
integer
store_id
integer
skus
json
product_opinions
Sync type availability: Full-refresh
Child of products
id
integer
opinion_title
text
opinion
text
rate
integer
created_at
date
upvotes_count
integer
downvotes_count
integer
third_party
boolean
user
json
sale_item
json
recommends
text
review_photos
json
sale
json
comments
json
links
json
product_opinions_overview
Sync type availability: Full-refresh
Child of products
rate
json
top_rated_opinion
json
top_rated_negative_opinion
json
opinions_count
json
questions_count
integer
clickable_logo
boolean
store_rate
json
overall_opinions_rate
json
features
json
store_name
text
raw_store_name
text
store_locale
text
prefetched_opinions
json
prefetched_questions
json
items
json
links
json
product_question_suggestions
Sync type availability: Full-refresh
Child of products
answer
text
answered_at
date
id
integer
links
json
origin
text
question
text
product_questions
Sync type availability: Full-refresh
Child of products
question
text
id
integer
origin
text
answer
text
answered_at
date
links
json
product_rate
Sync type availability: Full-refresh
Child of products
product_code
text
average
float
count
integer
product_name
text
product_recommendation_summary
Sync type availability: Full-refresh
Child of products
averageAnswerCount
integer
percentage
float
product_survey_answers_summary
Sync type availability: Full-refresh
Child of products
average
float
description
text
options
json
totalAnswersCount
integer
product_survey_question_summaries
Sync type availability: Full-refresh
Child of products
description
text
id
integer
kind
text
options
json
products
Sync type availability: Full-refresh
Parent of product_by_code, product_opinions, product_opinions_overview, product_question_suggestions, product_questions, product_rate, product_recommendation_summary, product_survey_answers_summary, product_survey_question_summaries
id
text
name
text
average_rate
text
total_recommends
integer
total_opinions
integer
ean
json
opinions
json
links
json
questions
Sync type availability: Full and incremental refresh
Cursor: updated_at
id
integer
text
text
created_at
timestamp
updated_at
timestamp
✓
visible
boolean
state
text
consumer
json
product
json
answer
json
seller_detail
Sync type availability: Full-refresh
Child of sellers
id
integer
name
text
store_id
integer
external_id
text
created_at
timestamp
updated_at
timestamp
average_rate
float
total_opinions
integer
photo_url
text
nps
json
histogram
json
summaries
json
seller_reviews
Sync type availability: Full-refresh
id
integer
rate
integer
text
text
client_id
integer
sale_id
integer
seller_id
integer
created_at
timestamp
updated_at
timestamp
seller
json
client
json
sellers
Sync type availability: Full-refresh
Parent of seller_detail
id
integer
name
text
store_id
integer
external_id
text
created_at
timestamp
updated_at
timestamp
photo_url
text
store_by_url
Sync type availability: Full-refresh
id
integer
name
text
created_at
timestamp
cnpj
text
store_token
text
links
json
store_reviews
Sync type availability: Full-refresh
id
integer
text
text
rate
integer
created_at
timestamp
client
json
tags
Sync type availability: Full-refresh
id
integer
name
text
Entity Relationships
Last updated

