Getting time from Queries API (Analytics New)

API & integrations
1

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.

2

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
3

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

4

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

1 Like