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&…
Tag: google-apps-script
How to set number format for each value from single column in Google Sheets depends from value?
I got an array in a single column. I need to reduce fractional part for big numbers like >= 1, keep 1 symbol of fractional part for numbers <1 and >=0,1, keep 2 symbols of fractional part for numbers <0,1 and >=0,01, keep 3 symbols of fractional part for numbers <0,01 and >=0,001. All val…
getConnectedNodes direction parameter
I have a small issue with the parameter direction of the function getConnectedNodes() based on the Vis.js documentation (search for “getConnectedNodes” in the link) Any idea to get the direction of the edges using the parameter (i don’t know how to)? JSON Example Here part of the code Before…
Vis.js JSON data to Google Spreadsheets Range
I have a little issue trying to retrieve the data from the Vis.js (here a example!) nodes position and edges related to the id, to a Google SpreadSheets range. Here’s the code (HTML and GAS) I think the problem is here, in the HTML Side 🡇 Recap: At this point, i have problems to read the data from the g…
Passing variables between functions by reference in Google Apps Script
I’m really new to Google Apps Script and just started a few days ago to learn it. I have previous knowledge in C++ but not more. I tried to write my first script doing some action on a google sheet. Here is the code I created so far: I realized that the value of LoopCounter is not changed, after being
Trying to pull stock quote info from TDAmeritrade with Google Script with API needing authentication
I’m using an API from TD Ameritrade to pull stock ticker information. The script needs authentication to pull real time data. The CURL command is as follows: curl -X GET –header “Authorization: ” –header “Authorization: Bearer ” “https://api.tdameritrade.com/v1/…
Google Webapp: How to dynamically pass array values to jquery script
I’ve been working on an answer to StackOverflow question Datepicker: Disabling dates in the data. I’ve successfully developed a small webapp that excludes specific dates from a jQuery Datepicker using the beforeShowDay option and an array of hardcoded dates. Problem At present, the array of exclud…
How do I fetch and parse JSON data to Google Sheets Script?
EDIT*** Modified the question now that I have a proper source… I am trying to copy a communication log to Google Sheets and don’t know enough about scripting ( or JSON for that matter) to pull this off. I just want to the spreadsheet to emulate/copy the entire log that is available. The script run…
Google App Script Web App GET and POST request blocked by CORS policy
I created a Google Web script app that adds a user’s name and email to a spreadsheet. This works fine when accessing the web page from directly in the browser, but both GET and POST requests from a website returns the error “Access to fetch at ‘https://script.google.com/macros/s/AKfycbxkG5hM…
google.script.run.withSuccessHandler does not return value
it is getting me crazy, the code was working yesterday, but not anymore. I tried to check all syntax again, but the issue still persists. this server-side request from Google Sheets, shows value on server side (Logger.log()), but returns null in client side. this is my server side code as well: for recap, Log…