Skip to main content
GET
/
v1
/
businesses
/
{businessId}
/
reports
/
profit-and-loss
/
lines
/
exports
/
excel
Export P&L line items as Excel
curl --request GET \
  --url https://sandbox.layerfi.com/v1/businesses/{businessId}/reports/profit-and-loss/lines/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 the P&L line items for.

Query Parameters

​
start_date
string<date-time>
required

Start date for the line item report (ISO 8601 format).

​
end_date
string<date-time>
required

End date for the line item report (ISO 8601 format).

​
line_item_name
string
required

Name of the specific line item to export details for.

​
reporting_basis
enum<string>

Accounting basis for the report.

Available options:
ACCRUAL,
CASH
​
structure
string

P&L structure template to use.

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"