apps-script-oauth1 | An OAuth1 library for Google Apps Script | OAuth library

Credits to @TheMaster

The errors were in not including contentType:"application/json" and JSON.stringify(payload) . Those need to be included.

Scraping a website for content is considered unethical. However the site you've referenced leverages a publicly available rest api called the XBox One API.

Sign up for the service to get access to the api. Then you can poll the requisite endpoints using a time-based trigger (for more info on time-based triggers check the apps script documentation).

Simple triggers like onEdit won't work in this scenario. According to the documentation,

They cannot access services that require authorization. For example, a simple trigger cannot send an email because the Gmail service requires authorization, but a simple trigger can translate a phrase with the Language service, which is anonymous.

You must use an installable trigger. https://developers.google.com/apps-script/guides/triggers/installable

Create the fuction that you need to execute on edit, go Edit -> Current project's triggers, and select 'From spreadsheet'-> 'On edit.

You are probably using Logger.log for checking results of code execution.

As noted in documentation:

The method Logger.log expects a string value, but if you pass in an object or array it will do its best to convert that into a string.

So response in this case response=response.getContentText() will give you String with expected behaviour when used in Logger.log, but in case response=JSON.parse(response) will give Object, that will have output in Logger.log in format [key1=val1, key2=val2, ..].

You can get used to it, or you can use convertion of your object to string before logging it:

Logger.log(JSON.stringify(response))

I needed to add the following line the first time I execute makeRequest: