page-user page-user-alejandro-hernandez-1063 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

Hi <a href="/user/chandru-arya-1291" data-id="1291" data-value="carya-1291" data-denotation-char="@" class="text-decoration-none mention">@carya-1291</a>​ , Could you elaborate the inquiry so as to include your particular system constrains? In particular I was looking to better understand the following: --&gt; snap logic environment The reason is that there are likely to be a few different solutions that may be relevant; depending on your particular framework/connector system that you're working with. In regards to scheduling JavaScript jobs; if you're setting up a node server; then this should possible to do with tools such as <a href="https://www.digitalocean.com/community/tutorials/nodejs-cron-jobs-by-examples" target="_blank">node-cron</a>. There is also the potential option to dockerize your .net application and work around your security guidelines. Have you considered either of these two? If you are working with a Linux system that has python already installed (most do); you could also execute a .py script file to act as the connector/data fetcher.  Hope these options help out - do let us know what your constrains are - such that we can find a most optimal way to guide you.  Regards, Alej.

Help required on consuming geotab api other than .net exe

Hi <a href="/user/keith-nicholson-1575" data-id="1575" data-value="KNich-1575" data-denotation-char="@" class="text-decoration-none mention">@KNich-1575</a>​  Here is a simple API call template for get addresses. <code>{
	"method": "GetAddresses",
	"params": {
		"coordinates": [{"x": -80.867537,"y": 41.178607} , {"x": -80.867537,"y": 41.178607}],
		"movingAddresses": true,
		"credentials": {
			"database": "dbname",
			"sessionId": "",
			"userName": ""
		}
	}
}</code>Best, Alej

Receiving" Value cannot be null. (Parameter 'coordinates')" for the GetAddresses API call, through Postman

