Hi All, It might sound trivial (and I have been looking at other samples on the community group), but it seems to be a challenge to get a single LATEST (no date filtering) value for the StatusData elements. I have tried to use the resultsLimit and sort options, but I get the error: "Failed:Only sorting by date in ascending order is supported when interpolating." Has anyone been successful in getting the latest / last value for a measurement metric (using the StatusData) on demand via the sdk?  My failed attempt:var deviceId = 'b1'
 
api.call("Get", {
    "typeName": "StatusData",
    "resultsLimit": 1,
    "search":  {
        "deviceSearch": { id: deviceId },
        "diagnosticSearch": {
            "id": "DiagnosticEngineOnTimeId"
        }
    },
    "sort": {
        "sortBy": "date",
        "sortDirection": "desc",
        "offset": null,
        "lastId": null
    },
}, function(result) {
    console.log("Done: ", result);
}, function(e) {
    console.error("Failed:", e);
}); 

Get Latest StatusData for one Asset (e.g. Odometer, Engine Hours, Fuel usage)

As part of the Geotab system settings, you can define a list of properties that could be applied to Assets (additional metadata fields that is stored with the Asset). How can I get these Asset Property fields and values using the SDK?  

Get Asset Custom Properties using MyGeotab SDK

page-user page-user-p-c-2133 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

Hi <a href="/user/daren-porter-1148" data-id="1148" data-value="DarenPorter-1148" data-denotation-char="@" class="text-decoration-none mention">@DarenPorter-1148</a>​ , I figured it out. It is actually so trivial - I only had to remove the toDate filter.  I'm not sure why it was so finnicky but I'm now able to get the last reported value. <code>var deviceId = 'b2'
 
api.call("Get", {
 "typeName": "StatusData",
 "search": {
 "deviceSearch": { id: deviceId },
 "diagnosticSearch": {
 //"id": "DiagnosticOdometerId" 
 //"id": "DiagnosticEngineHoursId" 
 "id": "DiagnosticDeviceTotalFuelId" 
 },
 "fromDate": new Date()
 },
}, function(results) {
 console.log("Done: ", results);
}, function(e) {
 console.error("Failed:", e);
});</code>

Thanks for the help... Yeah using the date (from / to startdate) to ge the most recent, is good if the vehicle has recorded the data today, but it does not show up for vehicles that were active last week. As I'm not ale to use the sort, I can use the array sort mechanism, but not ideal to have 6000+ records returned. I'm going to try and log a service request for this and see what the engineers come up with.<code>var deviceId = 'b1EC'
 
api.call("Get", {
 "typeName": "StatusData",
 //"resultsLimit": 1,
 "search": {
 "deviceSearch": { id: deviceId },
 "diagnosticSearch": {
 "id": "DiagnosticOdometerId"
 //"id": "DiagnosticEngineHoursAdjustmentId"
 //"id": "DiagnosticDeviceTotalFuelId"
 },
 //"toDate": new Date().toISOString(),
 //"fromDate": new Date().toISOString()
 },
 // "sort": {
 // "sortBy": "date",
 // "sortDirection": "desc",
 // },
}, function(results) {
 const descendingResults = results.sort((a, b) =&gt; 
 new Date(b.dateTime) - new Date(a.dateTime)
 );
 console.log("Done: ", descendingResults);
}, function(e) {
 console.error("Failed:", e);
});
 </code> <img src="/forum/plugins/gcs-uploads/files/069Pd000012zJxCIAU.png" alt="image" />

Hey <a href="/user/daren-porter-1148" data-id="1148" data-value="DarenPorter-1148" data-denotation-char="@" class="text-decoration-none mention">@DarenPorter-1148</a>​ , Thanks for spending the time to debug this with me.  So like I showed earlier, there is definitely data dor the metrics. Running the query without the start/end date does return results, the problem is that the results are in chronological order (oldest record first). I want the newest or last recorded record. In your sample, the record is dated 0001-01-01; I'm sure if you remove the resultLimit, it would return a bunch of records, with the dates following up on each other. The other problem is if I add the date, it queries for only today, so I'm not able to get the data if the vehicle was driving sa a week ago. As soon as I remove the dates and add in the sorting, then the error pops up: "Failed: Only sorting by date in ascending order is supported when interpolating." When I remove the resultLimit, all the data is returned (well up to 50 000 records), Technically I can then just get the last record of the array (if there is hopefully not more than the API limit), but that is a huge query. To be hones, I don't really understand why interpolation is playing a role on the values, as these are timestamped values collected directly from the CANBus (or I might be missing something). That said, I do not understand why Geotab does not have a "Get Last" type of call or allow descending sorting to give you the last recorded value of a metric (sounds so simple). Cheers

If I run the request without any limits/filters, I do get results, but typically ALL the data, and that is quite an expensive query if I need to do this per vehicle, per metric only to get the last result of the list.... <code>var deviceId = 'b1EC'
 
