How do you import to SQL? What's the problem in iterating through JSON and adding fields that you need? Unless you are not writing a code yourself and using some tool that does it for you.
P.S. I also have some questions then
In global JSON
https://whattomine.com/coins.json, what hashrate is used for
estimated_rewards/estimated_rewards24 (I assume these are based on current/24 diff)?
And also why changing
hr param in API call for particular coin is not changing
estimated_rewards accordingly?
E.g. for 10 MH/s it's 636 coins, but for 1000 MH/s it's 62102? 2.35% seems to be a huge rounding error.
I hope
estimated_rewards there is based on 24h average diff? Inconsistent field names
P.P.S.
?eth=true&factor[eth_hr]=50 works with global API, default hr must be from some presets... At least write an API docs with all the available params
or using it is trial and error.
At the moment I am using PowerShell to grab the JSON, works perfect. Where I run in to trouble is the SQL query to import the JSON file. Coins is the first property name, good, but there is no Coin Name property (the coin names are just listed), so the query blows up. Like I said I am a noob at this and possibly I need to manipulate the JSON and add the coin name property, but I am not sure how.
Below is an example of the JSON, see how the coin name is not under a property?
{
"coins": {
"Cannabiscoin": {
"id": 188,
"tag": "CANN",
"algorithm": "X11",
"block_time": "44.0",
"block_reward": 70,
"block_reward24": 70,
"last_block": 3030623,
"difficulty": 159943.13453935,
"difficulty24": 160679.297308647,
"nethash": 15612512092414,
"exchange_rate": 0.00000265,
"exchange_rate24": 0.00000240881924198251,
"exchange_rate_vol": 1.78501334098998,
"exchange_rate_curr": "BTC",
"market_cap": "$2,845,033.74",
"estimated_rewards": "298.68986",
"estimated_rewards24": "297.32436",
"btc_revenue": "0.00079153",
"btc_revenue24": "0.00078791",
"profitability": 115,
"profitability24": 114,
"lagging": false,
"timestamp": 1531882963
}
