Google App Script external API return error 406

Question

I'm trying to fetch a URL using optional advanced parameters in GAS:

function myFunction() {
  var options = {};
  options = {
    headers: {
      Authorization: 'Bearer ?????',
      'Content-Type': 'application/json',
    },
  };
  UrlFetchApp.fetch(<url>, options);
}

I always get:

Request failed for returned code 406 (line 52, file "Project").

HTTPResponse:

SyntaxError: Empty JSON string

I did the same fetching in Excel Power Query:

let
    Source = Json.Document(Web.Contents(<URL>, [Headers=[Authorization="Bearer 
?????????????", ContentType="application/json"]])),

And it works, it works also using Postman...

What's the problem with GAS? Please help me! Thanks in advance to everybody. Andrea

TheMaster · Accepted Answer · 2023-05-26 14:39:29Z

3

406 error is because content negotiation between server and client has failed. While setting Content-Type, It's possible that the accepted return content is also advertised as 'application/json' by Power query and Postman, but UrlFetchApp doesn't do the same. Adding a explicit Accept header solves this:

Accept: 'application/json'

References:

edited May 26, 2023 at 14:39

answered Oct 3, 2018 at 16:02

TheMaster

51.6k7 gold badges76 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dani Cuesta Over a year ago

Brilliant, thank you. My error was in another software but this solved it!

Collectives™ on Stack Overflow

Google App Script external API return error 406

1 Answer 1

References:

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

References:

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related