Developers
Set your API contextPick a region and space ID once. Every sample fills in your base URL.
Where do I find these?

In Coevera: open your space's API application and choose Show Access. It shows the space ID and the base URL, whose host starts with your region.

From the API: if you know the space ID, the discovery endpoint GET /api/discovery/spaces/{space_id} returns its region and base URLs, without credentials.

Only the region and space ID are kept, in this browser. Never paste a key or password here.

More in the quickstart

GraphQLRepositoriesforecast

entities.forecast

Read forecast records with the forecast repository, and change them with the forecast mutations. Same records as the REST Forecasts entity.

Queries

Fields of entities { forecast { … } }.

KindFieldReturns
QUERYgetById(entityId: ID!)
Returns the record with the given id, or null when there is none. Deleted records are returned as well.
ForecastEntity
QUERYgetByIds(entityIds: [ID!]!)
Returns the records with the given ids; ids without a record are left out. Deleted records are returned as well.
[ForecastEntity!]!
QUERYgetAll(limit: Int, offset: Int, filter: ForecastFilterInput, orderBy: [ForecastOrderByInput!], includeDeleted: Boolean)
Returns the records that match the filter, paged with limit and offset.
[ForecastEntity!]!
QUERYgetByCriteria(filter: ForecastFilterInput, orderBy: [ForecastOrderByInput!], includeDeleted: Boolean, before: String, after: String, first: Int, last: Int)
Returns the records that match the filter as a cursor-paginated connection.
ForecastEntityConnection
QUERYgetChangedFieldsSinceRevision(id: UUID!, revision: Int!)
Returns the ids of the fields of a record that changed after the given revision. Returns an empty list for entities without change tracking.
[UUID!]!

Mutations

KindMutationDoesReturns
MUTATIONcreateForecast(input: CreateForecastInput!, validationLevel: [ValidationLevel!])Create one recordCreateForecastPayload
MUTATIONupdateForecast(input: UpdateForecastInput!, validationLevel: [ValidationLevel!], sessionIdToUpdate: String)Update fieldsUpdateForecastPayload
MUTATIONbulkUpdateForecast(input: [CreateOrUpdateForecastInput!]!, deleteInput: [DeleteForecastInput!], validationLevel: [ValidationLevel!], rollbackMethod: RollbackMethod, match: MatchingInput)Create or update many; per-item resultsBulkUpdateForecastPayload
MUTATIONdeleteForecast(input: DeleteForecastInput!)Soft-deleteDeleteForecastPayload

Types

The types this repository uses, each with its fields and their descriptions. Types several repositories share, such as PageInfo and the filter fields, are in the types index.

ForecastEntity object 25 fields: isDeleteProtected, id, isDeleted, …

Sales forecast that sums an amount over the opportunities of a pipeline for a period, broken down by levels such as sales units and users.

FieldTypeDescription
isDeleteProtectedBoolean!True when the record is protected against deletion because it must always exist in the space. Deleting a record that is not protected can still fail on other checks. Read-only.
idID!Unique identifier of entity.
isDeletedBooleanSpecifies if the entity is considered deleted.
modifiedDateTimeLast modification time.
createdDateTimeCreation time.
fieldFieldEntityField whose value is summed when computing forecast amounts (typically a currency field on Opportunity).
ownerClientEntityUser who owns the forecast.
pipelinePipelineEntityPipeline whose opportunities the forecast aggregates.
descriptionStringFree-text description shown alongside the forecast.
endDateDate!Last date covered by the forecast period.
fieldIdID!Id of the aggregation field.
nameString!Name of the entity and its default text representation.
ownerIdID!Id of the owning user.
pipelineIdID!Id of the pipeline whose opportunities the forecast aggregates.
settingsBetterForecastSchema!Forecast configuration as a JSON object conforming to the BetterForecastSchema type: currency, period (year + quarter/month), breakdown levels (type), items and quotas, and column layout. Validated on write.
shareModeShareModeEnumWho besides the owner can access the forecast. Updating it to AllEdit shares the forecast with the users and sales units it covers (see sharedClients and sharedUnits) and stores the mode as Standard.
shareModeParamsIntLegacy additional sharing options; kept with the record but no longer applied.
startDateDate!First date covered by the forecast period.
typeJSONString!Order of forecast levels as a JSON array (e.g. ["Units", "Users"]). Each level adds a grouping dimension to the breakdown.
revisionIntRevision when entity was lastly changed.
lastTypeForecastType!For multi-level forecasts (a "type" path like Pipeline/Step/Owner), the last element of the path identifying the current breakdown axis.
sharedClients[ClientEntity!]!Users granted shared access to this forecast (custom share mode).
sharedUnits[SalesUnitEntity!]!Sales units granted shared access to this forecast (custom share mode).
instancePermissions[EntityPermsEnum!]! (1 args)Permissions the current user has on this record, out of the requested ones.
targetGoalInt! (1 args)Goal value to reach within the selected period; when the period covers only part of the target or forecast period, only the matching months count.
ForecastEntityConnection object pageInfo: PageInfo!, edges: [ForecastEntityEdge]!, totalCount: Int

Paginated list of Forecast records.

FieldTypeDescription
pageInfoPageInfo!Pagination data for this connection.
edges[ForecastEntityEdge]!Contains the nodes in this connection.
totalCountIntTotal number of items in the connection.
ForecastEntityEdge object node: ForecastEntity, cursor: String!

A Relay edge containing a ForecastEntity and its cursor.

FieldTypeDescription
nodeForecastEntityThe item at the end of the edge
cursorString!A cursor for use in pagination
ForecastFilterInput input AND, OR, NOT, globalSearchQuery, one condition per field

Filter conditions for Forecast records. Conditions on different fields are combined with AND; use OR, AND and NOT for other combinations.

Input fieldTypeDescription
OR[ForecastFilterInput!]Matches records that meet at least one of the listed filters.
AND[ForecastFilterInput!]Matches records that meet all of the listed filters.
NOTForecastFilterInputMatches records that do not meet this filter.
globalSearchQueryStringSearch term matched against the fields that the global search covers for this entity.
idEntityFilterStringFieldUnique identifier of entity.
isDeletedBooleanSpecifies if the entity is considered deleted.
modifiedEntityFilterDateTimeFieldLast modification time.
createdEntityFilterDateTimeFieldCreation time.
descriptionEntityFilterStringFieldFree-text description shown alongside the forecast.
fieldIdEntityFilterStringFieldId of the aggregation field.
nameEntityFilterStringFieldName of the entity and its default text representation.
ownerIdEntityFilterStringFieldId of the owning user.
pipelineIdEntityFilterStringFieldId of the pipeline whose opportunities the forecast aggregates.
shareModeShareModeEnumFilterInputWho besides the owner can access the forecast. Updating it to AllEdit shares the forecast with the users and sales units it covers (see sharedClients and sharedUnits) and stores the mode as Standard.
shareModeParamsShareModeParamsEnumFilterInputLegacy additional sharing options; kept with the record but no longer applied.
revisionEntityFilterNumberFieldRevision when entity was lastly changed.
lastTypeForecastTypeFor multi-level forecasts (a "type" path like Pipeline/Step/Owner), the last element of the path identifying the current breakdown axis.
fieldFieldFilterInputField whose value is summed when computing forecast amounts (typically a currency field on Opportunity). Matches records where a related record meets these conditions.
ownerClientFilterInputUser who owns the forecast. Matches records where a related record meets these conditions.
pipelinePipelineFilterInputPipeline whose opportunities the forecast aggregates. Matches records where a related record meets these conditions.
ForecastOrderByInput input Asc or Desc per field

