You need to be logged in to reply to this post and participate in the Geotab Community discussions.
Depending on how much data you're planning to extract there are better options. The API adapter is the best way to do a data feed unless you're just looking at 1 or 2 data points, in which case I'd just use GetFeed with the API. Are you the one on your team who would be building this feed or implementing the API Adapter?
Hey @KNaga-2128,
Are you wanting to do this using the API? If so, are you going to get this data once per day, or do you want to constantly update it throughout the day?
If just something like once per day, you can do a Get for LogRecord and then take the coordinates received, and then use GetAddresses to get the addresses.
Let me know if that's the general idea of what you're trying to do and I can send a sample API request that does that.
Thanks,
Tucker
Hi @TuckerBA-1087 ,
Yes, I need to use API. We have a dashboard that is shown on a TV to let the supervisors know the current location of all vehicles. The dashboard is refreshed every 15 mins. Please note that the data will be extracted into our Lakehouse using API. This won't be a direct call from dashboard. Also, we may need current odometer reading along with LAT & LONG. Thanks.
For data extraction, is there any other option available other than API?
Thanks for your assistance.
Depending on how much data you're planning to extract there are better options. The API adapter is the best way to do a data feed unless you're just looking at 1 or 2 data points, in which case I'd just use GetFeed with the API. Are you the one on your team who would be building this feed or implementing the API Adapter?
Hi @TuckerBA-1087 : Apologies for the delayed response. We currently have a Power BI dashboard that displays real‑time vehicle locations using data from an existing telematics provider. We refresh the report every 15 mins. As several vehicles are now equipped with Geotab devices, we would like to integrate data from both telematics sources into a single, consolidated dashboard. I will be responsible for developing this combined data feed.
Please note that the API from the other provider is a direct, single‑point call from the report, returning details such as the vehicle name, latitude, longitude, tracker timestamp, location (address and suburb), and current odometer reading. Please guide how to achieve this in Geotab.
Hey @KNaga-2128,
There are a few different options for that. If you want to get this information in as few requests as possible, you could use DeviceStatusInfo and StatusData. DeviceStatusInfo is a calculated Object, not actually stored in the database anywhere at Geotab, but it grabs data from multiple tables at request time, so it's a little slower of a request if you have a lot of vehicles, but once every 15 minutes shouldn't be too terrible.
The better way to do this would be to use the API adapter that I linked above, but that would (by default) feed into it's own tables. If you need it to feed into your own tables, you would need to fork the repository and customize the feed, but that repository has feeds that follow all of the best practices.
The last option would be to just write the feeds yourself using GetFeed. If you do that, you'll need to do a feed for LogRecord for lat/long; Device for any device info like device name, serial number, id, etc; timestamp will be on the LogRecord; You can use GetAddresses on the lat/long to get the address information; and odometer reading would be StatusData.
Let me know if that makes sense, none of the options are particularly complicated. Option 1 is the simplest if you're looking for simplicity, and if you ever run into performance issues, you could switch to one of the others.