Skip to main content
GET
/
v1
/
businesses
/
{businessId}
/
reports
/
transactions
/
exports
/
excel
Export transactions as Excel
curl --request GET \
  --url https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/excel \
  --header 'Authorization: Bearer <token>'
{
  "type": "S3_Presigned_Url",
  "presignedUrl": "https://example-bucket.s3.amazonaws.com/example-object?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=FAKEAWSACCESSKEY%2F20240710%2Fus-west-1%2Fs3%2Faws4_request&X-Amz-Date=20240710T000000Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=FAKESIGNATURE1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef\n",
  "fileType": "csv"
}

Authorizations

ā€‹
Authorization
string
header
required

Bearer authentication header of the form Bearer <token>, where <token> is your auth token.

Headers

ā€‹
Content-Type
string

Content-Type must be set to application/json

Path Parameters

ā€‹
businessId
string
required

The UUID of the business to export transactions for

Query Parameters

ā€‹
start_date
string<date-time>

Start date for transaction filtering (ISO 8601 format)

ā€‹
end_date
string<date-time>

End date for transaction filtering (ISO 8601 format)

ā€‹
account_filter
string

Filter transactions by account

ā€‹
categorization_status
enum<string>

Filter by categorization status

Available options:
CATEGORIZED,
UNCATEGORIZED,
PENDING

Response

Pre-signed URL for downloading the Excel export

A pre-signed URL to download a document

ā€‹
type
string

Resource type. Value will be 'S3_Presigned_Url'.

Example:

"S3_Presigned_Url"

ā€‹
presignedUrl
string

Pre-signed URL to download a document

Example:

"https://example-bucket.s3.amazonaws.com/example-object?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=FAKEAWSACCESSKEY%2F20240710%2Fus-west-1%2Fs3%2Faws4_request&X-Amz-Date=20240710T000000Z&X-Amz-Expires=3600&X-Amz-SignedHeaders=host&X-Amz-Signature=FAKESIGNATURE1234567890abcdef1234567890abcdef1234567890abcdef1234567890abcdef\n"

ā€‹
fileType
string

The file type of the document

Example:

"csv"