Hello,
Im trying to pull the same distance information I get on the Trip Summary page through API, I hace tried pulling the trips and then frouping them by start date, but get some minor differences comparing to the Trip summary page.
Now my approach is to get the ReportTripsSummary through API, can anuone help me build the call...
Thanks
You need to be logged in to reply to this post and participate in the Geotab Community discussions.
@AAlonso-1259 I hope all is well. You can use the following call to retrieve the report. Note, this method might be deprecated in the future.
{
"method": "GetExcel",
"params": {
"output": "pdf",
"isWebViewApp": false,
"credentials": {
"database": "", // insert your database name
"sessionId": "", // insert your sessionid
"userName": "" // insert your user name
},
"args": {
"reportArgument": {
"fromUtc": "2023-06-05T04:00:00.000Z", // run report for today
"toUtc": "2023-06-06T03:59:59.000Z",
"reportArgumentType": "DeviceActivitySummary",
"reportSubGroup": "None",
"minCustomerStopDuration": "00:00:00.000",
"groupLevel": -1,
"groups": [
{
"id": "GroupCompanyId"
}
],
"devices": [],
"includeZeroDistanceTrips": true
},
"template": {
"id": "ReportTemplateTripsSummaryId"
},
"name": "Standard",
"filter": [
{
"id": "GroupCompanyId"
}
]
}
}
}
@AAlonso-1259 I hope all is well. You can use the following call to retrieve the report. Note, this method might be deprecated in the future.
{
"method": "GetExcel",
"params": {
"output": "pdf",
"isWebViewApp": false,
"credentials": {
"database": "", // insert your database name
"sessionId": "", // insert your sessionid
"userName": "" // insert your user name
},
"args": {
"reportArgument": {
"fromUtc": "2023-06-05T04:00:00.000Z", // run report for today
"toUtc": "2023-06-06T03:59:59.000Z",
"reportArgumentType": "DeviceActivitySummary",
"reportSubGroup": "None",
"minCustomerStopDuration": "00:00:00.000",
"groupLevel": -1,
"groups": [
{
"id": "GroupCompanyId"
}
],
"devices": [],
"includeZeroDistanceTrips": true
},
"template": {
"id": "ReportTemplateTripsSummaryId"
},
"name": "Standard",
"filter": [
{
"id": "GroupCompanyId"
}
]
}
}
}
Thanks @SidSalah-1262