ASAAS

ASAAS is a financial system that allows entrepreneurs to quickly issue bills via card and payment slip. The ASAAS data pipeline for the Data Warehouse created by Kondado allows you to have access to your billing data in your analytical cloud.

Adding the data source

To automate ASAAS ETL with Kondado for your database, follow the steps below:

1) Log in to your ASAAS account, in the “My Account” section, click on the “Pipeline” tab and click on “Generate API Key”

2) After generating the API Key, copy the generated key

3) On the Kondado platform, go to the add new sources page and select the ASAAS data source;

4) Name your data source and, in “Token” paste the key generated in step (2)

Now just save the data source and start integrating your ASAAS data into the Data Lake or Data Warehouse.

Pipelines

Relationship Chart

Gráfico de relacionamento entre tabelas

Clientes

Main Object

Field	Type
additionalemails	text
id	text
foreigncustomer	boolean
city	text
cpfcnpj	text
state	text
addressnumber	text
postalcode	text
email	text
province	text
notificationdisabled	boolean
mobilephone	text
deleted	boolean
company	text
object	text
datecreated	date
phone	text
address	text
complement	text
externalreference	text
name	text
country	text

groups

Field	Type
groups__name	text
customer_id	text

Pagamentos

Field	Type
lastinvoicevieweddate	timestamp
interestvalue	float
duedate	date
invoicenumber	float
estimatedcreditdate	date
fine__type	text
fine__value	float
lastbankslipvieweddate	timestamp
id	text
paymentdate	date
interest__type	text
interest__value	float
creditdate	date
status	text
billingtype	text
clientpaymentdate	date
description	text
deleted	boolean
object	text
datecreated	date
netvalue	float
discount__type	text
discount__limitdate	date
discount__duedatelimitdays	float
discount__value	float
anticipated	boolean
externalreference	text
subscription	text
customer	text
invoiceurl	text
bankslipurl	text
originalduedate	date
value	float
originalvalue	float

Assinaturas

Field	Type
customer	text
status	text
billingtype	text
description	text
sendpaymentbypostalservice	boolean
deleted	boolean
object	text
value	float
datecreated	date
discount__type	text
discount__limitdate	date
discount__duedatelimitdays	float
discount__value	float
nextduedate	date
interest__type	text
interest__value	float
fine__type	text
fine__value	float
id	text
externalreference	text
cycle	text

Transferências

Field	Type
status	text
bankaccount__agencydigit	text
bankaccount__account	text
bankaccount__agency	text
bankaccount__accountdigit	text
bankaccount__ownername	text
bankaccount__cpfcnpj	text
bankaccount__bank__code	text
bankaccount__bank__name	text
bankaccount__accountname	text
scheduledate	date
object	text
datecreated	date
netvalue	float
id	text
effectivedate	text
value	float
transferfee	float
authorized	boolean
type	text

Notas Fiscais

Field	Type
validationcode	text
rpsserie	text
number	text
value	float
id	text
pdfurl	text
effectivedate	date
observations	text
type	text
statusdescription	text
servicedescription	text
status	text
object	text
rpsnumber	text
xmlurl	text
deductions	float
municipalservicename	text
payment	text
customer	text
installment	text
taxes__cofins	float
taxes__iss	float
taxes__ir	float
taxes__csll	float
taxes__inss	float
taxes__retainiss	boolean
taxes__pis	float
municipalservicecode	text
estimatedtaxesdescription	text