page-user page-user-jorge-pazrodriguez-1560 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

A broadcast-only group for receiving Geotab integrations news and updates!

Integrators Group

Hi <a href="/user/justin-cody-1821" data-id="1821" data-value="JCody-1821" data-denotation-char="@" class="text-decoration-none mention">@JCody-1821</a>​ The format of the API call would need to the following:<code>params=[
 typeName="ExceptionEvent",
 search = [fromDate = "2023-05-01T00:00:00.00Z", toDate = "2023-05-02T00:00:00.00Z", ruleSearch = 
 [id = "RulePostedSpeedingId"]],
 credentials = [database=database, username=username,sessionId=sessionId],
]</code>Note that for including filters in a <a href="https://geotab.github.io/sdk/software/api/reference/#Get1" target="_blank">GET API</a> calls you need to wrap the filters under a search object. Supported search properties are noted under the <a href="https://geotab.github.io/sdk/software/api/reference/#Get1" target="_blank">ExceptionEventSearch</a> reference, in there you'll see that for searching by a rule you need to have the ID of the rule you're interested in. So prior to making this call you would need to do a GET Rule API call to get the ID of the <a href="https://geotab.github.io/sdk/software/api/reference/#Rule" target="_blank">Rule</a> you're looking for. The API call would look like this for getting the default rule ID for speeding (Note this is using Insomnia and not Power BI):<code>{
	"method": "Get",
	"params": {
		"typeName": "Rule",
		"search": {
			"name": "Speeding"
		},
		"credentials": {
			"database": "{{ _.credentials.database }}",
			"userName": "{{ _.credentials.userName }}",
			"sessionId": "{{ _.credentials.sessionId }}"
		}
	}
}</code>The default speeding rule has an ID of RulePostedSpeedingId, however this would be different depending if you're using a custom rule.

GetFeed request limit?

Hi <a href="/user/cameron-martin-1617" data-id="1617" data-value="CMart-1617" data-denotation-char="@" class="text-decoration-none mention">@CMart-1617</a>​ ,Event handlers are currently not supported for notifications on GEOTAB Drive

Drive add-in push notification.

Hi <a href="/user/brett-galassi-1664" data-id="1664" data-value="BGala-1664" data-denotation-char="@" class="text-decoration-none mention">@BGala-1664</a>​ ,You'll need to add a fromDate and toDate property limits to your call so that you can only retrieve the ExceptionEvent data for that timeframe only, currently it's attempting to retrieve all of the data on your db. Try this format:<code>params=[
 typeName: "ExceptionEvent",
 credentials=[database=database, username=username, sessionId=sessionId ],
 fromDate="2022-07-14T17:22:10.996Z",
 toDate="2022-07-14T17:22:10.996Z"
]</code>Note that in the example format the fromDate and toDate are hardcoded, try converting them into variables as the database, username, and sessionId values are being used. This way you can dynamically configure them to be changed for your reports. You can also introduce other filters depending on what you want to achieve ( <a href="https://geotab.github.io/sdk/software/api/reference/#ExceptionEventSearch" target="_blank">ExceptionEventSearch</a> ), so you'll need to combine the knowledge of the GEOTAB API with the capabilities that PowerBI offers.

Hi <a href="/user/john-livermore-1628" data-id="1628" data-value="jeljeljel-1628" data-denotation-char="@" class="text-decoration-none mention">@jeljeljel-1628</a>​ you just new to include the new token before the GeotabApi instantiation. <code>$(document).ready(function() {
 var api = new GeotabApi({
 credentials: {
 database: 'mydb',
 userName: 'myusername',
 password: 'mypassword'
 },
 path: 'my.geotab.com'
 });
});</code>

error using javascript GeoTab api

Hi <a href="/user/johnj-johnj-1380" data-id="1380" data-value="jjohn-1380" data-denotation-char="@" class="text-decoration-none mention">@jjohn-1380</a>​ ,The parent needs to be set as an object with the id property in it. See the example below:<code>{
	"method": "Add",
	"params": {
		"typeName": "Group",
		"entity" : {
			"name" : "MY_GROUP_NAME",
			"parent": {
					"id":"MY_ID"
			}
 },
		"credentials": {
			"database": "MY_CREDENTIALS",
			"userName": "MY_USERNAME",
			"sessionId": "MY_SESSION_ID"
		}
	}
}</code>

"Id" Parameter needed for Add Group?

Hi <a href="/user/seth-pierce-1151" data-id="1151" data-value="Seth-1151" data-denotation-char="@" class="text-decoration-none mention">@Seth-1151</a>​,You can use the GetDeviceContractTransactions api call providing the necessary filters for the billing period you're looking for, this will return an array of ApiDeviceContractTransaction objects with the billing details for each device.  You can review more about these calls in the <a href="https://myadmin.geotab.com/sdk//#/api-reference" target="_blank">MyAdmin SDK reference site</a> and a guide on how to make the calls in JavaScript <a href="https://myadmin.geotab.com/sdk//#/using-javascript" target="_blank">here</a>.

What method/object do I call from the MyAdmin SDK to get the current billing costs per device for all of the current devices in our account?

Adding the id as empty will return no results. You need to just send the object as empty ("userSearch": {}), try using it like this:<code>{ 
 "method": "Get", 
 "params": { 
 "search": { 
 "userSearch": {}, 
 "fromdate": "2022-02-06T00:26:49" 
 }, 
 "typeName": "DutyStatusViolation", 
 "credentials": { 
 "database": "mydatabase", 
 "path": "ThisServer", 
 "sessionId": "mysessionid", 
 "userName": "myusername" 
 } 
 } 
} </code>

Driver Violations

Yes, you should be able to do it by supplying an empty userSearch object.

Hi <a href="/user/ron-koontz-1279" data-id="1279" data-value="RKoon-1279" data-denotation-char="@" class="text-decoration-none mention">@RKoon-1279</a>​ ,Thanks for sharing your API call. One thing that I noticed is that you're using carrierNumber as a search property, you will need to perform the search by one of the supported search properties for this API call (id, companyGroups, driverGroups), you can find more details by reviewing the <a href="https://geotab.github.io/sdk/software/api/reference/#DutyStatusViolationSearch" target="_blank">DutyStatusViolationSearch reference</a><code>{ 
 "method": "Get", 
 "params": { 
 "search": { 
 "userSearch": { 
 "id": "USER_ID" 
 }, 
 "fromdate": "2022-02-03T13:26:49" 
 }, 
 "typeName": "DutyStatusViolation", 
 "credentials": { 
 "database": "mydatabase", 
 "path": "ThisServer", 
 "sessionId": "mysessionid", 
 "userName": "myusername" 
 } 
 } 
} </code>  I was able to retrieve unverified violations right after they were triggered via the API with my test device. The way in which violations are triggered depend on the type of the violation and the ruleset that the driver has configured, you can review the specifics for each rule set by following this <a href="https://docs.google.com/document/d/10g2IAP8WjYQveYb-BEOEeEuElE2EOtBH4L13fRyeeTI/edit?usp=sharing" target="_blank">link</a>. If you're still presenting problems, feel free to reach out to me via email with the specific details and we can go over the specifics of your API call and current results.

Hi <a href="/user/ron-koontz-1279" data-id="1279" data-value="RKoon-1279" data-denotation-char="@" class="text-decoration-none mention">@RKoon-1279</a>​,Can you share the API call(s) that you're currently using so that we can review it.

Viimeaikaiset toiminnot