Sorting of Forecast records. Set exactly one field in each item; list several items to sort by more fields, in order of priority.

Input fieldTypeDescription
idOrderByEnumUnique identifier of entity.
isDeletedOrderByEnumSpecifies if the entity is considered deleted.
modifiedOrderByEnumLast modification time.
createdOrderByEnumCreation time.
field[FieldOrderByNestedInput!]Field whose value is summed when computing forecast amounts (typically a currency field on Opportunity). Sorts by fields of the related record, listed in order of priority.
owner[ClientOrderByNestedInput!]User who owns the forecast. Sorts by fields of the related record, listed in order of priority.
pipeline[PipelineOrderByNestedInput!]Pipeline whose opportunities the forecast aggregates. Sorts by fields of the related record, listed in order of priority.
descriptionOrderByEnumFree-text description shown alongside the forecast.
endDateOrderByEnumLast date covered by the forecast period.
fieldIdOrderByEnumId of the aggregation field.
nameOrderByEnumName of the entity and its default text representation.
ownerIdOrderByEnumId of the owning user.
pipelineIdOrderByEnumId of the pipeline whose opportunities the forecast aggregates.
shareModeOrderByEnumWho besides the owner can access the forecast. Updating it to AllEdit shares the forecast with the users and sales units it covers (see sharedClients and sharedUnits) and stores the mode as Standard.
startDateOrderByEnumFirst date covered by the forecast period.
revisionOrderByEnumRevision when entity was lastly changed.
lastTypeOrderByEnumFor multi-level forecasts (a "type" path like Pipeline/Step/Owner), the last element of the path identifying the current breakdown axis.
CreateForecastInput input 12 fields: clientMutationId, modified, created, …

Field values of a new Forecast record.

Input fieldTypeDescription
clientMutationIdStringOptional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention).
modifiedDateTimeLast modification time.
createdDateTimeCreation time.
descriptionStringFree-text description shown alongside the forecast.
nameString!Name of the entity and its default text representation.
ownerIdID!Id of the owning user.
settingsJSONString!Forecast configuration as a JSON object conforming to the BetterForecastSchema type: currency, period (year + quarter/month), breakdown levels (type), items and quotas, and column layout. Validated on write.
shareModeShareModeEnumWho besides the owner can access the forecast. Updating it to AllEdit shares the forecast with the users and sales units it covers (see sharedClients and sharedUnits) and stores the mode as Standard.
shareModeParamsIntLegacy additional sharing options; kept with the record but no longer applied.
revisionIntRevision when entity was lastly changed.
sharedClients[UUID!]!Users granted shared access to this forecast (custom share mode).
sharedUnits[UUID!]!Sales units granted shared access to this forecast (custom share mode).
CreateOrUpdateForecastInput input 13 fields: clientMutationId, id, modified, …

Field values of a Forecast record to create, or to update when its id is set.

Input fieldTypeDescription
clientMutationIdStringOptional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention).
idIDUnique identifier of entity.
modifiedDateTimeLast modification time.
createdDateTimeCreation time.
descriptionStringFree-text description shown alongside the forecast.
nameStringName of the entity and its default text representation.
ownerIdIDId of the owning user.
settingsJSONStringForecast configuration as a JSON object conforming to the BetterForecastSchema type: currency, period (year + quarter/month), breakdown levels (type), items and quotas, and column layout. Validated on write.
shareModeShareModeEnumWho besides the owner can access the forecast. Updating it to AllEdit shares the forecast with the users and sales units it covers (see sharedClients and sharedUnits) and stores the mode as Standard.
shareModeParamsIntLegacy additional sharing options; kept with the record but no longer applied.
revisionIntRevision when entity was lastly changed.
sharedClients[UUID!]Users granted shared access to this forecast (custom share mode).
sharedUnits[UUID!]Sales units granted shared access to this forecast (custom share mode).
DeleteForecastInput input clientMutationId: String, id: ID!

Id of the Forecast record to delete.

Input fieldTypeDescription
clientMutationIdStringOptional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention).
idID!Unique identifier of entity.
UpdateForecastInput input 13 fields: clientMutationId, id, modified, …

Id of a Forecast record and the field values to change.

Input fieldTypeDescription
clientMutationIdStringOptional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention).
idID!Unique identifier of entity.
modifiedDateTimeLast modification time.
createdDateTimeCreation time.
descriptionStringFree-text description shown alongside the forecast.
nameStringName of the entity and its default text representation.
ownerIdIDId of the owning user.
settingsJSONStringForecast configuration as a JSON object conforming to the BetterForecastSchema type: currency, period (year + quarter/month), breakdown levels (type), items and quotas, and column layout. Validated on write.
shareModeShareModeEnumWho besides the owner can access the forecast. Updating it to AllEdit shares the forecast with the users and sales units it covers (see sharedClients and sharedUnits) and stores the mode as Standard.
shareModeParamsIntLegacy additional sharing options; kept with the record but no longer applied.
revisionIntRevision when entity was lastly changed.
sharedClients[UUID!]Users granted shared access to this forecast (custom share mode).
sharedUnits[UUID!]Sales units granted shared access to this forecast (custom share mode).
BulkUpdateForecastPayload object result: BulkUpdateResults!

Result of the bulkUpdateForecast mutation.

FieldTypeDescription
resultBulkUpdateResults!Ids of the created, updated and deleted records, and the items that failed.
CreateForecastPayload object forecast: ForecastEntity, clientMutationId: String

Result of the createForecast mutation.

FieldTypeDescription
forecastForecastEntityThe created record.
clientMutationIdStringOptional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention).
DeleteForecastPayload object forecast: ForecastEntity, clientMutationId: String

Result of the deleteForecast mutation.

FieldTypeDescription
forecastForecastEntityThe deleted record.
clientMutationIdStringOptional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention).
UpdateForecastPayload object forecast: ForecastEntity, clientMutationId: String

Result of the updateForecast mutation.

FieldTypeDescription
forecastForecastEntityThe updated record.
clientMutationIdStringOptional client-supplied identifier passed on a mutation input and echoed back unchanged on its payload, so a client can correlate the response with its request (Relay convention).
AccountFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which accounts a saved profile or report includes, combining conditions on the account with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
AccountPivotReportProfile object filter: AccountFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: AccountRoleTab!

Settings of a pivot table that summarizes accounts: filter, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterAccountFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleAccountRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
AccountProfileInterface interface filter: AccountFilterTab!, role: AccountRoleTab!

Settings shared by the saved profiles and reports on accounts: the filter and the ownership scope of the accounts shown.

FieldTypeDescription
filterAccountFilterTab!Filter conditions that determine which records the profile includes.
roleAccountRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
AccountRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!

Ownership scope of account reports and views: which accounts are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
AccountTableReportProfile object filter: AccountFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!, role: AccountRoleTab!

Settings of a report table that lists accounts: filter, ownership scope, quick filter and the table view.

FieldTypeDescription
filterAccountFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleAccountRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ActivityFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which activities (tasks and appointments) a saved profile or report includes, combining conditions on the activity with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
ActivityPivotReportProfile object filter: ActivityFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: ActivityRoleTab!

Settings of a pivot table that summarizes activities: filter, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterActivityFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleActivityRoleTab!Ownership scope of the records shown, such as own, shared, managing-unit or unassigned items.
ActivityProfileInterface interface filter: ActivityFilterTab!, role: ActivityRoleTab!

Settings shared by the saved profiles and reports on activities: the filter and the ownership scope of the activities shown.

