How to delete a specific series from an individual or bulk ingested measurements?

What product/components do you use and which version/fix level are you on?

Cumulocity

Is your question related to the free trial, or to a production (customer) instance?

Customer Instance

What are you trying to achieve? Please describe it in detail.

I want to know how to delete a specific Series using the measurements API. When I tried to delete a specific measurement in the Measurements API, the valueFragmentType and the valueFragmentName or seriesName or any other combination is not working to delete a specific Series. Instead it keeps deleting the whole measurements entry from the Cumulocity.
I tried the below querey to delete with the following variations in place of valueFragmentSeries like seriesName or fragmentSeries. But all exhibit the same behaviour.

https://cloud.iot.solenis.com/measurement/measurements?dateFrom=2017-01-01T00:00:00.000Z&dateTo=2022-11-22T23:59:59.000Z&pageSize=2000&source=&valueFragmentType=sol_onguardMeasurement&valueFragmentSeries=Conductivity&revert=true

May be there is something to delete a specific series if the measurements ingestion is individual entries like below.

Individual measurement entry:

{
“measurements”: [
{
“sol_onguardMeasurement”: {
“Temperature”: {
“unit”: “F”,
“value”: 11
}
},
“time”: “2022-09-28T03:00:00”,
“source”: {
“id”: “6752817”
},
“type”: “sol_onguardMeasurement”
}
]
}

Bulk measurement entry:

But I also need to know the way to delete a specific Series if the entry is bulk as shown below.

{
“measurements”: [
{
“sol_onguardMeasurement”: {
“ORP S4”: {
“unit”: “rpm”,
“value”: 110
},
“Biofilm S4”: {
“unit”: “Th”,
“value”: 220
},
“Conductivity S4”: {
“unit”: “Amp”,
“value”: 5
},
“pH (S13)”: {
“unit”: “Amp”,
“value”: 5
}
},
“time”: “2022-11-23T01:00:00”,
“source”: {
“id”: “306385118”
},
“type”: “sol_onguardMeasurement”
}
]
}

Please help here.

Do you get any error messages? Please provide a full error message screenshot and log file.

Have you installed all the latest fixes for the products and systems you are using?

The DELETE endpoint for measurement collection does not support the same query parameters as the GET endpoint (see: https://cumulocity.com/api/10.14.0/#operation/deleteMeasurementCollectionResource and https://cumulocity.com/api/10.14.0/#operation/getMeasurementCollectionResource).

The parameters valueFragmentType and valueFragmentSeries are not supported for DELETE requests and are thus ignored.

Philipps last sentence is very important to keep in mind:

The filtering parameters are ignored (!!!) and the DELETE request is handled as no parameters where given.

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.