Pivot

Request

POST https://www.activityinfo.org/resources/query/pivot

Request body

application/json

object
sources	object		required
forms	array[string]		required
calculatedTables	array[object]		required
id	string		required
alias	string		required
formula	string		required
model	object		required
visualization	string	Values: TABLE BARCHART LINECHART PIECHART SLICER	required
measures	array[object]		required
id	string		required
code	string		required
label	string		required
formId	string		required
formula	string		required
statistics	array[string]	Values: COUNT COUNT_DISTINCT SUM AVERAGE MIN MAX	required
display	string	Values: DEFAULT PERCENT_ROW_TOTAL PERCENT_COLUMN_TOTAL PERCENT_GRAND_TOTAL	required
numberFormat	string		optional
calculated	boolean	True if this measure is a new, calculated measure.	required
dimensions	array[object]		required
id	string		required
label	string		required
mappings	array[object]		required
formId	string		required
formula	string		required
type	string	Values: FORM Maps the source Form's label to the dimension category FIELD Maps the source field's label to the dimension category VALUE Maps a value in the Record to the dimension category.	required
axis	string	Values: ROW COLUMN FILTER MAP	required
totals	boolean		required
missingIncluded	boolean		required
dateLevel	string	Values: DATE WEEK MONTH QUARTER YEAR WEEKYEAR MONTHYEAR QUARTERYEAR	optional
totalLabel	string		optional
missingLabel	string		optional
categoryMappings	array[object]		required
label	string		required
source	array[string]		required
visible	boolean		required
mapTemplateId	string		optional
filters	array[object]		required
id	string	The unique id of this filter within the analysis.	required
tableId	string	The id of the table on which to apply this filter.	required
columnId	string	The id of the column on which to filter.	required
active	boolean		required
filterType	string	Values: INITIAL BY_VALUE BY_CONDITION	required
selectedValues	array[string]		required
columnWidths	object		required
i	integer	The width of the column, keyed by the column index	required
showHidden	boolean		required

Response

Status Code	Error Code	Description
401	AUTHENTICATION_REQUIRED	The request must be authenticated

Next item

Query columns