Hello BAlco_324 , I have just now experimented (for the first time) with querying for Fault Data objects in SDK MyGeotab on the <a href="https://geotab.github.io/sdk/software/api/runner.html" target="_blank">runner</a>.  With the below code, you can see that by including in line 7 the state:"Active " in the search object as a parameter (as outlined in the <a href="https://geotab.github.io/sdk/software/api/reference/#T:Geotab.Checkmate.ObjectModel.Engine.FaultDataSearch" target="_blank">FaultDataSearch object</a> ) will allow you to filter out for just active faults as desired.   <code>let uniques=[];
api.call("Get", {
 "typeName": "FaultData",
 search:{
 FromDate:'2021-06-01T00:46:28.063Z',
 ToDate:'2021-08-20T00:46:28.063Z',
 state:'Active',
 },
 "resultsLimit": 10000
}, function(result) {
 for (let elem of result){
 
 
 if(!uniques.includes(elem.diagnostic.id)){
 uniques.push(elem.diagnostic.id) 
 }
 console.log(elem.faultState, '---',elem.diagnostic.id)
 }
 console.log("Done: ", result, uniques);
}, function(e) {
 console.error("Failed:", e);
});
/*opt nomin*/</code>I ran this code above on the runner against our internal testing database which is inclusive of hundreds of active vehicles and thus gives us a good sample size to play with.  As for the second question: [can we provide] a list for all the data-diagnostic and Description for each one of them.  <ul><li>I want to start with the Disclaimer: That I am not an expert in the facets of ECM-reported fault data and the particulars of how we generate these objects (this question would best be addressed from a colleague with a better understanding of Firmware aspect of how we read, parse and interpret fault-data) therefore take what I say next as a potentially incomplete answer (I am an an SME on working/best practices of with the SDK) </li></ul> My incomplete answer:I believe this will be a bit difficult to do (at least when it comes to faults that do not stem from the controller with ID ControllerGoDeviceId) since each vehicle has it's own proprietary source address and controller that would have to additionally be factored/considered in in order to ascertain the unique and exact details of what that fault object represents (see following screenshots) and I think that each vehicle may have it's own proprietary set of fault data codes which should then be individually referenced from a proper list (it may be the case that this mapping might not something that could easily be made completely publicly available by us as requested) though our UI and reporting do provide further details. <img src="/forum/plugins/gcs-uploads/files/0692J00000FKmplQAD.png" alt="vfa" />  <img src="/forum/plugins/gcs-uploads/files/0692J00000FKmfCQAT.png" alt="idFaultData" /><img src="/forum/plugins/gcs-uploads/files/0692J00000FKmg0QAD.png" alt="data4" /> Sample of unique generated diagnostic ids: <code>0: "DiagnosticLowPriorityWarningLightId"
1: "aoTo0CLr04k-ZRHCkwFmNGA"
2: "a_yFjCOS51UGLJfHf3PQG1w"
3: "a4gVqWEItZ0OoH7DSa26IWQ"
4: "agCqCLQH3f0KQUwcPXHgRjA"
5: "DiagnosticGeneralVehicleWarningLightId"
6: "arezmrttkpE-kydCqklvX3w"
7: "aoDYWrkptVkm8DrMFDqnyZg"
8: "DiagnosticCanBusExcessiveListenId"
9: "DiagnosticDeviceHasBeenUnpluggedId"
10: "ajSjCpfuGFUinkh2dQ9MAHA"
11: "DiagnosticVehicleAbsSystemFailedId"
12: "aKQNNYTc_t0msRWM86aQIyg"
13: "azj5cEUO1YE2dbXcdt1rPNg"
14: "abG36tozUaUaflzxJXnTFqQ"
15: "DiagnosticDeviceRestartedBecauseAllPowerWasRemovedId"
16: "aRayqcO358UOecqMvt8JlHw"
17: "DiagnosticVehicleBatteryLowVoltageId"
18: "aTKv2OaZyTUi-Geg1eWZkqA"
19: "aPqLtvG1MUE-Kf7Xb9zjEXg"
20: "anDqhqXkKR0aj4W5yc5Rn-g"
21: "a8ktLiK4Uw0iOhVJ9qF29YQ"
22: "aU2vmn2OtDEqqfv548VIJCA"
23: "aRxrKvzcA0k-dZ2llo0VeDQ"
24: "a9tWWfF8tJ0yhgIs86lfL_A"
25: "asjGJv-tkjE606LWWDnsNkA"
26: "aXoICcPeaVkyk18BkxVfvTQ"
27: "aNxYVfz-2w0WkJmHaVisqhQ"
28: "a8EtM1x982k6unweF3MWiww"
29: "ayEQWehVfJUygHRZbikhwsw"
30: "a5cb610MW8kqhVpH-qdX6iQ"
31: "a3uxhzxznD0mtTdLVc2CfUA"
32: "aqNjvpdOAB0CIxbkVgKVgYw"
33: "aCyrLXOEYcEK4P-bPZhcPsw"
34: "arhkryN8m80WaRbriPLZZPw"
35: "aiRp4JKuFaUajDHJKTCZPJQ"
36: "ae_xIcSHXO02bqRfqsPUQEw"
37: "DiagnosticAccidentLevelAccelerationEventId"
38: "ad26c1h6o9EeYw1HUE52gMg"
39: "aUsu8HwVZJkW0ZSuAzmJkLA"
40: "aQX-QpNV-0ESy5jOhw5cSgg"
41: "aYmJevEJ2_UGAn5SSbkYEhQ"
42: "aBMkjpMlJZ0yPfjmai8v80w"
43: "a84mBHb9yjkGYzwzv7UyzNw"
44: "apvJ2OgXaZkuOiaHHeP2Y5g"
45: "a_Q4kM2urAU20ktf7zdEZjg"
46: "DiagnosticInvalidOpcodeResetId"
47: "DiagnosticDeviceRestartedDueToInternalResetConditionId"
48: "a81V3qPTR1kqlym7x3IbpEA"
49: "DiagnosticDisabledExcessiveAccelerometerDataId"
50: "DiagnosticCanBusShortId"
51: "azdQcEP9sfUSQ_q9YGOYd1g"
52: "a3djJYPXz6U66KKJOZNR-Vg"
53: "aRbmDlP0lUk2knANrZ7pmvw"
54: "awE-8vCcTR0S4hxLcKqAviA"
55: "aNRDM-bqRkkiZGod5oHMC4g"
56: "ajz-1NMTBPk-m8FMejB1f4g"
57: "aarmtsAHVhkOeaiWzLPkscg"
58: "aqbqvN8oMfUONmDHLUMBzfQ"
59: "a9DwD4nkfH0u1WDgjDRrdug"
60: "aFkZTJv405Ees1WvnLp7MYA"
61: "avbwSiLOkNEqyP7i6YFL2_Q"
62: "a_7zYFhfPo0-aOEy84Qguew"
63: "asfUzIuFAMEWwCHdEEdauKw"
64: "aNv4akT-hHk2f7x5Qz5Gjww"
65: "DiagnosticDeviceRestartedBecauseOfLowVoltageInPowerSupplyId"
66: "apKlYlK6B5UKemXM3WE5CqA"
67: "aGaSAIaA7akWhSYOgKvsQCQ"
68: "a_z5LVdLDv02tI03qeQURUQ"
69: "DiagnosticGpsNotRespondingId"
70: "a-edUxxb-s0SgJvp3GzCP2Q"
71: "al0MxmSV71kGN-hiV3TXmIw"
72: "ayqnGUB_LY0umEzpNpW6gtw"
73: "aBp6GC53thki3SdIY6l60ag"
74: "aM-P0w824akW9ZbMQVR0ZDQ"
75: "DiagnosticDeviceRestartedDueToInternalWatchdogConditionId"
76: "aq2RxarWZ9Ey1E78Nnzv6Cg"
77: "aq0_bgE84UkqEYS3Q3W4bfQ"
78: "a-PhPBz3iDkKgQFZqBZidrQ"
79: "axMwLjGJu7ky1NG3FrMEIyw"
80: "aTimsx56_1E-pyzOzlUJfYA"
81: "aHbGUHDUu3EWAV8ZcMuufZg"
82: "acFU2akWf4Em6wMpGIF8rwA"
83: "aEPnsZHtMQk2f6siLuIAEPQ"
84: "DiagnosticIntermittentConnectionCommunicationsId"
85: "aF46bMZUQuEmW7nMuNuig4Q"
86: "aKaZPQpPkR0C-JTX4ADU0kA"
87: "aZpQedoUC4E20BrjZeU_G-g"
88: "a7QmO4IfGKEyw-A_HsgqPww"
89: "DiagnosticCanBusOscillatingActivePassiveId"
90: "azF05ux8JzUm8ViSkA9v-Kg"
91: "aq1tLwgwemUOg8NbMw7QbGQ"
92: "a-abP7hnZyUqOnJQroPUgig"
93: "aoZ263zQRHEWRdZHv6s_cpA"
94: "a6ATQY9QzwEKlWDsycvlYIw"
95: "aMnY8Qur2fkaA_kOEUDO67w"
96: "aIy5bkfE4UEGSZePHlt9MYQ"
97: "a8f6-SrT8skGQZW6KtSl7Tw"
98: "af3NS9ghZMkChAykt9584fQ"
99: "aNE-UoSUj_UOGB9h9tSKEHA"
100: "aoGPM1wAF30-NRmBa_PdhOQ"
101: "a9VzFTatoeEadLhsFIwptXg"
102: "afneS_bomckKrWpG2-ghsIA"
103: "awaovtNwKoEC8FJWZ-u5QSA"
104: "adAC8k50GRE-4UMkiNrRRCw"
105: "agzVF8LGFpky0EHprE8X7LA"
106: "aLrFZSVF4b0K7aK8odG2ukg"
107: "aVWsVEXkm5Emz-mvO0NMJdg"
108: "aZInGZpW3YEuxizVWuEYcmw"
109: "aUWiedqLmck-QvbMp82nAAQ"
110: "aw48AiYID1Uis-rbM8ZvpNQ"
111: "a53LVTgzPbU2toWIhg_n-Uw"
112: "arW2yYfnMZUi01w5v0JGokw"
113: "aJUa3taK8EUGuv3R18Zy6uQ"
114: "aTllSi3AzaEGxt_anfq7L8w"
115: "amVK3uCTvH0mEv7HQ-BuX-A"
116: "a6l84GVB_DkmgUNXAyK_rwg"
117: "aA8bOA7osCEWCHSI40makAQ"
118: "ahcw84I1FB0i2miOXuJCN_w"</code> I have started a conversation with the committee responsible for updating SDK/HDK documentation and will seek to have the team generate more documentation outlining best practices and details of working with fault data - but if you are in need of further immediate support; say if you are currently working on an integration and not having this info is a blocker to project completion -- then do feel free to open a support case and reference this community question/post so we can hop in and further assist further you.  Hope this helps!  Regards, Alej H.

