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

Add ASAAS as a Data Source on Kondado

Connect your ASAAS financial data to Kondado's data warehouse by generating an API key and configuring the source.

Generate your ASAAS API Key

Log in to your ASAAS account, navigate to the "My Account" section, click on the "Pipeline" tab, and click "Generate API Key". This key will authenticate your data pipeline.

Copy the generated API Key

After generating the API Key, copy it to your clipboard. You will need this token to authenticate the connection between ASAAS and Kondado.

Add ASAAS as a source on Kondado

On the Kondado platform, go to the add new sources page and select the ASAAS data source from the available connectors.

Configure and save your data source

Name your data source and paste the API Key into the "Token" field. Save the configuration to start integrating your ASAAS billing, payment, subscription, transfer, and invoice data into your Data Lake or Data Warehouse.

Frequently asked questions

What data from ASAAS can I access through Kondado?▼

You can access billing data including Clientes (customers), Pagamentos (payments), Assinaturas (subscriptions), Transferências (transfers), and Notas Fiscais (invoices). Each entity contains detailed fields such as payment status, due dates, values, customer information, and tax details that you can analyze in your data warehouse.

Where do I find the API Key in my ASAAS account?▼

Log in to your ASAAS account, go to the "My Account" section, click on the "Pipeline" tab, and then click "Generate API Key". After generation, copy the key to use as your authentication token in Kondado.

Can I connect ASAAS data to BI tools for visualization?▼

Yes, once your ASAAS data is integrated into Kondado's data warehouse, you can connect it to various data visualization and BI tools. Kondado supports connections to tools like Google Data Studio, Amazon QuickSight, and others for building dashboards and reports.

What is the 'Token' field when adding the ASAAS source?▼

The "Token" field is where you paste the API Key generated from your ASAAS account. This token authenticates Kondado's access to your ASAAS data, enabling the ETL pipeline to extract your billing and financial information securely.

Do I need technical knowledge to set up the ASAAS integration?▼

No advanced technical knowledge is required. The setup involves four straightforward steps: generating an API Key in ASAAS, copying it, selecting ASAAS as a source on Kondado, and pasting the token. The platform handles the ETL process automatically after configuration.

Written by

Thassyo Pereira·Published 2023-07-05·Updated 2026-04-25