You are viewing a single comment's thread from:

RE: December 2019 - Monthly Steem Report πŸ“πŸ“Š

in LeoFinance β€’ 4 years ago

I used this :)

DECLARE @json NVARCHAR(MAX)
SET @json = N'JSON HERE'

SELECT * FROM
OPENJSON ( @json )
WITH (
Timestamp varchar(200) '$.timestamp',
Curator varchar(200) '$.curator',
Author varchar(200) '$.author',
Amount int '$.int_amount',
Precision int '$.precision'
)

Then a little fiddling in excel.

Thanks for the link and encouragement :)

Sort: Β 

I am glad you got it to work :) Have you seen that you can also get ["curation_reward", "author_reward", "staking_reward", "mining_reward", "comment_benefactor_reward"]. That may be interesting if for example you have any miners.