Getting time from Queries API (Analytics New)

How do I get time from the Queries API (…/api/analytics/v1/query/)?
The column that is supposed to return the time is ‘timestamp’ but it returns the only date.
The type for the timestamp is also date type in the documentation here.

Query api is the one used to create aggregated reports. You can do with it whatever is possible within the user interface. In the UI it’s not possible to create a report aggregated by exact timestamp.

If you need all details (including exact timestamps), please use sessions or events API instead.

1 Like

Thank you. I guess I will need a different client credential for the session and/event API.

You can use the same client credentials for the session and event API.

1 Like