Custom pivots API
The custom pivots API allows you to take existing list and pivot reports and represent them as JSON. This enables developers to pull related data from multiple types of records in a single API query.
There are two types of reports that you can pull via this API: list or pivot. See the documentation below for a full explanation of their formats.
The :report_id
parameter is the ID of a saved view in Aha! To find the
ID of an existing report, choose the report from the Views -> Saved views
dropdown in Aha! Then take the large number at the end of the URL with the term
custom_pivots in it. For example, /bookmarks/custom_pivots/6434552458299516367
has a :report_id
of 6434552458299516367
.
Get the list view of a saved report
GET /api/v1/bookmarks/custom_pivots/:report_id
The list view responds with a JSON object with three attributes: pagination, columns, and rows.
The columns attribute is an array of objects that give detailed information about the columns of the list. The objects include the name of the table, the field, and a human readable title attribute.
The rows attribute is an of array of arrays. Each object within the inner array contains the value of that for a specific column. Each object contains attributes for various representations of the data. The fields are:
id
: The unique id of the objectplain_value
: A string representation of the objecthtml_value
: An HTML representation of the object. This is the same HTML that is used in Aha! to represent the value in our reports.rich_value
: If the object is a reference to another object (such as a tag), the, this will be the object representation. For instance, a tag would be representated as:
{
id: "6013053275679792248",
name: "API"
}
The third attribute is pagination. This works like everywhere else in the Aha! API and is documented here.
Name | Description |
---|---|
report_id | The ID of the saved report in Aha! |
view | The type of API response you want: |
Example request
GET /api/v1/bookmarks/custom_pivots/801750833?view=list
Example CURL command
curl -g "https://company.aha.io/api/v1/bookmarks/custom_pivots/801750833?view=list" -X GET \
-H "Authorization: Bearer 15b60d42d4bc417284a246ced6877b0bf13fb4aca415f7b55f7006bc3694a8ab" \
-H "Content-Type: application/json" \
-H "Accept: application/json"
Request
authorization: Bearer 15b60d42d4bc417284a246ced6877b0bf13fb4aca415f7b55f7006bc3694a8ab
contentType: application/json
accept: application/json
Response
Status: 200 OK
contentType: application/json; charset=utf-8
Response body