Configuring Bling as a Source
In the Sources tab, click on the “Add source” button located on the top right of your screen. Then, select the Bling option from the list of connectors. Click Next and you’ll be prompted to add your access.1. Add account access
You’ll need OAuth credentials to connect to Bling. You’ll need to provide:- Authorization: Log in with your Bling account to generate the access token. Make sure you use an account with sufficient privileges to access your Bling data.
2. Configuration Options
| Field | Description |
|---|---|
| Start Date | Records created or updated after this date will be extracted from the source |
| Lookback Window | The number of days to look back when re-fetching records based on the replication key (default: 30 days) |
3. Select streams
Choose which data streams you want to sync - you can select all streams or pick specific ones that matter most to you. The available streams include invoices (NFe, NFSe), products, sales orders, accounts payable/receivable, and more.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
4. Configure data streams
Customize how you want your data to appear in your catalog. Select a name for each table (which will contain the fetched data) and the type of sync.- Table name: we suggest a name, but feel free to customize it. You have the option to add a prefix and make this process faster!
-
Sync Type: you can choose between INCREMENTAL and FULL_TABLE.
- Incremental: every time the extraction happens, we’ll get only the new data - which is good if, for example, you want to keep every record ever fetched.
- Full table: every time the extraction happens, we’ll get the current state of the data - which is good if, for example, you don’t want to have deleted data in your catalog.
Bling API only allows fetching historical data from 2025-01-01.
5. Configure data source
Describe your data source for easy identification within your organization, not exceeding 140 characters. To define your Trigger, consider how often you want data to be extracted from this source. This decision usually depends on how frequently you need the new table data updated (every day, once a week, or only at specific times). Optionally, you can determine when to execute a full sync. This will complement the incremental data extractions, ensuring that your data is completely synchronized with your source every once in a while. Once you are ready, click Next to finalize the setup.6. Check your new source
You can view your new source on the Sources page. If needed, manually trigger the source extraction by clicking on the arrow button. Once executed, your data will appear in your Catalog.Stream to Endpoint Mapping
| Stream | API Endpoint | Sync Type |
|---|---|---|
| NFe | /nfe | Incremental |
| NFe Details | /nfe/{id} | Incremental |
| NFSe | /nfse | Incremental |
| NFe Situation | Static | Full Table |
| NFSe Situation | Static | Full Table |
| Operation Types | /naturezas-operacoes | Full Table |
| Products | /produtos | Full Table |
| Product Details | /produtos/{id} | Full Table |
| Product Categories | /categorias/produtos | Full Table |
| Sales Orders | /pedidos/vendas | Full Table |
| Sales Order Details | /pedidos/vendas/{id} | Full Table |
| Accounts Receivable | /contas/receber | Incremental |
| Accounts Receivable Details | /contas/receber/{id} | Incremental |
| Accounts Payable | /contas/pagar | Incremental |
| Accounts Payable Details | /contas/pagar/{id} | Incremental |
| Boleto | /contas/receber/{id} | Incremental |
| Accounting Accounts | /contas-contabeis | Full Table |
| Revenue Expense Categories | /categorias/receitas-despesas | Full Table |
| Revenue Expense Category Details | /categorias/receitas-despesas/{id} | Full Table |
| Store Categories | /categorias/lojas | Full Table |
| Store Category Details | /categorias/lojas/{id} | Full Table |
Streams and Fields
Below you’ll find all available data streams from Bling and their corresponding fields:Invoices & Fiscal Documents
NFe (Notas Fiscais Eletrônicas)
NFe (Notas Fiscais Eletrônicas)
Stream for managing electronic invoices (NFe) for products.
| Field | Type | Description |
|---|---|---|
id | Integer | The NFe ID |
tipo | Integer | The NFe type |
situacao | Integer | The NFe status |
numero | String | The NFe number |
dataEmissao | DateTime | The emission date (YYYY-MM-DD HH:MM:SS format) |
dataOperacao | String | The operation date (YYYY-MM-DD HH:MM:SS format) |
chaveAcesso | String | The access key |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.numeroDocumento | String | The document number |
contato.ie | String | State registration |
contato.rg | String | RG number |
contato.telefone | String | Phone number |
contato.email | String | Email address |
contato.endereco.endereco | String | Street address |
contato.endereco.numero | String | Address number |
contato.endereco.complemento | String | Address complement |
contato.endereco.bairro | String | Neighborhood |
contato.endereco.cep | String | ZIP code |
contato.endereco.municipio | String | City |
contato.endereco.uf | String | State |
contato.endereco.pais | String | Country |
naturezaOperacao.id | Integer | The nature of operation ID |
loja.id | Integer | The store ID |
NFe Details
NFe Details
Stream for detailed NFe information (child of NFe stream).
| Field | Type | Description |
|---|---|---|
id | Integer | The NFe ID |
tipo | Integer | The NFe type |
situacao | Integer | The NFe status |
numero | String | The NFe number |
dataEmissao | String | The emission date |
dataOperacao | String | The operation date |
chaveAcesso | String | The access key |
serie | Integer | The NFe series |
valorNota | Number | The invoice value |
valorFrete | Number | The freight value |
xml | String | The XML content |
linkDanfe | String | The DANFE link |
linkPDF | String | The PDF link |
optanteSimplesNacional | Boolean | Simple National taxpayer flag |
numeroPedidoLoja | String | Store order number |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.numeroDocumento | String | The document number |
contato.ie | String | State registration |
contato.rg | String | RG number |
contato.telefone | String | Phone number |
contato.email | String | Email address |
contato.endereco.endereco | String | Street address |
contato.endereco.numero | String | Address number |
contato.endereco.complemento | String | Address complement |
contato.endereco.bairro | String | Neighborhood |
contato.endereco.cep | String | ZIP code |
contato.endereco.municipio | String | City |
contato.endereco.uf | String | State |
contato.endereco.pais | String | Country |
naturezaOperacao.id | Integer | The nature of operation ID |
loja.id | Integer | The store ID |
transporte.fretePorConta | Integer | Freight responsibility |
transporte.transportador.nome | String | Transporter name |
transporte.transportador.numeroDocumento | String | Transporter document number |
transporte.volumes[].id | Integer | Volume ID |
transporte.etiqueta.nome | String | Label name |
transporte.etiqueta.endereco | String | Label street address |
transporte.etiqueta.numero | String | Label address number |
transporte.etiqueta.complemento | String | Label address complement |
transporte.etiqueta.municipio | String | Label city |
transporte.etiqueta.uf | String | Label state |
transporte.etiqueta.cep | String | Label ZIP code |
transporte.etiqueta.bairro | String | Label neighborhood |
vendedor.id | Integer | The seller ID |
itens[].codigo | String | Item code |
itens[].descricao | String | Item description |
itens[].unidade | String | Item unit |
itens[].quantidade | Number | Item quantity |
itens[].valor | Number | Item value |
itens[].valorTotal | Number | Item total value |
itens[].tipo | String | Item type |
itens[].pesoBruto | Number | Item gross weight |
itens[].pesoLiquido | Number | Item net weight |
itens[].numeroPedidoCompra | String | Purchase order number |
itens[].classificacaoFiscal | String | Fiscal classification |
itens[].cest | String | CEST code |
itens[].codigoServico | String | Service code |
itens[].origem | Integer | Origin |
itens[].informacoesAdicionais | String | Additional information |
itens[].gtin | String | GTIN code |
itens[].cfop | String | CFOP code |
itens[].documentoReferenciado.chaveAcesso | String | Referenced document access key |
itens[].documentoReferenciado.numero | String | Referenced document number |
itens[].documentoReferenciado.serie | String | Referenced document series |
itens[].documentoReferenciado.numeroItem | String | Referenced item number |
itens[].impostos.valorAproximadoTotalTributos | Number | Approximate total tax value |
itens[].impostos.icms.st | Number | ICMS ST |
itens[].impostos.icms.origem | Integer | ICMS origin |
itens[].impostos.icms.modalidade | Integer | ICMS modality |
itens[].impostos.icms.aliquota | Number | ICMS rate |
itens[].impostos.icms.valor | Number | ICMS value |
parcelas[].data | String | Installment date |
parcelas[].valor | Number | Installment value |
parcelas[].observacoes | String | Installment observations |
parcelas[].caut | String | CAUT code |
parcelas[].formaPagamento.id | Integer | Payment method ID |
NFSe (Notas Fiscais de Serviço Eletrônicas)
NFSe (Notas Fiscais de Serviço Eletrônicas)
Stream for managing electronic service invoices (NFSe). Unlike NFe which is for products, NFSe is specifically for service-based transactions.
| Field | Type | Description |
|---|---|---|
id | Integer | Unique identifier for the NFSe |
numero | String | The NFSe number |
numeroRPS | String | The RPS (Recibo Provisório de Serviços) number |
serie | String | The NFSe series |
situacao | Integer | The NFSe status |
dataEmissao | String | The emission date (YYYY-MM-DD format) |
valor | Number | The service value |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.numeroDocumento | String | The document number |
contato.email | String | Email address |
NFe Situation
NFe Situation
Static stream providing a mapping of NFe situation IDs to their descriptions.
| Field | Type | Description |
|---|---|---|
id | Integer | The NFe situation ID |
situacao | String | The NFe situation status description (e.g., “Pendente”, “Autorizada”, “Cancelada”) |
NFSe Situation
NFSe Situation
Static stream providing a mapping of NFSe situation IDs to their descriptions.
| Field | Type | Description |
|---|---|---|
id | Integer | The NFSe situation ID |
situacao | String | The NFSe situation status description (e.g., “Pendente”, “Emitida”, “Cancelada”) |
Operation Types
Operation Types
Stream for managing different types of business operations (nature of operations for invoices).
| Field | Type | Description |
|---|---|---|
id | Integer | The operation type ID |
descricao | String | The operation type description |
situacao | Integer | The operation type status (1 = Active, 0 = Inactive) |
padrao | Boolean | Indicates if this is the default operation type |
Sales & Orders
Sales Orders
Sales Orders
Stream for managing sales orders.
| Field | Type | Description |
|---|---|---|
id | Integer | The sales order ID |
numero | Integer | The sales order number |
numeroLoja | String | The store order number |
data | String | The order date (YYYY-MM-DD format) |
dataSaida | String | The departure date (YYYY-MM-DD format) |
dataPrevista | String | The expected delivery date (YYYY-MM-DD format) |
totalProdutos | Number | The total products value |
total | Number | The total order value |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.tipoPessoa | String | Person type (F = Individual, J = Legal Entity) |
contato.numeroDocumento | String | The document number |
situacao.id | Integer | The status ID |
situacao.valor | Integer | The status value |
loja.id | Integer | The store ID |
Sales Order Details
Sales Order Details
Stream for detailed sales order information (child of Sales Orders).
| Field | Type | Description |
|---|---|---|
id | Integer | The sales order ID |
numero | Integer | The sales order number |
numeroLoja | String | The store order number |
data | Date | The order date (YYYY-MM-DD format) |
dataSaida | Date | The departure date (YYYY-MM-DD format) |
dataPrevista | Date | The expected delivery date (YYYY-MM-DD format) |
totalProdutos | Number | The total products value |
total | Number | The total order value |
numeroPedidoCompra | String | Purchase order number |
outrasDespesas | Number | Other expenses |
observacoes | String | Order observations |
observacoesInternas | String | Internal observations |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.tipoPessoa | String | Person type (F = Individual, J = Legal Entity) |
contato.numeroDocumento | String | The document number |
situacao.id | Integer | The status ID |
situacao.valor | Integer | The status value |
loja.id | Integer | The store ID |
desconto.valor | Number | Discount value |
desconto.unidade | String | Discount unit (REAL, PERCENTUAL) |
categoria.id | Integer | The category ID |
notaFiscal.id | Integer | The invoice ID |
tributacao.totalICMS | Number | Total ICMS tax |
tributacao.totalIPI | Number | Total IPI tax |
itens[].id | Integer | Item ID |
itens[].codigo | String | Item code |
itens[].unidade | String | Item unit |
itens[].quantidade | Number | Item quantity |
itens[].desconto | Number | Item discount |
itens[].valor | Number | Item value |
itens[].aliquotaIPI | Number | IPI rate |
itens[].descricao | String | Item description |
itens[].descricaoDetalhada | String | Detailed description |
itens[].produto.id | Integer | Product ID |
itens[].comissao.base | Number | Commission base |
itens[].comissao.aliquota | Number | Commission rate |
itens[].comissao.valor | Number | Commission value |
itens[].naturezaOperacao.id | Integer | Natureza Operação ID |
parcelas[].id | Integer | Installment ID |
parcelas[].dataVencimento | Date | Due date |
parcelas[].valor | Number | Installment value |
parcelas[].observacoes | String | Installment observations |
parcelas[].caut | String | CAUT code |
parcelas[].formaPagamento.id | Integer | Payment method ID |
transporte.fretePorConta | Integer | Freight responsibility |
transporte.frete | Number | Freight value |
transporte.quantidadeVolumes | Integer | Number of volumes |
transporte.pesoBruto | Number | Gross weight |
transporte.prazoEntrega | Integer | Delivery term |
transporte.contato.id | Integer | Transporter contact ID |
transporte.contato.nome | String | Transporter name |
transporte.etiqueta.nome | String | Label name |
transporte.etiqueta.endereco | String | Label address |
transporte.etiqueta.numero | String | Label address number |
transporte.etiqueta.complemento | String | Label address complement |
transporte.etiqueta.municipio | String | Label city |
transporte.etiqueta.uf | String | Label state |
transporte.etiqueta.cep | String | Label ZIP code |
transporte.etiqueta.bairro | String | Label neighborhood |
transporte.etiqueta.nomePais | String | Label country name |
transporte.volumes[].id | Integer | Volume ID |
transporte.volumes[].servico | String | Service |
transporte.volumes[].codigoRastreamento | String | Tracking code |
vendedor.id | Integer | The seller ID |
intermediador.cnpj | String | Intermediator CNPJ |
intermediador.nomeUsuario | String | Username |
taxas.taxaComissao | Number | Commission rate |
taxas.custoFrete | Number | Freight cost |
taxas.valorBase | Number | Base value |
Products & Inventory
Products
Products
Stream for managing product catalog.
| Field | Type | Description |
|---|---|---|
id | Integer | The product ID |
idProdutoPai | Integer | The parent product ID (for variations) |
nome | String | The product name |
codigo | String | The product code/SKU |
preco | Number | The product price |
precoCusto | Number | The product cost price |
estoque.saldoVirtualTotal | Number | Total virtual stock balance |
tipo | String | The product type (P = Product, S = Service) |
situacao | String | The product status (A = Active, I = Inactive) |
formato | String | The product format (S = Simple, V = Variable) |
descricaoCurta | String | Short product description |
imagemURL | String | Product image URL |
Product Details
Product Details
Stream for detailed product information (child of Products).
| Field | Type | Description |
|---|---|---|
id | Integer | The product ID |
nome | String | The product name |
codigo | String | The product code |
preco | Number | The product price |
tipo | String | The product type (P = Product, S = Service) |
situacao | String | The product status (A = Active, I = Inactive) |
formato | String | The product format (S = Simple, V = Variable) |
descricaoCurta | String | Short product description |
imagemURL | String | Product image URL |
dataValidade | String | Product validity date |
unidade | String | Product unit |
pesoLiquido | Number | Net weight |
pesoBruto | Number | Gross weight |
volumes | Number | Number of volumes |
itensPorCaixa | Number | Items per box |
gtin | String | GTIN code |
gtinEmbalagem | String | Package GTIN code |
tipoProducao | String | Production type |
condicao | Integer | Product condition |
freteGratis | Boolean | Free shipping flag |
marca | String | Product brand |
descricaoComplementar | String | Complementary description |
linkExterno | String | External link |
observacoes | String | Product observations |
descricaoEmbalagemDiscreta | String | Discrete packaging description |
actionEstoque | String | Stock action |
categoria.id | Integer | The category ID |
estoque.minimo | Number | Minimum stock |
estoque.maximo | Number | Maximum stock |
estoque.crossdocking | Number | Crossdocking quantity |
estoque.localizacao | String | Stock location |
estoque.saldoVirtualTotal | Number | Total virtual stock balance |
fornecedor.id | Integer | The supplier ID |
fornecedor.contato.id | Integer | Supplier contact ID |
fornecedor.contato.nome | String | Supplier contact name |
fornecedor.codigo | String | Supplier code |
fornecedor.precoCusto | Number | Cost price |
fornecedor.precoCompra | Number | Purchase price |
dimensoes.largura | Number | Width |
dimensoes.altura | Number | Height |
dimensoes.profundidade | Number | Depth |
dimensoes.unidadeMedida | Integer | Measurement unit |
tributacao.origem | Integer | Origin |
tributacao.nFCI | String | NFCI code |
tributacao.ncm | String | NCM code |
tributacao.cest | String | CEST code |
tributacao.codigoListaServicos | String | Service list code |
tributacao.spedTipoItem | String | SPED item type |
tributacao.codigoItem | String | Item code |
tributacao.percentualTributos | Number | Tax percentage |
tributacao.valorBaseStRetencao | Number | ST retention base value |
tributacao.valorStRetencao | Number | ST retention value |
tributacao.valorICMSSubstituto | Number | ICMS substitute value |
tributacao.codigoExcecaoTipi | String | TIPI exception code |
tributacao.classeEnquadramentoIpi | String | IPI classification class |
tributacao.valorIpiFixo | Number | Fixed IPI value |
tributacao.codigoSeloIpi | String | IPI seal code |
tributacao.valorPisFixo | Number | Fixed PIS value |
tributacao.valorCofinsFixo | Number | Fixed COFINS value |
tributacao.codigoANP | String | ANP code |
tributacao.descricaoANP | String | ANP description |
tributacao.percentualGLP | Number | GLP percentage |
tributacao.percentualGasNacional | Number | National gas percentage |
tributacao.percentualGasImportado | Number | Imported gas percentage |
tributacao.valorPartida | Number | Starting value |
tributacao.tipoArmamento | Integer | Armament type |
tributacao.descricaoCompletaArmamento | String | Complete armament description |
tributacao.dadosAdicionais | String | Additional data |
tributacao.grupoProduto.id | Integer | The product group ID |
midia.video.url | String | Video URL |
midia.imagens.imagensURL | Array | Images URL |
midia.imagens.externas[].link | String | External image link |
midia.imagens.internas[].link | String | Internal image link |
midia.imagens.internas[].linkMiniatura | String | Thumbnail link |
midia.imagens.internas[].validade | String | Image validity |
midia.imagens.internas[].ordem | Integer | Image order |
midia.imagens.internas[].anexo.id | Integer | Attachment ID |
midia.imagens.internas[].anexoVinculo.id | Integer | Attachment link ID |
linhaProduto.id | Integer | The product line ID |
estrutura.tipoEstoque | String | Stock type |
estrutura.lancamentoEstoque | String | Stock release type |
estrutura.componentes[].produto.id | Integer | Component product ID |
estrutura.componentes[].quantidade | Number | Component quantity |
camposCustomizados[].idCampoCustomizado | Integer | Custom field ID |
camposCustomizados[].idVinculo | String | Link ID for updating |
camposCustomizados[].valor | String | Custom field value |
camposCustomizados[].item | String | Custom field item |
variacoes[] | Array | Product variations (contains same fields as parent product) |
product_id | Integer | Parent product ID from parent stream |
Product Categories
Product Categories
Stream for managing product categories.
| Field | Type | Description |
|---|---|---|
id | Integer | The category ID |
descricao | String | The category description |
categoriaPai.id | Integer | Parent category ID |
Financial
Accounts Receivable
Accounts Receivable
Stream for managing accounts receivable (amounts to be received).
| Field | Type | Description |
|---|---|---|
id | Integer | The account receivable ID |
situacao | Integer | The account receivable status |
vencimento | String | The due date (YYYY-MM-DD format) |
valor | Number | The amount to be received |
idTransacao | String | The transaction ID |
linkQRCodePix | String | The PIX QR code link |
linkBoleto | String | The boleto (payment slip) link |
dataEmissao | String | The emission date (YYYY-MM-DD format) |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.numeroDocumento | String | The contact document number |
contato.tipo | String | The contact type (F = Person, J = Company) |
formaPagamento.id | Integer | The payment method ID |
formaPagamento.codigoFiscal | Integer | The fiscal code |
contaContabil.id | Integer | The accounting account ID |
contaContabil.descricao | String | The accounting account description |
origem.id | Integer | The origin ID |
origem.tipoOrigem | String | The origin type (e.g., ‘venda’) |
origem.numero | String | The origin number |
origem.dataEmissao | String | The origin emission date |
origem.valor | Number | The origin value |
origem.situacao | Integer | The origin status |
origem.url | String | The origin URL |
Accounts Receivable Details
Accounts Receivable Details
Stream for detailed accounts receivable information (child of Accounts Receivable).
| Field | Type | Description |
|---|---|---|
id | Integer | The account receivable ID |
situacao | Integer | The account receivable status |
vencimento | String | The due date (YYYY-MM-DD format) |
valor | Number | The amount to be received |
idTransacao | String | The transaction ID |
linkQRCodePix | String | The PIX QR code link |
linkBoleto | String | The boleto link |
dataEmissao | String | The emission date (YYYY-MM-DD format) |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.numeroDocumento | String | The contact document number |
contato.tipo | String | The contact type (F = Person, J = Company) |
formaPagamento.id | Integer | The payment method ID |
formaPagamento.codigoFiscal | Integer | The fiscal code |
contaContabil.id | Integer | The accounting account ID |
contaContabil.descricao | String | The accounting account description |
origem.id | Integer | The origin ID |
origem.tipoOrigem | String | The origin type |
origem.numero | String | The origin number |
origem.dataEmissao | String | The origin emission date |
origem.valor | Number | The origin value |
origem.situacao | Integer | The origin status |
origem.url | String | The origin URL |
saldo | Number | The balance for the account receivable |
vencimentoOriginal | String | The original due date (YYYY-MM-DD format) |
numeroDocumento | String | The document number |
competencia | String | The competence date (YYYY-MM-DD format) |
historico | String | The history of the receivable |
numeroBanco | String | The bank number |
portador.id | Integer | The portador ID |
categoria.id | Integer | The category ID |
vendedor.id | Integer | The salesperson ID |
borderos | Array | List of borderos IDs |
ocorrencia.tipo | Integer | The occurrence type |
Boleto
Boleto
Stream for managing payment slips (boletos) associated with accounts receivable.
| Field | Type | Description |
|---|---|---|
origemId | Integer | The origin ID (links to sale/invoice) |
dataEmissaoNfe | String | The NFe emission date |
venda.numero | String | Sale number |
notaFiscal.numero | String | Invoice number |
valorTotal | Number | Total value |
contas[].id | Integer | Account ID |
contas[].numeroExterno | String | External number |
contas[].vencimento | String | Due date |
contas[].valor | Number | Value |
contas[].situacao | Integer | Status |
Accounts Payable
Accounts Payable
Stream for managing accounts payable (amounts to be paid).
| Field | Type | Description |
|---|---|---|
id | Integer | The account payable ID |
situacao | Integer | The account payable status |
vencimento | String | The due date (YYYY-MM-DD format) |
valor | Number | The amount to be paid |
dataEmissao | String | The emission date (YYYY-MM-DD format) |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.numeroDocumento | String | The contact document number |
contato.tipo | String | The contact type (F = Person, J = Company) |
formaPagamento.id | Integer | The payment method ID |
formaPagamento.codigoFiscal | Integer | The fiscal code |
contaContabil.id | Integer | The accounting account ID |
contaContabil.descricao | String | The accounting account description |
Accounts Payable Details
Accounts Payable Details
Stream for detailed accounts payable information (child of Accounts Payable).
| Field | Type | Description |
|---|---|---|
id | Integer | The account payable ID |
situacao | Integer | The account payable status |
vencimento | String | The due date (YYYY-MM-DD format) |
valor | Number | The amount to be paid |
dataEmissao | String | The emission date (YYYY-MM-DD format) |
contato.id | Integer | The contact ID |
contato.nome | String | The contact name |
contato.numeroDocumento | String | The contact document number |
contato.tipo | String | The contact type |
formaPagamento.id | Integer | The payment method ID |
formaPagamento.codigoFiscal | Integer | The fiscal code |
contaContabil.id | Integer | The accounting account ID |
contaContabil.descricao | String | The accounting account description |
saldo | Number | The balance |
vencimentoOriginal | String | The original due date |
numeroDocumento | String | The document number |
competencia | String | The competence date |
historico | String | The history |
numeroBanco | String | The bank number |
portador.id | Integer | The portador ID |
categoria.id | Integer | The category ID |
ocorrencia.tipo | Integer | The occurrence type |
Accounting Accounts
Accounting Accounts
Stream for managing accounting accounts (bank accounts, payment integrations).
| Field | Type | Description |
|---|---|---|
id | Integer | The accounting account ID |
descricao | String | The account description |
tipo | String | The account type (e.g., ‘integracao-pagamento’) |
aliasIntegracao | String | The integration alias (e.g., ‘BlingPagamentos’) |
saldoInicial | Number | The initial balance |
dataInicioTransacoes | String | The start date for transactions (YYYY-MM-DD format) |
Revenue Expense Categories
Revenue Expense Categories
Stream for managing revenue and expense categories.
| Field | Type | Description |
|---|---|---|
id | Integer | The category ID |
idCategoriaPai | Integer | The parent category ID (0 if no parent) |
descricao | String | The category description |
tipo | Integer | The category type (1 = Revenue, 2 = Expense) |
Revenue Expense Category Details
Revenue Expense Category Details
Stream for detailed revenue/expense category information (child of Revenue Expense Categories).
| Field | Type | Description |
|---|---|---|
id | Integer | The category ID |
idCategoriaPai | Integer | The parent category ID |
descricao | String | The category description |
tipo | Integer | The category type (1 = Revenue, 2 = Expense) |
situacao | Integer | The category status |
Configuration
Store Categories
Store Categories
Stream for managing store categories (for e-commerce integrations).
| Field | Type | Description |
|---|---|---|
id | Integer | The store category ID |
descricao | String | The category description |
codigo | String | The category code |
loja.id | Integer | Store ID |
categoriaProduto.id | Integer | Product category mapping ID |
Store Category Details
Store Category Details
Stream for detailed store category information (child of Store Categories).
| Field | Type | Description |
|---|---|---|
id | Integer | The store category ID |
descricao | String | The category description |
codigo | String | The category code |
loja.id | Integer | Store ID |
categoriaProduto.id | Integer | Product category mapping ID |
Data Model
The following diagram illustrates the relationships between the core data streams in Bling. The arrows indicate the join keys that link the different entities.Implementation Notes
Data Quality
- Portuguese Field Names: Field names use Portuguese terminology (e.g.,
contatofor contact,situacaofor status,vencimentofor due date) - Date Formats: Dates are typically in
YYYY-MM-DDformat, datetimes inYYYY-MM-DD HH:MM:SSformat - Status Values: Many entities use numeric status values - refer to the Situation streams for human-readable descriptions
API Behavior
- Historical Data Limit: Bling API only allows fetching data from 2025-01-01 onwards
- Incremental Sync: Streams with
dataEmissaoas replication key support incremental sync - Child Streams: Detail streams (e.g.,
Sales Order Details,NFe Details) fetch additional information for each parent record
Brazilian Context
- NFe/NFCe/NFSe: Brazilian electronic invoice types
- NFe: Product invoices
- NFCe: Consumer invoices (retail)
- NFSe: Service invoices
- Document Numbers:
numeroDocumentotypically refers to CPF (individuals) or CNPJ (companies) - ICMS/IPI: Brazilian tax codes included in invoice details