This sub-resource allows the user to retrieve BUY and SELL order history information.
Operation: GET
URL: https://api.lendingclub.com/api/lcx/v1/investors/{investor-id}/orders/history
Path Parameters:
Name | Type | Required | Description |
---|---|---|---|
Investor-id | Integer | Yes | Investor’s Actor ID |
Query Parameters:
Name | Type | Required | Description |
---|---|---|---|
orderTypes | List | No | Types of orders made. e.g. “BUY” or “SELL” |
orderItemStatuses | List | No | Status of orders being retrieved. e.g. “EXECUTED” |
Offset | Integer | No | Retrieve a subset of loans starting with the offset value |
limit | Integer | No | Limit the number of results returned |
startDate | String | No | Earliest date to retrieve order history for, in UTC format. Filter can be passed through up to the minute |
endDate | String | No | Latest date to retrieve order history for, in UTC format. Filter can be passed through up to the minute |
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. For non-list parameter types, the values must be separated by an `&`. For example
https://api.lendingclub.com/api/lcx/v1/investors/14212716/orders/historyorderTypes=BUY&orderItemStatuses=REJECTED,CONFIRMED&startDate=2019-10-31T10:05:45-08:00
Basket Parameters:
In the order history response, two new fields may appear under each sell order. The orderCategory indicates the type for the sale: if the value is BASKET then the sell order is BASKET sale.Otherwise, it is individual.
Response Parameters:
Name | Type | Description |
---|---|---|
investorId | Integer | Investor’s Actor ID |
startDate | String | Start date of the order history |
endDate | String | End date of the order history |
offset | BigDecimal | Offset to only return orders beginning from this value. For example, a value of 6 would only return orders from the 6th order onwards |
limit | Integer | Limit of the number of orders returned |
orders | An array of orders | |
allOrNoneFlag | Boolean | This parameter is only applicable to BASKET sell order. If it is set to |
description | String | Description of the order |
marketType | String | Market type of the order: PRIMARY or SECONDARY |
orderCategory | String | Order category: INDIVIDUAL or BASKET. This attribute is only applicable to sell orders |
orderCreatedDate | Date | Creation date of the order in ISO format |
orderExecutionType | String | Execution type of the order: SELL or BUY |
roomName | String | Name of the room where the order was placed |
totalOutstandingPrincipal | BigDecimal | Total outstanding principal of the items in this order |
totalAccruedInterest | BigDecimal | Total accrued interest of the items in this order |
totalFees | BigDecimal | Total fee charged for all the items in this order |
orderItems | Array | Array of items in this order |
noteId | Integer | Unique LC assigned id for the Note |
loanId | Integer | Unique LC assigned id for the loan. This is the same as the id loan attribute returned in the loan Listing result operation |
status | String | Status of the sell order item |
itemStatusReason | String | Reason of the current status |
statusDate | Date | Timestamp when status was lastly updated in ISO format |
startListingDate | Date | Start listing date of the item in ISO format. The item will show up in |
listingExpirationDate | Date | Listing expiration date of the item in ISO format |
outstandingPrincipal | BigDecimal | Outstanding principal of the item |
accruedInterest | BigDecimal | Accrued interest of the item |
fees | Array | Array of fees charged to the item |
type | String | Type of the fee |
amount | BigDecimal | Amount of the fee |
Sample Response:
{
"investorId": 171504826,
"startDate": "2019-06-04T22:32:10.669Z",
"endDate": "2019-06-19T22:32:10.669Z",
"offset": 0,
"limit": 1,
"orders":[
{
"id": 123007,
"orderExecutionType": "BUY",
"orderCreatedDate": "2019-06-19T13:01:37.746Z",
"totalOutstandingPrincipal": "USD 38033.131141000000",
"totalAccruedInterest": "USD 134.066787272024",
"allOrNoneFlag": false,
"orderItems": [
{
"id": 125007,
"status": "EXECUTED",
"statusDate": "2019-06-19T21:57:00.579Z",
"loanId": 162580874,
"noteId": 205060532,
"bidPricePercent": 1,
"askPricePercent": 1,
"askPriceEffectiveDate": "2019-06-18T13:01:36.000Z",
"outstandingPrincipal": "19016.565570500000",
"accruedInterest": "67.033393636012",
"startListingDate": "2019-06-19T13:00:23.995Z"
},
{
"id": 125008,
"status": "LISTED",
"statusDate": "2019-06-19T13:01:37.716Z",
"loanId": 162580886,
"noteId": 205060563,
"bidPricePercent": 1,
"askPricePercent": 1,
"askPriceEffectiveDate": "2019-06-19T13:00:27.554Z",
"outstandingPrincipal": "19016.565570500000",
"accruedInterest": "67.033393636012",
"startListingDate": "2019-06-19T13:00:26.272Z"
},
{
"id": 314025,
"status": "REJECTED",
"statusDate": "2020-03-12T12:47:09.502Z",
"itemStatusReason": "NO_MATCHING_PRICE",
"loanId": 176520289,
"noteId": 214461188,
"bidPricePercent": 0.05,
"askPricePercent": 1,
"askPriceEffectiveDate": "2019-06-19T13:00:27.554Z",
"outstandingPrincipal": "19016.565570500000",
"accruedInterest": "69.344889968289",
"startListingDate": "2019-06-19T13:00:26.272Z"
},
],
"marketType": "SECONDARY"
},
{
"id": 455161,
"orderExecutionType": "SELL",
"orderCreatedDate": "2021-03-25T18:29:10.410Z",
"totalOutstandingPrincipal": "USD 33876.146368003700",
"totalAccruedInterest": "USD 742.410000000000",
"totalFees": "USD 170.090000000000",
"allOrNoneFlag": false,
"orderItems": [
{
"id": 719276,
"status": "EXECUTED",
"statusDate": "2021-03-25T18:35:03.795Z",
"loanId": 155389515,
"noteId": 206002121,
"bidPricePercent": 1,
"askPricePercent": 1,
"askPriceEffectiveDate": "2021-03-25T18:15:19.000Z",
"outstandingPrincipal": "18404.640689249000",
"accruedInterest": "428.950000000000",
"startListingDate": "2021-03-25T18:15:19.000Z"
"fees":[
{
"type": "SELLER_TRANSACTION_FEE",
"amount": "92.330000000000"
}
]
},
{
"id": 719277,
"status": "EXECUTED",
"statusDate": "2021-03-25T18:35:03.795Z",
"loanId": 154482451,
"noteId": 205233079,
"bidPricePercent": 1,
"askPricePercent": 1,
"outstandingPrincipal": "15471.505678754700",
"accruedInterest": "313.460000000000",
"startListingDate": "2021-03-25T18:15:19.000Z"
"fees":[
{
"type": "SELLER_TRANSACTION_FEE",
"amount": "77.760000000000"
}
]
}
],
"orderCategory": "INDIVIDUAL",
"marketType": "SECONDARY"
}
]
}
HTTP status summary:
Code | Description |
---|---|
200 | Success |
400 | Validation or business error |
401 | Unauthorized |
403 | Forbidden |
404 | Not Found |
452 | Market closed |
500 | Unexpected failure |
Sell order itemStatusReason values
status | itemStatusReason | Scenario |
---|---|---|
EXPIRED | RESERVE_PRICE_CROSSED | When the sell order item crosses the reserve price and has been unsold |
EXPIRED | USER_EXPIRATION_DATE_CROSSED | When the sell order item crosses the user expiration date and has been unsold |
CANCELED | OWNER_CHANGE | When the note ownership has changed for a listed loan and corresponding sell order item has been canceled |
CANCELED | STATUS_CHANGE | When the loan status is no longer CURRENT OR ISSUED and corresponding sell order item has been canceled |
CANCELED | INVALID_NOTE_DETAIL | When a sell order item has been marked as canceled due to missing data for one of the several attributes |
CANCELED | NOTE_DETAIL_NOT_FOUND | When a sell order item has been marked canceled due to missing note data |
CANCELED | MANUAL | When a sell order or sell order item has been canceled by the seller using the API |
CANCELED | OTHER | When the sell order item is marked canceled due to the outstanding principal being |
EXECUTION_FAILED | ZERO_REMAINING_PRINCIPAL | When the sell order settlement fails due to outstanding principal on loan being 0 |
EXECUTION_FAILED | INVALID_LOAN_STATUS | When the sell order settlement fails due to the loan being in an invalid status |
EXECUTION_FAILED | INVALID_LOAN_OWNER | When the sell order settlement fails due to the seller not being the owner of the loan |
EXECUTION_FAILED | INVALID_SELLER_BANK_ACCOUNTINVALID_SELLER_BANK_ACCOUNT | When the sell order settlement fails due to problems with seller’s bank account information |
CANCELED | CAUSED_BY_OTHER_BASKET_ITEM | When one of the sell order items in sell order is canceled, all others are marked with this status/reason combo |
EXPIRED | CAUSED_BY_OTHER_BASKET_ITEM | When one of the sell order items in sell order is expired, all others are marked with this status/reason combo |
CANCELED | INVALID_LOAN_ORIGINATOR | When the sell order settlement fails due to originator of the loan not being allowed in the room |
Buy order itemStatusReason values:
status | itemStatusReason | Scenario |
---|---|---|
REJECTED | ITEM_ALREADY_WON | When the buy order fails due to selection of a competing bid for the loan |
REJECTED | OPEN_ROOM_DOES_NOT_EXIST | When the buy order fails as the room is closed |
REJECTED | BUYER_NOT_ACTIVE_ROOM_PARTICIPANT | When the buy order fails due to the buyer not being an active participant in the room |
REJECTED | BUYER_SAME_AS_SELLER | When the buy order fails acceptance due to buyer being same as seller |
REJECTED | NO_MATCHING_PRICE | When the buy order fails due to bid price being less than the asking price |
REJECTED | ITEM_NOT_LISTED | When the buy order fails due to the sell order item no longer being listed on the platform |
REJECTED | ITEM_ALREADY_EXPIRED | When the buy order fails due to the expiration of the corresponding sell order item listing |
REJECTED | ORDER_ALREADY_PLACED | When the buy order fails due to pre-existing buy order from buyer for the sell order item |
EXECUTION_FAILED | INSUFFICIENT_CASH | When the buy order settlement fails due to insufficient cash in buyer’s account to cover the loan purchase |
EXECUTION_FAILED | INVALID_BUYER_BANK_ACCOUNT | When the buy order settlement fails due to problems with the buyer bank account |
EXECUTION_FAILED | INVALID_BASKET_ORDER | When a basket buy order is rejected due to one of the following reasons |
REJECTED | ITEM_REJECTED_WITHIN_BASKET | At the time of processing buy order, when one of the items in the basket buy order is rejected, all others are marked with this status |