Skip to main content

Export Data

Reports allows exporting a .csv format file with your charges, which can be set up to have the fields based on your needs, and be received by e-mail.

Through Dashboard, you can:

  • Export charges with autonomously, being able to later import the data into some spreadsheet tool;
  • Apply the filter and choose the file columns based on your needs, like charge status, provider, merchant, and other detailed filters.

Exporting data through Dashboard​

  1. Sign in to your account, in the charges section, click on the "export" button:

  1. In the side menu, you will be able to choose:
  • Date range to export the charges
  • Payment method
  • Charge status
  • Merchant
  • Charge, payment and customer data selection
Status filterPayment method filterMerchant filterColumn data selection
info

If the user clicks on the "Reports" button, with filters already applied on the charges list, the side menu will show the applied filters and give to the user the option to clear these or export as the filters applied

  1. After applying filters and selecting the fields, you can click on "Download Results" and the data will be sent to your e-mail (the e-mail will be the one registered to your logged-in Dashboard account).

Exporting data through API​

It's possible to export data through the reports API as well, you can find details about the requests in the service documentation. Here's an example of a request made to the reports API:

curl --location --request POST 'https://api.dev.malga.io/v1/reports' \
--header 'X-Client-Id: <your_x_client_id>' \
--header 'X-Api-key: <your_x_api_key>' \
--header 'accept-language: en-US' \
--header 'User-Timezone: America/Sao_Paulo' \
--header 'Content-Type: application/json' \
--data-raw '{
  "fields": [
     "customer__client_id",
     "customer__name",
     "customer__email",
     "customer__phone_number",
     "customer__document_number",
     "customer__customer_adress_id",
     "customer_address__complement",
     "customer_address__zip_code",
     "customer_address__street",
     "customer_address__street_number",
     "customer_address__state",
     "customer_address__city",
     "customer_address__district",
     "customer_address__country",
     "transaction__id",
     "transaction__amount",
     "transaction__original_amount",
     "transaction__created_at",
     "transaction__currency",
     "transaction__description",
     "transaction__order_id",
     "transaction__merchant_id",
     "transaction_request__created_at",
     "transaction_request__payment_method",
     "transaction_request__provider_id",
     "transaction__installments",
     "transaction__status",
     "transaction__statement_descriptor",
     "provider__name"
  ],
  "sendTo": "test@test.com",
  "type": "transactions",
  "filters": {
    "transactionRequestPaymentMethod": ["pix"],
    "transactionCreatedAt": {
      "gte": "2022-08-09T03:00:00.000Z",
      "lte": "2023-02-14T02:50:00.000Z"
    }
  }
}'