Skip to content
For the complete documentation index, see llms.txt. This page is also available as Markdown.

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

Field
Type

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

Field
Type

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

Field
Type

tags

json

product_id

integer

store_id

integer

skus

json

product_opinions

Sync type availability: Full-refresh

Child of products

Field
Type

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

Field
Type

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

Field
Type

answer

text

answered_at

date

id

integer

links

json

origin

text

question

text

product_questions

Sync type availability: Full-refresh

Child of products

Field
Type

question

text

id

integer

origin

text

answer

text

answered_at

date

links

json

product_rate

Sync type availability: Full-refresh

Child of products

Field
Type

product_code

text

average

float

count

integer

product_name

text

product_recommendation_summary

Sync type availability: Full-refresh

Child of products

Field
Type

averageAnswerCount

integer

percentage

float

product_survey_answers_summary

Sync type availability: Full-refresh

Child of products

Field
Type

average

float

description

text

options

json

totalAnswersCount

integer

product_survey_question_summaries

Sync type availability: Full-refresh

Child of products

Field
Type

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

Field
Type

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

Field
Type
Cursor

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

Field
Type

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

Field
Type

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

Field
Type

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

Field
Type

id

integer

name

text

created_at

timestamp

cnpj

text

store_token

text

links

json

store_reviews

Sync type availability: Full-refresh

Field
Type

id

integer

text

text

rate

integer

created_at

timestamp

client

json

tags

Sync type availability: Full-refresh

Field
Type

id

integer

name

text

Entity Relationships

Last updated