Error Message: Incompatibility in Parameter Type Detected in UrlFetchApp Payload

Question

Error Message: Incompatibility in Parameter Type Detected in UrlFetchApp Payload

When attempting to make a POST request using Google Apps Script, I encountered the error message: 'Passed parameter type mismatch: 'fields''.

I attempted to resolve this issue by adding JSON.stringify(requestBody) to the payload, however, this solution did not work. What could be causing this problem?

 var fields = ["id","name","group_name"]

  var requestBody = {
    "project_id": "3259344",
    "fields": fields,
    "limit": "30"
} 

  var options =
      {
           'method'  : 'POST',
           'headers' : {
           'User-Id' : email,
           'Authorization' : 'Bearer '+ apiKey
           }, 
          'payload' : requestBody
      };


var response = UrlFetchApp.fetch("https://api.test.com/v2/json/get/keywords", options);

javascript google-apps-script google-sheets payload urlfetch

Answer 1

Answer №1

Uncertain about the precise specifications of the API you wish to utilize. Considering the error message from your inquiry, how do the following 3 adjustment patterns sound?

Pattern 1:

Adjusted script:

var fields = ["id","name","group_name"];
var requestBody = {
  "project_id": "3259344",
  "fields": fields,
  "limit": "30"
};
var options = {
  'method'  : 'POST',
  'headers' : {
    'User-Id' : email,
    'Authorization' : 'Bearer ' + apiKey
  }, 
  'payload' : JSON.stringify(requestBody),  // Adjusted
  'contentType': 'application/json'  // Added
};
var response = UrlFetchApp.fetch("https://api.test.com/v2/json/get/keywords", options);

Pattern 2:

Adjusted script:

var fields = "id,name,group_name";  // Adjusted
var requestBody = {
  "project_id": "3259344",
  "fields": fields,
  "limit": "30"
};
var options = {
  'method'  : 'POST',
  'headers' : {
    'User-Id' : email,
    'Authorization' : 'Bearer ' + apiKey
  }, 
  'payload' : JSON.stringify(requestBody),  // Adjusted
  'contentType': 'application/json'  // Added
};
var response = UrlFetchApp.fetch("https://api.test.com/v2/json/get/keywords", options);

Pattern 3:

Adjusted script:

var fields = "id,name,group_name";  // Adjusted
var requestBody = {
  "project_id": "3259344",
  "fields": fields,
  "limit": "30"
};
var options = {
  'method'  : 'POST',
  'headers' : {
    'User-Id' : email,
    'Authorization' : 'Bearer ' + apiKey
  }, 
  'payload' : requestBody
};
var response = UrlFetchApp.fetch("https://api.test.com/v2/json/get/keywords", options);

Resource:

Class UrlFetchApp

Answer 2

Uncertain about the precise specifications of the API you wish to utilize. Considering the error message from your inquiry, how do the following 3 adjustment patterns sound?

Pattern 1:

Adjusted script:

var fields = ["id","name","group_name"];
var requestBody = {
  "project_id": "3259344",
  "fields": fields,
  "limit": "30"
};
var options = {
  'method'  : 'POST',
  'headers' : {
    'User-Id' : email,
    'Authorization' : 'Bearer ' + apiKey
  }, 
  'payload' : JSON.stringify(requestBody),  // Adjusted
  'contentType': 'application/json'  // Added
};
var response = UrlFetchApp.fetch("https://api.test.com/v2/json/get/keywords", options);

Pattern 2:

Adjusted script:

var fields = "id,name,group_name";  // Adjusted
var requestBody = {
  "project_id": "3259344",
  "fields": fields,
  "limit": "30"
};
var options = {
  'method'  : 'POST',
  'headers' : {
    'User-Id' : email,
    'Authorization' : 'Bearer ' + apiKey
  }, 
  'payload' : JSON.stringify(requestBody),  // Adjusted
  'contentType': 'application/json'  // Added
};
var response = UrlFetchApp.fetch("https://api.test.com/v2/json/get/keywords", options);

Pattern 3:

Adjusted script:

var fields = "id,name,group_name";  // Adjusted
var requestBody = {
  "project_id": "3259344",
  "fields": fields,
  "limit": "30"
};
var options = {
  'method'  : 'POST',
  'headers' : {
    'User-Id' : email,
    'Authorization' : 'Bearer ' + apiKey
  }, 
  'payload' : requestBody
};
var response = UrlFetchApp.fetch("https://api.test.com/v2/json/get/keywords", options);

Resource:

Class UrlFetchApp

Error Message: Incompatibility in Parameter Type Detected in UrlFetchApp Payload

Answer №1

Pattern 1:

Adjusted script:

Pattern 2:

Adjusted script:

Pattern 3:

Adjusted script:

Resource:

Similar questions

Looking to display a gif when a user clicks a button

Ways to navigate to a specific list-group-item using JavaScript

Tips for modifying javascript code to have popups appear as bPopup instead of in a separate popup window

Maintain a fixed element and enable the rest of the elements to scroll as the mobile browser address bar collapses while scrolling upwards

"Troubleshooting: Ajax File Uploader Plugin Not Functioning Properly

Implementing automatic redirection upon clicking using React without the need for manual clicking

Unlocking the Power of Global Props in AlpineJS: A Step-by-Step Guide

The phonegap-plugin-push does not successfully register

What could be causing the Firebase email verification to result in a 400 error?

Disabling eventListener upon the occurrence of another event is ineffective

Receiving a 401 error while attempting to make an axios get request with authentication headers

Access the JavaScript array within a click function by dynamically generating the array name

Are the functionalities of my code implemented with Node.js and callback functions comparable to Java Threads?

Refresh the view in AngularJS following a successful $http.get request

In JQuery, an empty string will be returned if it contains the dollar sign character

Switching user agents to access mobile websites

"Using axios and async/await in VUE.JS to perform multiple asynchronous GET

Managing a variety of PHP responses using AJAX

What could be causing my handle button to slide off the timeline towards the right?

Show the present category name within breadcrumbs (utilizing angularJS)