I can get a case like this: This returns I would like to update Document_No__c to myString I was expecting to be able to change this to a patch and add the payload like this: However this is returning the error: Answer I needed to point to the right end point, as well as use @Tanaike’s change to the pay…
Tag: urlfetch
UrlFetchApp Variable Errors
I’m trying to make a proxy with the UrlFetchApp Google Scripts API. However, with a query string of ?url=”https://google.com”, it gives me this error: But when I substitute param in my code below for https://google.com, the exact value of param, it works perfectly fine for some reason. Here&…
How to add an API Key to a UrlFetchApp in Google Apps Scripts
Solved Thanks to Dimu Designs for helping out. The following works. Problem I’m trying to use Google App Scripts within Google Sheets to call the external Fortnite API to request player data. The bit I’m stuck on how to add an API Key as a header when passing the request. This is what I’ve b…
How can I see the full server response for this API error message in Google Scripts?
I’m getting an error response from the API that I’m using, but Google scripts seems to truncate the message. How can I see the full message in Google scripts? This is the message: Request failed for https://api.myintervals.com/task/ returned code 400. Truncated server response: {“personid…
Content Service for Google Apps Script returning HTML instead of JSON
Trying out the Content Service API and the example is returning HTML when it should be returning JSON, what am I doing wrong? https://developers.google.com/apps-script/guides/content GAS from another file trying to make the request: Answer Your usage of ContentService is correct, the code works exactly as is.…