Order Search
GET/v1.2/orders/search
This is used to search the order history. This can also be used to get a list of all the orders for a given period that match the given criteria.
Security type is required when there is no security account number.
If a symbol contains a backslash ( \ ) character, it needs to be replaced by %5C. (Ex.BOND\23H18\87.0 is replaced by BOND%5C23H18%5C87.0 ).
If a symbol contains a backtick (
`
) character, it needs to be replaced by %60. (Ex.510`TB is replaced by 510%60TB ).
When this end point is accessed via a server token and if orders should be retrieved only for a customer, customerNumber should be passed mandatorily.
Request
Query Parameters
Security account number
Find list of status here
Possible values: Value must match regular expression yyyy/MM/dd HH:mm:ss
Possible values: Value must match regular expression yyyy/MM/dd HH:mm:ss
Default value: 1
Default value: 100
Possible values: [CS
, OPT
, BND
, FND
]
CS(Equity), OPT(Option), BND(Fixed Income), FND(Mutual Fund)
Possible values: [createdDate
, lastUpdatedDate
]
Header Parameters
Responses
- 200
- 401
OK
- application/json
- Schema
- Example (from schema)
- Equity
- Option
- Fixed Income
- Fund
- Spot
Schema
- Array [
- ]
Default value: 1
Default value: 100
list object[]
Fintech order id
The total value of an order, calculated as price * quantity. It updates dynamically based on the quantity executed, reflecting the current executed value of the order.
appears only in rejected orders
Possible values: Value must match regular expression yyyy/MM/dd-HH:mm:ss
Possible values: Value must match regular expression yyyy/MM/dd-HH:mm:ss
Possible values: Value must match regular expression yyyy/MM/dd-HH:mm:ss
Last executed price of the order.
only applicable for Trailing stop orders. only support in ASIA region for equity and option orders.
Possible values: [TYPE:%
, TYPE:$
]
only applicable for Trailing stop orders. only support in ASIA region for equity.
only applicable for Trailing stop orders. only support in ASIA region for equity.
only applicable for Trailing stop orders. only support in ASIA region for equity.
the price which the order was placed
{
"status": "string",
"reason": "string",
"rejectCode": 0,
"isNextPageAvailable": true,
"pageNo": 1,
"pageWidth": 100,
"totalNoOfRecords": 0,
"list": [
{
"orderNumber": "string",
"externalOrderId": "string",
"orderId": "string",
"investmentId": "string",
"originalOrderId": "string",
"orderReferenceId": "string",
"orderQty": 0,
"orderType": "string",
"orderSide": "string",
"orderStatus": "string",
"orderValue": 0,
"commission": 0,
"accountNumber": "string",
"currency": "string",
"symbol": "string",
"text": "string",
"tif": 0,
"transactionTime": "string",
"orderRejectReason": "string",
"exchange": "string",
"createdDate": "string",
"averagePrice": 0,
"marketCode": "string",
"settleCurrency": "string",
"cumulativeQty": 0,
"cumulativeOrderValue": 0,
"cumulativeOrderNetValue": 0,
"cumulativeCommission": 0,
"cumulativeOrderNetSettle": 0,
"cumulativeVatAmount": 0,
"cumulativeStampDutyAmount": 0,
"lastUpdatedDate": "string",
"amount": 0,
"initalNav": 0,
"isPartialRedemption": 0,
"blockedAmount": 0,
"executedNav": 0,
"netSettle": 0,
"units": 0,
"netValue": 0,
"issueSettleRate": 0,
"requestType": 0,
"grossAmount": 0,
"filledQty": 0,
"vat": 0,
"lastPrice": 0,
"stopPrice": 0,
"trailType ": "TYPE:%",
"trailByValue": 0,
"trailStpEstPrice": 0,
"price": 0
}
]
}
{
"status": "SUCCESS",
"reason": "order search success",
"rejectCode": 0,
"isNextPageAvailable": true,
"pageNo": 1,
"pageWidth": 5,
"totalNoOfRecords": 8,
"list": [
{
"orderNumber": "24F222000002",
"externalOrderId": "ext-order-id",
"orderId": "24F222000003",
"originalOrderId": "24F222000002",
"orderReferenceId": "Efb44f83319e4",
"orderQty": 250,
"orderType": "2",
"orderSide": "1",
"orderStatus": "2",
"orderValue": 2500,
"commission": 1.01,
"accountNumber": "P000284400",
"currency": "USD",
"symbol": "AAPL",
"text": null,
"tif": 0,
"transactionTime": "2024/01/22-08:46:33",
"orderRejectReason": null,
"rejectReason": null,
"exchange": "NSDQ",
"createdDate": "2024/01/22-08:44:11",
"averagePrice": 10,
"marketCode": "ALL",
"settleCurrency": "USD",
"cumulativeQty": 250,
"cumulativeOrderValue": 2500,
"cumulativeOrderNetValue": 2876.01,
"cumulativeCommission": 1.01,
"cumulativeOrderNetSettle": 2876.01,
"lastUpdatedDate": "2024/01/22-08:46:33",
"cumulativeVatAmount": 0,
"cumulativeStampDutyAmount": 0,
"filledQty": 0,
"vat": 0,
"lastPrice": 0,
"price": 0
}
]
}
{
"status": "SUCCESS",
"reason": "order search success",
"rejectCode": 0,
"isNextPageAvailable": true,
"pageNo": 1,
"pageWidth": 1,
"totalNoOfRecords": 92,
"list": [
{
"orderNumber": "O24M07200016",
"orderId": "O24M07200016",
"orderReferenceId": "O7456455c1236",
"orderQty": 101,
"orderType": "2",
"orderSide": "1",
"orderStatus": "2",
"orderValue": 20200,
"commission": 0,
"accountNumber": "P001131090",
"currency": "USD",
"symbol": "AAPL\\\\24K15\\\\220.0",
"tif": 0,
"transactionTime": "2024/06/11-07:33:42",
"exchange": "OPRA",
"createdDate": "2024/06/07-07:04:36",
"averagePrice": 2,
"marketCode": "ALL",
"settleCurrency": "USD",
"cumulativeQty": 101,
"cumulativeOrderValue": 20200,
"cumulativeOrderNetValue": 20200,
"cumulativeCommission": 0,
"cumulativeOrderNetSettle": 20200,
"cumulativeVatAmount": 0,
"cumulativeStampDutyAmount": 0,
"lastUpdatedDate": "2024/06/11-07:33:42",
"filledQty": 101,
"vat": 0,
"lastPrice": 2,
"price": 3
}
]
}
{
"status": "SUCCESS",
"reason": "order search success",
"rejectCode": 0,
"isNextPageAvailable": true,
"pageNo": 1,
"pageWidth": 1,
"totalNoOfRecords": 47,
"list": [
{
"orderNumber": "CB240614-2-00011",
"orderId": "CB240614-2-00011",
"orderReferenceId": "CBe2f39a8228ae",
"orderQty": 2,
"orderType": "2",
"orderSide": "1",
"orderStatus": "8",
"amount": 0,
"commission": 0,
"accountNumber": "P001140030",
"currency": "USD",
"symbol": "ANF 07/15/25 8.75",
"tif": 0,
"exchange": "GTNFI",
"createdDate": "2024/06/14-10:10:07",
"averagePrice": 0,
"cumulativeQty": 0,
"cumulativeOrderValue": 0,
"cumulativeOrderNetValue": 0,
"cumulativeCommission": 0,
"cumulativeOrderNetSettle": 0,
"cumulativeVatAmount": 0,
"cumulativeStampDutyAmount": 0,
"securityType": "BND",
"principal": 1000,
"accruedInterest": 0,
"lastUpdatedDate": "2024/06/14-10:10:07",
"filledQty": 0,
"vat": 0,
"lastPrice": 0,
"price": 0
}
]
}
{
"status": "SUCCESS",
"reason": "order search success",
"rejectCode": 0,
"isNextPageAvailable": false,
"pageNo": 1,
"pageWidth": 100,
"totalNoOfRecords": 1,
"list": [
{
"orderNumber": "FO240313-2-000024",
"orderId": "FO240313-2-000024",
"investmentId": "FO240313-2-000024",
"exchange": "MFSFUNDS",
"symbol": "AFB007013406",
"accountNumber": "P001133137",
"currency": "USD",
"orderSide": "1",
"orderStatus": "@",
"commission": 5,
"vat": 0,
"createdDate": "2024/03/13-11:35:26",
"orderReferenceId": "Fa092999c3a62",
"lastUpdatedDate": "2024/03/13-11:55:54",
"amount": 5000,
"cumulativeVatAmount": 0,
"isPartialRedemption": 0,
"initialNav": 100,
"executedNav": 12,
"blockedAmount": 0,
"settleCurrency": "AED",
"issueSettleRate": 18,
"marketCode": "ALLFUNDS",
"netSettle": 90090.72,
"netValue": 5005.04,
"units": 416.67,
"requestType": 0,
"grossAmount": 90090
}
]
}
{
"status": "SUCCESS",
"reason": "order search success",
"rejectCode": 0,
"isNextPageAvailable": true,
"pageNo": 1,
"pageWidth": 5,
"totalNoOfRecords": 8,
"list": [
{
"orderNumber": "24F222000002",
"externalOrderId": "ext-order-id",
"orderId": "24F222000003",
"originalOrderId": "24F222000002",
"orderReferenceId": "Efb44f83319e4",
"orderQty": 250,
"orderType": "2",
"orderSide": "1",
"orderStatus": "2",
"orderValue": 2500,
"commission": 1.01,
"accountNumber": "P000284400",
"currency": "USD",
"symbol": "XAU/USD",
"text": null,
"tif": 0,
"transactionTime": "2024/01/22-08:46:33",
"orderRejectReason": null,
"rejectReason": null,
"exchange": "GTNSPOT",
"createdDate": "2024/01/22-08:44:11",
"averagePrice": 10,
"marketCode": "ALL",
"settleCurrency": "USD",
"cumulativeQty": 250,
"cumulativeOrderValue": 2500,
"cumulativeOrderNetValue": 2876.01,
"cumulativeCommission": 1.01,
"cumulativeOrderNetSettle": 2876.01,
"lastUpdatedDate": "2024/01/22-08:46:33",
"cumulativeVatAmount": 0,
"cumulativeStampDutyAmount": 0,
"filledQty": 0,
"vat": 0,
"lastPrice": 0
}
]
}
Unauthorized
- application/json
- Schema
- Example (from schema)
- Invalid Token
- Expired Token
Schema
{
"timestamp": "string",
"status": "string",
"error": "string",
"message": "string",
"path": "string",
"rejectCode": "string"
}
{
"timestamp": "2023-12-28T09:51:50.682Z",
"status": "401",
"error": "Unauthorized",
"message": "Invalid Token",
"path": "/api/v1.2/orders/search",
"rejectCode": "1008"
}
{
"timestamp": "2023-12-28T09:51:50.682Z",
"status": "401",
"error": "Unauthorized",
"message": "Expired Token",
"path": "/api/v1.2/orders/search",
"rejectCode": "1007"
}