BlueConic · Example Payload

Getonerollup Response 200

Get one timeline event rollup

Customer Data PlatformCDPCustomer ProfilesSegmentsData ActivationFirst-Party DataLifecycle StagesConnectionsPrivacy

Getonerollup 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

Raw ↑ 
{
  "summary": "GET /timelineEventRollups/{rollup} 200 - Response body",
  "description": "Get one timeline event rollup",
  "value": "{\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}"
}