FieldTypeDescription
filterActivityFilterTab!Filter conditions that determine which records the profile includes.
roleActivityRoleTab!Ownership scope of the records shown, such as own, shared, managing-unit or unassigned items.
ActivityRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!, showUnassignedItems: Boolean!

Ownership scope of activity reports and views: which activities are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
showUnassignedItemsBoolean!When true, includes records that have no owner assigned.
ActivityTableReportProfile object filter: ActivityFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!, role: ActivityRoleTab!

Settings of a report table that lists activities: filter, ownership scope, quick filter and the table view.

FieldTypeDescription
filterActivityFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleActivityRoleTab!Ownership scope of the records shown, such as own, shared, managing-unit or unassigned items.
AggregationComparison object isEnabled: Boolean!, type: AggregationComparisonType!, fieldId: UUID, operator: AggregationOperator!

Comparison of a pivot aggregation value with the row, column or grand total, or with another aggregation.

FieldTypeDescription
isEnabledBoolean!Whether the aggregation value is compared against another value in the pivot.
typeAggregationComparisonType!What the value is compared against: the row total, the column total, the grand total, or another field's aggregation.
fieldIdUUIDIdentifier of the field whose aggregation is compared against; set when the comparison type is Field.
operatorAggregationOperator!How the comparison field's values are aggregated, such as Count, Sum, Average, Min or Max.
AggregationComparisonType enum RowTotal, ColumnTotal, GrandTotal, Field

Reference total that a pivot aggregation is expressed against as a percentage.

ValueDescription
RowTotalEach value as a percentage of its row total.
ColumnTotalEach value as a percentage of its column total.
GrandTotalEach value as a percentage of the grand total of the report.
FieldEach value as a percentage of another aggregated field, identified by fieldId.
AggregationField object 8 fields: id, name, fieldId, …

Aggregation column of a pivot table: the field and the operation (such as count or sum) that produce each cell value.

FieldTypeDescription
idUUID!Unique identifier of this aggregation column in the pivot.
nameStringDisplay name of the aggregation column.
fieldIdUUIDID of field used for aggregation, leave empty if aggregation is set to Count
operatorAggregationOperator!Aggregation function that produces the column's values, such as Count, Sum or Average.
comparisonAggregationComparison!Comparison applied to this aggregation column, such as comparing against a row, column or grand total.
columnWidthIntWidth of the column; if Null the default width is used.
columnFormattingColumnFormattingConditional formatting applied to this column's cells based on their value.
columnColorIntRGB color code converted to integer, if value is Null uses no color
BetterForecastSchema object 21 fields: quickFilter, currencyId, period, …

Settings of a saved forecast: its period, breakdown dimensions, the opportunities included, quotas and the options of its list, trend and pipeline views.

FieldTypeDescription
quickFilterQuickFilterTab!Quick-filter conditions applied on top of the forecast, letting the user narrow the included opportunities without changing the saved filter.
currencyIdUUID!Currency used for all monetary values in the forecast.
periodForecastPeriodKind!Time granularity of the forecast — Monthly, Quarterly or Yearly.
startDateDate!First day of the forecast period.
endDateDate!Last day of the forecast period.
type[ForecastType!]!Breakdown dimension(s) the forecast is grouped by — Users, SalesUnits, Products, ProductCategories or Accounts.
items[ForecastItem!]!Forecast rows — one per entity in the breakdown, with per-period values and quotas.
quotaComparisonTypeForecastPerformanceComparisonType!Baseline that performance is compared against — PreviousPeriod, AveragePerformance or WeightedAveragePerformance.
fieldIdID!Opportunity value field summed into the forecast.
dateFieldIdID!Opportunity date field used to place each opportunity into a period.
fieldFilterFieldFilter!Field-condition filter selecting which opportunities feed the forecast.
filterOpportunityFilterTab!Saved opportunity filter tab further scoping the forecast.
pipelineIdUUID!Pipeline the forecast is computed over.
columns[ForecastColumn!]!Value columns shown in the forecast (prediction, open, comparison, …).
groupByUUIDOptional field the forecast values are additionally grouped by.
hideEmptyRowsBoolean!When true, rows with no values are hidden.
listViewOptionsForecastListViewOptions!Display options for the list view of the forecast.
trendViewOptionsForecastTrendViewOptions!Display options for the trend view of the forecast.
pipelineViewOptionsForecastPipelineViewOptions!Display options for the pipeline view of the forecast.
quotaCustomModeBoolean!When true, quotas are entered manually rather than derived from targets.
quotaSplitTypeOpportunityForecastQuotaSplitType!How a parent quota is split across child rows (e.g. evenly).
CalculatedField object id: UUID!, name: String!, advancedFormula: AdvancedFormulaProperty!

Value field of a report whose value is calculated by a formula.

FieldTypeDescription
idUUID!Unique identifier of this report value field.
nameString!Display name of the value field as shown in the report.
advancedFormulaAdvancedFormulaProperty!Formula definition that computes this field's value from other fields, conforming to the AdvancedFormulaProperty type.
ColumnFormatting object isEnabled: Boolean!, filterFields: [ColumnFormattingFieldFilterRule!]!

Conditional formatting of a report column: rules that color cells by their value.

FieldTypeDescription
isEnabledBoolean!Whether conditional formatting is applied to this column.
filterFields[ColumnFormattingFieldFilterRule!]!Conditional-formatting rules that decide which cells are highlighted and with what color.
ColumnFormattingFieldFilterRule object 6 fields: id, field, operator, …

Conditional formatting rule: a condition on a field value and the color applied to the matching cells.

FieldTypeDescription
idUUIDUnique identifier of this conditional-formatting rule.
fieldStringIdentifier of the field whose value the rule is evaluated against.
operatorFieldOperatorComparison applied between the field value and the rule values, such as equals, contains or is between.
values[[String]]Values the field is compared against; grouped into lists so a single rule can match any of several values.
colorIntColor applied to matching cells, given as an RGB color code encoded as an integer.
boxIdIDIdentifier of the report box that the compared field belongs to.
ColumnFormattingFilterFieldRuleInterface interface id: UUID, field: String, operator: FieldOperator, values: [[String]]

Condition of a conditional formatting rule, evaluated against a field value.

FieldTypeDescription
idUUIDIdentifier of this condition within the filter box. Used to reference the condition from the box formula.
fieldStringIdentifier of the field whose value the rule is evaluated against.
operatorFieldOperatorComparison applied between the field and the supplied values (for example Is, IsNot, Contains, Between, IsEmpty).
values[[String]]Values the field is compared against. The outer list holds alternatives combined with OR; the inner list holds the parts of a single value (such as the two bounds of a Between comparison).
ColumnPrintOverflow enum Wrap, Clip

How a report column handles content too long for the column width when printed.

ValueDescription
WrapContent wraps onto more lines so all of it is printed.
ClipContent is cut off at the column edge.
ContactFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which contacts a saved profile or report includes, combining conditions on the contact with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
ContactPivotReportProfile object filter: ContactFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: ContactRoleTab!

Settings of a pivot table that summarizes contacts: filter, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterContactFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleContactRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ContactProfileInterface interface filter: ContactFilterTab!, role: ContactRoleTab!

Settings shared by the saved profiles and reports on contacts: the filter and the ownership scope of the contacts shown.

FieldTypeDescription
filterContactFilterTab!Filter conditions that determine which records the profile includes.
roleContactRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ContactRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!

Ownership scope of contact reports and views: which contacts are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
ContactTableReportProfile object filter: ContactFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!, role: ContactRoleTab!

Settings of a report table that lists contacts: filter, ownership scope, quick filter and the table view.

FieldTypeDescription
filterContactFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleContactRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ConvertedCurrencyField object id: UUID!, fieldId: UUID!

