Providing you have suitable access control permissions, you can retrieve a time-variant property as a time-series for certain types of entity. See how to retrieve properties normally.
Note: A time-variant property is one whose property type has a
lifeTime
ofTimeVariant
. It can be single- or multi-value.
For example, imagine you have a Person/Manager/Address
property attached to a particular person with different values effective during the following time periods:
Property value | Effective from | Effective until |
1 Main Street | 1 January 2019 | 1 January 2020 |
2 High Street | 1 January 2020 | 1 January 2021 |
3 Station Street | 1 January 2021 | now |
To retrieve all the historical values of this property you would normally need to make three requests, one during each of the time periods. Instead, you can make one request and receive a time-series containing all the values together. More information on this scenario.
You can currently retrieve a property as a time series for the following types of entity:
Using the LUSID REST API
To retrieve a time-variant Person/Manager/Address
property for a particular person as a time-series:
Call the GetPersonPropertyTimeSeries API for your LUSID domain, passing in your API access token and the 3-stage key of the property to retrieve, for example:
curl -X GET "https://<your-domain>.lusid.com/api/persons/Traders/TraderId/Trader5/properties/time-series?propertyKey=Person%2FManager%2FAddress" -H "Authorization: Bearer <your-API-access-token>"
The response is as follows (for clarity, shown as table ouput from the equivalent method in the LUSID Python SDK):
Note there are two values for each of 1 Main Street and 2 High Street, with a status of
superseded
andprevailing
respectively. This is because each address was originally attached to the person without an effective until date. So for example 1 Main Street was initially upserted effective 1 January 2019 until the end of time; when 2 High Street was subsequently upserted effective 1 January 2020, LUSID automatically reset the effective until date of 1 Main Street to 1 January 2020.To retrieve just the prevailing values for each time period, specify a filter of
status eq 'Prevailing'
, for example:curl -X GET "https://<your-domain>.lusid.com/api/persons/Traders/TraderId/Trader5/properties/time-series?propertyKey=Person%2FManager%2FAddress&filter=status%20eq%20%27Prevailing%27" -H "Authorization: Bearer <your-API-access-token>"
Using the LUSID web app
Coming soon.