接收到无效的JSON负载。“请求[0]”处的未知名称“请求”：找不到字段

Question

我的第一篇文章，与以下文章相关我如何在PHP中设置一个基本的过滤器使用谷歌床单api？

我已经实现了下面的代码，但收到了这条消息，我不确定原因是什么：

收到无效的JSON有效载荷。未知名称"请求"处的"请求[0]"：找不到字段。

$criteria = new \stdClass();
$criteria->{'2'} = array(
    'condition' => array(
        'type' => 'NUMBER_EQ',
        'values' => array(
            'userEnteredValue' => '5'
        )
    )
);

$requests = [
    new Google_Service_Sheets_Request( array(
        'requests' => array(
            'setBasicFilter' => array(
                'filter' => array(
                    'range' => [
                        'sheetId'           => 0,
                        'startRowIndex'     => 4,
                        'endRowIndex'       => 20,
                        'startColumnIndex'  => 0,
                        'endColumnIndex'    => 11
                    ],
                    'criteria' => $criteria
                ),
            ),
        'includeSpreadsheetInResponse'  => true,
        'responseIncludeGridData'       => true
        )
    )
  )
];
  
$requestBody = new Google_Service_Sheets_BatchUpdateSpreadsheetRequest(array('requests' => $requests));
$response = $sheets->spreadsheets->batchUpdate($spreadsheetId, $requestBody);

Answer 1

• 请包含'userEnteredValue'=

当上述各点反映到脚本中时，它将变成如下所示。

$criteria = new \stdClass();
$criteria->{'2'} = array(
    'condition' => array(
        'type' => 'NUMBER_EQ',
        'values' => [array('userEnteredValue' => '5')]
    )
);
$requests = [
    new Google_Service_Sheets_Request( array(
            'setBasicFilter' => array(
                'filter' => array(
                    'range' => [
                        'sheetId'           => 0,
                        'startRowIndex'     => 4,
                        'endRowIndex'       => 20,
                        'startColumnIndex'  => 0,
                        'endColumnIndex'    => 11
                    ],
                    'criteria' => $criteria
                )
            )
        )
    )
];
$requestBody = new Google_Service_Sheets_BatchUpdateSpreadsheetRequest(array(
    'requests' => $requests,
    'includeSpreadsheetInResponse' => true,
    'responseIncludeGridData' => true
));
$response = $sheets->spreadsheets->batchUpdate($spreadsheetId, $requestBody);

• 在这种情况下，$criteria-

• 方法：spreadsheets.batch更新
• SetBasicFilterRequest