Value field of a report that shows a foreign currency field converted into the report currency.

FieldTypeDescription
idUUID!Unique identifier of this converted-currency value field.
fieldIdUUID!Identifier of the foreign-currency field whose value is converted into the report's currency.
CustomEntityFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which custom entity records a saved profile or report includes, combining conditions on the record with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
CustomEntityPivotReportProfile object filter: CustomEntityFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: CustomEntityRoleTab!

Settings of a pivot table that summarizes custom entity records: filter, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterCustomEntityFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleCustomEntityRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
CustomEntityProfileInterface interface filter: CustomEntityFilterTab!, role: CustomEntityRoleTab!

Settings shared by the saved profiles and reports on custom entity records: the filter and the ownership scope of the custom entity records shown.

FieldTypeDescription
filterCustomEntityFilterTab!Filter conditions that determine which records the profile includes.
roleCustomEntityRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
CustomEntityRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!

Ownership scope of custom entity reports and views: which records are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
CustomEntityTableReportProfile object filter: CustomEntityFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!, role: CustomEntityRoleTab!

Settings of a report table that lists custom entity records: filter, ownership scope, quick filter and the table view.

FieldTypeDescription
filterCustomEntityFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleCustomEntityRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
DisplayFieldItem object 7 fields: fieldId, displayOptions, columnWidth, …

Column of a report box: the field shown and its display, width, color, alignment, conditional formatting and print options.

FieldTypeDescription
fieldIdID!Id of the field shown in this column: a field of the box entity, or a value field defined in the report (reportValueFields).
displayOptionsDisplayOptionForm in which the column's values are shown, such as the readable name or the raw value of a related record; Natural when not set.
columnWidthIntSize of the column width, if value is Null uses default
columnColorIntRGB color code converted to integer, if value is Null uses no color
columnAlignmentColumnAlignmentHorizontal alignment of the values in the column: Left, Center or Right.
columnFormattingColumnFormattingConditional formatting applied to this column's cells based on their value.
columnPrintOverflowColumnPrintOverflow!How cell content that doesn't fit the column width is handled when the report is printed: Wrap keeps the full content on multiple lines, Clip prints it cut off to a single line. Affects printing only, not the report detail.
EmailFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions an email must meet to appear in an email list or report.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
EmailPivotReportProfile object filter: EmailFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: EmailRoleTab!

Pivot report of emails: which emails it includes and how it groups and aggregates them in rows and columns.

FieldTypeDescription
filterEmailFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleEmailRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
EmailProfileInterface interface filter: EmailFilterTab!, role: EmailRoleTab!

Saved view of emails: the filter and ownership scope that decide which emails it shows.

FieldTypeDescription
filterEmailFilterTab!Filter conditions that determine which emails the profile shows.
roleEmailRoleTab!Ownership scope of the emails shown, such as own, shared or managing-unit items.
EmailRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!

Ownership scope of an email list or report: whether own, shared and managing-unit emails are included.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, emails owned by other members of the current user managing unit are also included.
EmailTableReportProfile object filter: EmailFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!, role: EmailRoleTab!

Table report of emails: which emails it includes and the columns, sorting, grouping and totals it shows.

FieldTypeDescription
filterEmailFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleEmailRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
FeedFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which feed messages a report includes, combining conditions on the message with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
FeedPivotReportProfile object filter: FeedFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: FeedRoleTab!

Settings of a pivot table that summarizes feed messages: filter, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterFeedFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleFeedRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
FeedReportProfileInterface interface filter: FeedFilterTab!, role: FeedRoleTab!

Settings shared by the reports on feed messages: the filter and the ownership scope of the messages shown.

FieldTypeDescription
filterFeedFilterTab!Filter conditions that determine which records the profile includes.
roleFeedRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
FeedRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!

Ownership scope of feed reports and views: which feed items are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, feed items shared with the current user are also included.
FeedTableReportProfile object filter: FeedFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!, role: FeedRoleTab!

Settings of a report table that lists feed messages: filter, ownership scope, quick filter and the table view.

FieldTypeDescription
filterFeedFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleFeedRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ForecastBaseValueEnum enum Open, Won, WonOpen, Lost, Prediction

Opportunity value a forecast column is based on.

ValueDescription
OpenValue of open opportunities.
WonValue of won opportunities.
WonOpenCombined value of won and open opportunities.
LostValue of lost opportunities.
PredictionValue predicted from opportunities won before the forecast period.
ForecastColumn object id: ID!, baseValue: ForecastBaseValueEnum!, openValueType: ForecastOpenValueTypeEnum, valueComparison: ForecastValueComparisonEnum

Value column of a forecast, such as the open, won or predicted value, or a comparison.

FieldTypeDescription
idID!Id of the column.
baseValueForecastBaseValueEnum!Underlying value the column shows — Open, Won, WonOpen, Lost or Prediction.
openValueTypeForecastOpenValueTypeEnumFor open-value columns, how the value is weighted — Unweighted, Weighted, Ranked or Balanced.
valueComparisonForecastValueComparisonEnumFor comparison columns, the baseline compared against — Forecast, Quota, Prediction, PreviousPeriod or PreviousYear.
ForecastItem object 7 fields: id, parentId, entityId, …

Row of a forecast for one entity of the breakdown (user, sales unit, product, product category or account), with its values and quotas per period.

FieldTypeDescription
idID!Id of this forecast row.
parentIdIDId of the parent row in the breakdown hierarchy; empty for top-level rows.
entityIdUUID!Id of the entity (user, sales unit, product, product category or account) this row represents.
entityTypeEntityNameEnum!Type of the entity this row represents.
values[ForecastItemValue!]!Per-period value and quota entries for this row.
isActiveBoolean!Whether this row is included in forecast totals.
quotaSplitTypeOpportunityForecastQuotaSplitType!How this row's quota is split across its child rows (e.g. evenly).
ForecastItemValue object date: Date!, value: Float, quota: Float

Forecast value and quota of a forecast row for one period.

FieldTypeDescription
dateDate!First day of the period this value applies to.
valueFloatForecasted or actual value for the period.
quotaFloatQuota target for the period.
ForecastListViewOptions object columns: [GridColumnsOutput!]!, sortBy: ID!, sortOrder: SortOrder!

Display options of the list view of a forecast: its columns and sorting.

FieldTypeDescription
columns[GridColumnsOutput!]!Columns shown in the forecast list view, each with its width and display options.
sortByID!Id of the field the list view is sorted by.
sortOrderSortOrder!Direction the list view is sorted in — Ascending or Descending.
ForecastOpenValueTypeEnum enum Unweighted, Weighted, Ranked, Balanced

How the value of open opportunities is weighted in a forecast column.

ValueDescription
UnweightedFull opportunity value.
WeightedValue multiplied by the pipeline step probability.
RankedValue multiplied by the opportunity ranking.
BalancedValue multiplied by both the step probability and the ranking.
ForecastPerformanceComparisonType enum PreviousPeriod, AveragePerformance, WeightedAveragePerformance

Historical baseline used to judge forecast performance or to split quota by historical performance.

ValueDescription
PreviousPeriodPerformance in the same period of the previous year.
AveragePerformanceAverage of past performance across all earlier periods.
WeightedAveragePerformanceAverage of past performance with more recent periods weighted more heavily.
ForecastPeriodKind enum Monthly, Quarterly, Yearly

Length of each period in a forecast.

ValueDescription
MonthlyEach period is one month.
QuarterlyEach period is one quarter.
YearlyEach period is one year.
ForecastPipelineViewOptions object 9 fields: sortBy, sortOrder, groupBy, …

