datasetRows
Rows from a dataset, grouped by whichever dimensions you request.
start_date and end_date always bound the query. A date dimension in
fields is separate and optional — it only decides whether rows are broken
out over time within that window. Requesting no date dimension collapses the
whole window into one row per remaining dimension combination.
Dates are read in your Paminga time zone, and date dimensions and timestamps come back in it too, so rows line up with what Paminga's own dashboards show for the same range.
Integrations (a Personal Access Token, an OAuth app) are rate limited per
credential; Paminga's own pages are not. An identical request from the same
person within two minutes is answered from a cache and counts against no
limit. A refusal carries extensions.code: RATE_LIMITED and
extensions.retryAfter in seconds.
A request that takes too long is stopped and refused with
extensions.code: DATASET_TIMEOUT; narrow the date range or add a filter.
datasetRows(
dataset: String!
fields: [String!]!
start_date: Date!
end_date: Date!
filters: [DatasetFilterInput!]
filterLogic: FilterLogic = AND
parameters: [DatasetParameterInput!]
first: Int!
page: Int = 1
compare: DatasetCompare = NONE
sort: DatasetSortInput
top: Int
orderTopBy: DatasetSortInput
withLinks: Boolean = false
runningTotal: Boolean = false
other: Boolean = false
dashboard_id: ID
dashlet_id: String
): DatasetRowsResponse!
Arguments
datasetRows.dataset ● String! non-null scalar
Dataset key, as returned by datasets.
datasetRows.fields ● [String!]! non-null scalar
Field keys to return. Row values come back in this order.
datasetRows.start_date ● Date! non-null scalar
First day of the window, inclusive, in your Paminga time zone.
datasetRows.end_date ● Date! non-null scalar
Last day of the window, inclusive, in your Paminga time zone.
datasetRows.filters ● [DatasetFilterInput!] list input
datasetRows.filterLogic ● FilterLogic enum
datasetRows.parameters ● [DatasetParameterInput!] list input
Values for the parameters the dataset declares: its own, and its computed metrics'. Only needed when a default is not wanted; a parameter the dataset does not declare, or a value outside its allowed set, is rejected.
datasetRows.first ● Int! non-null scalar
datasetRows.page ● Int scalar
datasetRows.compare ● DatasetCompare enum
Run the same request over a comparison window too and return its rows
aligned to this page in comparison. Paging applies to the current window.
Counts as two requests against the rows rate limit.
datasetRows.sort ● DatasetSortInput input
Order the groups before paging, so first: 10 is the top ten. Omit to keep the dataset's own group order.
datasetRows.top ● Int scalar
Keep only the first top groups in sort's order (the dataset's own order
without one): a top N that stays the same N however it is then ordered
and paged. first and page then page those groups, and total counts
them. Not with compare.
datasetRows.orderTopBy ● DatasetSortInput input
Order the top groups by this before paging them; sort still decides
which groups they are. Requires top.
datasetRows.withLinks ● Boolean scalar
Also return links for the records the rows name. The id (and kind) each
requested name needs is fetched beside it and returned as an extra field,
so rows are grouped by the record, not only its name.
datasetRows.runningTotal ● Boolean scalar
The rows are drawn as a running total (a cumulative line's buckets, or its baseline over everything before the window). A level whose past the dataset can rebuild (a list's members, unfinished sync runs, open opportunities, active workflow contacts) then comes back as its net change over each bucket, which the running total adds back up into the level at each bucket's end. Every other metric is unchanged.
datasetRows.other ● Boolean scalar
Also return other: everything past the first page (or past top) as one
row, the request's total less the rows shown, for metrics that add up. One
more query, the request ungrouped. Not with compare.
datasetRows.dashboard_id ● ID scalar
The custom dashboard and dashlet this request draws, for timing only; never changes the rows.
datasetRows.dashlet_id ● String scalar
The custom dashboard and dashlet this request draws, for timing only; never changes the rows.


