O Pagar.me é uma solução de pagamento digital que nasceu em 2013 como um gateway de pagamentos, e que hoje se apresenta como um Payment Service Provider, o que significa que é responsável pela intermediação entre clientes, vendedores e adquirentes.
Contando com integrações com as maiores plataformas de e-commerce disponíveis no mercado hoje (Magento, Opencart, Woocommerce, Prestashop, Dotstore, Vtex, Loja Integrada e Beta Labs), os pagamentos processados pelo Pagar.me podem ser feitos em cartão de crédito e boleto bancário.
Além de fazer toda a gestão de pagamentos, o Pagar.me também dispõe de funcionalidades que permitem o acompanhamento de vendas e conversão do seu site, mostra informações dos seus clientes e ajuda no controle do seu fluxo de caixa.
Adicionando o conector
Para gerar métricas com os dados do Pagar.me, a Kondado criou um conector que integra todas as informações ao seu banco de dados, basta adicioná-lo na plataforma da Kondado, seguindo os passos abaixo:
1) Faça login na sua conta do Pagar.me e, à esquerda no menu lateral, clique em “Configurações” > “Dados da API” (ou acesse diretamente em https://beta.dashboard.pagar.me/#/settings/api_keys)
2) Uma vez na página de “DADOS DA API”, localize a sua chave que estará em “Live”, clique no botão “Revelar” e copie o valor exibido
3) Faça login na plataforma da Kondado
4) Com a Chave de API gerada no passo (2), vá para a página de adição de conectores e selecione o conector do Pagar.me
5) Para adicionar o conector, siga esses passos conforme figura abaixo
- Dê um nome ao seu conector (por exemplo, Pagar.me)
- Insira a Chave de API obtida no passo (2)
- Clique em Salvar
Integrações
Gráfico de relacionamento entre tabelas
Transações
Objeto principal
Campo | Tipo | |
---|---|---|
id |
float |
|
tid |
float |
|
date_updated |
timestamp |
|
authorized_amount |
float |
|
acquirer_id |
text |
|
nsu |
float |
|
card_holder_name |
text |
|
postback_url |
text |
|
billing__object |
text |
|
billing__id |
float |
|
billing__address__city |
text |
|
billing__address__state |
text |
|
billing__address__street |
text |
|
billing__address__neighborhood |
text |
|
billing__address__street_number |
text |
|
billing__address__complementary |
text |
|
billing__address__country |
text |
|
billing__address__object |
text |
|
billing__address__zipcode |
text |
|
billing__address__id |
float |
|
billing__name |
text |
|
acquirer_name |
text |
|
addition |
text |
|
antifraud_metadata |
text |
|
receipt_url |
text |
|
payment_method |
text |
|
split_rules |
text |
|
card_brand |
text |
|
card_pin_mode |
text |
|
authorization_code |
text |
|
phone |
text |
|
referer |
text |
|
card_magstripe_fallback |
boolean |
|
status_reason |
text |
|
card_last_digits |
text |
|
soft_descriptor |
text |
|
customer__external_id |
text |
|
customer__object |
text |
|
customer__birthday |
text |
|
customer__phone_numbers |
text |
|
customer__document_type |
text |
|
customer__id |
float |
|
customer__name |
text |
|
customer__country |
text |
|
customer__document_number |
text |
|
customer__born_at |
text |
|
customer__gender |
text |
|
customer__date_created |
timestamp |
|
customer__type |
text |
|
customer__email |
text |
|
refunded_amount |
float |
|
boleto_url |
text |
|
acquirer_response_code |
text |
|
reference_key |
text |
|
fraud_covered |
boolean |
|
ip |
text |
|
boleto_barcode |
text |
|
cost |
float |
|
refuse_reason |
text |
|
risk_level |
text |
|
paid_amount |
float |
|
order_id |
text |
|
subscription_id |
text |
|
metadata__offer_id |
text |
|
status |
text |
|
capture_method |
text |
|
local_transaction_id |
text |
|
object |
text |
|
discount |
text |
|
address |
text |
|
device |
text |
|
payment |
text |
|
card__holder_name |
text |
|
card__date_updated |
timestamp |
|
card__brand |
text |
|
card__object |
text |
|
card__first_digits |
text |
|
card__fingerprint |
text |
|
card__id |
text |
|
card__last_digits |
text |
|
card__country |
text |
|
card__valid |
boolean |
|
card__expiration_date |
text |
|
card__date_created |
timestamp |
|
boleto_expiration_date |
text |
|
shipping__fee |
float |
|
shipping__name |
text |
|
shipping__object |
text |
|
shipping__expedited |
boolean |
|
shipping__address__city |
text |
|
shipping__address__state |
text |
|
shipping__address__street |
text |
|
shipping__address__neighborhood |
text |
|
shipping__address__street_number |
text |
|
shipping__address__complementary |
text |
|
shipping__address__country |
text |
|
shipping__address__object |
text |
|
shipping__address__zipcode |
text |
|
shipping__address__id |
float |
|
shipping__id |
float |
|
shipping__delivery_date |
date |
|
amount |
float |
|
local_time |
text |
|
antifraud_score |
text |
|
installments |
float |
|
date_created |
timestamp |
|
card_first_digits |
text |
customer->documents
Campo | Tipo | |
---|---|---|
transaction_id |
float |
|
customer__id |
float |
|
customer__documents__object |
text |
|
customer__documents__type |
text |
|
customer__documents__id |
text |
|
customer__documents__number |
text |
items
Campo | Tipo | |
---|---|---|
transaction_id |
float |
|
items__category |
text |
|
items__tangible |
boolean |
|
items__title |
text |
|
items__date |
text |
|
items__object |
text |
|
items__venue |
text |
|
items__id |
text |
|
items__unit_price |
float |
|
items__quantity |
float |
Assinaturas
Campo | Tipo | |
---|---|---|
payment_method |
text |
|
id |
float |
|
postback_url |
text |
|
current_period_end |
timestamp |
|
date_updated |
timestamp |
|
card_brand |
text |
|
card_last_digits |
text |
|
metadata__plan_name |
text |
|
metadata__plan_id |
float |
|
status |
text |
|
settled_charges |
text |
|
manage_url |
text |
|
object |
text |
|
phone__id |
float |
|
phone__ddi |
text |
|
phone__object |
text |
|
phone__number |
text |
|
phone__ddd |
text |
|
plan__invoice_reminder |
text |
|
plan__color |
text |
|
plan__object |
text |
|
plan__trial_days |
float |
|
plan__id |
float |
|
plan__name |
text |
|
plan__charges |
float |
|
plan__days |
float |
|
plan__payment_methods |
text |
|
plan__payment_deadline_charges_interval |
float |
|
plan__amount |
float |
|
plan__installments |
float |
|
plan__date_created |
timestamp |
|
address__city |
text |
|
address__state |
text |
|
address__street |
text |
|
address__neighborhood |
text |
|
address__street_number |
text |
|
address__complementary |
text |
|
address__country |
text |
|
address__object |
text |
|
address__zipcode |
text |
|
address__id |
float |
|
card__holder_name |
text |
|
card__date_updated |
timestamp |
|
card__brand |
text |
|
card__object |
text |
|
card__first_digits |
text |
|
card__fingerprint |
text |
|
card__id |
text |
|
card__last_digits |
text |
|
card__country |
text |
|
card__valid |
boolean |
|
card__expiration_date |
text |
|
card__date_created |
timestamp |
|
soft_descriptor |
text |
|
customer__external_id |
text |
|
customer__object |
text |
|
customer__birthday |
text |
|
customer__phone_numbers |
text |
|
customer__document_type |
text |
|
customer__id |
float |
|
customer__documents |
text |
|
customer__name |
text |
|
customer__country |
text |
|
customer__document_number |
text |
|
customer__born_at |
text |
|
customer__gender |
text |
|
customer__date_created |
timestamp |
|
customer__type |
text |
|
customer__email |
text |
|
current_period_start |
timestamp |
|
current_transaction__date_updated |
timestamp |
|
current_transaction__authorized_amount |
float |
|
current_transaction__acquirer_id |
text |
|
current_transaction__nsu |
float |
|
current_transaction__card_holder_name |
text |
|
current_transaction__postback_url |
text |
|
current_transaction__acquirer_name |
text |
|
current_transaction__addition |
text |
|
current_transaction__antifraud_metadata |
text |
|
current_transaction__receipt_url |
text |
|
current_transaction__payment_method |
text |
|
current_transaction__card_brand |
text |
|
current_transaction__card_pin_mode |
text |
|
current_transaction__authorization_code |
text |
|
current_transaction__referer |
text |
|
current_transaction__card_magstripe_fallback |
boolean |
|
current_transaction__status_reason |
text |
|
current_transaction__card_last_digits |
text |
|
current_transaction__soft_descriptor |
text |
|
current_transaction__refunded_amount |
float |
|
current_transaction__boleto_url |
text |
|
current_transaction__acquirer_response_code |
text |
|
current_transaction__reference_key |
text |
|
current_transaction__fraud_covered |
boolean |
|
current_transaction__ip |
text |
|
current_transaction__boleto_barcode |
text |
|
current_transaction__cost |
float |
|
current_transaction__refuse_reason |
text |
|
current_transaction__id |
float |
|
current_transaction__risk_level |
text |
|
current_transaction__paid_amount |
float |
|
current_transaction__order_id |
text |
|
current_transaction__tid |
float |
|
current_transaction__subscription_id |
float |
|
current_transaction__metadata__plan_name |
text |
|
current_transaction__metadata__plan_id |
float |
|
current_transaction__status |
text |
|
current_transaction__capture_method |
text |
|
current_transaction__local_transaction_id |
text |
|
current_transaction__object |
text |
|
current_transaction__discount |
text |
|
current_transaction__device |
text |
|
current_transaction__payment |
text |
|
current_transaction__boleto_expiration_date |
text |
|
current_transaction__amount |
float |
|
current_transaction__local_time |
text |
|
current_transaction__antifraud_score |
text |
|
current_transaction__installments |
float |
|
current_transaction__date_created |
timestamp |
|
current_transaction__card_first_digits |
text |
|
charges |
float |
|
date_created |
timestamp |
Clientes
Objeto principal
Campo | Tipo | |
---|---|---|
gender |
text |
|
name |
text |
|
type |
text |
|
document_number |
text |
|
object |
text |
|
text |
||
born_at |
text |
|
birthday |
text |
|
country |
text |
|
date_created |
timestamp |
|
phone_numbers |
text |
|
document_type |
text |
|
external_id |
text |
|
id |
float |
documents
Campo | Tipo | |
---|---|---|
customer_id |
float |
|
documents__object |
text |
|
documents__type |
text |
|
documents__id |
text |
|
documents__number |
text |
addresses
Campo | Tipo | |
---|---|---|
customer_id |
float |
|
addresses__city |
text |
|
addresses__state |
text |
|
addresses__street |
text |
|
addresses__neighborhood |
text |
|
addresses__street_number |
text |
|
addresses__complementary |
text |
|
addresses__country |
text |
|
addresses__object |
text |
|
addresses__zipcode |
text |
|
addresses__id |
float |
phones
Campo | Tipo | |
---|---|---|
customer_id |
float |
|
phones__id |
float |
|
phones__ddi |
text |
|
phones__object |
text |
|
phones__number |
text |
|
phones__ddd |
text |
Recebíveis
Campo | Tipo | |
---|---|---|
bulk_anticipation_id |
text |
|
payment_date |
timestamp |
|
fee |
float |
|
installment |
float |
|
accrual_date |
timestamp |
|
payment_method |
text |
|
anticipation_fee |
float |
|
object |
text |
|
originator_model_id |
text |
|
originator_model |
text |
|
status |
text |
|
amount |
float |
|
recipient_id |
text |
|
fraud_coverage_fee |
float |
|
split_rule_id |
text |
|
original_payment_date |
timestamp |
|
date_created |
timestamp |
|
type |
text |
|
id |
float |
|
transaction_id |
float |
Operações de saldo
Campo | Tipo | |
---|---|---|
id |
text |
[pt] Identificador da operação |
status |
text |
[pt] Estado do saldo da conta. Valores possíveis : waiting_funds , available e transferred |
balance_amount |
float |
[pt] Saldo atual da conta |
amount |
float |
[pt] Valor transacionado para a conta |
fee |
float |
[pt] Taxa cobrada pela transação |
movement_object__payment_method |
text |
|
movement_object__anticipation_fee |
float |
|
movement_object__fraud_coverage_fee |
float |
|
movement_object__id |
text |
|
movement_object__payment_date |
timestamp |
|
movement_object__fee |
float |
|
movement_object__accrual_date |
timestamp |
|
movement_object__date_updated |
timestamp |
|
movement_object__anticipation_id |
text |
|
movement_object__type |
text |
|
movement_object__transaction_id |
text |
|
movement_object__status |
text |
|
movement_object__object |
text |
|
movement_object__target_id |
text |
|
movement_object__source_type |
text |
|
movement_object__funding_estimated_date |
timestamp |
|
movement_object__split_rule_id |
text |
|
bank_account__bank_code |
text |
|
bank_account__charge_transfer_fees |
boolean |
|
bank_account__object |
text |
|
bank_account__conta_dv |
text |
|
bank_account__agencia |
text |
|
bank_account__document_type |
text |
|
bank_account__id |
text |
|
bank_account__legal_name |
text |
|
bank_account__conta |
text |
|
bank_account__agencia_dv |
text |
|
bank_account__document_number |
text |
|
bank_account__date_created |
timestamp |
|
bank_account__type |
text |
|
movement_object__bulk_anticipation_id |
text |
|
movement_object__original_payment_date |
timestamp |
|
movement_object__installment |
float |
|
movement_object__target_type |
text |
|
movement_object__funding_date |
timestamp |
|
movement_object__amount |
float |
|
movement_object__recipient_id |
text |
|
movement_object__source_id |
text |
|
movement_object__date_created |
timestamp |
|
date_created |
timestamp |
[pt] Data da movimentação |
object |
text |
|
type |
text |
[pt] O que gerou a movimentação. Valores possíveis : payable , refund , anticipation , transfer ou fee_collection |