Display options of a pipeline board of opportunity cards: sorting, how the cards are grouped and which details each card shows.

FieldTypeDescription
sortByID!Identifier of the field the records are sorted by.
sortOrderSortOrder!Sort direction: Asc for ascending, Desc for descending.
groupByOpportunityGroupBy!How opportunity cards are grouped on the pipeline board: NoGrouping, Owner, Account, Contact, Unit, or ClosingDate.
showCardValueBoolean!When true, shows the opportunity value on each card.
showCardRankingBoolean!When true, shows the opportunity ranking on each card.
showCardLabelsBoolean!When true, shows the assigned labels on each card.
showCardVelocityBoolean!When true, shows the opportunity velocity on each card.
showCardFitnessBoolean!When true, shows the fitness indicator on each card.
showExtraFieldIds[UUID!]Identifiers of additional fields to display on each card.
ForecastTrendViewOptions object runningTotal: Boolean!

Display options of the trend view of a forecast.

FieldTypeDescription
runningTotalBoolean!When true, the trend view shows cumulative running totals rather than the value for each period in isolation.
ForecastType enum Users, SalesUnits, Products, ProductCategories, Accounts

Dimension a forecast is broken down by.

ValueDescription
UsersOne row per opportunity owner.
SalesUnitsOne row per sales unit.
ProductsOne row per product on the opportunities.
ProductCategoriesOne row per product category.
AccountsOne row per account.
ForecastValueComparisonEnum enum NoComparison, Forecast, Quota, Prediction, PreviousPeriod, PreviousYear

Baseline a forecast column's value is compared against.

ValueDescription
NoComparisonNo comparison is shown.
ForecastThe forecast value entered for the row.
QuotaThe quota set for the row.
PredictionThe value predicted from opportunities won before the forecast period.
PreviousPeriodThe same value for the period of equal length immediately before.
PreviousYearThe same value for the same period one year earlier.
FrozenPaneType enum NoRowCol, FirstRow, FirstCol, FirstRowCol

Which leading rows and columns of a report table stay visible while scrolling.

ValueDescription
NoRowColNothing is frozen.
FirstRowThe first row is frozen.
FirstColThe first column is frozen.
FirstRowColThe first row and the first column are frozen.
GridColumnsOutput object fieldId: String!, width: Float!, frozen: Boolean!, pixels: Boolean!

Column of a grid: the field shown, its width (relative or in pixels) and whether it is frozen.

FieldTypeDescription
fieldIdString!Identifier of the field shown in this grid column.
widthFloat!Column width. Interpreted as an exact pixel count when pixels is true, otherwise as a relative weight.
frozenBoolean!True when the column is pinned to the left edge so it stays visible while the grid scrolls horizontally.
pixelsBoolean!True when width is given in absolute pixels; false when it is a relative weight.
GroupField object boxId: ID!, fieldId: ID!, groupOption: GroupOption, groupIntervals: [GroupInterval!]

Field a table report groups its rows by.

FieldTypeDescription
boxIdID!Identifier of the report box that the field belongs to.
fieldIdID!Identifier of the field being referenced.
groupOptionGroupOptionHow records are grouped on this field, for example by day, week, month, quarter or year for dates, by first letter for text, or by manual or automatic intervals for numbers.
groupIntervals[GroupInterval!]Custom numeric intervals used to group records when the group option is set to manual intervals.
GroupInterval object start: Float, end: Float

Numeric interval used to group the rows of a report.

FieldTypeDescription
startFloatLower bound of the numeric interval, inclusive.
endFloatUpper bound of the numeric interval, exclusive.
LeadOpportunityFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which leads and opportunities a saved profile or report includes, combining conditions on the record with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
LeadOpportunityPivotReportProfile object 7 fields: filter, view, quickFilter, …

Settings of a pivot table that summarizes leads and opportunities: filter, sales pipelines, lead processes, ownership scope, target, quick filter and the pivot view.

FieldTypeDescription
filterLeadOpportunityFilterTab!Filter tab restricting which leads and opportunities the report shows.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
salesPipeline[ID!]Identifiers of the sales pipelines the profile is restricted to. Null includes all pipelines.
roleLeadOpportunityRoleTab!Ownership scope of the records shown (own, shared, managing-unit, or unassigned items).
targetOpportunityReportTargetTab!Target tab defining the goal, measured period and comparison for the report.
leadProcess[UUID!]Identifiers of the lead processes the profile is restricted to. Null includes all lead processes.
LeadOpportunityReportProfileInterface interface leadProcess: [UUID!], filter: LeadOpportunityFilterTab!, salesPipeline: [ID!], role: LeadOpportunityRoleTab!

Settings shared by the reports on leads and opportunities: the filter, sales pipelines, lead processes and the ownership scope of the records shown.

FieldTypeDescription
leadProcess[UUID!]Identifiers of the lead processes the profile is restricted to. Null includes all lead processes.
filterLeadOpportunityFilterTab!Filter tab restricting which leads and opportunities the report shows.
salesPipeline[ID!]Identifiers of the sales pipelines the profile is restricted to. Null includes all pipelines.
roleLeadOpportunityRoleTab!Ownership scope of the records shown (own, shared, managing-unit, or unassigned items).
LeadOpportunityRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!, showUnassignedItems: Boolean!

Ownership scope of lead and opportunity reports and views: which records are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
showUnassignedItemsBoolean!When true, includes records that have no owner assigned.
LeadOpportunityTableReportProfile object 7 fields: filter, view, quickFilter, …

Settings of a report table that lists leads and opportunities: filter, sales pipelines, lead processes, ownership scope, target, quick filter and the table view.

FieldTypeDescription
filterLeadOpportunityFilterTab!Filter tab restricting which leads and opportunities the report shows.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
salesPipeline[ID!]Identifiers of the sales pipelines the profile is restricted to. Null includes all pipelines.
roleLeadOpportunityRoleTab!Ownership scope of the records shown (own, shared, managing-unit, or unassigned items).
targetOpportunityReportTargetTab!Target tab defining the goal, measured period and comparison for the report.
leadProcess[UUID!]Identifiers of the lead processes the profile is restricted to. Null includes all lead processes.
NoteFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which notes a saved profile or report includes, combining conditions on the note with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
NotePivotReportProfile object filter: NoteFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!

Settings of a pivot table that summarizes notes: filter, quick filter and the pivot view.

FieldTypeDescription
filterNoteFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
NoteProfileInterface interface filter: NoteFilterTab!

Settings shared by the saved profiles and reports on notes, consisting of the filter that selects the notes shown.

FieldTypeDescription
filterNoteFilterTab!Filter conditions that determine which records the profile includes.
NoteTableReportProfile object filter: NoteFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!

Settings of a report table that lists notes: filter, quick filter and the table view.

FieldTypeDescription
filterNoteFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
OpportunityFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which opportunities a saved profile, forecast or dashboard item includes, combining conditions on the opportunity with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
OpportunityForecastQuotaSplitType enum Evenly, HistoricalPerformance, Custom

How a forecast quota is distributed across its periods.

ValueDescription
EvenlyThe quota is split equally across all periods.
HistoricalPerformanceThe quota is split in proportion to historical performance in each period.
CustomThe quota for each period is entered manually.
OpportunityGroupBy enum NoGrouping, Owner, Account, Contact, Unit, ClosingDate

How opportunity cards are grouped on a pipeline or archive board.

ValueDescription
NoGroupingCards are not grouped.
OwnerGrouped by opportunity owner.
AccountGrouped by related account.
ContactGrouped by related contact.
UnitGrouped by sales unit.
ClosingDateGrouped by closing date.
OpportunityReportTargetTab object 7 fields: targetValueFieldId, targetPeriodCurrent, targetSource, …

