Hello, I am able to connect to Geotab using the Api adapter. How can I use the Api to pull specific reports?
Skip to main content
How to pull certain reports using the Geotab adapter API
JRome-1938
Original Poster
Join the conversation
You need to be logged in to reply to this post and participate in the Geotab Community discussions.
8 Replies
Hello @JRome-1938 ,
Thank you for asking your question in our community. Simply put you can't. The API Adapter pulls the data. You would have to create the reports on your end with the data that you pull.
Feel free to ask any follow up questions. We are here to help.
Have a good one!
Eishi FUN
JRome-1938
Original Poster
Edited by JRome-1938
Great, since it's connected, I should be able to access all the data I need.
I'll go ahead and create the report on my end.
For instance, Geotab sends me an Excel file with the necessary columns for the report I need to recreate in Microsoft SQL Server. However, I'm unable to locate a specific column labeled "Device". Should I make adjustments in the appsettings.json file to resolve this issue?
The Data Dictionary section in the API Adapter guide (https://docs.google.com/document/d/12TIgTCuWVF_AYc3evsIms9VOecc1NT4P9Kn-eVg-H7k/edit#heading=h.t2qoeecgt3g6) shows all of the tables in the adapter database. The Devices table lists all of the devices and the GeotabId column is the Device.Id. In other tables, such as the StatusData table, there will be a "DeviceId" column that corresponds with the GeotabId in the Devices table.
Note that the adapter database should be considered a staging database as it really contains raw data pulled from the MyGeotab API and is not relational. See the Suggested Strategy (https://docs.google.com/document/d/12TIgTCuWVF_AYc3evsIms9VOecc1NT4P9Kn-eVg-H7k/edit#heading=h.aqakdi5gf7v6) section in the guide for more information.
The "Understanding the Database Through Examples" (https://docs.google.com/document/d/12TIgTCuWVF_AYc3evsIms9VOecc1NT4P9Kn-eVg-H7k/edit#heading=h.thdwbufa83yi) section provides more information to help understand and work with the data.
Let us know if you have any other questions!
JRome-1938
Original Poster
I've thoroughly reviewed the data dictionary and written an SQL query to retrieve the specific columns I need from the database. Despite my efforts, I still cannot locate these fields. The columns in question are from an Excel sheet sourced from Geotab.
Could someone assist me in resolving this issue? If I'm extracting data from Geotab, why are the fields I'm looking for missing? I've attached an image showing only 6 out of 15 exist in the database.
Hey @JRome-1938 Will you please make a support ticket about this. Support should be better equipped to help iron this out for you and get you what you need.
I am sorry I could not offer more help in the community for this. If you need anything else feel free to reach out. I can help you make a ticket as well if you would like.
Have a great day!
Eishi FUN
JRome-1938
Original Poster
Hello I tried to fill out the support ticket but it did not go through. So, yes I need help thank you.
JRome-1938
Original Poster
Thank you for your help!
Still have questions?