MyGeotab Fault Data question

<code>api.call("Get", {
 "typeName": "StatusData",
 search:{
 diagnosticSearch:{
 id:"DiagnosticDeviceTotalIdleFuelId" }
 },
 "resultsLimit": 10
}, function(result) {
 console.log("Done: ", result);
 
}, function(e) {
 console.error("Failed:", e);
});
/*opt nomin*/</code>Heya RKoon_664, See the above sample for a basic call that would look for this particular Status data. Note: this call was made using the <a href="https://geotab.github.io/sdk/software/api/runner.html#" target="_blank">javascript api runner</a>  If you're going to be building a report for multiple devices and over a time-span of days, the best thing to do would be to use getFeed and process the returned JSON data, using the relevant id of the device and the relevant diagnostic ids to build your report. Sample of the returned data below:   <img src="/forum/plugins/gcs-uploads/files/0692J00000DyBjdQAF.png" alt="Screenshot 2021-05-07 4.17.43 PM" /> Hope this helps!-Alej

Total fuel used while idling thru the Geotab API

Hi Ayersha,  Just to follow up, were you able to set up the multi-call for the desired status data? In addition to the c# multicall example and FAQ found at the bottom section of the<a href="https://geotab.github.io/sdk/software/guides/concepts/" target="_blank"> reference page</a>, here is a generic multi-call function that you can use as reference. Do let us if we can provide further support with your script! Regards, Alej<code>public ICallResult &lt; List &lt; MyStatusData &gt;&gt; GetAllDesiredStatusData(IEnumerable &lt; UniqueStatusDataRequests &gt; uniqueStatusDataRequests)
{
 List &lt; object[] &gt; desiredDataCalls = new List &lt; object[] &gt; ();
 foreach(var item in uniqueStatusDataRequests)
 {
 object[] call = new object[] {
 "Get",
 typeof (StatusData),
 new
 {
 search = new {
 deviceSearch = new DeviceSearch {
 Id = item.DeviceId
 },
 diagnosticSearch = new DiagnosticSearch {
 Id = desiredDiagnosticId
 },
 fromDate = item.FromDate,
 toDate = item.ToDate
 }
 },
 typeof ( List &lt; StatusData &gt; )
 };
 desiredDataCalls.Add(call);
 }
 
 var multiCallResults = Client.MultiCall(desiredDataCalls.ToArray());
 var data = new List &lt; MyStatusData &gt; ();
 
 foreach(var result in multiCallResults)
 {
 var statusData = ((IEnumerable &lt; StatusData &gt; ) result) ;
 data.AddRange(statusData);
 }
 return new CallResult &lt; List &lt; MyStatusData &gt;&gt; () {
 Data = data, ObjectName = "StatusDataGeotab"
 };
}</code>

