Session data

List session properties in table form

GET/api/websites/{websiteId}/session-data-pivot

Returns a page of sessions matching the selected property and filters, with the latest property keys and values grouped into one row per session.

Headers

Name	Type	Description
Authorizationrequired	string	Authentication credentials, e.g. `Bearer <token>`.

Path parameters

Name	Type	Description
websiteIdrequired	string	ID of the website.

Query parameters

Name	Type	Description
startAtrequired	integer	Start of the date range as a Unix timestamp in milliseconds.
endAtrequired	integer	End of the date range as a Unix timestamp in milliseconds.
propertyNamerequired	string	Name of the custom event or session property.
timezone	string	IANA time zone used to interpret dates and group results, for example America/New_York.
unit	string	Time interval used to group results: minute, hour, day, month, or year.
path	string	Filter by page URL path.
referrer	string	Filter by referring URL.
title	string	Filter by page title.
query	string	Filter by page URL query string.
os	string	Operating system used by the visitor.
browser	string	Browser used by the visitor.
device	string	Device category used by the visitor.
country	string	Country code of the visitor.
region	string	Region or subdivision of the visitor.
city	string	City of the visitor.
tag	string	Tag attached to the tracked activity.
hostname	string	Hostname on which the activity occurred.
distinctId	string	Custom identifier assigned to the visitor.
language	string	Preferred language reported by the visitor browser.
event	string	Filter by custom event name.
utmSource	string	UTM campaign source.
utmMedium	string	UTM campaign medium.
utmCampaign	string	UTM campaign name.
utmContent	string	UTM campaign content.
utmTerm	string	UTM campaign search term.
excludeBounce	string	Set a non-empty value to exclude visits with only one pageview.
segment	string	ID of a saved segment used to filter results.
cohort	string	ID of a saved cohort used to filter visitors.
eventType	integer	Event type: 1 for a pageview or 2 for a custom event.
match	enum<string>	Whether records must match all filters or any filter. Options: `all`, `any`
page	integer	Page number, starting at 1.
pageSize	integer	Number of results per page.
maxResults	integer	Maximum number of results to include.

Responses

200The operation completed successfully.

Name	Type	Description
countrequired	number	Number of matching records.
datarequired	object[]	Data returned by the operation.

isCapped	boolean	Whether the results were truncated by the maximum result limit.
orderBy	string	Field to sort the results by.
pagerequired	number	Page number, starting at 1.
pageSizerequired	number	Number of results per page.
search	string	Search text used to filter results.
sortDescending	boolean	Whether to sort results in descending order.

200 example

{
  "count": 0,
  "data": [
    {
      "createdAt": "string",
      "distinctId": "string",
      "propertyKeys": [
        "string"
      ],
      "propertyValues": [
        "string"
      ],
      "sessionId": "string"
    }
  ],
  "isCapped": true,
  "orderBy": "string",
  "page": 0,
  "pageSize": 0,
  "search": "string",
  "sortDescending": true
}

400Bad request.

Name	Type	Description
errorrequired	object	Error details returned when the operation fails.

400 example

{
  "error": {
    "code": "bad-request",
    "message": "Bad request.",
    "status": 400
  }
}

401Unauthorized.

Name	Type	Description
errorrequired	object	Error details returned when the operation fails.

401 example

{
  "error": {
    "code": "unauthorized",
    "message": "Unauthorized.",
    "status": 401
  }
}

Code samples

cURL

curl -X GET 'https://api.example.com/api/websites/{websiteId}/session-data-pivot?startAt=0&endAt=0&propertyName=string' \
  -H 'Authorization: Bearer <token>'

PreviousDelete a website segment or cohort NextGet session array values over time