Hello, Got a question regarding setting up the "MyGeotabAPI adapter" in my local machine. model: DM2version: v3.13.0MyGeotabAPIAdapter_SCD_win-x64.zipSQL server SQL platform: SSMS 21 Following is the:"Device": {
        "EnableDeviceCache": true,
        "DeviceCacheIntervalDailyReferenceStartTimeUTC": "2025-01-01T06:00:00Z",
        "DeviceCacheUpdateIntervalMinutes": 1,
        "DeviceCacheRefreshIntervalMinutes": 1440
      },
      "User": {
        "EnableUserCache": true,
        "UserCacheIntervalDailyReferenceStartTimeUTC": "2025-01-01T06:00:00Z",
        "UserCacheUpdateIntervalMinutes": 1,
        "UserCacheRefreshIntervalMinutes": 1440
      },error when I start api:  2025-11-05 16:11:39.9492|INFO|"******** PAUSING SERVICE: DatabaseMaintenanceService2 because of the following:
&gt; The Orchestrator service has not completed initialization.
The DatabaseMaintenanceService2 will check again at 11/5/2025 9:11:44 PM (UTC) and will resume operation if the Orchestrator service has completed initialization at that time.
"||MyGeotabAPIAdapter.Logging.MessageLogger|
2025-11-05 16:11:40.3148|INFO|Initialization completed.||MyGeotabAPIAdapter.Services.Orchestrator2|
2025-11-05 16:11:41.1251|INFO|******** STARTING SERVICE: MyGeotabAPIAdapter.BinaryDataProcessor2 (v3.13.0.0)||MyGeotabAPIAdapter.Services.BinaryDataProcessor2|
2025-11-05 16:11:41.2785|INFO|"******** PAUSING SERVICE: BinaryDataProcessor2 because of the following:
&gt; The prerequisite DeviceProcessor2 has never been run.
&gt; The prerequisite DeviceProcessor2 is not currently running or has not yet completed initialization.
Please ensure that all prerequisite processors are running. The BinaryDataProcessor2 will check again at 11/5/2025 9:11:51 PM (UTC) and will resume operation if all prerequisite processors are running at that time.
"||MyGeotabAPIAdapter.Logging.MessageLogger|
2025-11-05 16:11:41.8026|INFO|******** STARTING SERVICE: MyGeotabAPIAdapter.ChargeEventProcessor2 (v3.13.0.0)||MyGeotabAPIAdapter.Services.ChargeEventProcessor2|
2025-11-05 16:11:41.9561|INFO|"******** PAUSING SERVICE: ChargeEventProcessor2 because of the following:
&gt; The prerequisite DeviceProcessor2 has never been run.
&gt; The prerequisite DeviceProcessor2 is not currently running or has not yet completed initialization.
Please ensure that all prerequisite processors are running. The ChargeEventProcessor2 will check again at 11/5/2025 9:11:51 PM (UTC) and will resume operation if all prerequisite processors are running at that time.
"||MyGeotabAPIAdapter.Logging.MessageLogger|
 