api.call("Get", {
 "typeName": "StatusData",
 //"resultsLimit": 1,
 "search": {
 "deviceSearch": { id: deviceId },
 "diagnosticSearch": {
 //"id": "DiagnosticEngineHoursAdjustmentId"
 //"id": "DiagnosticOdometerId"
 "id": "DiagnosticDeviceTotalFuelId"
 },
 //"toDate": new Date().toISOString(),
 //"fromDate": new Date().toISOString()
 },
 // "sort": {
 // "sortBy": "date",
 // "sortDirection": "desc",
 // },
}, function(result) {
 console.log("Done: ", result);
}, function(e) {
 console.error("Failed:", e);
});</code>Output:  <img src="/forum/plugins/gcs-uploads/files/069Pd000012wpmtIAA.png" alt="request" />

Hi <a href="/user/daren-porter-1148" data-id="1148" data-value="DarenPorter-1148" data-denotation-char="@" class="text-decoration-none mention">@DarenPorter-1148</a>​ , I tried this as well, but because the search date is then limited to a defined time, I get no results.  The aim is to get the latest or last recorded value. With some vehicles (machines that only run certain days), I do not know when they last ran, and it would be a process to have to loop back in time until they last reported. The reason why I have the Sort option in, is that the data is returned chronologically in the array (old to new), and I want the latest last value, thus sorting descending. In the end, I want to build a report that shows (I'm pasting in the diagnostic codes as in the Geotab definition list): <ul><li>Timestamp</li><li>Device Serial / ID</li><li>"description": "Odometer", "code": "5", "diagnosticCodeId": "DiagnosticOdometerId", "conversion": 100</li><li>"description": "Engine operational time", "code": "9", "diagnosticCodeId": "DiagnosticEngineHoursId", "conversion": 360</li><li>"description": "Total fuel used (since telematics device install)", "code": "2187", "diagnosticCodeId": "DiagnosticDeviceTotalFuelId", "conversion": 0.01</li></ul> Typically it would be the last recorded values you see on the measurements screen: <img src="/forum/plugins/gcs-uploads/files/069Pd000012wigbIAA.png" alt="Measurements" />

Hi All, It might sound trivial (and I have been looking at other samples on the community group), but it seems to be a challenge to get a single LATEST (no date filtering) value for the StatusData elements. I have tried to use the resultsLimit and sort options, but I get the error: "Failed:Only sorting by date in ascending order is supported when interpolating." Has anyone been successful in getting the latest / last value for a measurement metric (using the StatusData) on demand via the sdk?  My failed attempt:<code>var deviceId = 'b1'
 
api.call("Get", {
 "typeName": "StatusData",
 "resultsLimit": 1,
 "search": {
 "deviceSearch": { id: deviceId },
 "diagnosticSearch": {
 "id": "DiagnosticEngineOnTimeId"
 }
 },
 "sort": {
 "sortBy": "date",
 "sortDirection": "desc",
 "offset": null,
 "lastId": null
 },
}, function(result) {
 console.log("Done: ", result);
}, function(e) {
 console.error("Failed:", e);
});</code>

PS - There is no way of getting these fields in a standard Geotab report (the Excel version)??

Hey <a href="/user/daren-porter-1148" data-id="1148" data-value="DarenPorter-1148" data-denotation-char="@" class="text-decoration-none mention">@DarenPorter-1148</a>​  Thanks for your feedback. Using your input I was able to get to the Asset Custom Properties. For anyone seeing this post in the future, here is a sample that you can run in the API <a href="https://developers.geotab.com/myGeotab/runner/index.html" target="_blank">Runner | MyGeotab | Geotab Developers</a>:  <code>var desiredDevices = ['b1'];
api.call("Get",{
 "typeName":"Device",
}, function(devices) {
 devices.forEach(function(device){
 if(desiredDevices.indexOf(device.id) &gt; -1){
 console.log(`Custom Properties for device ${device.serialNumber}`);
 device.customProperties.forEach(function(customProp){
 //console.log(JSON.stringify(customProp));
 var propName = String(customProp.property.name);
 var propValue = customProp.value
 console.log(`${propName}: ${propValue}`);
 });
 }
 });
}, function(e) {
 console.error("Failed:", e);
});</code> PC

Silly question, but have you perhaps checked the vehicle using the VIN with the Vehicle Eligibility Check in MyAdmin (https://myadmin.geotab.com/vin-vehicle-lookup)?Sounds trivial, but we found that some "versions" (like the Mercedes-Benz eCitan) is not fully supported. Hope it helps PC

Is there any Geotab documentation available on the installation of a harness to obtain engine data from a 2026 Mercedes Benz Sprinter unit?

Hi <a href="/user/henry-lui-1390" data-id="1390" data-value="HLui-1390" data-denotation-char="@" class="text-decoration-none mention">@HLui-1390</a>​ , We have a similar issue. We logged a service request and it would seem that there is a known issue. Might be an idea to check the firmware version of your devices. This was the response from the support team: "The repeated audio alarm was caused by a known issue affecting FW version 45.33, which triggered constant IOX-NFC resets." They rolled-back the FW on all our devices back to version 45.32 Hope this helps. PC

Последна активност

Get Latest StatusData for one Asset (e.g. Odometer, Engine Hours, Fuel usage)

Get Asset Custom Properties using MyGeotab SDK