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 :)
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit