读取 JSON

从 24.1 版本起，Alteryx Designer 可以使用“输入数据”工具读取和解析结构化 JSON 数据。目前，AMP Engine 仅支持顶层嵌套对象。

[
    {
        "business_id": "vcNAWiLM4dR7D2nwwJ7nCA",
        "open": true,
        "review_count": 9,
        "hours": {
            "Tuesday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Friday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Monday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Wednesday": {
                "close": "17:00",
                "open": "08:00"
            },
            "Thursday": {
                "close": "17:00",
                "open": "08:00"
            }
        },
        "stars": 3.5
    },
    {
        "business_id": "UsFtqoBl7naz8AVUBZMjQQ",
        "open": true,
        "review_count": 4,
        "hours": {
            "Monday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Tuesday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Friday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Wednesday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Thursday": {
                "close": "21:00",
                "open": "10:00"
            },
            "Sunday": {
                "close": "18:00",
                "open": "11:00"
            },
            "Saturday": {
                "close": "21:00",
                "open": "10:00"
            }
        },
        "stars": 3.5
    },
    {
        "business_id": "cE27W9VPgO88Qxe4ol6y_g",
        "open": false,
        "review_count": 5,
        "stars": 2.5
    }
]