How to get the latest measurement in microservice

vaibhavi_ghumare · November 22, 2023, 10:26am

how to get the latest measurement from measurementApi.getMeasurementsByFilter(measurementFilter)

Murat_Bayram · November 22, 2023, 1:09pm

Hi,

could you provide a bit more infos. Are you using the JavaSDK here?

Harald_Meyer · November 22, 2023, 1:18pm

In general, when using the API, the trick is to do revert=true and pageSize=1. This will give you the last measurement.

Here is an example how to do it with the Java SDK (replace 2000 in the get() call with 1 to get only the lastest):

github.com

Cumulocity-IoT/cumulocity-microservice-templates/blob/94b1a2ae21d95a065ae310732ccc2a05e6b73d0c/basic/src/main/java/com/c8y/ms/templates/basic/service/MeasurementService.java#L39


      
          /**
           * Query the latest measurement for a specific device. This requires to set the
           * date and also to provide the query parameter "revert=true". For the revert
           * query parameter a custom class RevertQueryParameter has been implemented
           * which is used on the list. If you want to query for a specific type you need
           * to add the type as a filter to the MeasurementFilter
           *
           * @param deviceId id of device for which the latest measurement should be queried
           * @return the latest measurement as MeasurementRepresentation
           */
          public Optional<MeasurementRepresentation> getLatestMeasurement(final String deviceId) {
              if (Strings.isNullOrEmpty(deviceId)) {
                  return Optional.absent();
              }
          
              final DateTime dateFrom = new DateTime(2020, 1, 1, 0, 0);
              final DateTime dateNow = new DateTime();
              final MeasurementFilter filter = new MeasurementFilter().bySource(new GId(deviceId)).byDate(dateFrom.toDate(),
                      dateNow.toDate());
          
              try {

vaibhavi_ghumare · November 22, 2023, 1:41pm

Yes, I am writing a function for microservice in which I have to return the latest measurement for the defined measurementFilter

system · May 20, 2024, 1:41pm

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

Topic		Replies	Views
MicroserviceSDK no revert parameter in MeasurementFilter or QueryParam Forum MicroserverSDK	2	169	December 3, 2024
Revert in Epl Forum Streaming-Analytics-Apama	4	308	June 4, 2024
Create a Measurement filter Forum microservice	2	432	August 4, 2024
How to query multiple fragments in 1 api call in measurements Forum	7	282	February 28, 2024
How to fetch the measurements from MeasurementRepresentation as returned by the /measurement/measurements/series API which returns the min max values? Forum	3	573	October 5, 2022

How to get the latest measurement in microservice

Related topics