/api/dataSets/:id/dataLoads dataset data. データセットデータをロードします。 リソース情報Request ParametersリクエストパラメーターParametersパラメーター | Detail詳細 | Example例 |
|---|
id | ID of the data set to fetch. You can find the ID in the response to フェッチするデータセットのID。 IDは、/api/dataSets.123へのレスポンスで見つけることができます。 | 123 | | joinPoints | データのロードに使用される結合ポイントの定義。 使用可能な結合タイプ: - LEFT_OUTER_JOIN
- INNER_JOIN
- CROSS_JOIN
| joinPoints={"joins"=[
{"joinedDataSetId":"198", "primaryAttribute": "L_ID", "joinedAttribute":"L_ID_JOINED", "alias":"th", "joinType": "INNER_JOIN"}
]} | filter
| ( Optionalオプション) Filter used to load data. Prefix (PT) can be used when join contains columns with the same names. See the complete list of Filter operation types. conditionType (optional) is used to define condition operator between conditions. Available values: Searching part of String: use '%' wildcard to search selected String in data set values. E.g. "value": "%al%" In order to join multiple filters or apply two filters on the same parameter, attribute drilldown can be an array. "conditionType" attribute outside "drilldown" defines condition between drilldown array members and "conditionType" attribute inside drilldown member defines condition between attributes in the drilldown. | {
"drilldown": {
"UID": {
"op":"IN",
"values":["1","2","4","10"]
},
"L_COUNTRY_OR_AREA": {
"op": "EQ",
"value": "Slovakia"
},
"L_TYPE": {
"op": "IN",
"values": [ "Type 1", "Type 2", "Type 3" ]
},
"PT.L_DATE": {
"op": "NOT_NULL"
},
"conditionType":"OR"
}
}
Example of a between filter:
{"drilldown":[{"L_ID":{"op":"GT","value":"10"}},{"L_ID":{"op":"LT","value":"20"}}]}
| offset (query parameter) | (Optionalオプション) Specifies the page offset if pagination is necessary. | 2 | size (query parameter) | (Optionalオプション) Specifies the number of entries on each page if pagination is necessary. | 15 |
| order (query parameter) | (オプション) Specifies the sorting order of the listed data | M_INDICATOR asc |
レスポンス構造| Code Block |
|---|
| {
"dataSet" : { ... },
"data" : [ { "UID" : 123456, "L_ATTRIBUTE" : "value", "M_INDICATOR" : 11.99 }, { "UID" : 123457, "L_ATTRIBUTE" : "value2", "M_INDICATOR" : 22.08 } ],
} "offset" : 0,
"size" : 2
} |
JSONレスポンスには2つのページネーション要素 (offsetとsize) が含まれますが、主な2つの要素はデータセットに関する詳細情報を含むdataSet (JSON response contains 2 elements dataSet that contains detailed information about data set (see GET Data Set Detail) and data which contains array of data rows in following strcutureを参照）と、次の構造のデータ行の配列を含むdataです: | Name名 | Description説明 |
|---|
| UID | Unique ID of data row. | | L_* | Attribute values contained in the data row. | | M_* | Indicator values contained in the data row. |
結合データセット| Note |
|---|
BellaDati 2.9.19から利用可能です。 |
結合データセットでは、プレフィックスは重複した属性またはインジケータのソースデータセットを示します。 例: DATASETCODE_L_ATTRIBUTE サンプルリクエスト/レスポンスcurl使用: | Code Block |
|---|
curl -H "Authorization: OAuth realm=\"https://service.belladati.com/\", oauth_consumer_key=\"myConsumer\", oauth_token=\"mh7an9dkrg59\", oauth_timestamp=\"135131231\", oauth_nonce=\"randomString\"" https://service.belladati.com/api/dataSets/123/data
|
JSONフォーマットの応答JSONフォーマットのレスポンス: | Code Block |
|---|
| {
"dataSet" : {
"id" : 123,
"name" : "My test data set",
"code" : "DATASET_CODE",
"localization" : {
"de" : "Deutsch Name"
},
"description" : "This is a sample data set.",
"owner" : "John Smith",
"lastChange" : "Tue, 22 May 2012 17:16:31 GMT",
"attributesdata" : [
{
"id { "UID" : "123.FO8j1HfdDz",
"name123456, "L_ATTRIBUTE" : "Cityvalue",
"code" : "L_CITY",
"typeM_INDICATOR" : "String"
11.99 }
],
"indicators" : [
{
"id
{ "UID" : "123.8RnLDOwZnY",
"name123457, "L_ATTRIBUTE" : "Countvalue2",
"type" : "DATA_INDICATOR",
"codeM_INDICATOR" : "M_COUNT"
},
{
"id" : "123.Jiq7Cuyai1"22.08 }
],
"nameoffset" : "Calculated indicator"0,
"typesize" : "FORMULA_INDICATOR"2,
"formulaparameters" : "M_COUNT * 1000"[
},
{
"id" : "123.MrrmQgYyyo",
"name" param1": "Indicator groupvalue1",
"type" : "INDICATOR_GROUP"
}
],
"reports" : [
{
"id" : 7497,
"name" "param2": "My Reportvalue2",
"description" : "This is a sample report.",
"owner" : "John Smith",
"lastChange" : "Mon, 16 Apr 2012 10:17:26 GMT"
}
]
},
"data" : [
{ "UID" : 123456, "L_ATTRIBUTE" : "value", "M_INDICATOR" : 11.99 },
{ "UID" : 123457, "L_ATTRIBUTE" : "value2", "M_INDICATOR" : 22.08 }
]
} |
|