Community
Driver-Assignments Endpoint Data Returned Question
almost 3 years ago by Sarah H.
Hello,
I am using PowerShell to connect to the Driver-Assignments endpoint. I export the data to a CSV file, which we then use to automatically upload to our local databases. We use this format for 5 - 10 different API calls, but I have an issue with this specific end point.
If multiple drivers have driven the same asset, the drivers are listed in a single cell, versus being listed as new rows for the same asset ID. Is there another way to pull this information? The way the data comes back currently is unusable in our databases. I need the data to be returned in a way that shows a single asset ID and then a single driver ID.