# Export transfer details

GET https://api-sandbox.payabli.com/api/Export/transferDetails/{format}/{entry}/{transferId}

Export a list of transfer details for an entrypoint. Use filters to limit results.

Reference: https://docs.payabli.com/developers/api-reference/export/export-list-of-transferdetails

## OpenAPI Specification

```yaml
openapi: 3.1.1
info:
  title: Export list of transfer details
  version: endpoint_export.ExportTransferDetails
paths:
  /Export/transferDetails/{format}/{entry}/{transferId}:
    get:
      operationId: export-transfer-details
      summary: Export list of transfer details
      description: >-
        Export a list of transfer details for an entrypoint. Use filters to
        limit results.
      tags:
        - - subpackage_export
      parameters:
        - name: format
          in: path
          description: 'Format for the export, either XLSX or CSV. '
          required: true
          schema:
            $ref: '#/components/schemas/type_export:ExportFormat1'
        - name: entry
          in: path
          description: >-
            The paypoint's entrypoint identifier. [Learn
            more](/developers/api-reference/api-overview#entrypoint-vs-entry)
          required: true
          schema:
            type: string
        - name: transferId
          in: path
          description: Transfer identifier.
          required: true
          schema:
            type: integer
            format: int64
        - name: columnsExport
          in: query
          required: false
          schema:
            type: string
        - name: fromRecord
          in: query
          description: >-
            The number of records to skip before starting to collect the result
            set.
          required: false
          schema:
            type: integer
            default: 0
        - name: limitRecord
          in: query
          description: >-
            The number of records to return for the query. The maximum is 30,000
            records. When this parameter isn't sent, the API returns up to
            25,000 records.
          required: false
          schema:
            type: integer
            default: 25000
        - name: parameters
          in: query
          description: >-
            Collection of field names, conditions, and values used to filter the
            query


            <Info>
              **You must remove `parameters=` from the request before you send it, otherwise Payabli will ignore the filters.**

              Because of a technical limitation, you can't make a request that includes filters from the API console on this page. The response won't be filtered. Instead, copy the request, remove `parameters=` and run the request in a different client.

              For example:

              --url https://api-sandbox.payabli.com/api/Query/transactions/org/236?parameters=totalAmount(gt)=1000&limitRecord=20

              should become:

              --url https://api-sandbox.payabli.com/api/Query/transactions/org/236?totalAmount(gt)=1000&limitRecord=20
            </Info>


            See [Filters and Conditions
            Reference](/developers/developer-guides/pay-ops-reporting-engine-overview#filters-and-conditions-reference)
            for help. 


            List of field names accepted:

              - `grossAmount` (gt, ge, lt, le, eq, ne)

              - `chargeBackAmount` (gt, ge, lt, le, eq, ne)

              - `returnedAmount` (gt, ge, lt, le, eq, ne)

              - `billingFeeAmount` (gt, ge, lt, le, eq, ne)

              - `thirdPartyPaidAmount` (gt, ge, lt, le, eq, ne)

              - `netFundedAmount` (gt, ge, lt, le, eq, ne)

              - `adjustmentAmount` (gt, ge, lt, le, eq, ne)

              - `transactionId` (eq, ne, in, nin)

              - `category` (eq, ne, ct, nct)

              - `type` (eq, ne, in, nin)

              - `method` (eq, ne, in, nin)
          required: false
          schema:
            type: object
            additionalProperties:
              type: string
        - name: sortBy
          in: query
          description: >-
            The field name to use for sorting results. Use `desc(field_name)` to
            sort descending by `field_name`, and use `asc(field_name)` to sort
            ascending by `field_name`.
          required: false
          schema:
            type: string
        - name: requestToken
          in: header
          required: true
          schema:
            type: string
      responses:
        '200':
          description: Success
          content:
            application/json:
              schema:
                $ref: '#/components/schemas/type_:File'
        '400':
          description: Bad request/ invalid data
          content: {}
        '401':
          description: Unauthorized request.
          content: {}
        '500':
          description: Internal API Error
          content: {}
        '503':
          description: Database connection error
          content: {}
components:
  schemas:
    type_export:ExportFormat1:
      type: string
      enum:
        - value: csv
        - value: xlsx
    type_:File:
      type: object
      additionalProperties:
        description: Any type

```

## SDK Code Examples

