JSON格式错误 [英] JSON Formatting error

问题描述

我在尝试将此JSON导入到google bigquery表中时遇到此错误
file-00000000：JSON表遇到太多错误，放弃。行数：1;错误：1.（错误代码：无效）
在文件file：00000000处从位置0开始的行中的JSON解析错误。在没有开始对象的情况下遇到数组开始。 （错误代码：无效）

I am getting this error while trying to import this JSON into google bigquery table file-00000000: JSON table encountered too many errors, giving up. Rows: 1; errors: 1. (error code: invalid) JSON parsing error in row starting at position 0 at file: file-00000000. Start of array encountered without start of object. (error code: invalid)

这是JSON

[{'instrument_token': 11192834, 'average_price': 8463.45, 'last_price': 8471.1, 'last_quantity': 75, 'buy_quantity': 1065150, 'volume': 5545950, 'depth': {'buy': [{'price': 8471.1, 'quantity': 300, 'orders': 131072}, {'price': 8471.0, 'quantity': 300, 'orders': 65536}, {'price': 8470.95, 'quantity': 150, 'orders': 65536}, {'price': 8470.85, 'quantity': 75, 'orders': 65536}, {'price': 8470.7, 'quantity': 225, 'orders': 65536}], 'sell': [{'price': 8471.5, 'quantity': 150, 'orders': 131072}, {'price': 8471.55, 'quantity': 375, 'orders': 327680}, {'price': 8471.8, 'quantity': 1050, 'orders': 65536}, {'price': 8472.0, 'quantity': 1050, 'orders': 327680}, {'price': 8472.1, 'quantity': 150, 'orders': 65536}]}, 'ohlc': {'high': 8484.1, 'close': 8336.45, 'low': 8422.35, 'open': 8432.75}, 'mode': 'quote', 'sell_quantity': 998475, 'tradeable': True, 'change': 1.6151959167271395}]

http://jsonformatter.org/ 也给这个JSON块提供了解析错误。需要帮助了解格式错误的位置 - 这是来自其他API的JSON

http://jsonformatter.org/ also gives parse error for this JSON block. Need help understanding where the formatting is wrong - this is the JSON from a rest API

推荐答案

这是无效的JSON。 JSON使用双引号，而不是单引号。另外， True 应该是 true 。

This is not valid JSON. JSON uses double quotes, not single quotes. Also, True should be true.

如果我不得不猜测，我猜想这是Python代码被传递为JSON。 ： - ）

If I had to guess, I would guess that this is Python code being passed off as JSON. :-)

我怀疑，即使这种方法制作成正确的JSON，也不是Google BigQuery预期的格式。从 https://cloud.google.com/bigquery/data-formats#json_format，看起来你应该有一个文本文件，每行有一个JSON对象。试试这个：

I suspect that even once this is made into correct JSON, it's not the format Google BigQuery is expecting. From https://cloud.google.com/bigquery/data-formats#json_format, it looks like you should have a text file with one JSON object per line. Try just this:

{"mode": "quote", "tradeable": true, "last_quantity": 75, "buy_quantity": 1065150, "depth": {"buy": [{"quantity": 300, "orders": 131072, "price": 8471.1}, {"quantity": 300, "orders": 65536, "price": 8471.0}, {"quantity": 150, "orders": 65536, "price": 8470.95}, {"quantity": 75, "orders": 65536, "price": 8470.85}, {"quantity": 225, "orders": 65536, "price": 8470.7}], "sell": [{"quantity": 150, "orders": 131072, "price": 8471.5}, {"quantity": 375, "orders": 327680, "price": 8471.55}, {"quantity": 1050, "orders": 65536, "price": 8471.8}, {"quantity": 1050, "orders": 327680, "price": 8472.0}, {"quantity": 150, "orders": 65536, "price": 8472.1}]}, "change": 1.6151959167271395, "average_price": 8463.45, "ohlc": {"close": 8336.45, "high": 8484.1, "open": 8432.75, "low": 8422.35}, "instrument_token": 11192834, "last_price": 8471.1, "sell_quantity": 998475, "volume": 5545950}

这篇关于JSON格式错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！