Target shown in lead and opportunity reports and dashboards: the goal, the field summed toward it, the period it is measured over and the period it is compared with.

FieldTypeDescription
targetValueFieldIdID!Identifier of the field whose values are summed and compared against the target goal.
targetPeriodCurrentPeriodOption!Period the target is measured over.
targetSourceTargetSourceKind!Whose records contribute to the target: My counts only the current user, All counts every matching record.
goalFloat!Numeric target value the accumulated field total is measured against.
isVisibleBoolean!Defines if target should be displayed in report
targetPeriodComparePeriodCompareOption!Reference period the current target period is compared against.
showTargetOnTopBooleanWhen true, the target row is pinned above the data instead of below it.
OpportunityRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!

Ownership scope of opportunity reports and views: which opportunities are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
PeriodCompareKind enum DoNotCompare, PreviousPeriod, PreviousYear, Custom

Period a KPI or chart value is compared against.

ValueDescription
DoNotCompareNo comparison is made.
PreviousPeriodThe period immediately before the current one, of the same kind (for example the previous month for MonthCurrent).
PreviousYearThe same period one year earlier.
CustomExplicit range given by periodCustomFrom and periodCustomTo.
PeriodCompareOption object periodCustomFrom: Date, periodCustomTo: Date, period: PeriodCompareKind!

Reference period another period is compared with: none, the previous period, the previous year or a custom date range.

FieldTypeDescription
periodCustomFromDateSet only if period set to Custom
periodCustomToDateSet only if period set to Custom
periodPeriodCompareKind!Reference period the current period is compared against: DoNotCompare, PreviousPeriod, PreviousYear, or Custom. When Custom, periodCustomFrom and periodCustomTo define the bounds.
PipelineProfileInterface interface filter: ProfileFilterBaseInterface!, salesPipeline: [ID!]

Saved profile restricted to selected sales pipelines.

FieldTypeDescription
filterProfileFilterBaseInterface!Filter conditions that determine which records the profile includes.
salesPipeline[ID!]Identifiers of the sales pipelines the profile is restricted to. Null includes all pipelines.
PivotField object 5 fields: fieldId, groupOption, sortFieldId, …

Row or column dimension of a pivot table: the field the values are grouped by and how the groups are sorted.

FieldTypeDescription
fieldIdID!Identifier of the field used as a pivot row or column dimension.
groupOptionGroupOptionHow the field's values are grouped, for example by month or by interval.
sortFieldIdIDId of the value field whose totals this dimension's groups are sorted by, in sortOrder; when null, the groups are sorted by their own values.
sortOrderSortOrderSort direction applied to this dimension's values, either ascending (Asc) or descending (Desc).
groupIntervals[GroupInterval!]Custom numeric intervals used to group records when the group option is set to manual intervals.
PivotReportTabsInterface interface filter: ProfileFilterBaseInterface!, view: ViewPivotReportTab!

Filter and view settings of a pivot table; the variant depends on the record type the pivot summarizes.

FieldTypeDescription
filterProfileFilterBaseInterface!Filter conditions that determine which records the pivot report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
PivotReportTotal object isEnabled: Boolean!, position: ReportTotalPosition!

Totals of a pivot table: whether they are shown and where.

FieldTypeDescription
isEnabledBoolean!Whether totals are shown for the pivot table.
positionReportTotalPosition!Whether the totals appear above the values they summarise (Top) or below them (Bottom).
ProductFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which products a saved profile or report includes, combining conditions on the product with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
ProductPivotReportProfile object filter: ProductFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: OpportunityRoleTab!

Settings of a pivot table that summarizes products: filter, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterProductFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleOpportunityRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ProductProfileInterface interface filter: ProductFilterTab!

Settings shared by the saved profiles and reports on products, consisting of the filter that selects the products shown.

FieldTypeDescription
filterProductFilterTab!Filter conditions that determine which records the profile includes.
ProductTableReportProfile object filter: ProductFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!

Settings of a report table that lists products: filter, quick filter and the table view.

FieldTypeDescription
filterProductFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
ProfileFilterBoxTabsInterface interface filter: ProfileFilterBoxTabInterface!

Saved profile or report whose filter is built from filter boxes.

FieldTypeDescription
filterProfileFilterBoxTabInterface!Filter conditions that determine which records the profile includes.
ProfileTabsInterface interface filter: ProfileFilterBaseInterface!

Settings shared by every saved profile, report and dashboard, starting with the filter that selects its records.

FieldTypeDescription
filterProfileFilterBaseInterface!Filter conditions that determine which records the profile includes.
ProjectFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which projects a saved profile or report includes, combining conditions on the project with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
ProjectPivotReportProfile object filter: ProjectFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!, role: ProjectRoleTab!

Settings of a pivot table that summarizes projects: filter, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterProjectFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleProjectRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ProjectProfileInterface interface filter: ProjectFilterTab!, role: ProjectRoleTab!

Settings shared by the saved profiles and reports on projects: the filter and the ownership scope of the projects shown.

FieldTypeDescription
filterProjectFilterTab!Filter conditions that determine which records the profile includes.
roleProjectRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ProjectRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!

Ownership scope of project reports and views: which projects are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
ProjectTableReportProfile object filter: ProjectFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!, role: ProjectRoleTab!

Settings of a report table that lists projects: filter, ownership scope, quick filter and the table view.

FieldTypeDescription
filterProjectFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
roleProjectRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
QuickFilterInterface interface quickFilter: QuickFilterTab!

Saved profile or report that supports a quick filter on top of its saved filter.

FieldTypeDescription
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
QuickFilterTab object filterMainBox: MainFilterBox!, filterSiblingBoxes: [FilterBox!]!, filterFieldOrder: [UUID!]!

Ad-hoc filter applied on top of the saved filter of a profile or report to narrow the records shown without changing the saved filter.

FieldTypeDescription
filterMainBoxMainFilterBox!Primary group of quick-filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of quick-filter conditions evaluated on related record types.
filterFieldOrder[UUID!]!Identifiers of the filtered fields in the order they are shown in the quick filter.
QuoteFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which quotes a saved profile or report includes, combining conditions on the quote with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
QuotePivotReportProfile object 5 fields: filter, view, quickFilter, …

Settings of a pivot table that summarizes quotes: filter, quote processes, ownership scope, quick filter and the pivot view.

FieldTypeDescription
filterQuoteFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
quoteProcess[UUID!]Identifiers of the quote processes the profile is restricted to. Null includes all quote processes.
roleQuoteRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
QuoteProfileInterface interface filter: QuoteFilterTab!, quoteProcess: [UUID!]

Settings shared by the saved profiles and reports on quotes: the filter and the quote processes the quotes belong to.

FieldTypeDescription
filterQuoteFilterTab!Filter conditions that determine which records the profile includes.
quoteProcess[UUID!]Identifiers of the quote processes the profile is restricted to. Null includes all quote processes.
QuoteReportProfileInterface interface filter: QuoteFilterTab!, quoteProcess: [UUID!], role: QuoteRoleTab!

Settings shared by the reports on quotes: the filter, the quote processes and the ownership scope of the quotes shown.

FieldTypeDescription
filterQuoteFilterTab!Filter conditions that determine which records the profile includes.
quoteProcess[UUID!]Identifiers of the quote processes the profile is restricted to. Null includes all quote processes.
roleQuoteRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
QuoteRoleTab object showMyItems: Boolean!, showMySharedItems: Boolean!, showManagingUnitItems: Boolean!

