API GPS Import
Tracksolid Pro OpenAPI (raw GPS vendor). Choose endpoint to test.
Devices
Fetch list of device names (and IMEI) for the configured account. Use “Force new token” if the cached token is expired or you rotated credentials.
Step 3: GPS for day
Pick a device and date, or run all devices (fleet) for one date. A row is written to tbl_logs per fetch (logtype=APIfetch). Run Step 2 first so the token is cached.
Do this first:|
Mode
Step 4: Fetch GPS steps
For jobs on the selected date where steps_fetched = false, derive step 2–4 from tbl_tracking and write to tbl_vworkjobs. Each job is then marked steps_fetched = true, steps_fetched_when = now(). Use "Reset Steps" to clear the flag so jobs can be re-run.