Suggest edit
Help us improve the documentation
Did you see wrong information and would you like us to explain something else or improve our manuals? Please leave your suggestions on GitHub.

Search and Reconciliation

An important part of the generation of payments is the reconciliation. The API allows you to search your advanced payments in order to reconcile all the transactions that were made through your Marketplace.

It is possible to search through the Advanced Payments API.

Request

Curl

curl -X GET \
    -H 'Accept: application/json' \
    -H 'Content-Type: application/json' \
    'https://api.mercadopago.com/v1/advanced_payments/search?access_token=MKT_ACCESS_TOKEN&limit=10&offset=0'

Response

Which returns the results in a structure that also shows the amount of results and information for its pagination.

Json

{
  "paging": {
    "total": 3,
    "limit": 10,
    "offset": 0
  },
  "results": [
    {
      "id": 11111111,
      "status": "approved",
      ...
    },
    {
      "id": 22222222,
      "status": "rejected",
      ...
    },
    {
      "id": 33333333,
      "status": "pending",
      ...
    }
  ]
}

Search filters

State Description
status Advanced Payment status.
payments.id Buyer’s payment ID.
payments.payment_method_id Payment method.
payments.payment_type_id Payment type.
payer.id Buyer ID.
payer.email Buyer’s email address.
disbursement.collector_id Seller ID.
external_reference ID generated by the marketplace which identifies the Advanced Payment.

Search filters by date range

It is also possible to search setting specific dates:

  • range: Search attribute, can be date_created or date_last_updated.
  • begin_date: Start date of the search (ISO 8601), e.g. 2017-05-06T00:00:00.000-04:00.
  • end_date: End date of the search (ISO 8601), e.g. 2017-05-06T23:59:59.999-04:00.

Request

Curl

curl -X GET \
    -H 'Accept":"application/json' \
    -H 'Content-Type: application/json' \
    'https://api.mercadopago.com/v1/advanced_payments/search?access_token=MKT_ACCESS_TOKEN&range=date_created&begin_date=2017-05-06T00:00:00.000-04:00&end_date=2017-05-06T23:59:59.999-04:00'

Export Activities

There is also the possibility of exporting the activities from the list of your Mercado Pago account with the link Export.

export_activities

You can select the filters you need and choose the CSV or XLS format to perform the reconciliation manually.

export_activities_2

Your search returns no results.

Verifique a ortografia de termos de pesquisa ou teste com outras palavras-chave.