Ownership scope of quote reports and views: which quotes are included by their relation to the current user.

FieldTypeDescription
showMyItemsBoolean!When true, includes records owned by the current user.
showMySharedItemsBoolean!When true, includes records shared with the current user.
showManagingUnitItemsBoolean!When true, includes records owned by users in the sales units the current user manages.
QuoteTableReportProfile object 5 fields: filter, view, quickFilter, …

Settings of a report table that lists quotes: filter, quote processes, ownership scope, quick filter and the table view.

FieldTypeDescription
filterQuoteFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
quoteProcess[UUID!]Identifiers of the quote processes the profile is restricted to. Null includes all quote processes.
roleQuoteRoleTab!Ownership scope of the records shown, such as own, shared or managing-unit items.
ReportComparisonDatesHistory object trackedFieldIds: [UUID]!, fields: [ReportHistoryField!]!, comparisonDates: [ReportHistoryComparisonDate!]!

History settings that compare the values of tracked fields at selected dates.

FieldTypeDescription
trackedFieldIds[UUID]!Identifiers of the fields whose historical values are tracked and made available to the report.
fields[ReportHistoryField!]!History value fields produced by the report, each tied to a tracked field and, for comparison reports, a comparison date.
comparisonDates[ReportHistoryComparisonDate!]!Dates the tracked field values are compared against in this comparison-type history report.
ReportField interface boxId: ID!, fieldId: ID!

Reference to a field of a report box, used for sorting and grouping.

FieldTypeDescription
boxIdID!Identifier of the report box that the field belongs to.
fieldIdID!Identifier of the field being referenced.
ReportHistoricalTrendHistory object trackedFieldIds: [UUID]!, fields: [ReportHistoryField!]!, period: PeriodOption!, periodGranularity: PeriodGranularity!

History settings that plot the values of tracked fields as a trend over a period.

FieldTypeDescription
trackedFieldIds[UUID]!Identifiers of the fields whose historical values are tracked and made available to the report.
fields[ReportHistoryField!]!History value fields produced by the report, each tied to a tracked field and, for comparison reports, a comparison date.
periodPeriodOption!Time span over which the historical trend is plotted.
periodGranularityPeriodGranularity!Interval at which trend data points are sampled across the period, such as Day, Week, Month, Quarter or Year.
ReportHistory union ReportComparisonDatesHistory | ReportHistoricalTrendHistory

History settings of a report that shows past values of tracked fields: comparison dates or a historical trend.

ReportHistoryCommon interface trackedFieldIds: [UUID]!, fields: [ReportHistoryField!]!

History settings shared by both history modes: the tracked fields and the history value fields the report produces.

FieldTypeDescription
trackedFieldIds[UUID]!Identifiers of the fields whose historical values are tracked and made available to the report.
fields[ReportHistoryField!]!History value fields produced by the report, each tied to a tracked field and, for comparison reports, a comparison date.
ReportHistoryComparisonDate object 5 fields: id, date, dynamicDate, …

Date at which tracked field values are compared: a fixed date, a special value or a date relative to today.

FieldTypeDescription
idUUID!Unique identifier of this comparison date.
dateDateFixed calendar date to compare against; set when neither a dynamic date nor a special value is used.
dynamicDate[ReportHistoryDynamicDate!]Ordered date operations evaluated against today to produce a relative comparison date, such as the start of the previous quarter.
isDynamicDateCustomBoolean!Whether the dynamic date was built from custom operations rather than chosen from a predefined relative-date option.
specialValueReportHistorySpecialValueSpecial comparison value instead of a date: FirstValue compares against the first recorded value and PreviousValue against the preceding one.
ReportHistoryDynamicDate object operation: ReportHistoryDynamicDateOperation!, value: Int, unit: ReportHistoryDynamicDateUnit!

Date operation, such as subtracting one month or moving to the start of the quarter, used to compute a relative comparison date.

FieldTypeDescription
operationReportHistoryDynamicDateOperation!Operation applied to the reference date: add or subtract an amount, set a specific value, or snap to the start or end of the unit.
valueIntAmount the operation uses; required for Add, Subtract and Set, and omitted for StartOf and EndOf.
unitReportHistoryDynamicDateUnit!Calendar unit the operation works on, such as Day, Week, Month, Quarter or Year.
ReportHistoryDynamicDateOperation enum Add, Subtract, Set, StartOf, EndOf

Operation applied to a reference date to compute a dynamic date for historical report values.

ValueDescription
AddAdds value units to the date.
SubtractSubtracts value units from the date.
SetSets the unit part of the date to value, for example month 3 or week 10.
StartOfMoves the date to the first day of its unit, such as the start of the week or month.
EndOfMoves the date to the last day of its unit, such as the end of the week or month.
ReportHistoryDynamicDateUnit enum Day, Week, Month, Quarter, Year

Calendar unit a dynamic date operation works on.

ValueDescription
DayDays; with Set, the day of the month (1 to 31).
WeekWeeks; with Set, the ISO week number (1 to 53).
MonthMonths; with Set, the month number (1 to 12).
QuarterQuarters; with Set, the quarter number (1 to 4).
YearYears; with Set, the year (1970 to 2070).
ReportHistoryField object id: UUID!, fieldId: UUID, comparisonDateId: UUID

History value field of a report: a tracked field's past value at a comparison date, or a record count.

FieldTypeDescription
idUUID!Unique identifier of this history field within the report.
fieldIdUUIDIdentifier of the tracked field whose historical value is reported; left empty when the history field counts records.
comparisonDateIdUUIDIdentifier of the comparison date this history value is taken at, for comparison-date history reports.
ReportHistorySpecialValue enum FirstValue, PreviousValue

Special reference used instead of a date when comparing historical field values.

ValueDescription
FirstValueCompares against the first recorded value of the field.
PreviousValueCompares against the value the field had before its latest change.
ReportTabInterface interface filter: ProfileFilterBaseInterface!

Filter and view settings of a report table or pivot table.

FieldTypeDescription
filterProfileFilterBaseInterface!Filter conditions that determine which records the profile includes.
ReportTotalPosition enum Top, Bottom

Where totals are placed relative to the values they summarize.

ValueDescription
TopTotals appear above the rows.
BottomTotals appear below the rows.
ReportValueField union CalculatedField | SummaryField | ConvertedCurrencyField

Value field computed for a report: a calculated formula, a rollup summary or a currency conversion.

ReportValueFieldInterface interface id: UUID!, name: String!

Value field computed for a report, identified by its id and name.

FieldTypeDescription
idUUID!Unique identifier of this report value field.
nameString!Display name of the value field as shown in the report.
RoleProfileInterface interface filter: ProfileFilterBaseInterface!, role: RoleTabInterface!

Saved profile or report that restricts the records shown by ownership scope, such as own, shared or managing-unit items.

FieldTypeDescription
filterProfileFilterBaseInterface!Filter conditions that determine which records the profile includes.
roleRoleTabInterface!Ownership scope of the records shown, such as own, shared or managing-unit items.
SortField object boxId: ID!, fieldId: ID!, direction: SortOrder!

Field a table report sorts its rows by, with the sort direction.

FieldTypeDescription
boxIdID!Identifier of the report box that the field belongs to.
fieldIdID!Identifier of the field being referenced.
directionSortOrder!Sort direction for this field, either ascending (Asc) or descending (Desc).
SummaryField object id: UUID!, name: String!, rollup: RollupProperty!

Value field of a report that aggregates values of related records, like a rollup field.

