Returns a list of objects that match the criteria specified in the request.
operationType | string non-empty |
startRow | number |
endRow | number |
sortBy | Array of objects |
textMatchStyle | string non-empty |
required | object |
oldValues | any |
{- "operationType": "fetch",
- "startRow": 0,
- "endRow": 100000,
- "sortBy": [ ],
- "textMatchStyle": "exact",
- "data": {
- "query": {
- "name": null,
- "datamart": "DM.TransactionsDM",
- "label": "Series1",
- "source": "DM.TransactionsDM",
- "projections": {
- "bandBy": {
- "alias": "bandBy",
- "expression": "CustomerID",
- "function": "",
- "parameters": { },
- "name": "CustomerID",
- "label": "CustomerID"
}, - "bubbleSize": {
- "alias": "bubbleSize",
- "expression": "SUM({field})",
- "function": null,
- "parameters": {
- "field": "Quantity",
- "quantity": "Quantity",
- "base": "ListPrice"
}, - "name": "Quantity",
- "label": "∑Quantity",
- "default": null,
- "advancedProjection": true,
- "formatString": "∑{field}"
}, - "bubbleSize_n": {
- "alias": "bubbleSize_n",
- "expression": "SUM({field})",
- "function": null,
- "parameters": {
- "field": "Quantity",
- "quantity": "Quantity",
- "base": "ListPrice"
}, - "name": "Quantity",
- "label": "∑Quantity (norm)",
- "default": null,
- "advancedProjection": true,
- "formatString": "∑{field}"
}, - "groupBy": {
- "alias": "groupBy",
- "expression": "Region",
- "function": "",
- "parameters": { },
- "name": "Region",
- "label": "Region"
}, - "x": {
- "alias": "x",
- "expression": "SUM({field})",
- "function": null,
- "parameters": {
- "field": "BasePrice",
- "quantity": "Quantity",
- "base": "ListPrice"
}, - "name": "BasePrice",
- "label": "∑BasePrice",
- "default": null,
- "advancedProjection": true,
- "formatString": "∑{field}"
}, - "y": {
- "alias": "y",
- "expression": "SUM({field})/SUM({quantity})",
- "function": null,
- "parameters": {
- "field": "ListPrice",
- "quantity": "Quantity",
- "base": "ListPrice"
}, - "name": "ListPrice",
- "label": "∑ListPrice/∑Quantity",
- "default": null,
- "advancedProjection": true,
- "formatString": "∑{field}/∑{quantity}"
}
}, - "options": {
- "currency": "EUR",
- "regression": [
- "y",
- "x"
], - "distribution": [
- "m1",
- "x",
- "y"
], - "normalization": [
- "bubbleSize_n"
]
}, - "filter": {
- "criteria": [ ],
- "operator": "and",
- "_constructor": "AdvancedCriteria"
}, - "aggregateFilter": null,
- "dimensionFilters": [ ],
- "limit": null,
- "rollup": true,
- "sortBy": [ ]
}
}, - "oldValues": null
}
{- "response": {
- "node": "e2e-staging-node",
- "startRow": 0,
- "data": [
- {
- "bandBy": "CD-0004",
- "bubbleSize": 548,
- "bubbleSize_n": 0.292108362779741,
- "groupBy": "Europe",
- "x": 12075200,
- "y": 220350.364963504,
- "summary": "{\"projections\":{\"y\":{\"LRa\":239348.912312387,\"ERa\":237200.359912615,\"Sum\":15041879.5665948,\"Avg\":250697.992776579,\"Mean\":250697.992776579,\"Min\":93904.7619047619,\"Max\":353076.923076923,\"Std\":46309.6235068131,\"Q.05\":166714.083007813,\"Q.1\":196816.897460938,\"Q.2\":219184.366210938,\"Q.25\":226486.880371094,\"Q.3\":236223.565917969,\"Q.4\":243526.080078125,\"Q.5\":249915.779968262,\"Q.6\":258131.108398438,\"Q.7\":271519.051025391,\"Q.75\":280038.650878906,\"Q.8\":290262.170703125,\"Q.9\":311682.878906250,\"Q.95\":331156.250000000,\"Hist\":{\"118174.538085938\":1,\"154579.196777344\":2,\"178848.969238281\":1,\"193900.376464844\":2,\"199733.418457031\":1,\"205566.460449219\":2,\"211399.502441406\":1,\"217967.280517578\":3,\"225269.794677734\":3,\"232572.308837891\":2,\"238049.194458008\":2,\"241700.451538086\":4,\"245351.708618164\":2,\"248090.151428223\":3,\"249915.779968262\":2,\"254479.851318359\":5,\"261782.365478516\":1,\"267259.251098633\":3,\"270910.508178711\":3,\"276387.393798828\":2,\"283689.907958984\":2,\"294643.679199219\":5,\"309248.707519531\":3,\"323853.735839844\":2,\"342116.593750000\":3}},\"x\":{\"LRb\":0.000564991849158590,\"ERb\":2.44510211980881E-9,\"Sum\":1118727900.00000,\"Avg\":18645465.0000000,\"Mean\":18645465.0000000,\"Min\":1183200.00000000,\"Max\":41407200.0000000,\"Std\":12268723.3236501,\"Q.05\":2081450.00000000,\"Q.1\":3481156.25000000,\"Q.2\":5028200.00000000,\"Q.25\":6796250.00000000,\"Q.3\":8564300.00000000,\"Q.4\":12954533.3333333,\"Q.5\":16979450.0000000,\"Q.6\":22194221.8750000,\"Q.7\":25844716.6666667,\"Q.75\":28035013.5416667,\"Q.8\":30955409.3750000,\"Q.9\":36650181.2500000,\"Q.95\":39951862.5000000,\"Hist\":{\"1260425.00000000\":1,\"1414875.00000000\":1,\"2376125.00000000\":3,\"3702162.50000000\":4,\"4586187.50000000\":3,\"5912225.00000000\":3,\"7238262.50000000\":1,\"8122287.50000000\":2,\"9149450.00000000\":1,\"10942075.0000000\":4,\"13357025.0000000\":3,\"15168237.5000000\":2,\"16375712.5000000\":2,\"18491687.5000000\":2,\"21099073.4375000\":4,\"23289370.3125000\":4,\"25479667.1875000\":3,\"27669964.0625000\":3,\"30955409.3750000\":4,\"35336003.1250000\":5,\"38496525.0000000\":1,\"40436975.0000000\":4}}},\"Count\":60}"
}, - {
- "bandBy": "CD-0008",
- "bubbleSize": 355,
- "bubbleSize_n": 0.178445229681979,
- "groupBy": "Asia",
- "x": 11279100,
- "y": 296039.37007874
}, - {
- "bandBy": "CD-0001",
- "bubbleSize": 405,
- "bubbleSize_n": 0.207891637220259,
- "groupBy": "Europe",
- "x": 10922500,
- "y": 269691.358024691
}
], - "endRow": 3,
- "totalRows": 3,
- "status": 0
}
}