I am building a custom dashboard using Google Sheets
I am using a few nice add-ons for cryptocurrencies etc. for basic info like current BTC price etc.
I need to pull the latest Average Daily Earnings from the viabtc.com website
(BTC Avg. Daily Earnings 0.00002764 BTC/T (≈PPS 99.1%)
Any ideas where can I pull that info from?
I searched viabtc website API help section but it was not helpful.
Posted on their wechat group which is chinese heavy.... but no reply.
Any ideas?
Have you accessed the actual API? Seems like you need an account to get access to it. Once there you should have a number of requests you can make to pull data.
Yes, I have a working account in viabtc and further research on viabtc APIs are generally for trading/exchange related APIs but not pool and operational parameters. Last resort, maybe screen scrapping will do the trick
Yep, if the API doesn't provide you with what your require, it's going to be a tough one to crack. I'm not sure that many pool offer a lot of information on the inner workings.
If you have simple access to the page that the information is displayed on, you could indeed try scraping. Just be careful with that, as usually websites that are not too shitty, will see this as a bad thing and might potentially ban your IP address.
I personally have no experience with google sheet dashboards, but with some PHP, once you have the URL and know where, in the html code, the information is displayed, it's quite simple to dig down to the element and extract the value.
This is how I do it on my solar inverted which has no API, just some dumb webpages with the information displayed in html tables.