Skip to main content

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.

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.

Type​

DatasetRowsResponse object​

Product

PricingFAQPaminga vs. MarketoMigration CenterMarketo to Paminga TranslatorMarketo Alternative
Paminga Logo
LinkedInFacebookXYouTube
ISO 27001 CompliantSOC 2 Compliant

Built with pride in Denver, Colorado, USA

Copyright © Paminga, Inc. 2026
All rights reserved. Various trademarks held by their respective owners.