PivotTableColumnInputV2

Input Object

aggFunc

How a value column adds up its cells; counts (countOf…) take count.

columnId

What the column shows: for a row, a group-by field (projects, assignees, statuses…); for a column, a date bucket (dateByDay, dateByWeek, dateByMonth, dateByQuarter, or projectDueDateBy…); for a value, a measure (countOfActions, estimatedTime…). A custom field uses its ID, and a tag its ID with discriminatorId. getDashboardWidgetOptions lists the IDs a report allows.

columnWidth

conditionalFormatting

Unsupported on V2 writes because read and write rule shapes differ; omit this field.

customTitle

discriminatorId

For a tag row or value, which tags it is: userTags or projectTags.

formula

Pivot column formula — arg-based (arg1/arg2 columnIds) or code-based (formulaValue with field("Column Label"))

isHidden

orderIndex

Position among the columns of its type, from 0: the first row is the outer group.

pinned

pivotedColumns

sortIndex

sortType

type

Row, column or value. A pivot has at most one column.