If there are more than 100K vehicles, how do you get mileages of all vehicles on a daily basis using the MyGeotab SDK?

Hi AHey_471  Hope all is well! I've reached out via email to you to get some more details so we can resolve this issue :)  Regards, Alej

Why would SSRS not work properly in an Add-in

Hi AAlonso,  When you do a Get Device call, you'll find the two following properties: parameterVersion and parameterVersionOnDevice. if parameterVersion is higher than parameterVersionOnDevice, that means that there is a pending change on this device that is yet to take place at the device level, but which has been requested in the UI:   If both values are equivalent, this means that there are no pending changes on the device: <img src="/forum/plugins/gcs-uploads/files/0692J00000D0KEjQAN.png" alt="Screenshot 2021-02-22 at 3.54.24 PM" />  Hope this resolves your inquiry!  Regards,  Alej

Pending changes of device through MyGeotab SDK

Hi TWalu_486,  Here is the call on insomnia, the headers were automatically generated after I inputted the correct URL to which the POST call would be made and as you can see just including the below code in the body should be enough to get the desired data: <code>{
 "method":"GetAddresses",
 "params":{
 "coordinates":[
 {
 "y":"40.658499",
 "x":"-73.980357"
 },
 {
 "y":"39.950858",
 "x":"-75.192500"
 }
 ],
 "credentials":{
 "database":"myDatabase",
 "sessionId":"redactedSesshId",
 "userName":"alejemail@geotab"
 }
 }
}</code> <img src="/forum/plugins/gcs-uploads/files/0692J00000CzkFMQAZ.png" alt="Screenshot 2021-02-17 at 1.06.48 PM" />I did note that the Content-Type which is automatically generated by insomnia is application/json: you should not need to configure this if using insomnia. <img src="/forum/plugins/gcs-uploads/files/0692J00000CzkIBQAZ.png" alt="Screenshot 2021-02-17 at 1.10.40 PM" />  Do let us know if you need further support! Regards, Alej.

