如何将 Google 电子表格的 Json 解码为 Php 数组

Question

我的 google 文档电子表格调用以 json 格式返回此响应
（我只需要“行”之后的所有内容） 请查看这里的格式化响应 :)

我使用php的json_decode 函数解析数据并使用它（是的，我对 php 很糟糕）此代码返回 NULL，并且根据文档，“如果 json 无法解码”，则返回 NULL。

$json = file_get_contents($jsonurl);
$json_output = json_decode($json);

var_dump($json_output); // 返回 NULL

基本上，我想要完成的是从 Json 响应的第一行值创建一个简单的数组。

你们都是天才

$array = {'john','John Handcock','[email protected]','2929292','blanc'}

，我非常感谢你们的洞察力和帮助！

答案正如“sberry2A”提到的，响应不是有效的Json，谷歌提供了

Answer 1

您提供的链接中的数据不是有效的 JSON。您提供的似乎是解码版本。您可以看出这不是 JSON，因为数组键没有被引用。例如，版本应该是“版本”。

您的数据应该看起来更像这样

'{"version":"0.6","reqId":"requestIDnumber","status":"ok","sig":"65724392","table":{"cols":[{"id":"A","label":"slug","type":"string", "pattern":""},{"id":"B","label":"name","type":"string","pattern":""},{"id":"C","label":"email","type":"string","pattern":""},{"id":"D","label" :"nsid","type":"number","pattern":"#0.###############"},{"id":"E","label":"theme","type":"string","pattern":""}],"rows":[{"c":[{"v":"mo"},{"v": "Mohammad Taheri"},{"v":"[email protected]"},{"v":"2929292.0","f":"2929292"},{"v":"blanc"}]}]}}'



$json = '{"version":"0.6","reqId":"requestIDnumber","status":"ok","sig":"65724392","table":{"cols":[{"id":"A","label":"slug","type":"string", "pattern":""},{"id":"B","label":"name","type":"string","pattern":""},{"id":"C","label":"email","type":"string","pattern":""},{"id":"D","label" :"nsid","type":"number","pattern":"#0.###############"},{"id":"E","label":"theme","type":"string","pattern":""}],"rows":[{"c":[{"v":"mo"},{"v": "Mohammad Taheri"},{"v":"[email protected]"},{"v":"2929292.0","f":"2929292"},{"v":"blanc"}]}]}}';
$data = json_decode($json);
print_r($data->table->rows);

//output

Array ( [0] => stdClass Object ( [c] => Array ( [0] => stdClass Object ( [v] => mo ) [1] => stdClass Object ( [v] => Mohammad Taheri ) [2] => stdClass Object ( [v] => [email protected] ) [3] => stdClass Object ( [v] => 2929292.0 [f] => 2929292 ) [4] => stdClass Object ( [v] => blanc ) ) ) ) 

Answer 2

您是否尝试从响应 myData(...) 中删除回调函数？

Answer 3

$json = file_get_contents($jsonfile);
$data = json_decode($json);
print_r($data);

Answer 4

PEAR 包 Services_Json 能够使用不带引号的键解析 JSON。因此，剥离回调并使用 Services_Json 进行解析，我相信这会起作用。

http://mike.teczno.com/JSON/doc/