Exports

Pathway exposes a stable bank-underwriting CSV and a gallery of generated Excel and PDF templates. Gallery availability can vary by organization, so integrations should discover templates before requesting one by ID.

List available templates

GET /parse/spreadsheet-templates

import requests

API_BASE = "https://api.lendpathway.com/api"
TOKEN = "pat_your_token_here"
headers = {"Authorization": f"Bearer {TOKEN}"}

response = requests.get(
    f"{API_BASE}/parse/spreadsheet-templates",
    headers=headers,
    timeout=30,
)
response.raise_for_status()

for template in response.json()["templates"]:
    print(template["id"], template["type"], template["format"])

from typing import Literal

from pydantic import BaseModel, Field


class SpreadsheetTemplate(BaseModel):
    id: str
    name: str
    type: Literal["mca", "credit_report", "tax"]
    format: Literal["excel", "pdf"]
    description: str


class SpreadsheetTemplatesConfig(BaseModel):
    templates: list[SpreadsheetTemplate] = Field(default_factory=list)

The response excludes private templates that do not belong to the token’s organization.

Public gallery

ID	Name	Data	Format
`mca_stack_view`	MCA Stack View	Bank statements and detected debt positions	Excel
`mca_monthly_columns`	MCA Monthly Columns	Monthly deposits, true revenue, DTI, and payment analysis	Excel
`mca_stacking_pro`	Debt Stacking Drilldown	Advances, schedules, remittance burden, misses, and modifications	Excel
`mca_sample_bank_statement_report`	Sample Bank Statement Report	Rendered bank statement analysis	PDF
`vlad_full`	Credit Report Full	Bureau tabs, FICO scores, accounts, utilization, and inquiries	Excel
`vlad_summary`	Credit Report Summary	Compact score and account summary	Excel
`vlad_loc_scrub`	Credit Report LOC Scrub	Revolving utilization, unsecured loans, and derogatory history	Excel
`tax_qualifying_income`	Tax Qualifying Income	Wages, Schedule C, pass-through entities, and qualifying income	Excel

The discovery endpoint is authoritative. New public templates can appear without a client release.

Download bank analytics as CSV

GET /books/{book_id}/csv-export

table_format

string

default:"month_as_row"

month_as_row writes one row per statement period and account. month_as_col writes metrics as rows and statement periods as columns.

from pathlib import Path
import requests

url = f"{API_BASE}/books/{BOOK_ID}/csv-export"
response = requests.get(
    url,
    headers=headers,
    params={"table_format": "month_as_row"},
    timeout=60,
)
response.raise_for_status()

Path("underwriting.csv").write_bytes(response.content)

import { writeFile } from "node:fs/promises";

const url = new URL(`${API_BASE}/books/${BOOK_ID}/csv-export`);
url.searchParams.set("table_format", "month_as_row");

const response = await fetch(url, {
  headers: { Authorization: `Bearer ${TOKEN}` },
});

if (!response.ok) {
  throw new Error(`${response.status}: ${await response.text()}`);
}

await writeFile("underwriting.csv", Buffer.from(await response.arrayBuffer()));

curl --fail-with-body \
  "https://api.lendpathway.com/api/books/{book_id}/csv-export?table_format=month_as_row" \
  -H "Authorization: Bearer pat_your_token_here" \
  --output underwriting.csv

`month_as_row`

The file contains individual account rows followed by NET and Average summary rows.

Period,Document,Account,Starting Balance,Deposits,Deposit Count,Withdrawals,Withdrawal Count,Ending Balance,Loan In,Loan Out,Avg Daily Balance,Days Negative,True Revenue,DTI %
Jan 2026,january.pdf,Business Checking,8149.06,101019.45,83,94510.22,106,14658.29,20000.00,12440.00,11281.33,0,81587.45,15.2%
NET,,1 Account,8149.06,101019.45,83,94510.22,106,14658.29,20000.00,12440.00,11281.33,0,81587.45,15.2%
Average,,1 Account,8149.06,101019.45,83,94510.22,106,14658.29,20000.00,12440.00,11281.33,0,81587.45,15.2%

`month_as_col`

The file uses the combined cash row for each statement period.

Metric,Jan 2026,Feb 2026,Mar 2026
Starting Balance,8149.06,14658.29,12211.08
Deposits,101019.45,97004.12,108440.90
True Revenue,81587.45,79220.83,90118.70
DTI %,15.2%,13.8%,17.1%

Both formats use the same exclusions and analytics configuration as GET /books/{book_id}/analytics.

Generate a gallery export

GET /books/{book_id}/spreadsheet-export

sheet_type

string

required

mca for bank statement templates, vlad for credit report templates, or tax for tax templates.

template_id

string

A template returned by GET /parse/spreadsheet-templates. When omitted, Pathway uses the organization’s default for that sheet type.

from pathlib import Path
import requests

response = requests.get(
    f"{API_BASE}/books/{BOOK_ID}/spreadsheet-export",
    headers=headers,
    params={
        "sheet_type": "mca",
        "template_id": "mca_stacking_pro",
    },
    timeout=120,
)
response.raise_for_status()

content_type = response.headers.get("content-type", "")
suffix = ".pdf" if "pdf" in content_type else ".xlsx"
Path(f"deal{suffix}").write_bytes(response.content)

The chosen template must match sheet_type and must be visible to the token’s organization.

Omit template_id when you want the file to follow the default selected in Pathway settings. Pass an explicit ID when another system depends on a fixed layout.

Get a browser-ready export

GET /books/{book_id}/spreadsheet-embed

This endpoint accepts the same sheet_type and template_id parameters. It generates the file, uploads a temporary copy, and returns URLs suitable for an embedded preview or download.

class SpreadsheetEmbedResponse(BaseModel):
    embed_url: str
    download_url: str
    drive_file_url: str | None = None
    drive_embed_url: str | None = None
    drive_synced_at: str | None = None

response = requests.get(
    f"{API_BASE}/books/{BOOK_ID}/spreadsheet-embed",
    headers=headers,
    params={"sheet_type": "vlad", "template_id": "vlad_full"},
    timeout=120,
)
response.raise_for_status()

print(response.json()["embed_url"])

download_url is temporary. Generate a new response when the old URL expires or when the Book changes.

Response conditions

Status	Meaning
`400`	The Book lacks the required parsed data, the sheet type is invalid, or the template does not match
`401`	Missing or invalid PAT
`403`	The token cannot access the Book or the requested template
`404`	The Book or template does not exist
`500`	The selected template could not be rendered

For multi-file packaging and filename handling, see Export data.

Overview

Endpoints

Cookbook

List available templates

Public gallery

Download bank analytics as CSV

`month_as_row`

`month_as_col`

Generate a gallery export

Get a browser-ready export

Response conditions

​List available templates

​Public gallery

​Download bank analytics as CSV

​month_as_row

​month_as_col

​Generate a gallery export

​Get a browser-ready export

​Response conditions

List available templates

Public gallery

Download bank analytics as CSV

`month_as_row`

`month_as_col`

Generate a gallery export

Get a browser-ready export

Response conditions