Newer Version Available

This content describes an older version of this product. View Latest

Example

This example provides details on the integration metadata JSON with data source.
PromotionMeasures
1{
2  "datasources": [
3    {
4      "name": "PromotionMeasures"
5    }
6  ],
7  "dimensions": {
8    "accountdimension": {
9      "attributes": [
10        {
11          "label": "ExternalId",
12          "name": "externalid"
13        },
14        {
15          "label": "Name",
16          "name": "name"
17        },
18        {
19          "label": "AccountNUmber",
20          "name": "accountnumber"
21        }
22      ],
23      "key": "externalid",
24      "level": ""
25    },
26    "productdimension": {
27      "attributes": [
28        {
29          "label": "Description",
30          "name": "description"
31        },
32        {
33          "label": "ExternalId",
34          "name": "externalid"
35        },
36        {
37          "label": "Category",
38          "name": "category"
39        }
40      ],
41      "key": "externalid",
42      "level": "Product"
43    },
44    "timedimension": {
45      "includetotal": false,
46      "splitweeks": false,
47      "periodtype": "custom"
48    },
49    "kpidimension": {
50      "measures": [
51        {
52          "name": "ProPlanIncrVolume",
53          "label": "Incremental Volume"
54        }
55      ]
56    },
57    "promotiondimension": {
58      "attributes": [
59        {
60          "label": "id",
61          "name": "id"
62        },
63        {
64          "label": "datefrom",
65          "name": "datefrom"
66        },
67        {
68          "label": "templateName",
69          "name": "templateName"
70        },
71        {
72          "label": "accountid",
73          "name": "accountid"
74        },
75        {
76          "label": "accountplanrelevant",
77          "name": "accountplanrelevant"
78        },
79        {
80          "label": "accountexternalid",
81          "name": "accountexternalid"
82        }
83      ],
84      "key": "id",
85      "level": ""
86    }
87  },
88  "exportsettings": {
89    "columns": [
90      "accountdimension.externalid",
91      "promotiondimension.id",
92      "promotiondimension.datefrom",
93      "promotiondimension.templateName",
94      "productdimension.externalid",
95      "productdimension.category",
96      "productdimension.description",
97      "kpidimension.label",
98      "kpidimension.measurecode",
99      "...timedimension.label"
100    ],
101    "csvseparator": ","
102  },
103  "exportfilters": {
104    "conditions": [
105      {
106        "operator": "includes",
107        "value": [
108          "Kroger_Atlanta"
109        ],
110        "attribute": "externalid",
111        "dimension": "accountdimension",
112        "name": "cond1"
113      }
114    ]
115  }
116}