```python
from payabli import payabli

client = payabli(
    api_key="YOUR_API_KEY",
)
client.export.export_transfer_details(
    entry="8cfec329267",
    format="csv",
    transfer_id=1000000,
    columns_export="BatchDate:Batch_Date,PaypointName:Legal_name",
    from_record=251,
    limit_record=1000,
    sort_by="desc(field_name)",
)

```

```typescript
import { PayabliClient } from "@payabli/sdk-node";

const client = new PayabliClient({ apiKey: "YOUR_API_KEY" });
await client.export.exportTransferDetails("csv", "8cfec329267", 1000000, {
    columnsExport: "BatchDate:Batch_Date,PaypointName:Legal_name",
    fromRecord: 251,
    limitRecord: 1000,
    sortBy: "desc(field_name)"
});

```

```go
import (
	context "context"
	option "github.com/payabli/sdk-go/option"
	sdkgo "github.com/payabli/sdk-go"
	sdkgoclient "github.com/payabli/sdk-go/client"
)

client := sdkgoclient.NewClient(
	option.WithApiKey(
		"<YOUR_ApiKey>",
	),
)
response, err := client.Export.ExportTransferDetails(
	context.TODO(),
	"8cfec329267",
	sdkgo.ExportFormat1Csv,
	1000000,
	&sdkgo.ExportTransferDetailsRequest{
		ColumnsExport: sdkgo.String(
			"BatchDate:Batch_Date,PaypointName:Legal_name",
		),
		FromRecord: sdkgo.Int(
			251,
		),
		LimitRecord: sdkgo.Int(
			1000,
		),
		SortBy: sdkgo.String(
			"desc(field_name)",
		),
	},
)

```

```csharp
using PayabliApi;

var client = new PayabliApiClient("API_KEY");
await client.Export.ExportTransferDetailsAsync(
    "8cfec329267",
    ExportFormat1.Csv,
    1000000,
    new ExportTransferDetailsRequest
    {
        ColumnsExport = "BatchDate:Batch_Date,PaypointName:Legal_name",
        FromRecord = 251,
        LimitRecord = 1000,
        SortBy = "desc(field_name)",
    }
);

```

```ruby
require 'uri'
require 'net/http'

url = URI("https://api-sandbox.payabli.com/api/Export/transferDetails/csv/8cfec329267/1000000?columnsExport=BatchDate%3ABatch_Date%2CPaypointName%3ALegal_name&fromRecord=251&limitRecord=1000&sortBy=desc%28field_name%29")

http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true

request = Net::HTTP::Get.new(url)
request["requestToken"] = '<apiKey>'

response = http.request(request)
puts response.read_body
```

```java
HttpResponse<String> response = Unirest.get("https://api-sandbox.payabli.com/api/Export/transferDetails/csv/8cfec329267/1000000?columnsExport=BatchDate%3ABatch_Date%2CPaypointName%3ALegal_name&fromRecord=251&limitRecord=1000&sortBy=desc%28field_name%29")
  .header("requestToken", "<apiKey>")
  .asString();
```

```php
<?php

$client = new \GuzzleHttp\Client();

$response = $client->request('GET', 'https://api-sandbox.payabli.com/api/Export/transferDetails/csv/8cfec329267/1000000?columnsExport=BatchDate%3ABatch_Date%2CPaypointName%3ALegal_name&fromRecord=251&limitRecord=1000&sortBy=desc%28field_name%29', [
  'headers' => [
    'requestToken' => '<apiKey>',
  ],
]);

echo $response->getBody();
```

```swift
import Foundation

let headers = ["requestToken": "<apiKey>"]

let request = NSMutableURLRequest(url: NSURL(string: "https://api-sandbox.payabli.com/api/Export/transferDetails/csv/8cfec329267/1000000?columnsExport=BatchDate%3ABatch_Date%2CPaypointName%3ALegal_name&fromRecord=251&limitRecord=1000&sortBy=desc%28field_name%29")! as URL,
                                        cachePolicy: .useProtocolCachePolicy,
                                    timeoutInterval: 10.0)
request.httpMethod = "GET"
request.allHTTPHeaderFields = headers

let session = URLSession.shared
let dataTask = session.dataTask(with: request as URLRequest, completionHandler: { (data, response, error) -> Void in
  if (error != nil) {
    print(error as Any)
  } else {
    let httpResponse = response as? HTTPURLResponse
    print(httpResponse)
  }
})

dataTask.resume()
```