Get all loans

Returns a list of all loans in your account. Only basic information about the loans is returned. For full records, see the Get a loan call. If format=csv is sent, we will return the full loan tape with all custom fields.

Recent Requests
Log in to see full request history
TimeStatusUser Agent
Retrieving recent requests…
LoadingLoading…

CSV Format

When format=csv is passed, the API returns a 302 redirect to a signed download URL for a CSV file containing your full loan tape. This includes all standard loan fields, borrower and guarantor details, addresses, custom fields, and trust balances.

Example

curl -L -X GET "https://production.baselinesoftware.com/production/api/loan?format=csv" \
  -H "Authorization: Token your-api-key" \
  -o loan_tape.csv

ℹ️

Note

Use the -L flag (or your HTTP client's follow-redirects option) to automatically follow the redirect to the download URL.

CSV Columns

The CSV includes the following columns (among others):

ColumnDescription
Created_AtLoan creation timestamp
Updated_AtLast update timestamp
IdLoan ID
NameLoan name
StatusCurrent loan status
AmountLoan amount
RateInterest rate
TermLoan term
FrequencyPayment frequency
Regular_PaymentRegular payment amount
Date_MaturityMaturity date
Borrower_NamePrimary borrower name
Borrower_EmailPrimary borrower email
Borrower_AddressPrimary borrower address
Guarantor_NamePrimary guarantor name
Guarantor_AddressPrimary guarantor address
Num_GuarantorsNumber of guarantors
Num_AddressesNumber of collateral addresses
Borrower_Num_ProjectsBorrower's number of projects
Guarantor_Num_ProjectsGuarantor's number of projects
Maturity_OriginalOriginal maturity date
First_Loan_Funding_DateDate of first funding payment
Application_SubmittedApplication submission date
Product_NameProduct name
Loan_TypeLoan type
Exit_StrategyExit strategy
Use_Of_FundsUse of funds
Account_OwnersComma-separated list of account owners
FCI_IdFCI ID (if applicable)

Additional columns for trust balances and custom fields will vary based on your account configuration.

Query Params
string
enum
Defaults to json

Response format. Use json for a JSON array of loans, or csv to download the full loan tape as a CSV file.

Allowed:
Headers
string
enum
Defaults to application/json

Generated from available response content types

Allowed:
Responses

Language
Credentials
Header
LoadingLoading…
Response
Click Try It! to start a request and see the response here! Or choose an example:
application/json
text/plain