Google Fusion表更新SQL查询返回400 ok错误

Question

插入工作正常，但我得到错误与更新和删除代码。

$http({
  method: 'POST',
  url: "https://www.googleapis.com/fusiontables/v1/query?sql = UPDATE 1SubDA6g3Mz15DIHWpdec4iQ7sCV13aF7B94tJskK SET id = '2001' WHERE ROWID = "+pid+"&access_token="+$scope.Atoken
})

错误:

domain: "global",
reason: "required",
message: "Required parameter: sql", 
locationType: "parameter",
location: "sql"

Answer 1

去掉等号周围的空格:"sql="而不是"sql="

Answer 2

我终于找到了解决办法。

解决方案:

$http({
method: "POST",
url: "https://www.googleapis.com/fusiontables/v2/query?
access_token="+$routeParams.token,
params: { 
         sql: "UPDATE 1R0f3qRr1Ew-V6rDcmZzrqEXxbCOit SET cId='"+answer.id+"',cName='"+answer.name+"',pass='"+answer.pass+"' WHERE ROWID ='"+detail.rId+"'"    
}
})