Export Subscriptions

Export rentals to CSV

curl --request POST \
  --url https://api-eu.flexportal.io/v1/exports/rentals \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'Tenant-ID: <tenant-id>' \
  --data '
{
  "startDate": "2023-11-07T05:31:56Z",
  "endDate": "2023-11-07T05:31:56Z",
  "format": "csv",
  "includeFields": {
    "customerDetails": true,
    "deviceDetails": true,
    "financialDetails": true,
    "customFields": true
  },
  "status": "active",
  "customerIds": [
    "<string>"
  ]
}
'

{
  "success": true,
  "filename": "<string>",
  "csvData": "<string>",
  "totalRecords": 123,
  "generatedAt": "<string>",
  "filters": {},
  "totalRentals": 123,
  "activeRentals": 123,
  "totalRevenue": 123,
  "averageMonthlyRevenue": 123
}

POST

exports

rentals

Export rentals to CSV

curl --request POST \
  --url https://api-eu.flexportal.io/v1/exports/rentals \
  --header 'Authorization: Bearer <token>' \
  --header 'Content-Type: application/json' \
  --header 'Tenant-ID: <tenant-id>' \
  --data '
{
  "startDate": "2023-11-07T05:31:56Z",
  "endDate": "2023-11-07T05:31:56Z",
  "format": "csv",
  "includeFields": {
    "customerDetails": true,
    "deviceDetails": true,
    "financialDetails": true,
    "customFields": true
  },
  "status": "active",
  "customerIds": [
    "<string>"
  ]
}
'

{
  "success": true,
  "filename": "<string>",
  "csvData": "<string>",
  "totalRecords": 123,
  "generatedAt": "<string>",
  "filters": {},
  "totalRentals": 123,
  "activeRentals": 123,
  "totalRevenue": 123,
  "averageMonthlyRevenue": 123
}

Overview

Export subscription data to CSV format. Use this for reporting, data analysis, or importing into external systems like spreadsheets or business intelligence tools.

Common Use Cases

Financial Reporting

Export data for revenue analysis and forecasting

Accounting Integration

Import subscription data into accounting software

Business Intelligence

Feed data into BI tools for advanced analytics

Compliance Audits

Generate reports for audit and compliance needs

Request Fields

Field	Required	Description
`status`	No	Filter by status: `active`, `ended`, etc.
`startDateFrom`	No	Filter by start date (from)
`startDateTo`	No	Filter by start date (to)
`endDateFrom`	No	Filter by end date (from)
`endDateTo`	No	Filter by end date (to)
`customerId`	No	Filter by customer

Example: Export All Active Subscriptions

{
  "status": "active"
}

Example: Export by Date Range

{
  "startDateFrom": "2024-01-01",
  "startDateTo": "2024-12-31"
}

Response

The response includes a download URL for the CSV file:

{
  "success": true,
  "downloadUrl": "https://storage.example.com/exports/rentals-2025-01-15.csv?signature=...",
  "expiresAt": "2025-01-15T12:00:00Z",
  "recordCount": 1250
}

CSV Columns

The exported CSV includes:

Column	Description
`subscriptionId`	Subscription ID
`customerId`	Customer ID
`customerEmail`	Customer email
`customerName`	Customer full name
`company`	Company name (if business)
`sku`	Product SKU
`productName`	Product name
`serialNumber`	Asset serial number
`status`	Subscription status
`startDate`	Contract start date
`endDate`	Contract end date
`contractLength`	Duration in months
`monthlyAmount`	Monthly payment
`currency`	Currency code
`totalCollected`	Total payments collected
`acquisitionCost`	Asset acquisition cost
`costRecoveryPercent`	Cost recovery percentage

Example: Monthly Revenue Report

async function generateMonthlyReport(year, month) {
  const startDate = `${year}-${month.toString().padStart(2, '0')}-01`;
  const endDate = new Date(year, month, 0).toISOString().split('T')[0];

  const { downloadUrl, recordCount } = await exportSubscriptions({
    status: 'active',
    startDateFrom: startDate,
    startDateTo: endDate
  });

  return {
    period: `${year}-${month}`,
    subscriptions: recordCount,
    downloadUrl
  };
}

Example: Customer Data Export

async function exportCustomerData(customerId) {
  const { downloadUrl, recordCount } = await exportSubscriptions({
    customerId
  });

  return {
    customerId,
    totalSubscriptions: recordCount,
    downloadUrl
  };
}

URL Expiration

Download URLs expire after a short period (typically 15-60 minutes). Download the file promptly after generation.

Large Exports

For very large exports:

Consider filtering by date range to reduce size
Export in batches by customer or time period
Monitor the recordCount to estimate file size

List Subscriptions - Query subscriptions via API
Get Subscription - Get individual subscription details
List Customers - Get customer data

Authorizations

Authorization

string

header

required

API key obtained from FlexPortal dashboard

Headers

Tenant-ID

string

required

Your tenant identifier

Body

application/json

startDate

string<date-time>

endDate

string<date-time>

format

enum<string>

default:csv

Available options:

csv

includeFields

object

Show child attributes

status

enum<string>

Available options:

active,

cancelled,

ended_completed,

ended_buyout,

ended_upgrade,

ended_early_return

customerIds

string[]

Response

Export generated

success

boolean

required

filename

string

required

csvData

string

required

totalRecords

number

required

generatedAt

string

required

filters

object

required

Show child attributes

totalRentals

number

required

activeRentals

number

required

totalRevenue

number

required

averageMonthlyRevenue

number

required

Delete File

⌘I

Overview

Products

Customers

Orders

Subscriptions

Assets

Payments

Billing Groups

Files

Exports

Export Subscriptions

Overview

Common Use Cases

Financial Reporting

Accounting Integration

Business Intelligence

Compliance Audits

Request Fields

Example: Export All Active Subscriptions

Example: Export by Date Range

Response

CSV Columns

Example: Monthly Revenue Report

Example: Customer Data Export

URL Expiration

Large Exports

Authorizations

Headers

Body

Response

Overview

Products

Customers

Orders

Subscriptions

Assets

Payments

Billing Groups

Files

Exports

​Overview

​Common Use Cases

Financial Reporting

Accounting Integration

Business Intelligence

Compliance Audits

​Request Fields

​Example: Export All Active Subscriptions

​Example: Export by Date Range

​Response

​CSV Columns

​Example: Monthly Revenue Report

​Example: Customer Data Export

​URL Expiration

​Large Exports

​Related Endpoints

Authorizations

Headers

Body

Response

Overview

Common Use Cases

Request Fields

Example: Export All Active Subscriptions

Example: Export by Date Range

Response

CSV Columns

Example: Monthly Revenue Report

Example: Customer Data Export

URL Expiration

Large Exports

Related Endpoints