881 questions
0
votes
1
answer
99
views
API Handling on Google Apps Script is not using API key
I am a beginner, trying my hand at realtime API data handling for a small project.
I am trying to create an HTML page (for an iframe later) that gives me the realtime data for one specific metro stop ...
-1
votes
1
answer
116
views
Google Apps Script PUT API call [closed]
I am creating a small tool to help easily add tickets to Teamhub. For this, I am using Teamhub's own API. My issue arises when I actually run the API.
Documentation:
const url = 'https://api.teamhub....
0
votes
1
answer
124
views
Valid Zoom API endpoint not recognized
I'm trying to write a Google Apps Script (using the Oauth2 library) to upload content to a Zoom Room display playlist. I have a Zoom app created with the proper scopes authorized, and content is ...
1
vote
1
answer
167
views
How do I get the HTTP status code from UrlFetchApp.fetch() when it throws an error?
I am using Google Apps Script to fetch data from an external URL. When the request is successful, I can get the HTTP status code with HTTPResponse.getResponseCode. However, if the request fails with a ...
0
votes
0
answers
96
views
Error getting data with fetch in web worker
I'm trying to get data in the order of bybit -> cloudflare worker -> google scripts. I got the value from bybit to the worker via API, but when I get the value from the worker via google scripts,...
1
vote
0
answers
164
views
DNS error when using URLfetchapp for a URL with "=" string / URL with potential Redirect issue
UPDATE
I discovered that the entire domain "https://www.mots.go.th" appears to give DNS error when using urlfetchapp, not just this specific page. Perhaps this is some sort of protection ...
-2
votes
1
answer
143
views
Submit Google Form via Google Apps Script giving 401 [closed]
I try to submit Google Form using Google Apps Script. I found this tutorial and follow the instructions properly. Below is the code with a sample of public link I've generated from the Google Form ...
0
votes
1
answer
238
views
cURL API call in Google App Script with Header & Body data
I'm a bit of a novice with Google App Script and looking for a bit of help making an API call. The data in my call is working fine when used in Postman.
Postman shows me the cURL call is as follows:
...
-1
votes
2
answers
134
views
Download file and paste col E3:F to sheet
I'm using this script to create new sheet every week
function getFile(fileURL) {
// see https://developers.google.com/apps-script/class_urlfetchapp
var response = UrlFetchApp.fetch("https://...
1
vote
1
answer
100
views
Copy certain cells over to another sheet when the script is running
I have the below script. It works perfectly.
This script runs a sales agreement for the sale of something.
When the sales advisor clicks the email icon and sends this to the customer. I would like ...
0
votes
1
answer
121
views
A CoinMarketCap App-Script modification to read multiple tickers in google sheets
So, I have this script from CoinMarketCap to lookup crypto prices. I want to modify this script where I can apply it to a cell and then drag and drop it down the column to read the ticker symbol in ...
0
votes
1
answer
337
views
How to fetch google form response with required email in Google App Script
As the title, I got some problem when trying to automate response google forms type collect submitter data but I am not the form's owner
Here is the form:
Sample Form
Below is my scratch code in GAS:
...
1
vote
0
answers
186
views
How to fetch JSON of files from OneDrive public folder using Google Apps Script
I have a public folder stored in my personal OneDrive account, which contains several files. The link to this folder is in the form: https://1drv.ms/f/c/{driveId}/{...
0
votes
2
answers
138
views
Problem submitting Bing API search request from apps script
I'm implementing the bing api search in google apps script.
I've tried this approach:
var url =https://api.bing.microsoft.com/v7.0/search?key=[appkey]&q=Bart's%20Heating%20%26%20Air
var response = ...
0
votes
0
answers
85
views
Google Apps Script unexpected error in UrlFetchApp.fetch method for HEIC image
I'm getting a strange error while trying to download an image from an URL through Google Apps Script.
The script is a simple GET of an image to download it. It works perfectly for .jpg and .png images,...