JSON/HTTP API Documentation

Hi JGonz_722,  For reference, here is <a href="https://developers.google.com/maps/documentation/distance-matrix/" target="_blank">one option</a> (Google's distance matrix API) you could use to calculate the driving distances &amp; duration info between route points: <ul><li>It is also good to keep in mind that we currently support up to a maximum of 24 waypoints for a route/route plan. </li><li>I did confirm that we do not provide an API method to retrieve this particular info; although I will make some further inquiries and see if there are planned changes to this functionality down the road/in the near future. </li></ul> Regards, Alej.

what is the structure to add planned trips(routes) using the python api?

Hi Twalu_486,  Below is code you can try out in the <a href="https://geotab.github.io/sdk/software/api/runner.html" target="_blank">api runner</a> , and also the actual JSON-RPC associated with this API call. See the example below:<code>api.call("GetAddresses", {
 coordinates:[
 {y:"40.658499",
 x:"-73.980357"},
 
 {y:"39.950858",
 x:"-75.192500"}
 ]
 
 // "resultsLimit": 10
}, function(result) {
 console.log("Done: ", result);
}, function(e) {
 console.error("Failed:", e);
});
/*opt nomin*/</code><img src="/forum/plugins/gcs-uploads/files/0692J00000CecdTQAR.png" alt="Screenshot 2021-02-16 at 3.37.50 PM" />Returned data ^ ... from the console, we can see the JSON info for this call is:  (Method: POST,Request URL: https://myXYZ.geotab.com/apiv1,content-type: application/x-www-form-urlencoded) <code>{
 "method":"GetAddresses",
 "params":{
 "coordinates":[
 {
 "y":"40.658499",
 "x":"-73.980357"
 },
 {
 "y":"39.950858",
 "x":"-75.192500"
 }
 ],
 "credentials":{
 "database":"myDatabase",
 "sessionId":"redactedSesshId",
 "userName":"alejemail@geotab"
 }
 }
}</code>Do let us know if you require further support - Hope this helps! Regards, Alej.

最近の活動