Hello @Maarten Oosterkamp ,
Thanks for the question and using MS Q&A platform.
From my research - The output returns data in a complex format
Username : string
Trips : Array of TripID
From this doc and from my testing ODATA connector does not support the complex types
Now I was able to achieve your requirement partially using the copy activity using a REST API Connector.
RESTAPI Connector :
You can parameterize the above the url as per your need.
This might not still meet your requirement of getting the TripId Values.
You will have to make use of the Mapping Data flow. To make the necessary transformation to get the TripID Values.