Conversations - Drilldown by Field

This report is similar to the Conversations Report, but instead of returning statistics about conversation volume, it drills down and returns the conversation data (by conversation field) that makes up the Conversations Report.

Note: The reporting endpoints are only available to Plus and Pro plans.

Request

GET /v2/reports/conversations/fields-drilldown HTTP/1.1
Authorization: Bearer oauth_token

URL Parameters

Parameter Type Examples Description
start date start=2019-05-02T12:00:00Z
Start of the interval
end date end=2019-06-02T12:00:00Z
End of the interval
field enumeration field=tagid
The field on which to drill down; valid values are:
tagid (for tags), replyid (for saved replies), workflowid (for workflows), customerid (for most active customers)
fieldid number fieldid=55439
The identifier on which to drill down; can be an identifier representing a tag, saved reply, workflow, or customer
mailboxes number mailboxes=123
mailboxes=123,567
List of comma separated ids to filter on mailboxes
tags number tags=99787
tags=5666,99787
List of comma separated ids to filter on tags
types enumeration types=email
List of comma separated conversation types to filter on, valid values are email, chat, phone
folders number folders=991
folders=991,992
List of comma separated folder ids to filter on folders
page number page=2
The page number
rows number rows=30
Number of result to return per page; defaults to 25; maximum is 50

Response

HTTP/1.1 200 OK
Content-Type: application/json

{
  "conversations" : {
    "pages" : 157,
    "page" : 1,
    "count" : 1561,
    "results" : [ {
      "id" : 583,
      "number" : 12345,
      "type" : "email",
      "mailboxid" : 2,
      "attachments" : false,
      "subject" : "Sample subject",
      "status" : "active",
      "threadCount" : 6,
      "preview" : "This is a preview...",
      "customerName" : "John Smith",
      "customerEmail" : "john@example.com",
      "customerIds" : [ 2 ],
      "modifiedAt" : "2015-04-24T18:59:49Z",
      "assignedid" : 4,
      "tags" : [ {
        "id" : 123,
        "name" : "sample-tag",
        "color" : "none"
      } ],
      "assignedName" : "Mary Jones"
    } ]
  }
}

Response fields

Path Type Description
conversations.pages Number The number of total available pages
conversations.page Number The current page
conversations.count Number The number of total conversations included in all pages
conversations.results Array Contains abbreviated versions of each conversation associated with the search criteria

Response fields

Path Type Description
id Number Unique identifier of the conversation
number Number The conversation number displayed in the UI. This number can be used in combination with the id to construct a URL to the conversation on the Help Scout website. Example: https://secure.helpscout.net/conversation/<id>/<number>/
type String The type of conversation; Accepted values are:
chat
email
phone
mailboxid Number Identifier of the mailbox in which this conversation resides
attachments Boolean attachments
subject String Conversation subject
status String Status of the conversation; Accepted values are:
active
closed
open
pending
spam
threadCount Number The number of published threads found on the conversation (does not include line items, drafts or threads held for review by Collision Detection)
preview String Preview of the most recent thread in the conversation
customerName String The customer who this conversation is associated with
customerEmail String The customer email address who this conversation is associated with
customerIds Array Identifiers of customer this conversation is associated with
modifiedAt String The date/time this conversation was last modified
assignedid Number The identifier of the user assigned to this conversation
assignedName String The name of the User assigned to this conversation
tags Array Collection of tags with each element containing the tag identifier, name, and color