Hello <a href="/user/ssartor" data-id="1546" data-value="ssartor" data-denotation-char="@" class="text-decoration-none mention">@ssartor</a>​, Following call can be used to get the date and time of data reprocess requests and there is a status property that would have show if the reprocess is scheduled or completed. You can get the id to search it by from the audit log.<code>api.call("Get", {
 "typeName": "ReprocessRequest",
 "search": {
 id:"__" //id of the reprocess goes here 
 
 },
}, function(result) {
 console.log(result);
}, function(e) {
 console.error("Failed:", e);
});
/*opt nomin*/</code>

What are the API calls to get the date and time of data reprocess requests and completions?

page-user page-user-adwity-sharma-1064 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

hello <a href="/user/anthony-lee-1866" data-id="1866" data-value="A-1866" data-denotation-char="@" class="text-decoration-none mention">@A-1866</a>​, Please do a get call for status data with diagnostic id "DiagnosticSolidMaterialTypeId" to get solid material type. Please let me know you have any additional questions. <a href="https://geotab.github.io/sdk/software/api/reference/#KnownId:~:text=diagnosticSolidMaterialTypeId" target="_blank">Link to reference</a>

Get Material Management Solid Type and the Solid Total from MyGeotab

hello <a href="/user/admin-user-1440" data-id="1440" data-value="AUser-1440" data-denotation-char="@" class="text-decoration-none mention">@AUser-1440</a>​ , FaultData has a diagnostic object that returns the diagnostic id associated with that fault.As an example:<img src="/forum/plugins/gcs-uploads/files/069Ht00000T4bisIAB.png" alt="image" /> Please let me know if you are still having issues retrieving the diagnostic id.

The Geotab API/SDK for Fault Data does not provide Diagnostic Code.

hello <a href="/user/ashley-fc-1448" data-id="1448" data-value="AshleyFC-1448" data-denotation-char="@" class="text-decoration-none mention">@AshleyFC-1448</a>​ , you are right to use JSON stringify to parse the existing comment to see where the new line characters are. In order to ensure consistent results, you can use string literals when appending to the comments. Here is an example of concatenating to existing comment and adding a new line between the new addition and existing comment. <code>var comment = "
 Addition";
 
api.call("Get", {
 "typeName": "Device",
 search:{id:" "} // device id here 
}, function(result) {
 result[0].comment = result[0].comment.concat(comment);
 api.call("Set", {
 typeName : "Device",
 entity : result[0]
 }, function (results) {
 console.log("Completed");
 }, console.error);
}, function(e) {
 console.error("Failed:", e);
});
/*opt nomin*/</code>

Newline/Return in Device Comments MyGeotab SDK

hello <a href="/user/shufang-cheng-1824" data-id="1824" data-value="SChen-1824" data-denotation-char="@" class="text-decoration-none mention">@SChen-1824</a>​, I see that the devices that does not have device status data shows empty for this column. You can add a check to see if deviceStatusInfo returns nothing which can be mapped to devices that has empty column for DeviceStatusAnalysisTroubleDownloadStatus.

What Geotab API to call to get DeviceStatusAnalysisTroubleDownloadStatus ? This is in Advanced Default Device Report column AI.

hi <a href="/user/eld-eld-1830" data-id="1830" data-value="eeld-1830" data-denotation-char="@" class="text-decoration-none mention">@eeld-1830</a>​ , Please find a sample of the call below:<code> bool dbexists = await api.CallAsync&lt;bool&gt;("DatabaseExists", new { database = "" });
 Console.WriteLine(dbexists);</code>

How do you use access the DatabaseExists command in the MyAdmin SDK (.Net)

Hello <a href="/user/shufang-cheng-1824" data-id="1824" data-value="SChen-1824" data-denotation-char="@" class="text-decoration-none mention">@SChen-1824</a>​, I see that DeviceStatusAnalysisTroubleDownloadStatus is based on isDeviceCommunicating property from devicestatusinfo object. If isDeviceCommunicating is true, it will result in "OK" and "Device is not downloading data" if it is false.Please let me know if you have any additional questions.

Hello <a href="/user/lindsey-mundy-1759" data-id="1759" data-value="lmund-1759" data-denotation-char="@" class="text-decoration-none mention">@lmund-1759</a>​, we cannot get fields such as location, speed etc. from the ExceptionEvent object. The properties for Exception event object can be found here: https://geotab.github.io/sdk/software/api/reference/#ExceptionEvent.You can pass the from date and to date from the exception and use [LogRecord|https://geotab.github.io/sdk/software/api/reference/#LogRecord] to get location and speed for the time.

Retrieving data associated with an Exception Event from MyGeotab API

Hello <a href="/user/barb-hamlin-1638" data-id="1638" data-value="bhaml-1638" data-denotation-char="@" class="text-decoration-none mention">@bhaml-1638</a>​, I tried a get call for a device that has serial number starting with GA* and the result did return the correct serial number. Please try the following call on the runner and let me know if you are still not getting the correct serial number. <code>api.call("Get", {
 "typeName": "Device",
 search:{
 serialNumber:"" //serial number
}
}, function(result) {
 console.log("Done: ", result[0].serialNumber);
}, function(e) {
 console.error("Failed:", e);
});
/*opt nomin*/</code>

App using Geotab API returns GT serialnumber for GA units - isn't this a bug?

hi <a href="/user/joy-b-1408" data-id="1408" data-value="JoyB-1408" data-denotation-char="@" class="text-decoration-none mention">@JoyB-1408</a>​ Thanks a lot for jumping in and helping as always. <a href="/user/darrel-jiang-1838" data-id="1838" data-value="DJian-1838" data-denotation-char="@" class="text-decoration-none mention">@DJian-1838</a>​, I wanted to update this thread with a simple call that might make this task easier (to assist people who might have similar questions).We can modify the call below to look at only Off status, so that we are just looking at drivers who are in OFF duty. In addition, using fromDate as datetime now and setting includeBoundryLogs to true would give us the last log for the users. You can also add search parameter to check for groups of users rather than a single user. <code>var dateTime = new Date();
 
api.call("GetFeed", {
 "typeName": "DutyStatusLog",
 search:{
 "statuses": [
 "ON",
 "OFF",
 "D",
 "SB",
 "YM",
 "PC",
 "PC_Exempted",
 "WT"
 ],
 "includeBoundaryLogs": true,
 "fromDate": dateTime,
 "userSearch": {
 "id": ""
 }
 }
}, function(result) {
 console.log("Done: ", result);
}, function(e) {
 console.error("Failed:", e);
});
/*opt nomin*/</code>Hope this helps 😄

Projected end time of daily rest and cycle reset MyGeotab API

Hello <a href="/user/darrel-jiang-1838" data-id="1838" data-value="DJian-1838" data-denotation-char="@" class="text-decoration-none mention">@DJian-1838</a>​, looking at the conversation above it looks like you have already explored "DutyStatusAvailability". I was using the same call for testing and I see we get back information about duration left for the cycle and duration left for the workday through this call (so information around when driver's daily or cycle clock will reset). Could you please help me understand the question a bit better?

Nesenās aktivitātes