All Questions
7 questions
0
votes
1
answer
176
views
How to filter/sum array data by year/quarter?
Trying to consolidate dividend data by year and quarter from an object from this URL.
I was able to retrieve dividend date and dividend amount from the object and convert the dividend date to YYYY Q ...
- 281
0
votes
0
answers
68
views
Struggling to work with 1d array from API to spreadsheet [duplicate]
Code that I'm working with:
function BTC_1hour() {
var url = '/api/v1/market/candles?type=1min&symbol=BTC-USDT&startAt=1566703297';
var response = UrlFetchApp.fetch(url); // store API ...
- 73
0
votes
2
answers
178
views
Why does the function fail after UrlFetchApp.fetchAll () is executed?
After executing the useFetchAll function, I pass the response value to the stringform function, and I get an error
TypeError: A.forEach is not a function
In the example, I made the variable asdf and ...
- 101
0
votes
0
answers
357
views
Process binary data retrieved with UrlFetchApp in Google Apps Script
I am trying to process binary data retrieved from a Davis weather station via their web server.
I do this using a script attached to a Google Apps Spreadsheet.
var lResponse = UrlFetchApp.fetch(...
- 171
0
votes
1
answer
156
views
Passing arrays as URL parameter JavaScript/GAS
I have two functions.
One queries for project id, project name, and project status and saves them up in an array.This works fine.
function get_All_Projects() {
var options = {
method: "...
- 437
0
votes
2
answers
2k
views
How do I Save JSON API response in different javascript arrays
Working on API response that gets user data from 10K ft system via API. The response looks like:
"data": [{
"id": 30000,
"display_name": "John Doe",
"email": "[email protected]",
},
...
- 437
0
votes
1
answer
89
views
GAS/ Javascript: Save API as a response perform calculations on them and if they meet condition send emails
I am working on a personal project to try and stretch limits of a 10K ft project management systems API and being new to GAS or Javascript I will appreciate help on the code I am trying to do. The API ...
- 437