Comments (6)
After researching it seems that Binance blacklists the IP addresses of the Google servers that Google Sheets uses to make the request. No idea how it could be fixed.
from list.
I have the same issue, does anyone have a fix for this?
from list.
Same here... and have no idea on how to fix.
from list.
Same here
from list.
Happen to find this -
When Apps Script runs a script, the script is assigned to one of the Google Cloud nodes. This notes makes an outbound IP connection to fetch the data from Binance. When one node (ip address) is generating to much traffic on Binance it may get banned for a period of time. Luckily, Google has a large pool of IP addresses for Apps Script. Let's all treat these lovely APIs with RESPECT and don't hammer them to hard to avoid bans. If you write your own scripts, try using the Google Cache Service when possible.
source
Can we migrate to App Script with Google Cache Service? is it possible?
from list.
In Apps Script, go to Settings -> enable manifest "appscript.json"
Go back to your editor, you should see appscript.json in your files.
Open this manifest.
After runtimeVersion in the manifest, add this :
"urlFetchWhitelist": [ "https://api.binance.com/", "https://api1.binance.com/", "https://api2.binance.com/", "https://api3.binance.com/", "https://fapi.binance.com/", "https://dapi.binance.com/", "https://pro-api.coinmarketcap.com/v1/", "https://api.kraken.com/0/private/", "https://api.kucoin.com/api/v1/accounts/" ]
Remove kraken/kucoin if not needed
from list.
Related Issues (20)
- USD balance and bitfinex/Kraken HOT 1
- Request Bitmex HOT 2
- HitBTC request HOT 2
- Binance error -1022 HOT 2
- Kucoin API update HOT 4
- Binance API isn't pulling all rates HOT 8
- function coinmarketcap() Error 429 "Too many requests" HOT 3
- Missing File | Page 404 HOT 2
- ReferenceError: jsSHA is not defined HOT 1
- Coinmarketcap API change of endpoint URI + API Key HOT 2
- NUM! everywhere. [HELP] HOT 1
- BITFINEX "apikey: invalid"
- The number of rows in the range must be at least 1
- coinMarketCap api error HOT 4
- Binance Error 401 - fapi request HOT 2
- https://api.binance.com returned code 400. "msg":"Signature for this request is not valid."
- Kucoin API request fail (code 401) HOT 3
- Google Sheets no longer has Tools / Script editor function
- API Bitvavo
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from list.