Tray Corp by FBits

Adding the data source

By adding Tray Corp by FBits data source to Kondado, you can access your e-commerce data in your Data Warehouse or Data Lake – process also known as ETL or ELT

To add the Tray Corp by FBits data source, follow the steps below:

1) Login to your Tray Corp by FBits admin page

2) In the side menu, go to the “Pipelines” option at the bottom

3) Then select “Tokens”

4) Then click on “Add Token”

5) Fill in the information as below:

  • In “Application Name”, fill in an identifier of yours, such as “Kondado”
  • Under “Pipelines Type”, select “REST”
  • In “Technical Responsible”, fill in your email
  • In “Allowed Operations”, choose at least GET on /orders
  • Copy the value of “Token” highlighted in yellow

6) Login to Kondado, go to add data sources section and select Tray Corp data source

7) In the data source, in “Name” give a name for your data source and in “Token” paste the token obtained in step (5)

Now just click on SAVE and to start receiving data from Tray Corp in the Data Warehouse or Data Lake

ATTENTION: A new token can take up to 20 minutes to be activated by Tray Corp. Therefore, wait a while before testing the connection and starting to create your pipelines.

Pipelines

Relationship Chart

Pedidos

Field Type

pedidoid

text

canalid

float

canalnome

text

canalorigem

text

cupomdesconto

text

data

timestamp

datapagamento

timestamp

dataultimaatualizacao

timestamp

ispedidoevento

boolean

marketplacepedidoid

text

marketplacepedidositeid

text

retiradalojaid

float

situacaopedidoid

float

tiporastreamentopedido

text

transacaoid

text

usuario__cnpj

text

usuario__cpf

text

usuario__dataatualizacao

timestamp

usuario__datacriacao

timestamp

usuario__datanascimento

timestamp

usuario__email

text

usuario__grupoinformacaocadastral

text

usuario__inscricaoestadual

text

usuario__listainformacaocadastral

text

usuario__nome

text

usuario__origemcontato

text

usuario__razaosocial

text

usuario__responsavel

text

usuario__revendedor

boolean

usuario__rg

text

usuario__telefonecelular

text

usuario__telefonecomercial

text

usuario__telefoneresidencial

text

usuario__tipopessoa

text

usuario__tiposexo

text

usuario__usuarioid

text

valido

boolean

valorcreditofidelidade

float

valordebitocc

float

valordesconto

float

valorfrete

float

valorsubtotalsemdescontos

float

valortotalpedido

float