curl --request GET \
--url https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv \
--header 'Authorization: Bearer <token>'import requests
url = "https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"data": {
"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",
"fileName": "receipt.pdf",
"createdAt": "2023-11-07T05:31:56Z",
"type": "S3_Presigned_Url",
"documentId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"document_type": "RECEIPT"
}
}{
"type": "InvalidParameters",
"description": "<string>",
"error_enum": "InvalidPayload",
"meta": {}
}Export transactions as CSV
Exports transaction data as a CSV file. Returns a pre-signed URL for downloading the generated CSV file.
curl --request GET \
--url https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv \
--header 'Authorization: Bearer <token>'import requests
url = "https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv"
headers = {"Authorization": "Bearer <token>"}
response = requests.get(url, headers=headers)
print(response.text)const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};
fetch('https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv', options)
.then(res => res.json())
.then(res => console.log(res))
.catch(err => console.error(err));<?php
$curl = curl_init();
curl_setopt_array($curl, [
CURLOPT_URL => "https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_HTTPHEADER => [
"Authorization: Bearer <token>"
],
]);
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
echo $response;
}package main
import (
"fmt"
"net/http"
"io"
)
func main() {
url := "https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv"
req, _ := http.NewRequest("GET", url, nil)
req.Header.Add("Authorization", "Bearer <token>")
res, _ := http.DefaultClient.Do(req)
defer res.Body.Close()
body, _ := io.ReadAll(res.Body)
fmt.Println(string(body))
}HttpResponse<String> response = Unirest.get("https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv")
.header("Authorization", "Bearer <token>")
.asString();require 'uri'
require 'net/http'
url = URI("https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/transactions/exports/csv")
http = Net::HTTP.new(url.host, url.port)
http.use_ssl = true
request = Net::HTTP::Get.new(url)
request["Authorization"] = 'Bearer <token>'
response = http.request(request)
puts response.read_body{
"data": {
"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",
"fileName": "receipt.pdf",
"createdAt": "2023-11-07T05:31:56Z",
"type": "S3_Presigned_Url",
"documentId": "3c90c3cc-0d44-4b50-8888-8dd25736052a",
"document_type": "RECEIPT"
}
}{
"type": "InvalidParameters",
"description": "<string>",
"error_enum": "InvalidPayload",
"meta": {}
}Authorizations
Bearer authentication header of the form Bearer <token>, where <token> is your auth token.
Headers
Content-Type must be set to application/json.
Path Parameters
The UUID of the business to export transactions for.
Query Parameters
Start date for transaction filtering (ISO 8601 format).
End date for transaction filtering (ISO 8601 format).
Comma-separated list of Layer external account UUIDs (Layer's internal identifier for an external account, e.g. a linked Plaid account). Filters transactions to those within the provided list of accounts. Unlike source_account_ids, these are Layer-assigned IDs rather than the external provider's account IDs. Takes precedence over account_filter if both are specified.
Comma-separated list of Layer bank account UUIDs. Filters transactions by their owning bank account. A bank account may back multiple external accounts (Plaid, Unit, Stripe Treasury, or custom), so this provides a higher-level filter than external_account_ids.
Comma-separated list of external provider account IDs. Filters transactions by their source account ID from the external provider (e.g., Plaid account ID, Unit account ID, Stripe financial account ID, or custom account external ID).
Filter transactions by external account ID. This is a legacy alias for external_account_ids - prefer using external_account_ids instead. Only used when external_account_ids is not specified.
Filter by transaction direction.
INFLOW, OUTFLOW The minimum amount of the transaction to include (in cents).
The maximum amount of the transaction to include (in cents).
Filter transactions by category identifier or stable name.
Filter transactions by whether they are categorized (true) or not categorized (false).
Filter by categorization status.
CATEGORIZED, UNCATEGORIZED, PENDING, MATCHED Filter transactions by whether they are matched (true) or not matched (false).
Case-insensitive substring to search for in transaction descriptions (contains match, not exact equality).
Regex to search for in transaction descriptions. Regex will be parsed exactly as given and an error will be returned if the regex is invalid.
Substring to search for in merchant name. Only exact matches will be returned.
Regex to search for in merchant name. Regex will be parsed exactly as given and an error will be returned if the regex is invalid.
Search query string to filter transactions. Searches across multiple fields.
Filter transactions by exact memo match.
Filter transactions where memo contains this substring.
Filter by exact reference number match. Returns only records with this exact reference number.
Comma-separated list of reference numbers to filter transactions. Only transactions with reference numbers matching any value in this list will be returned.
UUID of the customer to filter transactions by.
External ID of the customer to filter transactions by.
UUID of the vendor to filter transactions by.
External ID of the vendor to filter transactions by.
UUID of the counterparty to filter transactions by.
Filter transactions by tag key. Must be used together with tag_values.
Comma-separated list of tag values to filter by. Must be used together with tag_key.
Response
Pre-signed URL for downloading the CSV export.
A pre-signed URL to download a document or generated file.
Show child attributes
Show child attributes