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’s my code: Thank you for any help! Answer How about this modification?
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 values can not be rounded, for
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 hand, thanks a lot! Answer index is the index of the
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 google
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/marketdata/AAPL/quotes?apikey=” I’m using a Google Script to read the data from the API, do some calculations, and then write the data to a
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 excluded dates is hard coded, but these dates should be generated dynamically. Although I have
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 and there are no errors,
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/AKfycbxkG5hM6MMswwHdzWSJKwutMYsOZRT3zjC7jFti0sDvJ47bWB4BTsHPhvbyEVGSsSc5/exec’ from origin ” has been blocked by CORS policy: No ‘Access-Control-Allow-Origin’ header is
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, Logger.log(result) returns the array I needed, but