addedInput schema / properties / request_body
Added value: +{
+ "description": "Request body of type RunPivotReportRequest: pass it via `params` (merged into the built body) or whole via `body_file`.",
+ "properties": {
+ "cohortSpec": {
+ "properties": {
+ "cohortReportSettings": {
+ "properties": {
+ "accumulate": {
+ "type": "boolean"
+ }
+ },
+ "type": "object"
+ },
+ "cohorts": {
+ "items": {
+ "properties": {
+ "dateRange": {
+ "properties": {
+ "endDate": {
+ "type": "string"
+ },
+ "name": {
+ "type": "string"
+ },
+ "startDate": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "dimension": {
+ "type": "string"
+ },
+ "name": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "cohortsRange": {
+ "properties": {
+ "endOffset": {
+ "type": "integer"
+ },
+ "granularity": {
+ "enum": [
+ "GRANULARITY_UNSPECIFIED",
+ "DAILY",
+ "WEEKLY",
+ "MONTHLY"
+ ],
+ "type": "string"
+ },
+ "startOffset": {
+ "type": "integer"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "comparisons": {
+ "items": {
+ "properties": {
+ "comparison": {
+ "type": "string"
+ },
+ "dimensionFilter": {
+ "properties": {
+ "andGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "filter": {
+ "properties": {
+ "betweenFilter": {
+ "type": "object"
+ },
+ "emptyFilter": {
+ "type": "object"
+ },
+ "fieldName": {
+ "type": "string"
+ },
+ "inListFilter": {
+ "type": "object"
+ },
+ "numericFilter": {
+ "type": "object"
+ },
+ "stringFilter": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "notExpression": {
+ "properties": {
+ "andGroup": {
+ "type": "object"
+ },
+ "filter": {
+ "type": "object"
+ },
+ "notExpression": {
+ "type": "object"
+ },
+ "orGroup": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "orGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "name": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "currencyCode": {
+ "type": "string"
+ },
+ "dateRanges": {
+ "items": {
+ "properties": {
+ "endDate": {
+ "type": "string"
+ },
+ "name": {
+ "type": "string"
+ },
+ "startDate": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "dimensionFilter": {
+ "properties": {
+ "andGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "properties": {
+ "andGroup": {
+ "type": "object"
+ },
+ "filter": {
+ "type": "object"
+ },
+ "notExpression": {
+ "type": "object"
+ },
+ "orGroup": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "filter": {
+ "properties": {
+ "betweenFilter": {
+ "properties": {
+ "fromValue": {
+ "type": "object"
+ },
+ "toValue": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "emptyFilter": {
+ "type": "object"
+ },
+ "fieldName": {
+ "type": "string"
+ },
+ "inListFilter": {
+ "properties": {
+ "caseSensitive": {
+ "type": "boolean"
+ },
+ "values": {
+ "items": {
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "numericFilter": {
+ "properties": {
+ "operation": {
+ "enum": [
+ "OPERATION_UNSPECIFIED",
+ "EQUAL",
+ "LESS_THAN",
+ "LESS_THAN_OR_EQUAL",
+ "GREATER_THAN",
+ "GREATER_THAN_OR_EQUAL"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "stringFilter": {
+ "properties": {
+ "caseSensitive": {
+ "type": "boolean"
+ },
+ "matchType": {
+ "enum": [
+ "MATCH_TYPE_UNSPECIFIED",
+ "EXACT",
+ "BEGINS_WITH",
+ "ENDS_WITH",
+ "CONTAINS",
+ "FULL_REGEXP",
+ "PARTIAL_REGEXP"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "notExpression": {
+ "properties": {
+ "andGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "filter": {
+ "properties": {
+ "betweenFilter": {
+ "type": "object"
+ },
+ "emptyFilter": {
+ "type": "object"
+ },
+ "fieldName": {
+ "type": "string"
+ },
+ "inListFilter": {
+ "type": "object"
+ },
+ "numericFilter": {
+ "type": "object"
+ },
+ "stringFilter": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "notExpression": {
+ "properties": {
+ "andGroup": {
+ "type": "object"
+ },
+ "filter": {
+ "type": "object"
+ },
+ "notExpression": {
+ "type": "object"
+ },
+ "orGroup": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "orGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "orGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "properties": {
+ "andGroup": {
+ "type": "object"
+ },
+ "filter": {
+ "type": "object"
+ },
+ "notExpression": {
+ "type": "object"
+ },
+ "orGroup": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "dimensions": {
+ "items": {
+ "properties": {
+ "dimensionExpression": {
+ "properties": {
+ "concatenate": {
+ "properties": {
+ "delimiter": {
+ "type": "string"
+ },
+ "dimensionNames": {
+ "items": {
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "lowerCase": {
+ "properties": {
+ "dimensionName": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "upperCase": {
+ "properties": {
+ "dimensionName": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "name": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "keepEmptyRows": {
+ "type": "boolean"
+ },
+ "metricFilter": {
+ "properties": {
+ "andGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "properties": {
+ "andGroup": {
+ "type": "object"
+ },
+ "filter": {
+ "type": "object"
+ },
+ "notExpression": {
+ "type": "object"
+ },
+ "orGroup": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "filter": {
+ "properties": {
+ "betweenFilter": {
+ "properties": {
+ "fromValue": {
+ "type": "object"
+ },
+ "toValue": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "emptyFilter": {
+ "type": "object"
+ },
+ "fieldName": {
+ "type": "string"
+ },
+ "inListFilter": {
+ "properties": {
+ "caseSensitive": {
+ "type": "boolean"
+ },
+ "values": {
+ "items": {
+ "type": "string"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "numericFilter": {
+ "properties": {
+ "operation": {
+ "enum": [
+ "OPERATION_UNSPECIFIED",
+ "EQUAL",
+ "LESS_THAN",
+ "LESS_THAN_OR_EQUAL",
+ "GREATER_THAN",
+ "GREATER_THAN_OR_EQUAL"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "stringFilter": {
+ "properties": {
+ "caseSensitive": {
+ "type": "boolean"
+ },
+ "matchType": {
+ "enum": [
+ "MATCH_TYPE_UNSPECIFIED",
+ "EXACT",
+ "BEGINS_WITH",
+ "ENDS_WITH",
+ "CONTAINS",
+ "FULL_REGEXP",
+ "PARTIAL_REGEXP"
+ ],
+ "type": "string"
+ },
+ "value": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "notExpression": {
+ "properties": {
+ "andGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "filter": {
+ "properties": {
+ "betweenFilter": {
+ "type": "object"
+ },
+ "emptyFilter": {
+ "type": "object"
+ },
+ "fieldName": {
+ "type": "string"
+ },
+ "inListFilter": {
+ "type": "object"
+ },
+ "numericFilter": {
+ "type": "object"
+ },
+ "stringFilter": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "notExpression": {
+ "properties": {
+ "andGroup": {
+ "type": "object"
+ },
+ "filter": {
+ "type": "object"
+ },
+ "notExpression": {
+ "type": "object"
+ },
+ "orGroup": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "orGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "orGroup": {
+ "properties": {
+ "expressions": {
+ "items": {
+ "properties": {
+ "andGroup": {
+ "type": "object"
+ },
+ "filter": {
+ "type": "object"
+ },
+ "notExpression": {
+ "type": "object"
+ },
+ "orGroup": {
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "metrics": {
+ "items": {
+ "properties": {
+ "expression": {
+ "type": "string"
+ },
+ "invisible": {
+ "type": "boolean"
+ },
+ "name": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "pivots": {
+ "items": {
+ "properties": {
+ "fieldNames": {
+ "items": {
+ "type": "string"
+ },
+ "type": "array"
+ },
+ "limit": {
+ "type": "string"
+ },
+ "metricAggregations": {
+ "items": {
+ "enum": [
+ "METRIC_AGGREGATION_UNSPECIFIED",
+ "TOTAL",
+ "MINIMUM",
+ "MAXIMUM",
+ "COUNT"
+ ],
+ "type": "string"
+ },
+ "type": "array"
+ },
+ "offset": {
+ "type": "string"
+ },
+ "orderBys": {
+ "items": {
+ "properties": {
+ "desc": {
+ "type": "boolean"
+ },
+ "dimension": {
+ "properties": {
+ "dimensionName": {
+ "type": "string"
+ },
+ "orderType": {
+ "enum": [
+ "ORDER_TYPE_UNSPECIFIED",
+ "ALPHANUMERIC",
+ "CASE_INSENSITIVE_ALPHANUMERIC",
+ "NUMERIC"
+ ],
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "metric": {
+ "properties": {
+ "metricName": {
+ "type": "string"
+ }
+ },
+ "type": "object"
+ },
+ "pivot": {
+ "properties": {
+ "metricName": {
+ "type": "string"
+ },
+ "pivotSelections": {
+ "items": {
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ }
+ },
+ "type": "object"
+ },
+ "type": "array"
+ },
+ "property": {
+ "type": "string"
+ },
+ "returnPropertyQuota": {
+ "type": "boolean"
+ }
+ },
+ "type": "object"
+}