Order History

This sub-resource allows the user to retrieve BUY order history information.

Operation: GET

URL: https://api.lendingclub.com/api/lcx/v1/investors/{investor-id}/orders/history

Path Parameters:
NameTypeRequiredDescription
Investor-idIntegerYesInvestor’s Actor ID

Query Parameters:
NameTypeRequiredDescription
orderTypesListNoTypes of orders made. e.g. “BUY” or “SELL”
orderItemStatusesListNoStatus of orders being retrieved. e.g. “EXECUTED”
OffsetIntegerNoRetrieve a subset of loans starting with the offset value
limitIntegerNoLimit the number of results returned. Default value is 10
startDateStringNoEarliest date to retrieve order history for, in UTC format. Filter can be passed through up to the minute. Eg. 2020-05-03T22:45:56.348Z
endDateStringNoLatest date to retrieve order history for, in UTC format. Filter can be passed through up to the minute. Eg. 2020-10-03T22:45:56.348Z
marketTypesStringNoAccepted inputs are “PRIMARY” or “SECONDARY” and will return only orders from that market. No input will return orders from both markets

Supported formats: JSON

Request Payload: JSON request for submit order

For the parameters where the Type is a List, the different values must be separated by commas, whereas for non-list parameter types, the values must be separated by an `&`.

For example:

https://api.lendingclub.com/api/lcx/v1/investors/14212716/orders/history?orderTypes=BUY&orderItemStatuses=REJECTED,CONFIRMED&startDate=2019-10-31T10:05:45-08:00

Basket Parameters:

In order history response, two new fields may appear under each sell order:

orderCategory indicates the type for the sale, if value is BASKET then the sell order is BASKET sale. Otherwise it is individual.


Response Parameters:
NameTypeDescription
investorIdIntegerInvestor’s Actor ID
startDateStringStart date of the order history
endDateStringEnd date of the order history
offsetBigDecimalOffset to only return orders beginning from this value. For example, a value of 6 would only return orders from the 6th order onwards
limitIntegerLimit of the number of orders returned
orders An array of orders (see details below)

orders:
NameTypeDescription
orderExecutionTypeStringOrder Type
orderCreatedDateStringDate the order was created
totalOutstandingPrincipalBigDecimalPrincipal outstanding on the loan
totalAccruedInterestBigDecimalInterest accrued on the loan
orderItemsStringThe items and details related to the order (see details below)
auctionTypeStringDescribes the auction type for the trade – “ACTIVE”

orderItems:
NameTypeDescription
idIntegerUnique id for the order
statusStringStatus of the order being retrieved: Listed, Executed, Rejected, Execution_Failed
statusDateStringDate of the status
itemStatusReasonStringReason for the rejection, only used when status is "Rejected" Possible Values: NO_MATCHING_PRICE, ITEM_ALREADY_WON, ITEM_NOT_LISTED, ORDER_ALREADY_PLACED, ITEM_ALREADY_EXPIRED, ITEM_BELONGS_TO_BASKET,ITEM_REJECTED_WITHIN_BASKET, INVALID_BASKET_ORDER, OPEN_ROOM_DOES_NOT_EXIST, BUYER_NOT_ACTIVE_ROOM_PARTICIPANT
loanIdStringUnique LendingClub ID number for the loan
bidPricePercentBig Decimal1.0 is 100% or par
askPricePercentBig DecimalaskPricePercentage * PrincipalOutstanding + accruedInterest * 100% = askPrice
askPriceEffectiveDateBig DecimalDate the ask price became effective
outstandingPrincipalBig DecimalPrincipal outstanding on the loan
startListingDateStringListing date of the loan
roomNameStringRoom that the order was placed in


HTTP Status Summary:

CodeDescription
200Success
202Accepted
400Validation or business error
401Unauthorized
403Forbidden
404Not found
500Unexpected failure

Sample Request:

https://api.lendingclub.com/api/lcx/v1/investors/123123123/orders/history?marketTypes=PRIMARY

Sample Response:

