API Connectors

users-love-us medal soc2
Send your Bling! data to
Data StudioGoogle SheetsChatGPTClaudePower BIExcelTableauGoogle BigQueryAmazon S3Azure Blob StorageSnowflakeMySQLPostgreSQLPythonAzure SQLAmazon RedshiftDatabricksWindsor MCPMicrosoft FabricCopilot AgentPerplexityLovableAntigravitySupabase

Bling! Connector Reference

14 metrics185 dimensions
Fields

The Bling! connector exposes 199 fields (14 metrics, 185 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.


Bling! Fields

Bling! Bills Pay fields

The Bills Pay report of the Bling! connector includes 6 fields.

ID Type Name Description Report
bills_pay_contact_id TEXT Bills Pay Contact ID Bills Pay Contact ID bills_pay
bills_pay_due_date DATE Bills Pay Due Date Bills Pay Due Date bills_pay
bills_pay_id TEXT Bills Pay ID Bills Pay ID bills_pay
bills_pay_payment_method_id TEXT Bills Pay Payment Method ID Bills Pay Payment Method ID bills_pay
bills_pay_status TEXT Bills Pay Status Bills Pay Status. Available values : 1 (Open), 2 (Received), 3 (Partially received), 4 (Returned), 5 (Canceled) bills_pay
bills_pay_value NUMERIC Bills Pay Value Bills Pay Value bills_pay

Bling! Bills Receive fields

The Bills Receive report of the Bling! connector includes 6 fields.

ID Type Name Description Report
bills_receive_contact_id TEXT Bills Receive Contact ID Bills Receive Contact ID bills_receive
bills_receive_due_date DATE Bills Receive Due Date Bills Receive Due Date bills_receive
bills_receive_id TEXT Bills Receive ID Bills Receive ID bills_receive
bills_receive_payment_method_id TEXT Bills Receive Payment Method ID Bills Receive Payment Method ID bills_receive
bills_receive_status TEXT Bills Receive Status Bills Receive Status. Available values : 1 (Open), 2 (Received), 3 (Partially received), 4 (Returned), 5 (Canceled) bills_receive
bills_receive_value NUMERIC Bills Receive Value Bills Receive Value bills_receive

Bling! Categories Income Expenses fields

The Categories Income Expenses report of the Bling! connector includes 4 fields.

ID Type Name Description Report
categories_income_expenses_description TEXT Categories Income Expenses Description Categories Income Expenses Description categories_income_expenses
categories_income_expenses_id TEXT Categories Income Expenses ID Categories Income Expenses ID categories_income_expenses
categories_income_expenses_parent_id TEXT Categories Income Expenses Parent ID Categories Income Expenses Parent ID categories_income_expenses
categories_income_expenses_type TEXT Categories Income Expenses Type Categories Income Expenses Type. Available values : 0 (All), 1 (Expense), 2 (Revenue), 3 (Revenue and expense) categories_income_expenses

Bling! Categories Products fields

The Categories Products report of the Bling! connector includes 3 fields.

ID Type Name Description Report
categories_products_description TEXT Categories Products Description Categories Products Description categories_products
categories_products_id TEXT Categories Products ID Categories Products ID categories_products
categories_products_parent_id TEXT Categories Products Parent ID Categories Products Parent ID categories_products

Bling! Categories Stores fields

The Categories Stores report of the Bling! connector includes 5 fields.

ID Type Name Description Report
categories_stores_category_product_id TEXT Categories Stores Category Product ID Categories Stores Category Product ID categories_stores
categories_stores_code TEXT Categories Stores Code Categories Stores Code categories_stores
categories_stores_description TEXT Categories Stores Description Categories Stores Description categories_stores
categories_stores_id TEXT Categories Stores ID Categories Stores ID categories_stores
categories_stores_store_id TEXT Categories Stores Store ID Categories Stores Store ID categories_stores

Bling! Consumer Invoices fields

The Consumer Invoices report of the Bling! connector includes 23 fields.

ID Type Name Description Report
consumer_invoices_contact_address_address TEXT Consumer Invoices Contact Address Address Consumer Invoices Contact Address Address consumer_invoices
consumer_invoices_contact_address_city CITY Consumer Invoices Contact Address City Consumer Invoices Contact Address City consumer_invoices
consumer_invoices_contact_address_complement TEXT Consumer Invoices Contact Address Complement Consumer Invoices Contact Address Complement consumer_invoices
consumer_invoices_contact_address_country COUNTRY Consumer Invoices Contact Address Country Consumer Invoices Contact Address Country consumer_invoices
consumer_invoices_contact_address_neighborhood TEXT Consumer Invoices Contact Address Neighborhood Consumer Invoices Contact Address Neighborhood consumer_invoices
consumer_invoices_contact_address_number TEXT Consumer Invoices Contact Address Number Consumer Invoices Contact Address Number consumer_invoices
consumer_invoices_contact_address_state TEXT Consumer Invoices Contact Address State Consumer Invoices Contact Address State consumer_invoices
consumer_invoices_contact_address_zipcode TEXT Consumer Invoices Contact Address ZipCode Consumer Invoices Contact Address ZipCode consumer_invoices
consumer_invoices_contact_document_number TEXT Consumer Invoices Contact Document Number Consumer Invoices Contact Document Number consumer_invoices
consumer_invoices_contact_email TEXT Consumer Invoices Contact Email Consumer Invoices Contact Email consumer_invoices
consumer_invoices_contact_id TEXT Consumer Invoices Contact ID Consumer Invoices Contact ID consumer_invoices
consumer_invoices_contact_ie TEXT Consumer Invoices Contact IE Consumer Invoices Contact IE consumer_invoices
consumer_invoices_contact_name TEXT Consumer Invoices Contact Name Consumer Invoices Contact Name consumer_invoices
consumer_invoices_contact_phone TEXT Consumer Invoices Contact Phone Consumer Invoices Contact Phone consumer_invoices
consumer_invoices_contact_rg TEXT Consumer Invoices Contact RG Consumer Invoices Contact RG consumer_invoices
consumer_invoices_id TEXT Consumer Invoices ID Consumer Invoices ID consumer_invoices
consumer_invoices_issue_date DATE Consumer Invoices Issue Date Consumer Invoices Issue Date consumer_invoices
consumer_invoices_nature_operation_id TEXT Consumer Invoices Nature Operation ID Consumer Invoices Nature Operation ID consumer_invoices
consumer_invoices_number TEXT Consumer Invoices Number Consumer Invoices Number consumer_invoices
consumer_invoices_operation_date DATE Consumer Invoices Operation Date Consumer Invoices Operation Date consumer_invoices
consumer_invoices_status TEXT Consumer Invoices Status Consumer Invoices Status. Available values : 1 (Pending), 2 (Canceled), 3 (Waiting for receipt), 4 (Rejected), 5 (Authorized), 6 (Issued DANFE), 7 (Registered), 8 (Waiting for protocol), 9 (Denied), 10 (Check situation), 11 (Blocked) consumer_invoices
consumer_invoices_store_id TEXT Consumer Invoices Store ID Consumer Invoices Store ID consumer_invoices
consumer_invoices_type TEXT Consumer Invoices Type Consumer Invoices Type consumer_invoices

Bling! Contacts fields

The Contacts report of the Bling! connector includes 7 fields.

ID Type Name Description Report
contacts_code TEXT Contacts Code Contacts Code contacts
contacts_document_number TEXT Contacts Document Number Contacts Document Number contacts
contacts_id TEXT Contacts ID Contacts ID contacts
contacts_mobile TEXT Contacts Mobile Contacts Mobile contacts
contacts_name TEXT Contacts Name Contacts Name contacts
contacts_phone TEXT Contacts Phone Contacts Phone contacts
contacts_status TEXT Contacts Status Contacts Status contacts

Bling! Contracts fields

The Contracts report of the Bling! connector includes 7 fields.

ID Type Name Description Report
contracts_contact_id TEXT Contracts Contact ID Contracts Contact ID contracts
contracts_date DATE Contracts Date Contracts Date contracts
contracts_description TEXT Contracts Description Contracts Description contracts
contracts_id TEXT Contracts ID Contracts ID contracts
contracts_number TEXT Contracts Number Contracts Number contracts
contracts_status TEXT Contracts Status Contracts Status. Available values : 0 (Inactive), 1 (Active), 2 (Downloaded), 3 (Exempt) contracts
contracts_value NUMERIC Contracts Value Contracts Value contracts

Bling! Deposits fields

The Deposits report of the Bling! connector includes 5 fields.

ID Type Name Description Report
deposits_default BOOLEAN Deposits Default Deposits Default deposits
deposits_description TEXT Deposits Description Deposits Description deposits
deposits_disregard_balance BOOLEAN Deposits Disregard Balance Deposits Disregard Balance deposits
deposits_id TEXT Deposits ID Deposits ID deposits
deposits_status TEXT Deposits Status Deposits Status. Available values : 0 (Inactive), 1 (Active) deposits

Bling! Invoice fields

The Invoice report of the Bling! connector includes 23 fields.

ID Type Name Description Report
invoice_date_issue DATE Invoice Date Issue Invoice Date (Notas Fiscais Eletrônicas) invoices
invoice_date_operation DATE Invoice Date Operation Invoice Date Operation (Notas Fiscais Eletrônicas) invoices
invoice_id TEXT Invoice ID Invoice ID (Notas Fiscais Eletrônicas) invoices
invoice_number TEXT Invoice Number Invoice Number (Notas Fiscais Eletrônicas) invoices
invoice_status TEXT Invoice Status Invoice Status (Notas Fiscais Eletrônicas) Available values : 1 (Pendente), 2 (Cancelada), 3 (Aguardando recibo), 4 (Rejeitada), 5 (Autorizada), 6 (Emitida DANFE), 7 (Registrada), 8 (Aguardando protocolo), 9 (Denegada), 10 (Consulta situação), 11 (Bloqueada) invoices
invoice_type TEXT Invoice Type Invoice Type (Notas Fiscais Eletrônicas) Available values : 0 (Entrada), 1 (Saída) invoices
invoices_contact_address_address TEXT Invoice Contact Address Address Invoice Contact Address Address invoices
invoices_contact_address_city CITY Invoice Contact Address City Invoice Contact Address City invoices
invoices_contact_address_complement TEXT Invoice Contact Address Complement Invoice Contact Address Complement invoices
invoices_contact_address_country COUNTRY Invoice Contact Address Country Invoice Contact Address Country invoices
invoices_contact_address_neighborhood TEXT Invoice Contact Address Neighborhood Invoice Contact Address Neighborhood invoices
invoices_contact_address_number TEXT Invoice Contact Address Number Invoice Contact Address Number invoices
invoices_contact_address_state TEXT Invoice Contact Address State Invoice Contact Address State invoices
invoices_contact_address_zipcode TEXT Invoice Contact Address ZipCode Invoice Contact Address ZipCode invoices
invoices_contact_document_number TEXT Invoice Contact Document Number Invoice Contact Document Number invoices
invoices_contact_email TEXT Invoice Contact Email Invoice Contact Email invoices
invoices_contact_id TEXT Invoice Contact ID Invoice Contact ID invoices
invoices_contact_ie TEXT Invoice Contact IE Invoice Contact IE invoices
invoices_contact_name TEXT Invoice Contact Name Invoice Contact Name invoices
invoices_contact_phone TEXT Invoice Contact Phone Invoice Contact Phone invoices
invoices_contact_rg TEXT Invoice Contact RG Invoice Contact RG invoices
invoices_nature_operation_id TEXT Invoice Nature Operation ID Invoice Nature Operation ID invoices
invoices_store_id TEXT Invoice Store ID Invoice Store ID invoices

Bling! Logistics fields

The Logistics report of the Bling! connector includes 6 fields.

ID Type Name Description Report
logistics_description TEXT Logistics Description Logistics Description logistics
logistics_id TEXT Logistics ID Logistics ID logistics
logistics_integration_id TEXT Logistics Integration ID Logistics Integration ID logistics
logistics_integration_type TEXT Logistics Integration Type Logistics Integration Type logistics
logistics_native_integration BOOLEAN Logistics Native Integration Logistics Native Integration logistics
logistics_status TEXT Logistics Status Logistics Status. Available values : H (Enabled), D (Disabled) logistics

Bling! Logistics Services fields

The Logistics Services report of the Bling! connector includes 9 fields.

ID Type Name Description Report
logistics_services_active BOOLEAN Logistics Services Active Logistics Services Active logistics_services
logistics_services_carrier_id TEXT Logistics Services Carrier ID Logistics Services Carrier ID logistics_services
logistics_services_code TEXT Logistics Services Code Logistics Services Code logistics_services
logistics_services_delivery_estimate NUMERIC Logistics Services Delivery Estimate Logistics Services Delivery Estimate logistics_services
logistics_services_description TEXT Logistics Services Description Logistics Services Description logistics_services
logistics_services_freight_item NUMERIC Logistics Services Freight Item Logistics Services Freight Item logistics_services
logistics_services_id TEXT Logistics Services ID Logistics Services ID logistics_services
logistics_services_logistics_id TEXT Logistics Services Logistics ID Logistics Services Logistics ID logistics_services
logistics_services_service_code_id TEXT Logistics Services Service Code ID Logistics Services Service Code ID logistics_services

Bling! Natures Operations fields

The Natures Operations report of the Bling! connector includes 4 fields.

ID Type Name Description Report
natures_operations TEXT Natures Operations Natures Operations natures_operations
natures_operations_default BOOLEAN Natures Operations Default Natures Operations Default natures_operations
natures_operations_description TEXT Natures Operations Description Natures Operations Description natures_operations
natures_operations_status TEXT Natures Operations Status Natures Operations Status. Available values : 0 (Inactive), 1 (Active) natures_operations

Bling! Orders Purchases fields

The Orders Purchases report of the Bling! connector includes 8 fields.

ID Type Name Description Report
order_purchases_date DATE Order Purchases Date Order Purchases Date (Pedidos Compras) orders_purchases
order_purchases_date_prevision DATE Order Purchases Date Prevision Order Purchases Date Prevision (Pedidos Compras) orders_purchases
order_purchases_id TEXT Order Purchases ID Order Purchases ID (Pedidos Compras) orders_purchases
order_purchases_number TEXT Order Purchases Number Order Purchases Number (Pedidos Compras) orders_purchases
order_purchases_status TEXT Order Purchases Status Order Purchases Status (Pedidos Compras) orders_purchases
order_purchases_supplier_id TEXT Order Purchases Supplier ID Order Purchases Supplier ID (Pedidos Compras) orders_purchases
order_purchases_total NUMERIC Order Purchases Total Order Purchases Total (Pedidos Compras) orders_purchases
order_purchases_total_products NUMERIC Order Purchases Total Products Order Purchases Total Products (Pedidos Compras) orders_purchases

Bling! Orders Sales fields

The Orders Sales report of the Bling! connector includes 15 fields.

ID Type Name Description Report
order_sales_contact_document_number TEXT Order Sales Contact Document Number Order Sales Contact Document Number (Pedidos Vendas) orders_sales
order_sales_contact_id TEXT Order Sales Contact ID Order Sales Contact ID (Pedidos Vendas) orders_sales
order_sales_contact_name TEXT Order Sales Contact Name Order Sales Contact Name (Pedidos Vendas) orders_sales
order_sales_contact_person_type TEXT Order Sales Contact Person Type Order Sales Contact Person Type (Pedidos Vendas) orders_sales
order_sales_date DATE Order Sales Date Order Sales Date (Pedidos Vendas) orders_sales
order_sales_date_out DATE Order Sales Date Out Order Sales Date Out (Pedidos Vendas) orders_sales
order_sales_date_prevision DATE Order Sales Date Prevision Order Sales Date Prevision (Pedidos Vendas) orders_sales
order_sales_id TEXT Order Sales ID Order Sales ID (Pedidos Vendas) orders_sales
order_sales_number TEXT Order Sales Number Order Sales Number (Pedidos Vendas) orders_sales
order_sales_number_store TEXT Order Sales Number Store Order Sales Number Store (Pedidos Vendas) orders_sales
order_sales_status_id TEXT Order Sales Status ID Order Sales Status ID (Pedidos Vendas) orders_sales
order_sales_status_value TEXT Order Sales Status Value Order Sales Status Value (Pedidos Vendas) orders_sales
order_sales_store_id TEXT Order Sales Store ID Order Sales Store ID (Pedidos Vendas) orders_sales
order_sales_total NUMERIC Order Sales Total Order Sales Total (Pedidos Vendas) orders_sales
order_sales_total_products NUMERIC Order Sales Total Products Order Sales Total Products (Pedidos Vendas) orders_sales

Bling! Payment Methods fields

The Payment Methods report of the Bling! connector includes 6 fields.

ID Type Name Description Report
payment_methods_default BOOLEAN Payment Methods Default Payment Methods Default payment_methods
payment_methods_description TEXT Payment Methods Description Payment Methods Description payment_methods
payment_methods_fixed BOOLEAN Payment Methods Fixed Payment Methods Fixed payment_methods
payment_methods_id TEXT Payment Methods ID Payment Methods ID payment_methods
payment_methods_payment_type TEXT Payment Methods Payment Type Payment Methods Payment Type. Available values : 1 (Money), 2 (Check), 3 (Credit Card), 4 (Debit Card), 5 (Store Credit), 10 (Meal Ticket), 11 (Meal Ticket), 12 (Gift Voucher), 13 (Fuel Voucher), 14 (Commercial Duplicate), 15 (Bank Slip), 16 (Bank Deposit), 17 (Instant Payment (PIX)), 18 (Bank Transfer, Digital Wallet), 19 (Loyalty Program, Cashback, Virtual Credit), 90 (No payment), 99 (Others) payment_methods
payment_methods_status TEXT Payment Methods Status Payment Methods Status. Available values : 1 (Active), 0 (Inactive) payment_methods

Bling! Products fields

The Products report of the Bling! connector includes 8 fields.

ID Type Name Description Report
product_code TEXT Product Code (product_code) Product Code products
product_format TEXT Product Format Product Format products
product_id TEXT Product ID Product ID products
product_name TEXT Product Name Product Name products
product_price NUMERIC Product Price Product Price products
product_short_description TEXT Product Short Description Product Short Description products
product_status TEXT Product Status Product Status products
product_type TEXT Product Type Product Type Available values : P (Produtos), S (Serviços), E (Composições), PS (Produtos simples), C (Com variações), V (Variações) products

Bling! Products Suppliers fields

The Products Suppliers report of the Bling! connector includes 8 fields.

ID Type Name Description Report
products_suppliers_code TEXT Products Suppliers Code Products Suppliers Code products_suppliers
products_suppliers_cost_price NUMERIC Products Suppliers Cost Price Products Suppliers Cost Price products_suppliers
products_suppliers_default BOOLEAN Products Suppliers Default Products Suppliers Default products_suppliers
products_suppliers_description TEXT Products Suppliers Description Products Suppliers Description products_suppliers
products_suppliers_id TEXT Products Suppliers ID Products Suppliers ID products_suppliers
products_suppliers_product_id TEXT Products Suppliers Product ID Products Suppliers Product ID products_suppliers
products_suppliers_purchase_price NUMERIC Products Suppliers Purchase Price Products Suppliers Purchase Price products_suppliers
products_suppliers_supplier_id TEXT Products Suppliers Supplier ID Products Suppliers Supplier ID products_suppliers

Bling! Sellers fields

The Sellers report of the Bling! connector includes 6 fields.

ID Type Name Description Report
sellers_contact_id TEXT Sellers Contact ID Sellers Contact ID sellers
sellers_contact_name TEXT Sellers Contact Name Sellers Contact Name sellers
sellers_contact_status TEXT Sellers Contact Status Sellers Contact Status sellers
sellers_discount_limit NUMERIC Sellers Discount Limit Sellers Discount Limit sellers
sellers_id TEXT Sellers ID Sellers ID sellers
sellers_store_id TEXT Sellers Store ID Sellers Store ID sellers

Bling! Service Invoices fields

The Service Invoices report of the Bling! connector includes 11 fields.

ID Type Name Description Report
service_invoices_contact_document_number TEXT Service Invoices Contact Document Number Service Invoices Contact Document Number service_invoices
service_invoices_contact_email TEXT Service Invoices Contact Email Service Invoices Contact Email service_invoices
service_invoices_contact_id TEXT Service Invoices Contact ID Service Invoices Contact ID service_invoices
service_invoices_contact_name TEXT Service Invoices Contact Name Service Invoices Contact Name service_invoices
service_invoices_id TEXT Service Invoices ID Service Invoices ID service_invoices
service_invoices_issue_date DATE Service Invoices Issue Date Service Invoices Issue Date service_invoices
service_invoices_number TEXT Service Invoices Number Service Invoices Number service_invoices
service_invoices_rps_number TEXT Service Invoices RPS Number Service Invoices RPS Number service_invoices
service_invoices_series TEXT Service Invoices Series Service Invoices Series service_invoices
service_invoices_status TEXT Service Invoices Status Service Invoices Status. Available values : 1 (Pending), 2 (Issued), 3 (Available for consultation), 4 (Canceled) service_invoices
service_invoices_value NUMERIC Service Invoices Value Service Invoices Value service_invoices

Bling! Situations Modules fields

The Situations Modules report of the Bling! connector includes 4 fields.

ID Type Name Description Report
situations_modules_create_situations BOOLEAN Situations Modules Create Situations Situations Modules Create Situations situations_modules
situations_modules_description TEXT Situations Modules Description Situations Modules Description situations_modules
situations_modules_id TEXT Situations Modules ID Situations Modules ID situations_modules
situations_modules_name TEXT Situations Modules Name Situations Modules Name situations_modules

Bling! other fields

The Bling! connector has 25 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID Type Name Description Report
account_id TEXT Account ID The Account ID
account_name TEXT Account Name The Account Name
accounting_accounts_description TEXT Accounting Accounts Description Accounting Accounts Description accounting_accounts
accounting_accounts_id TEXT Accounting Accounts ID Accounting Accounts ID accounting_accounts
contacts_types_description TEXT Contacts Types Description Contacts Types Description contacts_types
contacts_types_id TEXT Contacts Types ID Contacts Types ID contacts_types
data_fetched_at TIMESTAMP Data fetched at UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource TEXT Data Source The name of the Windsor connector returning the row
date DATE Date The Date
day_of_month TEXT Day of month Day of the month
month TEXT Month Number of the month
now TIMESTAMP Now Current timestamp
source TEXT Source The name of the Windsor connector returning the row
today DATE Today Today's date
week TEXT Week Week (Sun-Sat).
week_day TEXT Day of week and day number Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso TEXT Day of week and day number, ISO Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso TEXT Week ISO Week, ISO format (Mon-Sun).
year TEXT Year Year
year_month TEXT Yearmonth Year and month, e.g. 2024|3
year_month_name TEXT Year month name Year and month with the month name written out, e.g. "Jan 2025".
year_of_week TEXT Year of week The year that contains first day of the week (Sun-Sat).
year_of_week_iso TEXT Year of week, ISO The year that contains first day of the ISO week (Mon-Sun).
year_week TEXT Year week Year and week for US weeks (Sun-Sat), e.g. 2024|15
year_week_iso TEXT Year week ISO Year and week for ISO weeks (Mon-Sun), e.g. 2024|20