---
title: "Get Funding Payment Report File"
method: GET
path: "/v1/perpetuals/fundingpaymentreport/records.xlsx"
tags: ["Derivatives"]
---

# Get Funding Payment Report File

`GET /v1/perpetuals/fundingpaymentreport/records.xlsx`

## Request

- Base URL: `https://api.gemini.com`
- URL: `https://api.gemini.com/v1/perpetuals/fundingpaymentreport/records.xlsx`
- Auth: API key in header `X-GEMINI-APIKEY` and API key in header `X-GEMINI-SIGNATURE` and API key in header `X-GEMINI-PAYLOAD`

### Roles
The API key you use to access this endpoint must have the Trader or Auditor role assigned. See <a href="/roles#roles">Roles</a> for more information.

The OAuth scope must have `orders:read` assigned to access this endpoint. See [OAuth Scopes](/authentication/oauth#oauth-scopes) for more information.

### Examples
- `&fromDate=2024-04-10&toDate=2024-04-25&numRows=1000` </br>
  Compare and obtain the minimum records between (2024-04-10 to 2024-04-25) and 1000. If (2024-04-10 to 2024-04-25) contains 360 records. Then fetch the minimum between 360 and 1000 records only.

- `&numRows=2024-04-10&toDate=2024-04-25` </br>
  If (2024-04-10 to 2024-04-25) contains 360 records. Then fetch 360 records only.

- `&numRows=1000` </br>
  Fetch maximum 1000 records starting from Now to a historical date

- `<blank>` </br>
  Fetch maximum 8760 records starting from Now to a historical date

## Query parameters

- `fromDate` string, date
- `toDate` string, date
- `numRows` integer

## Headers

- `X-GEMINI-APIKEY` string, required
- `X-GEMINI-SIGNATURE` string, required
- `X-GEMINI-PAYLOAD` string, required
- `Content-Type` string
- `Content-Length` string
- `Cache-Control` string

## Request body

- object
  - `request` string, required: The API endpoint path
  - `nonce` union, required: timestamp
    - string: Gemini strongly recommends using milliseconds instead of seconds for timestamps. | Timestamp format | Example | Supported request type | |-----------------------|-----------------------|------------------------| | string (seconds) | `1495127793` | `POST` only | | string (milliseconds) | `1495127793000` | `POST` only |
    - integer: Gemini strongly recommends using milliseconds instead of seconds for timestamps. | Timestamp format | Example | Supported request type | |-----------------------------|---------------------------|------------------------| | whole number (seconds) | `1495127793` | `GET`, `POST` | | whole number (milliseconds) | `1495127793000` | `GET`, `POST` |
  - `account` string: Required for Master API keys as described in [Private API Invocation](/authentication/api-key#private-api-invocation). The name of the account within the subaccount group. Specifies the account on which you intend to place the order. Only available for exchange accounts.

## Response `200`

XLSX file downloaded containing funding payment report.

## Other responses

- `400`: Bad request - malformed request or invalid parameters
- `404`: Resource not found
- `429`: Too many requests - you have exceeded the rate limit
- `500`: Internal server error

---

[API](https://skmtc.dev/gemini/apis/rest-api.md) - [All operations](https://skmtc.dev/gemini/apis/rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/gemini/apis/rest-api/revisions/24979792d748?raw)