SteemSQL Wrapper API

Recently I launched SteemSQL Wrapper to help non-tech users creating analyses from Steemit data and I got really the great feedback. Someone even created a French video tutorial. Thanks to all (and especially to @roxane for the tutorial)! It really gives the great motivation to continue the work.

But the help to non-tech users is only one reason why I created SteemSQL Wrapper. The project idea is much more — I want to simplify the life of every who want the access to Steemit data.

And today I present SteemSQL Wrapper API.

bg source: unsplash

How to use

Just send a POST request to sql.steemhelpers.com/api. In the body your request should contain a key query, a value should be your SQL. Note: you do not need to encode your request in JSON.

A response will contain headers with all titles of columns, rows with all data which was returned by SteemSQL, and error — if all is correct then it will be null but if SteemSQL Wrapper gets an error then it will contain a description and headers/rows will be empty.

cURL example

curl --data-urlencode "query=SELECT COUNT(*) as accounts FROM TxAccountCreates" https://sql.steemhelpers.com/api

A response will be

{"headers": ["accounts"], "rows": [{"accounts": 492751}], "error": null}

My commits

Commit #1
Commit #2
Commit #3