...
CPS temporal data query allows the user to fetch data based on multiple filtering criteria. This data can be used by an analytical system to take decisions.
...
| No | Name | Type | Default | Purpose | Example |
|---|---|---|---|---|---|
| 1 | index | int | 0 | The query output can have many rows so it is important to limit the fetched data. To limit the number of records and to provide pagination, these two parameters can be used. "index" parameter represents the page number, starts with 0, and maxSize is the page size. | |
| 2 | maxSize | int | 1000 | ||
| 3 | pointInTimeDateTime | Timestamp (ISO Format) | CurrentDateTime | When a user uses the APIs with pagination (by running several stateless requests), the result set can be impacted by new states stored while navigating. This can be a challenge to retrieve a consistent result set. This parameter must be used to avoid this issue. | |
| 4 | sortBy | string | LATEST_FIRST | Possible values - OLDEST_FIRST & LATEST_FIRST |
Assumptions
- Temporal database stores full information in the payload (CPS-192: Design data store for Temporal Service).
- Data in the response body will always contain the entire payload data.
...
| Code Block | ||
|---|---|---|
| ||
{
"idNearRTRIC": "1",
"labels" : [ "cps", "ran"],
"nestedObject": {
"id": "4",
"
"attributes": {
"gNBDUId": 4.0,
"gNBDUName": "gnduserver4",
"gNBIdLength": 32.0
}
},
"GNBDUFunction": [
{
"idGNBDUFunction": "5",
"NRCellDU": [
{
"idNRCellDU": "13905",
"attributes": {
"nRPCI": 12.0,
"nRTAC": 310.0,
"cellLocalId": 13905.0
}
},
{
"idNRCellDU": "14655",
"attributes": {
"nRPCI": 12.0,
"nRTAC": 310.0,
"cellLocalId": 14655.0
}
}
],
"attributes": {
"gNBDUId": 5.0,
"gNBDUName": "gnduserver5",
"gNBIdLength": 32.0
}
}
]
} |
...
| No | Type of field | To be search | Format | |
|---|---|---|---|---|
| 1 | Top-level fieldfield | idNearRTRIC | { "idNearRTRIC": "1"} | |
| 2 | The field inside another objectNested Field | nestedObject → id | { "nestedObject" : {"attributes" : {"gNBDUId": 4.0 }} } | |
| 3 | String collection field at the top level | value(s) in a collection | labels | { "labels": ["cps"] } |
| 4 | The field of an object inside a collection | GNBDUFunction → idGNBDUFunction | { "GNBDUFunction" : [ {"idGNBDUFunction" : 5 }] } |
Proposed APIs
Currently, we are not supporting all the filtering criteria defined in the overview. The supported ones are defined below and are passed as query parameter.
- after - timestamp ( ISO Format) to consider data created after the specified Timestamp
- payload - to define payload filtering criteria
- index - to define the page number (required for pagination)
- maxSize - to limit the response size
- pointInTime - to consider data changed or added before this time.
- sortBy - to define the order of data in the result set
The response format for all GET APIs is the same and defined here
...