Hi Team,We pull data for our fleet via the API. We call teh various api endpoints on a daily basis and ask for the last 48 hours of data, so every day there is an overlap of 24 hours in case any data is missed.Even doing that though, often we find that if we go back at month end and pull the whole month we fill in gaps with missing data. What's the best method of pulling the data from the geotab datasets to avoid this? We pull a lot of different callsevents, trips, odometers, engine hours, log status, etc etc. Would really appreciate knowing how we can pull the data using a reported date instead of the event date so we know we've got everything, thanks 

Method of get late reporting assets

Hi Team,I've been pulling data from geotab for a few years now via the APIs, but as we get bigger i need to ask a best practice question.​Currently we make a call tovgrt devices and from those devices we then make calls to get the events for those devices over a period of time. The event comes with date/time rule info etc.​ then make calls to get odometer values, engine hours, coordinates, speed limits for overspend events etc etc.​I'm hoping someone will tell me I've been doing it the hard way and that there is a simpler method to pull events with the associated info of the asset at that time. Is there an option to call the apis and have a it return almost a flat table version of the assets at the time of the event?​  

Getting the data all at once

Hi Team,I've recently been successful in getting the tyre pressure out via an API call. The value returned as an example was 248000 and wanted to know how to turn this number into PSI/kPa/BAR? Is it just missing a decimal point somewhere? thanks

Tire Pressure values that come from the Geotab API

page-user page-user-support-fleetyr-2132 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

thanks Eishi, Iv'e peiced this all together now and I can see an improvement. There does come one more question though and it has to do with the adjusted engine hours. I make a call to get an adjusted engine hour reading based on the following trip start dates 2026-06-30 21:44:00	3515.986344166672026-06-30 04:10:00	4169.414330833332026-06-02 22:03:00	2861.14995666667 These results were asked for not in the same call, but certainly with in moments of eachother.Why does the adjusted hour value bounce around? Is this because in the background there is an additional record which suggests an increase in engine hour usage, but then also in the background there is an adjustment record? How could I know when I should, after an adjustment has been made....is there a way to know programmatically that there has been an adjustment and that I should back back a period of days to get renewed values for those records? thanks

Is the answer that the status data call, of course, doesn't supply information on the DiagnosticOdometerAdjustmentId nor DiagnosticEngineHoursAdjustmentId?

Additionally, I have assets, which under previous status data calls using dates and filtered for diagnotistic ids I was getting engine hours and odometers. I've changed the call to suit what you suggested and not filter out any of the data on the server side. I'm getting tons of data for these assets - but not odometers now. I do note that I have all kinds of custom diagnotistic id's which aren't decoded, maybe it's hidden in those? How can I decode them?

Thanks for this. I've got it all working now. But strugglign with a couple of anomolies. I have an asset which between June 16 and June 22 (inclusive) show no engine hours in the status data output. The asset had activity. When I go to the front end and prepare Trips Detail report include the start of trip engine hours and end of trip engine hours the dates between June 16 and June 22 are populated with incrementing engine hours. I'm definitly getting all Status Data, it's all sequentially ordered. I'm not filtering anything on the query either.

Think I see how it works for events/faults/trips using GetFeed. How does this apply to statusdata and log records?So if I want to make sure I don't miss odometers/enginehour readings/log records/tyre pressure readings? How can I avoid missing those records that are reported late? But I didn't see the documentation for GetFeed for these data types. Also the VERSION.The VERSION is database specific? It is call specific as well? ie does FAULT have a differsion VERSION sequence then EVENTS and/or TRIPS? thanks

Thanks for this, this will take me some time to refer to and rebuild. Will post with updates, comments/concerns, Kind Regards,

Hi Team,We pull data for our fleet via the API. We call teh various api endpoints on a daily basis and ask for the last 48 hours of data, so every day there is an overlap of 24 hours in case any data is missed.Even doing that though, often we find that if we go back at month end and pull the whole month we fill in gaps with missing data. What's the best method of pulling the data from the geotab datasets to avoid this? We pull a lot of different callsevents, trips, odometers, engine hours, log status, etc etc. Would really appreciate knowing how we can pull the data using a reported date instead of the event date so we know we've got everything, thanks

Thanks for the responses. Let's try a different tac, is it possible to make Batch calls to statusdata and logrecord? Can you point me to the documentation for that? That might solve, or at least massively mitigate issues

Hi Team,I've been pulling data from geotab for a few years now via the APIs, but as we get bigger i need to ask a best practice question.​Currently we make a call tovgrt devices and from those devices we then make calls to get the events for those devices over a period of time. The event comes with date/time rule info etc.​ then make calls to get odometer values, engine hours, coordinates, speed limits for overspend events etc etc.​I'm hoping someone will tell me I've been doing it the hard way and that there is a simpler method to pull events with the associated info of the asset at that time. Is there an option to call the apis and have a it return almost a flat table version of the assets at the time of the event?​

Hi Team,I've recently been successful in getting the tyre pressure out via an API call. The value returned as an example was 248000 and wanted to know how to turn this number into PSI/kPa/BAR? Is it just missing a decimal point somewhere? thanks

Viimane tegevus

Method of get late reporting assets

Getting the data all at once

Tire Pressure values that come from the Geotab API