
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. 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 NFe (electronic invoices), products and sales orders.Tip: The stream can be found more easily by typing its name.Select the streams and click Next.
3. 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.
4. 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.5. 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.For you to be able to see it on your Catalog, you need at least one successful source run.
Streams and Fields
Below you’ll find all available data streams from Bling and their corresponding fields:NFe (Notas Fiscais Eletrônicas)
NFe (Notas Fiscais Eletrônicas)
Stream for managing electronic invoices (NFe).Key Fields:
id
: Unique identifier for the NFetipo
: The NFe typesituacao
: The NFe statusnumero
: The NFe numberdataEmissao
: The emission date (YYYY-MM-DD HH:MM:SS format)dataOperacao
: The operation date (YYYY-MM-DD HH:MM:SS format)chaveAcesso
: The access keycontato
: Contact information including:- Basic info (id, nome)
- Document info (numeroDocumento, ie, rg)
- Contact details (telefone, email)
- Address (endereco, numero, complemento, bairro, cep, municipio, uf, pais)
naturezaOperacao
: Nature of operation information (id)loja
: Store information (id)
NFe Details
NFe Details
Stream for detailed NFe information.Key Fields:
id
: Unique identifier for the NFetipo
: The NFe typesituacao
: The NFe statusnumero
: The NFe numberdataEmissao
: The emission datedataOperacao
: The operation datechaveAcesso
: The access keyserie
: The NFe seriesvalorNota
: The invoice valuevalorFrete
: The freight valuexml
: The XML contentlinkDanfe
: The DANFE linklinkPDF
: The PDF linkoptanteSimplesNacional
: Simple National taxpayer flagnumeroPedidoLoja
: Store order numbercontato
: Contact information (same as NFe stream)naturezaOperacao
: Nature of operation informationloja
: Store informationtransporte
: Transport information including:- Freight details (fretePorConta)
- Transporter info (nome, numeroDocumento)
- Volumes
- Label information (nome, endereco, etc.)
vendedor
: Seller informationitens
: Array of items with:- Basic info (codigo, descricao, unidade)
- Quantities and values (quantidade, valor, valorTotal)
- Product details (tipo, pesoBruto, pesoLiquido)
- Fiscal information (classificacaoFiscal, cest, cfop)
- Tax information (impostos)
parcelas
: Payment installments with:- Basic info (data, valor)
- Payment method (formaPagamento)
- Additional details (observacoes, caut)
Products
Products
Stream for managing product catalog.Key Fields:
id
: Unique identifier for the productidProdutoPai
: The parent product IDnome
: The product namecodigo
: The product codepreco
: The product priceprecoCusto
: The product cost priceestoque
: Stock information including:saldoVirtualTotal
: Total virtual stock balance
tipo
: The product type (P = Product, S = Service)situacao
: The product status (A = Active, I = Inactive)formato
: The product format (S = Simple, V = Variable)descricaoCurta
: Short product descriptionimagemURL
: Product image URL
Product Details
Product Details
Stream for detailed product information.Key Fields:
id
: Unique identifier for the productnome
: The product namecodigo
: The product codepreco
: The product pricetipo
: The product typesituacao
: The product statusformato
: The product formatdescricaoCurta
: Short product descriptionimagemURL
: Product image URLdataValidade
: Product validity dateunidade
: Product unitpesoLiquido
: Net weightpesoBruto
: Gross weightvolumes
: Number of volumesitensPorCaixa
: Items per boxgtin
: GTIN codegtinEmbalagem
: Package GTIN codecategoria
: Category informationestoque
: Stock information including:- Limits (minimo, maximo)
- Location (localizacao)
- Balance (saldoVirtualTotal)
fornecedor
: Supplier information including:- Basic info (id, codigo)
- Contact details
- Pricing (precoCusto, precoCompra)
dimensoes
: Product dimensionstributacao
: Taxation information including:- Basic info (origem, ncm, cest)
- Tax details (percentualTributos)
- Additional codes and values
midia
: Media information including:- Video URL
- Images (external and internal)
estrutura
: Product structure informationvariacoes
: Product variations with all relevant details
Sales Orders
Sales Orders
Stream for managing sales orders.Key Fields:
id
: Unique identifier for the sales ordernumero
: The sales order numbernumeroLoja
: The store order numberdata
: The order date (YYYY-MM-DD format)dataSaida
: The departure datedataPrevista
: The expected delivery datetotalProdutos
: The total products valuetotal
: The total order valuecontato
: Customer information including:- Basic info (id, nome)
- Type (tipoPessoa)
- Document (numeroDocumento)
situacao
: Order status information (id, valor)loja
: Store information (id)