Hello, I have a problem with External Collections with API. I can’t test the connection successfully.
Is it because of the JSON data structure (see “full response” in photo 1) problem or the third result key is wrong(see “Endpoints” in photo 2)?
Full Response :
{
"success": "true",
"result": {
"resource_id": "F-D0047-089",
"fields": [
{
"id": "contentDescription",
"type": "String"
},
{
"id": "datasetDescription",
"type": "String"
},
{
"id": "locationsName",
"type": "String"
},
{
"id": "dataid",
"type": "String"
},
{
"id": "locationName",
"type": "String"
},
{
"id": "geocode",
"type": "Double"
},
{
"id": "lat",
"type": "Double"
},
{
"id": "lon",
"type": "Double"
},
{
"id": "elementName",
"type": "String"
},
{
"id": "description",
"type": "String"
},
{
"id": "startTime",
"type": "Timestamp"
},
{
"id": "endTime",
"type": "Timestamp"
},
{
"id": "dataTime",
"type": "Timestamp"
},
{
"id": "value",
"type": "String"
},
{
"id": "measures",
"type": "String"
}
]
},
"records": {
"locations": [
{
"datasetDescription": "臺灣各縣市鄉鎮未來3天(72小時)逐3小時天氣預報",
"locationsName": "台灣",
"dataid": "D0047-089",
"location": [
{
"locationName": "新北市",
"geocode": "65000000",
"lat": "25.01154",
"lon": "121.450888",
"weatherElement": [
{
"elementName": "Wx",
"description": "天氣現象",
"time": [
{
"startTime": "2024-05-22 18:00:00",
"endTime": "2024-05-22 21:00:00",
"elementValue": [
{
"value": "短暫陣雨或雷雨",
"measures": "自定義 Wx 文字"
},
{
"value": "15",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-22 21:00:00",
"endTime": "2024-05-23 00:00:00",
"elementValue": [
{
"value": "陰",
"measures": "自定義 Wx 文字"
},
{
"value": "07",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 00:00:00",
"endTime": "2024-05-23 03:00:00",
"elementValue": [
{
"value": "短暫陣雨或雷雨",
"measures": "自定義 Wx 文字"
},
{
"value": "15",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 03:00:00",
"endTime": "2024-05-23 06:00:00",
"elementValue": [
{
"value": "陰",
"measures": "自定義 Wx 文字"
},
{
"value": "07",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 06:00:00",
"endTime": "2024-05-23 09:00:00",
"elementValue": [
{
"value": "短暫陣雨或雷雨",
"measures": "自定義 Wx 文字"
},
{
"value": "15",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 09:00:00",
"endTime": "2024-05-23 12:00:00",
"elementValue": [
{
"value": "陰",
"measures": "自定義 Wx 文字"
},
{
"value": "07",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 12:00:00",
"endTime": "2024-05-23 15:00:00",
"elementValue": [
{
"value": "短暫陣雨或雷雨",
"measures": "自定義 Wx 文字"
},
{
"value": "15",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 15:00:00",
"endTime": "2024-05-23 18:00:00",
"elementValue": [
{
"value": "短暫陣雨或雷雨",
"measures": "自定義 Wx 文字"
},
{
"value": "15",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 18:00:00",
"endTime": "2024-05-23 21:00:00",
"elementValue": [
{
"value": "陰",
"measures": "自定義 Wx 文字"
},
{
"value": "07",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-23 21:00:00",
"endTime": "2024-05-24 00:00:00",
"elementValue": [
{
"value": "短暫陣雨或雷雨",
"measures": "自定義 Wx 文字"
},
{
"value": "15",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 00:00:00",
"endTime": "2024-05-24 03:00:00",
"elementValue": [
{
"value": "短暫陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "08",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 03:00:00",
"endTime": "2024-05-24 06:00:00",
"elementValue": [
{
"value": "短暫陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "08",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 06:00:00",
"endTime": "2024-05-24 09:00:00",
"elementValue": [
{
"value": "短暫陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "08",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 09:00:00",
"endTime": "2024-05-24 12:00:00",
"elementValue": [
{
"value": "短暫陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "08",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 12:00:00",
"endTime": "2024-05-24 15:00:00",
"elementValue": [
{
"value": "短暫陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "08",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 15:00:00",
"endTime": "2024-05-24 18:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 18:00:00",
"endTime": "2024-05-24 21:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-24 21:00:00",
"endTime": "2024-05-25 00:00:00",
"elementValue": [
{
"value": "短暫陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "08",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 00:00:00",
"endTime": "2024-05-25 03:00:00",
"elementValue": [
{
"value": "短暫陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "08",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 03:00:00",
"endTime": "2024-05-25 06:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 06:00:00",
"endTime": "2024-05-25 09:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 09:00:00",
"endTime": "2024-05-25 12:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 12:00:00",
"endTime": "2024-05-25 15:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 15:00:00",
"endTime": "2024-05-25 18:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 18:00:00",
"endTime": "2024-05-25 21:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-25 21:00:00",
"endTime": "2024-05-26 00:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-26 00:00:00",
"endTime": "2024-05-26 03:00:00",
"elementValue": [
{
"value": "晴",
"measures": "自定義 Wx 文字"
},
{
"value": "01",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-26 03:00:00",
"endTime": "2024-05-26 06:00:00",
"elementValue": [
{
"value": "晴",
"measures": "自定義 Wx 文字"
},
{
"value": "01",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-26 06:00:00",
"endTime": "2024-05-26 09:00:00",
"elementValue": [
{
"value": "晴",
"measures": "自定義 Wx 文字"
},
{
"value": "01",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-26 09:00:00",
"endTime": "2024-05-26 12:00:00",
"elementValue": [
{
"value": "晴",
"measures": "自定義 Wx 文字"
},
{
"value": "01",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-26 12:00:00",
"endTime": "2024-05-26 15:00:00",
"elementValue": [
{
"value": "午後短暫雷陣雨",
"measures": "自定義 Wx 文字"
},
{
"value": "15",
"measures": "自定義 Wx 單位"
}
]
},
{
"startTime": "2024-05-26 15:00:00",
"endTime": "2024-05-26 18:00:00",
"elementValue": [
{
"value": "多雲",
"measures": "自定義 Wx 文字"
},
{
"value": "04",
"measures": "自定義 Wx 單位"
}
]
}
]
}
]
}
]
}
]
}
}
