I am using VBA to get some exchange rates from a website to Excel. The json response I get appears to be valid, as I checked with this online tool: / Still, when the code tries to parse it, I get this error first: Dictionary key not found: result. If I debug, I get another error: Run time error 10001 Error parsing json Expecting 'STRING', 'NUMBER', null, true, false, '{', or '['. Any idea on how to solve this? Thanks. I paste the json string here: { "result": "success", "documentation": ";, "terms_of_use": ";, "time_last_update_unix": 1738800001, "time_last_update_utc": "Thu, 06 Feb 2025 00:00:01 +0000", "time_next_update_unix": 1738886401, "time_next_update_utc": "Fri, 07 Feb 2025 00:00:01 +0000", "base_code": "UAH", "conversion_rates": { "UAH": 1, "AED": 0.08816, "AFN": 1.7829, "ALL": 2.2856, "AMD": 9.5177 } }
parsing - Apparently validated json response gives a run-time error 10001 - Stack Overflow
评论列表(0)
- 暂无评论