GET GetByGenericDate()
Retrieves data filtered by a logical process date (such as ‘first’, ‘last’, or ‘prev’) across multiple datasets.
Base URL
https://api.wealthtechs.com/v2/odata/Supported Resources
This function is available on the following OData resources:
| Resource | Endpoint |
|---|---|
| FxRates | /fxrates/GetByGenericDate(date='last') |
| Prices | /prices/GetByGenericDate(date='last') |
| InterfaceStatuses | /interfacestatuses/GetByGenericDate(date='last') |
| Positions | /positions/GetByGenericDate(date='last') |
| Transactions | /transactions/GetByGenericDate(date='last') |
Summary
The GetByGenericDate function simplifies querying for time-sensitive data by allowing clients to specify a logical keyword representing a date range anchor instead of a specific date. The system will internally compute the correct date value based on the authenticated user’s data scope.
Technical Notes
- Results are paginated in sets of 1000 records.
- JWT authentication is required.
- Supports $select, $filter, $orderby, $expand (up to depth 4).
- Non-supported tokens or strings will return an empty result set (200 OK with no records).
Benefits
- Reduces client-side complexity by avoiding hard-coded or calculated dates.
- Improves portability of API queries across environments.
- Enables cleaner, simpler scheduling and automation scripts.
- Ensures consistency across all date-based queries.
Parameters
| Name | Type | Location | Required | Description |
|---|---|---|---|---|
date | string | OData URI | Yes | A case-insensitive keyword for a temporal anchor. Valid values: first, last, prev. |
Keyword Behavior
| Keyword | Description |
|---|---|
first | Returns records for the earliest available ProcessDate |
last | Returns records for the most recent ProcessDate |
prev | Returns records for the process date just before last |
Authorization
// Authorization via JWT Token.
Authorization: Bearer <YourToken>Learn how to get access to our API V2.0 by clicking here.
You can copy and use our API v2.0 Public Token to get familiar with our API OData Resources.
Example Usage
GET https://api.wealthtechs.com/v2/odata/Positions/GetByGenericDate(date='last')
// Returns all Position records for the most recent available process date.GET https://api.wealthtechs.com/v2/odata/Transactions/GetByGenericDate(date='prev')
// Returns Transaction records for the date immediately before the most recent process date.GET https://api.wealthtechs.com/v2/odata/FxRates/GetByGenericDate(date='first')
// Returns FX Rate records for the earliest recorded process date.Responses
| Code | Type |
|---|---|
| 200 | Success |
| 204 | No Content |
| 400 | Bad Request |
| 401 | Unauthorized |