FieldTypeDescription
idUUID!Unique identifier of this report value field.
nameString!Display name of the value field as shown in the report.
rollupRollupProperty!Rollup definition that aggregates values from related records into this field, conforming to the RollupProperty type.
TableReportTabsInterface interface filter: ProfileFilterBaseInterface!, view: ViewTableReportTab!

Filter and view settings of a report table; the variant depends on the record type of the table's main box.

FieldTypeDescription
filterProfileFilterBaseInterface!Filter conditions that determine which records the table report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
TableReportTotal object 8 fields: isEnabled, showGrandTotal, position, …

Totals of a report table: which totals (sum, average, minimum, maximum, status) are shown and where.

FieldTypeDescription
isEnabledBoolean!Whether the totals row is shown for each group in a table report. Has no effect unless at least one of the individual total values below is enabled.
showGrandTotalBoolean!Whether a grand total covering all rows is shown in addition to the per-group totals.
positionReportTotalPosition!Whether the totals appear above the rows they summarise (Top) or below them (Bottom).
showSumBoolean!Whether the sum of each numeric column is shown in the totals.
showAverageBoolean!Whether the average of each numeric column is shown in the totals.
showMinBoolean!Whether the minimum value of each numeric column is shown in the totals.
showMaxBoolean!Whether the maximum value of each numeric column is shown in the totals.
showStatusBoolean!Whether a status breakdown (such as won, lost and open counts for opportunities or leads) is shown in the totals.
TargetProfileInterface interface filter: ProfileFilterBaseInterface!, target: TargetTabInterface!

Saved profile, report or dashboard that shows a target: a goal measured over a period.

FieldTypeDescription
filterProfileFilterBaseInterface!Filter conditions that determine which records the profile includes.
targetTargetTabInterface!Target settings of the profile: the field whose values are summed and the period they are measured over.
TargetSourceKind enum My, All

Whose records count toward an opportunity board target.

ValueDescription
MyOnly the current user's records.
AllAll matching records.
TargetTabInterface interface targetValueFieldId: ID!, targetPeriodCurrent: PeriodOption!

Target settings of a saved profile: the field summed toward the goal and the period it is measured over.

FieldTypeDescription
targetValueFieldIdID!Identifier of the field whose values are summed and compared against the target goal.
targetPeriodCurrentPeriodOption!Period the target is measured over.
TimeframeFilterTab object 6 fields: isEnabled, filterMainBox, filterSiblingBoxes, …

Filter conditions that select which timeframes (periods a lead or opportunity spent in a pipeline step) a saved profile or report includes, combining conditions on the timeframe with conditions on related records.

FieldTypeDescription
isEnabledBoolean!Whether the filter is applied. When false, the filter conditions are ignored.
filterMainBoxMainFilterBox!Primary group of filter conditions evaluated on the main record type.
filterSiblingBoxes[FilterBox!]!Additional groups of filter conditions evaluated on related record types.
isCustomBoolean!True when the conditions are combined with a custom formula rather than a simple And/Or across all conditions.
operatorFilterGroupOperator!How the conditions are combined: And applies all conditions, Or applies any, Custom evaluates the expression in the formula.
formulaStringBoolean expression combining the numbered conditions (for example "1 AND (2 OR 3)"). Used when the operator is Custom.
TimeframePivotReportProfile object filter: TimeframeFilterTab!, view: ViewPivotReportTab!, quickFilter: QuickFilterTab!

Settings of a pivot table that summarizes timeframes: filter, quick filter and the pivot view.

FieldTypeDescription
filterTimeframeFilterTab!Filter conditions that determine which records the report includes.
viewViewPivotReportTab!View configuration of the pivot report, including its row and column dimensions, aggregation columns, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
TimeframeProfileInterface interface filter: TimeframeFilterTab!

Settings shared by the saved profiles and reports on timeframes, consisting of the filter that selects the timeframes shown.

FieldTypeDescription
filterTimeframeFilterTab!Filter conditions that determine which records the profile includes.
TimeframeTableReportProfile object filter: TimeframeFilterTab!, view: ViewTableReportTab!, quickFilter: QuickFilterTab!

Settings of a report table that lists timeframes: filter, quick filter and the table view.

FieldTypeDescription
filterTimeframeFilterTab!Filter conditions that determine which records the report includes.
viewViewTableReportTab!View configuration of the table report, including its columns, sorting, grouping, totals and chart.
quickFilterQuickFilterTab!Ad-hoc filter applied on top of the saved filter, narrowing the visible records without changing the profile.
ViewPivotReportTab object 13 fields: frozenPanes, chart, reportValueFields, …

View settings of a pivot table: row and column dimensions, aggregation columns, totals, chart and drilldown.

FieldTypeDescription
frozenPanesFrozenPaneType!Which leading rows and columns stay frozen while scrolling: none, the first row, the first column, or the first row and column.
chartReportChart!Chart configuration for this report tab.
reportValueFields[ReportValueField!]!Additional value fields computed for the report, such as calculated formula fields, rollup summary fields and converted-currency fields.
historyReportHistoryHistory configuration when the report tracks field values over time, either as a comparison against specific dates or as a trend over a period.
currencyIdUUID!Identifier of the currency that monetary values in the report are displayed in.
totalPivotReportTotal!Configuration of the totals shown for the pivot table.
rowFields[PivotField!]!List of the field IDs that are reported as pivot rows, beware if depth is very big report generates an Out of size error report
rowNumberColumnWidthIntWidth of the leading row-number column; if Null the default width is used.
rowValueColumnWidthIntWidth of the row-label value columns; if Null the default width is used.
columnFields[PivotField!]!List of the field IDs that are reported as pivot columns, beware if depth is very big report generates an Out of size error report
aggregationFields[AggregationField!]!Value columns aggregated for each cell of the pivot, each with its aggregation operator and optional comparison.
isDrilldownEnabledBoolean!Whether users can drill down from a pivot cell into the underlying records.
drilldownFields[DisplayFieldItem!]!List of fields to display as drilldown table
ViewReportTab interface 5 fields: frozenPanes, chart, reportValueFields, …

View settings shared by report tables and pivot tables: frozen panes, chart, computed value fields, history and currency.

FieldTypeDescription
frozenPanesFrozenPaneType!Which leading rows and columns stay frozen while scrolling: none, the first row, the first column, or the first row and column.
chartReportChart!Chart configuration for this report tab.
reportValueFields[ReportValueField!]!Additional value fields computed for the report, such as calculated formula fields, rollup summary fields and converted-currency fields.
historyReportHistoryHistory configuration when the report tracks field values over time, either as a comparison against specific dates or as a trend over a period.
currencyIdUUID!Identifier of the currency that monetary values in the report are displayed in.
ViewTableReportTab object 9 fields: frozenPanes, chart, reportValueFields, …

View settings of a report table: sorting, grouping, totals, chart and computed value fields.

FieldTypeDescription
frozenPanesFrozenPaneType!Which leading rows and columns stay frozen while scrolling: none, the first row, the first column, or the first row and column.
chartReportChart!Chart configuration for this report tab.
reportValueFields[ReportValueField!]!Additional value fields computed for the report, such as calculated formula fields, rollup summary fields and converted-currency fields.
historyReportHistoryHistory configuration when the report tracks field values over time, either as a comparison against specific dates or as a trend over a period.
currencyIdUUID!Identifier of the currency that monetary values in the report are displayed in.
sortFields[SortField!]!Fields the table rows are sorted by, in priority order, each with its sort direction.
groupFields[GroupField!]!Fields the table rows are grouped by, in nesting order.
totalTableReportTotal!Configuration of the totals rows shown for groups and the whole table.
keepLineBreaksBoolean!Whether line breaks within text values are preserved when the table is rendered.