I am attempting to use the Python SDK to retrieve/query Trips for a particular device from one date/time to another that I can see from a report that I pulled from our environment.  My understanding is that the database date/time's are in UTC, so I am converting from out local time to UTC for simplicity sake. I know that I am pulling the correct device information as well. "trips.json" is what I receive back from this particular call, and it returns trips that started nowhere near the date entered. Can I get some help to get particular trips where the start (or end) date/times are within a certain bounds similar to what I have in the attached example report?import mygeotab.dates
import datetime, mygeotab, pytz
 
cst_tz = pytz.timezone('US/Central');
startDateTime_cst = cst_tz.localize(datetime.datetime(2024, 9, 3, 10, 34, 1));
startDateTime_utc = startDateTime_cst.astimezone(datetime.UTC);
 
endDateTime_cst = cst_tz.localize(datetime.datetime(2024, 9, 3, 11, 0, 0));
endDateTime_utc = startDateTime_cst.astimezone(datetime.UTC);
 
 
client = mygeotab.API(username='{username}', password='{password}', database='{db}');
client.authenticate();
 
device = client.get('Device', name='-')[0];
 
trips = client.get('Trip', FromDate=mygeotab.dates.format_iso_datetime(startDateTime_utc), ToDate=mygeotab.dates.format_iso_datetime(endDateTime_utc), IncludeOverlappedTrips=True, device=device);
 
print(trips);   069Pd00000DWcp9IAD.xlsx


Accurately querying MyGeotab Trips with Python SDK

page-user page-user-eli-ross-1985 template-account-profile page-status-200 theme-harmony user-guest

Company

Title

Thank you for your response <a href="/user/ajay-srinivasan-1240" data-id="1240" data-value="AjaySrinivasan-1240" data-denotation-char="@" class="text-decoration-none mention">@AjaySrinivasan-1240</a>​ , after applying the changes you recommended it looks like I continue to receive Trip objects with start times from completely different years.

I am attempting to use the Python SDK to retrieve/query Trips for a particular device from one date/time to another that I can see from a report that I pulled from our environment.  My understanding is that the database date/time's are in UTC, so I am converting from out local time to UTC for simplicity sake. I know that I am pulling the correct device information as well. "trips.json" is what I receive back from this particular call, and it returns trips that started nowhere near the date entered. Can I get some help to get particular trips where the start (or end) date/times are within a certain bounds similar to what I have in the attached example report?<code>import mygeotab.dates
import datetime, mygeotab, pytz
 
cst_tz = pytz.timezone('US/Central');
startDateTime_cst = cst_tz.localize(datetime.datetime(2024, 9, 3, 10, 34, 1));
startDateTime_utc = startDateTime_cst.astimezone(datetime.UTC);
 
endDateTime_cst = cst_tz.localize(datetime.datetime(2024, 9, 3, 11, 0, 0));
endDateTime_utc = startDateTime_cst.astimezone(datetime.UTC);
 
 
client = mygeotab.API(username='{username}', password='{password}', database='{db}');
client.authenticate();
 
device = client.get('Device', name='-')[0];
 
trips = client.get('Trip', FromDate=mygeotab.dates.format_iso_datetime(startDateTime_utc), ToDate=mygeotab.dates.format_iso_datetime(endDateTime_utc), IncludeOverlappedTrips=True, device=device);
 
print(trips);</code>  <a href="/forum/plugins/gcs-uploads/files/069Pd00000DWcp9IAD.xlsx" target="_blank"> 069Pd00000DWcp9IAD.xlsx</a>

Viimane tegevus

Accurately querying MyGeotab Trips with Python SDK