2025-11-05 16:11:42.4718|INFO|******** STARTING SERVICE: MyGeotabAPIAdapter.ControllerProcessor2 (v3.13.0.0)||MyGeotabAPIAdapter.Services.ControllerProcessor2|
2025-11-05 16:11:42.6223|INFO|Controller cache cleared.||MyGeotabAPIAdapter.GenericGeotabObjectCacher`1|
2025-11-05 16:11:42.8622|INFO|Controller cache updated with 815 records added.||MyGeotabAPIAdapter.GenericGeotabObjectCacher`1|
2025-11-05 16:11:42.8622|INFO|Controller cache refresh completed.||MyGeotabAPIAdapter.GenericGeotabObjectCacher`1|
2025-11-05 16:11:43.1555|INFO|******** STARTING SERVICE: MyGeotabAPIAdapter.DeviceProcessor2 (v3.13.0.0)||MyGeotabAPIAdapter.Services.DeviceProcessor2|
2025-11-05 16:11:43.3010|INFO|Device cache cleared.||MyGeotabAPIAdapter.GenericGeotabObjectCacher`1|
2025-11-05 16:11:43.7436|INFO|ControllerProcessor2 pausing for the configured update interval (00:10:00).||MyGeotabAPIAdapter.BackgroundServiceAwaiter`1|
2025-11-05 16:11:44.1486|INFO|******** STARTING SERVICE: MyGeotabAPIAdapter.DeviceStatusInfoProcessor2 (v3.13.0.0)||MyGeotabAPIAdapter.Services.DeviceStatusInfoProcessor2|
2025-11-05 16:11:44.2982|INFO|"******** PAUSING SERVICE: DeviceStatusInfoProcessor2 because of the following:
&gt; The prerequisite DeviceProcessor2 and UserProcessor2 have never been run.
&gt; The prerequisite DeviceProcessor2 and UserProcessor2 are not currently running. 

Mygeotab API Adapter - DeviceProcessor2 and UserProcessor2 have never been run

Using the myGeotab Adapter API, I can't seem to find the data I need in the published data dictionary.  Looking for "Status" where valid values are OFF, ON, D, INT_D, SB, and YM.  Also looking for "Duration" 

myGeoTab API Adapter, looking for specific data

Doesn't the SDK obect model match one-to-one to the GeotabAdaptor database Schema ? e,g., DVIRLogs table does not contain AuthorityAddress as specified in Geotab Developers (SDK Manual). If we need these properties in the GeotaAdaptor database what should be done ?

Why Geotab SDK object properties do not exist/match what is in GeotabAdapter Schema ?

I'm trying to locate fuel consumption data while using the Geotab API adapter. When I log into MyGeotab.com, I can find fuel-related information, but I am unable to find any fuel-related data or the corresponding tables via the API adapter.I need this data to calculate MPG (Miles Per Gallon). I have already located the odometer data required for the calculation. I initially assumed the fuel data might be in the Diagnostics table, but it doesn't appear to be there.Could someone please guide me on where to find this fuel data or suggest alternative tables that might contain this information?Thank you for your assistance!

Locating Fuel Consumption Data via Geotab API Adapter

Hello everyone,I'm currently using the MyGeotab API Adapter to retrieve raw data, specifically through the "appsettings.json" file. However, I've noticed in the data dictionary that this setup doesn't include information on the posted speed limit. Has anyone encountered and solved this issue? Any insights or suggestions on retrieving the max road speed data would be greatly appreciated!Thank you!

Assistance with Retrieving Max Road Speed Using MyGeotab API Adapter

Just managed to successfully run the API adapter on linux at the command prompt. Looking for a way to install it &amp; run it as a windows service-like. that will restart on reboot or failure. Any pointers? Thanks,Nic

run API adapter as unattended (or service) on linux

The 'AdapterMachineName' of ***-ops' is different than that of ***-data-01' logged in the adapter database for the 'BinaryDataProcessor' AdapterService.

deploy the API Adapter to a prod machine throws an error

It started to throw this errorCould someone please point to where I can start troubleshooting? Is disabling the Rule cache a good option? Thanks,Nic

Geotab API Adapter Cache

Hello CommunityI starting to use the database MyqGeotab API Adapter and Api OPtimizer and have a couple of questions about the data model.1.- In the Optimizer db I have the [DiagnosticsT] with the [DiagnosticCode] which is really useful for our case, but I want to link them to he corresponding RuleiD and cannot see how to relate this code within the db.  2.- I want to use the user groups to classify the exceptionevents, in the users table there's no information about the user groups, where is this information in the db? Thanks in advance for your help

Data model MyGeotab API Adapter / Optimizer

Started to use the API adapter few days ago and really impressed with the quality of the work. I ran into an issue. myGeotab portal shows asset details on a page that takes as an input the device GeotabID and displays the device.name plus asset type and asset groups.  Can't seem to be able to locate the type and group table/fields in the API adapter database. Do in need to use different means to download them? Thanks,Nic

download asset information (type and groups) form MyGeotab API

I've setup the API Adapter and I'm trying to retrieve as much data from it as I can that I used to pull through the C# SDK. One thing I absolutely need to get is odometer data. I'm not seeing that I'm getting StatusData for all of our units for the odometer. I can see units that are showing odometer values updating when I look at our asset list in the website, and if I use the SDK to pull the 'DiagnosticOdometerAdjustmentId' diagnostic (where FromDate and EndDate are set to UtcNow), I get the updated value. But I'm apparently not getting the corresponding data flowing into the Optimizer database. From what it looks like, the only odometer data I'm getting in the Optimizer database is the 'DiagnosticOdometerId' data, not the adjustment data. This isn't happening for all units though. So, does this mean that there's something wrong that's not allowing the Geotab device to read the actual odometer reading from the ECM and is therefore having to generate a guessed amount? If so, is there any way to get adjustment odometer data through the API adapter? I'd like to be able to rely on the API adapter data as much as possible, but in order to do that, I need to be able to get odometer readings for all of our units. Thanks,Sean

Determining unit's current odometer with API Adapter data in Optimizer database

I currently retrieve from the SDK any duty status logs that show a codriver but we don't show the driver in our backend system having a codriver and then email this information to the appropriate party to see if the codriver should be removed in Geotab. I'm not pulling in data with the API adapter and I see that we're getting JSON data in the CoDriver field in the DutyStatusLogs table when the driver has a codriver, but the Id for the codriver is always empty. Is there a way to have this be populated with the Geotab user id of the codriver? If there is no codriver on the log, the CoDriver field in the record is null, so we can identify which drivers have an attached codriver, but we just can't determine who the codriver is based on the field being empty in the database. Thanks,Sean