While I was working on various analyses for Steemit, I started hating the Markdown tables. Why? Because if you want to include tables in your analysis then you need to manually copy/paste and format all rows. And if you have many rows then you also will start to hate this process.
But it is easy to automate.
And now SteemSQL Wrapper gives a possibility to you convert any table with Steemit data to Markdown with one click. You need to write a SQL query, get results, and then you will see the Export button. If you will click the button for exporting to Markdown then SteemSQL Wrapper will open a new window (or a tab, it depends on your browser settings) with a clear Markdown table. The export to Excel right now is not available but I will add it in the near future.
Important note: sometimes your browser can block the opening of a window, in this case, you should allow it (see the below GIF) and click the export button again.
In the GIF I used the next query:
SELECT TOP 30 author, pending_payout_value, net_votes, children, title, url
FROM Comments
WHERE
parent_author='' AND
created >= '2017/12/12' AND
created < '2017/12/19' AND
category='utopian-io'
ORDER BY pending_payout_value DESC
Posted on Utopian.io - Rewarding Open Source Contributors
Good to see export to markdown that is something people will want to use often and will help in making posts more informative.
Beside mark down it would maybe also be nice to add a direct link option, that links to just only the result/raw data, without styling. this way people can use the data as a web-api.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks! API already is created — it returns JSON with all headers and rows :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This post has received a 0.24 % upvote from @drotto thanks to: @banjo.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for the contribution. It has been approved.
You can contact us on Discord.
[utopian-moderator]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey @emptyname I am @utopian-io. I have just upvoted you!
Achievements
Community-Driven Witness!
I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!
Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit