Skip to main content
Support Center
Help ArticlesAcademyCommunity
HomeCommunitySDK/APIAPI AdapterData model MyGeotab API Adapter / Optimizer

Data model MyGeotab API Adapter / Optimizer

Solved
SDK/API
API Adapter
J
J
JVera-1874
Original Poster

Edited by EishiFUN

Hello Community

I 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

3
Join the conversation

You need to be logged in to reply to this post and participate in the Geotab Community discussions.

Top Answers

S
S
SteveD-1097

@JVera-1874​ ,

 

The Future-Proofing Queries Against Changes to Diagnostic Ids section in the guide should provide an understanding of how to use the Diagnostics tables.

 

The API Adapter doesn't currently pull Groups, so it would be necessary to do that separately using the SDK or you could modify the API Adapter (since it's open source) yourself. Groups are on the road map, but there's no ETA now.

 

Steve

Best Answer

3 Replies

S
S
SteveD-1097

@JVera-1874​ ,

 

The Future-Proofing Queries Against Changes to Diagnostic Ids section in the guide should provide an understanding of how to use the Diagnostics tables.

 

The API Adapter doesn't currently pull Groups, so it would be necessary to do that separately using the SDK or you could modify the API Adapter (since it's open source) yourself. Groups are on the road map, but there's no ETA now.

 

Steve

Best Answer
J
J
JVera-1874
Original Poster

Hi SteveD, thanks but one basic question, the ExceptionEvents table of the Adapter is the Statusdata table in Optimizer, is rigth?

Even this I'm not able to find the driver and deviceid of an entry of the statusdata table, the following query allways shows driver and deviceid blank

 

SELECT StatusDataT.DriverId, StatusDataT.DateTime, StatusDataT.DeviceId  FROM [GeotabO].[dbo].[DiagnosticsT] 

 left join StatusDataT on [DiagnosticsT].[id] = [DiagnosticId]

 left join DiagnosticIdsT on [DiagnosticsT].[GeotabGUID] = [DiagnosticIdsT].[GeotabGUID]

 left join FaultDataT on FaultDataT.DiagnosticId = [DiagnosticsT].[id]

 where [DiagnosticsT].[DiagnosticCode] = '479' 

  

 code 479 --> (Brake fluid level is low)

 

Thanks

 

 

 

 

 

S
S
SteveD-1097

@JVera-1874​ ,

 

The Optimizer Database doesn't have ExceptionEvents. Not all tables have been brought over from the adapter database. This slide provides more information.

 

Steve

Still have questions?
Learn with AcademyBrowse documents