直连模式

本节以表格仪表板为例带您快速了解直连模式+动态传参创建仪表板的流程。

1. 数据准备

1.1 创建数据源

为销售城市列表创建JSON API数据源：

参考配置：

数据源属性	属性值
Web API地址	https://result.eolink.com/fJW9VD107626a923906a5baae0c87fa617a3b6a11b6ddce?uri=/sale-cityList
请求方法	GET
JSON路径	$.data[*]

扩展：
Json路径：即解析JSON数据结构并取出指定数据集合的JSON Path表达式，如 $.bookstore.books[*]。
JSON Path的语法参考

Web API返回数据：

请求：

https://result.eolink.com/fJW9VD107626a923906a5baae0c87fa617a3b6a11b6ddce?uri=/sale-cityList

响应：

{
    "success": true,
    "code": 200,
    "message": "successful",
    "data": [{
        "id": "1",
        "cityName": "海东市"
    }, {
        "id": "2",
        "cityName": "安康市"
    }, {
        "id": "3",
        "cityName": "西宁市"
    }],
    "count": 4
}

1.2 新增数据源到数据集

1.3 编辑销售城市列表数据集字段

1.4 为城市销售统计数据源创建JSON API数据源

参考配置：

数据源属性	属性值
Web API地址	https://mockapi.eolink.com/fJW9VD107626a923906a5baae0c87fa617a3b6a11b6ddce/sales-city
添加Web API参数	cityName String false
请求方法	GET
JSON路径	$.data[*]

扩展：
Json路径：即解析JSON数据结构并取出指定数据集合的JSON Path表达式，如 $.bookstore.books[*]。
JSON Path的语法参考

Web API返回数据：

cityName的值包含：海东市、安康市、西宁市。下面我们传入参数?cityName=海东市进行测试。

请求：

https://mockapi.eolink.com/fJW9VD107626a923906a5baae0c87fa617a3b6a11b6ddce/sales-city?cityName=海东市

响应：

{
    "success": true,
    "code": 200,
    "message": "successful",
    "data": [{
        "id": "1",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "生鲜蔬果",
        "productName": "产品001",
        "quantity": 3,
        "orderAmount":179.2
    }, {
        "id": "2",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "综合商品",
        "productName": "产品011",
        "quantity": 4,
        "orderAmount":299.3
    }, {
        "id": "3",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "饮料烟酒",
        "productName": "产品038",
        "quantity": 22,
        "orderAmount":297.8
    }, {
        "id": "4",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "食品副食",
        "productName": "产品031",
        "quantity": 7,
        "orderAmount":677.5
    }, {
        "id": "5",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "生鲜蔬果",
        "productName": "产品001",
        "quantity": 5,
        "orderAmount":79.2
    }, {
        "id": "6",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "综合商品",
        "productName": "产品011",
        "quantity": 7,
        "orderAmount":2299.3
    }, {
        "id": "7",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "综合商品",
        "productName": "产品038",
        "quantity": 22,
        "orderAmount":1697.8
    }, {
        "id": "8",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "食品副食",
        "productName": "产品031",
        "quantity": 23,
        "orderAmount":677.5
    }, {
        "id": "9",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "饮料烟酒",
        "productName": "产品001",
        "quantity": 18,
        "orderAmount":559.2
    }, {
        "id": "10",
        "salesRegion": "西北",
        "salesProvince": "青海省",
        "salesCity": "海东市",
        "category": "综合商品",
        "productName": "产品011",
        "quantity": 16,
        "orderAmount":1299.3
    }],
    "count": 10
}