BlueConic · Example Payload

Getallrollups Response 200

Get all timeline event rollups

Customer Data PlatformCDPCustomer ProfilesSegmentsData ActivationFirst-Party DataLifecycle StagesConnectionsPrivacy

Getallrollups Response 200 is an example object payload from BlueConic, with 3 top-level fields. It illustrates the shape of data this provider's APIs accept or return.

Top-level fields

summarydescriptionvalue

Example Payload

{
  "summary": "GET /timelineEventRollups 200 - Response body",
  "description": "Get all timeline event rollups",
  "value": "{\n  \"itemsPerPage\": 20,\n  \"startIndex\": 0,\n  \"timelineEventRollups\": [\n    {\n      \"creationDate\": \"2025-09-23T11:40:21.373Z\",\n      \"creator\": {\n        \"fullName\": \"ondemand@blueconic.com\",\n        \"userName\": \"ondemand@blueconic.com\"\n      },\n      \"description\": \"\",\n      \"id\": \"ae4d6f16-502e-4822-be38-90abd63ae425\",\n      \"lastModifiedDate\": \"2025-09-23T12:39:02.787Z\",\n      \"lastModifiedUser\": {\n        \"fullName\": \"ondemand@blueconic.com\",\n        \"userName\": \"ondemand@blueconic.com\"\n      },\n      \"name\": \"Revenue last 360 days\",\n      \"query\": {\n        \"conditions\": [\n          {\n            \"conditionOperator\": \"WITHIN_LAST\",\n            \"eventPropertyId\": \"date\",\n            \"toValue\": 360.0,\n            \"values\": []\n          }\n        ],\n        \"eventTypeIds\": [\n          \"order\"\n        ],\n        \"mappings\": [\n          {\n            \"eventPropertyId\": \"total_revenue\",\n            \"profilePropertyId\": \"revenue_last_360_days\",\n            \"sqlSelectColumnName\": \"revenue_last_360_days\"\n          }\n        ],\n        \"sqlQuery\": \"SELECT\\\\n  SUM(`order_event`.`total_revenue`) AS `revenue_last_360_days`\\\\nFROM\\\\n  `order_event`\\\\nWHERE\\\\n  (\\\\n    `order_event`.`date` >= DATEADD (day, -360, CURRENT_DATE())\\\\n    AND `order_event`.`date` <= NOW ()\\\\n  )\",\n        \"type\": \"SQL\"\n      },\n      \"isEnabled\": true,\n      \"tags\": []\n    },\n    {\n      \"creationDate\": \"2025-09-18T11:25:00.141Z\",\n      \"creator\": {\n        \"fullName\": \"ondemand@blueconic.com\",\n        \"userName\": \"ondemand@blueconic.com\"\n      },\n      \"description\": \"\",\n      \"id\": \"7a098eec-c4b8-4f17-933f-accf6ad0723f\",\n      \"lastModifiedDate\": \"2025-09-23T09:12:07.611Z\",\n      \"lastModifiedUser\": {\n        \"fullName\": \"ondemand@blueconic.com\",\n        \"userName\": \"ondemand@blueconic.com\"\n      },\n      \"lastStatisticsUpdate\": \"2025-09-23T09:08:40.763Z\",\n      \"name\": \"Order t-shirt revenue last 30 days\",\n      \"profilesMarkedForRollup\": 0,\n      \"profilesUpdated\": 0,\n      \"query\": {\n        \"conditions\": [\n          {\n            \"conditionOperator\": \"WITHIN_LAST\",\n            \"eventPropertyId\": \"date\",\n            \"toValue\": 30.0,\n            \"values\": []\n          },\n          {\n            \"conditionOperator\": \"CONTAINS_ANY\",\n            \"eventPropertyId\": \"order.product.tag\",\n            \"values\": [\n              \"t-shirt\",\n              \"tshirt\"\n            ]\n          }\n        ],\n        \"eventTypeIds\": [\n          \"order\"\n        ],\n        \"mappings\": [\n          {\n            \"eventPropertyId\": \"revenue\",\n            \"mappingOperator\": \"SUM\",\n            \"profilePropertyId\": \"revenue_last_30_days\"\n          }\n        ],\n        \"type\": \"BASIC\"\n      },\n      \"isEnabled\": true,\n      \"tags\": []\n    }\n  ],\n  \"totalPages\": 1,\n  \"totalResults\": 3\n}"
}