{

  • "investorId": 123123123,
  • "startDate": "2020-05-11T19:24:18.955Z",
  • "endDate": "2020-05-26T19:24:18.955Z",
  • "limit": 10,
  • "orders": [
    {
    • "id": 64106,
    • "orderExecutionType": "BUY",
    • "orderCreatedDate": "2020-05-26T19:10:59.201Z",
    • "totalOutstandingPrincipal": "USD 0.000000000000",
    • "totalAccruedInterest": "USD 0.000000000000",
    • "orderItems":
      {
      • "id": 76279,
      • "status": "REJECTED",
      • "statusDate": "2020-05-26T19:12:00.504Z",
      • "itemStatusReason": "SUBMIT_ORDER_LOAN_LEVEL_FAILURE",
      • "loanId": 181932125,
      • "bidPricePercent": 1.000000000000,
      • "askPricePercent": 1.000000000000,
      • "askPriceEffectiveDate": "2020-05-26T17:00:00.000Z",
      • "outstandingPrincipal": "0.000000000000",
      • "accruedInterest": "0.000000000000",
      • "startListingDate": "2020-05-26T16:21:40.432Z",
      • "roomName": "PRIMARY_MARKET"
      }
      ],
    • "marketType": "PRIMARY",
    • "auctionType": "ACTIVE"
    },
    {
    • "id": 64103,
    • "orderExecutionType": "BUY",
    • "orderCreatedDate": "2020-05-26T19:09:09.112Z",
    • "totalOutstandingPrincipal": "USD 0.000000000000",
    • "totalAccruedInterest": "USD 0.000000000000",
    • "orderItems": [
      {
      • "id": 76276,
      • "status": "REJECTED",
      • "statusDate": "2020-05-26T19:09:09.118Z",
      • "loanId": 181922168,
      • "bidPricePercent": 1.000000000000,
      • "askPricePercent": 1.000000000000,
      • "askPriceEffectiveDate": "2020-05-26T19:06:37.511Z",
      • "outstandingPrincipal": "0.000000000000",
      • "accruedInterest": "0.000000000000",
      • "startListingDate": "2020-05-26T19:06:37.511Z",
      • "roomName": "PRIMARY_MARKET"
      }
      ],
    • "marketType": "PRIMARY",
    • "auctionType": 'ACTIVE"
    },
    {
    • "id": 64063,
    • "orderExecutionType": "BUY",
    • "orderCreatedDate": "2020-05-22T21:02:28.542Z",
    • "totalOutstandingPrincipal": "USD 10625.000000000000",
    • "totalAccruedInterest": "USD 0.000000000000",
    • "orderItems": [
      {
      • "id": 76168,
      • "status": "EXECUTED",
      • "statusDate": "2020-05-22T21:03:57.845Z",
      • "loanId": 181379133,
      • "bidPricePercent": 0.900000000000,
      • "askPricePercent": 0.900000000000,
      • "askPriceEffectiveDate": "2020-05-22T21:00:00.000Z",
      • "outstandingPrincipal": "10625.000000000000",
      • "startListingDate": "2020-05-22T21:00:00.000Z",
      • "roomName": "PRIMARY_MARKET"
      }
      ],
    • "marketType": "PRIMARY",
    • "auctionType": "ACTIVE"
    },
    {
    • "id": 64061,
    • "orderExecutionType": "BUY",
    • "orderCreatedDate": "2020-05-22T21:00:16.983Z",
    • "totalOutstandingPrincipal": "USD 10625.000000000000",
    • "totalAccruedInterest": "USD 0.000000000000",
    • "orderItems": [
      {
      • "id": 76166,
      • "status": "EXECUTED",
      • "statusDate": "2020-05-22T21:03:12.824Z",
      • "loanId": 181379128,
      • "bidPricePercent": 1.100000000000,
      • "askPricePercent": 1.100000000000,
      • "askPriceEffectiveDate": "2020-05-22T21:00:00.000Z",
      • "outstandingPrincipal": "10625.000000000000",
      • "startListingDate": "2020-05-22T21:00:00.000Z",
      • "roomName": "PRIMARY_MARKET"
      }
      ],
    • "marketType": "PRIMARY",
    • "auctionType": "ACTIVE"
    },
    {
    • "id": 64060,
    • "orderExecutionType": "BUY",
    • "orderCreatedDate": "2020-05-22T19:00:54.259Z",
    • "totalOutstandingPrincipal": "USD 1000.000000000000",
    • "totalAccruedInterest": "USD 0.000000000000",
    • "orderItems": [
      {
      • "id": 76165,
      • "status": "EXECUTED",
      • "statusDate": "2020-05-22T19:04:01.126Z",
      • "loanId": 181379131,
      • "bidPricePercent": 1.000000000000,
      • "askPricePercent": 1.000000000000,
      • "askPriceEffectiveDate": "2020-05-22T19:00:52.684Z",
      • "outstandingPrincipal": "1000.000000000000",
      • "accruedInterest": "0.000000000000",
      • "startListingDate": "2020-05-22T19:00:52.684Z",
      • "roomName": "PRIMARY_MARKET"
      }
      ],
    • "marketType": "PRIMARY",
    • "auctionType": "ACTIVE"
    },
    {
    • "id": 64058,
    • "orderExecutionType": "BUY",
    • "orderCreatedDate": "2020-05-22T17:10:42.507Z",
    • "totalOutstandingPrincipal": "USD 10625.000000000000",
    • "totalAccruedInterest": "USD 0.000000000000",
    • "orderItems": [
      {
      • "id": 76163,
      • "status": "EXECUTED",
      • "statusDate": "2020-05-22T17:15:51.984Z",
      • "loanId": 181402120,
      • "bidPricePercent": 1.100000000000,
      • "askPricePercent": 1.100000000000,
      • "askPriceEffectiveDate": "2020-05-22T17:00:00.000Z",
      • "outstandingPrincipal": "10625.000000000000",
      • "startListingDate": "2020-05-22T17:00:00.000Z",
      • "roomName": "PRIMARY_MARKET"
      }
      ],
    • "marketType": "PRIMARY",
    • "auctionType": "ACTIVE"
    }
    ]

}