如何从Google Ads API修复无效的JSON有效负载错误

Question

我试图将一个报告从Google Ads API拉到Google sheets中，但我无法让API将我的查询识别为查询

    function basicReport() {
  var query = {
    "query" : "SELECT campaign.name, campaign.status FROM campaign ORDER BY campaign.id"
  };
  
  var body = JSON.stringify(query);
  
  var head = {
    'Developer-token' : "<Dev token>",
    'login-customer-id' : <Manager ID>,
    'Authorization' : "Bearer <Auth token>",
  };

var options = {
  'method' : 'POST',
  'content-type': 'application/json',
  'headers' : head,
  'payload' : body,
  'muteHttpExceptions' : true
};
  
var response = UrlFetchApp.fetch('https://googleads.googleapis.com/v4/customers/<Customer ID>/googleAds:searchStream', options);
  var json = response.getContentText();
  var data = JSON.parse(json);

"error": {
    "code": 400,
    "message": "Invalid JSON payload received. Unknown name \"{\"query\":\"SELECT campaign.name, campaign.status FROM campaign ORDER BY campaign.id\"}\": Cannot bind query parameter. Field '{\"query\":\"SELECT campaign' could not be found in request message.",
    "status": "INVALID_ARGUMENT",
    "details": [
      {
        "@type": "type.googleapis.com/google.rpc.BadRequest",
        "fieldViolations": [
          {
            "description": "Invalid JSON payload received. Unknown name \"{\"query\":\"SELECT campaign.name, campaign.status FROM campaign ORDER BY campaign.id\"}\": Cannot bind query parameter. Field '{\"query\":\"SELECT campaign' could not be found in request message."

Answer 1

万一还有人在找这个-我确实解决了。

当设置在标题中时，Content-Type有一个破折号，当设置在选项中时，contentType没有。

function basicReport() {
     var query = {
        "query" : "SELECT campaign.name, campaign.status FROM campaign ORDER BY campaign.id"
     };
  
     var body = JSON.stringify(query);
  
     var head = {
        'developer-token' : "<Dev token>",
        'login-customer-id' : "<Manager ID>",
        'authorization' : "Bearer <Auth token>",
        'accept' : 'application/json'
        'Content-Type': 'application/json',
     };

    var options = {
        'method' : 'POST',
        'headers' : head,
        'payload' : body,
        'muteHttpExceptions' : true
    };
  
    var response = UrlFetchApp.fetch('https://googleads.googleapis.com/v4/customers/<Customer ID>/googleAds:searchStream', options);
    var json = response.getContentText();
    var data = JSON.parse(json);

    Logger.log(data);