Pagar.me

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

  1. Dê um nome ao seu conector (por exemplo, Pagar.me)
  2. Insira a Chave de API obtida no passo (2)
  3. 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

email

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