Morph-proxy

Morph-proxy is a simple proxy for the Morph.io scraper API.

It allows you to query data from Morph.io without revealing your API key.

Both free-form SQL and canned queries are supported.

It can be deployed to Heroku with one click:

If you specify a QUERY environment variable in the Heroku setup, only this query will be available, regardless of what is sent in the query
URL parameter.

Once running, you can replace api.morph.io with your Heroku app’s URL and issue queries without the need to specify your API key. If
defined, only the scrapers identified by the OWNER and/or SCRAPER environment variables can be accessed regardless of the path passed
to the proxy, which should still be of the form /{owner}/{scraper}/data.{format}.

Accessing the root path (/) of the running proxy will display a test page, unless the LANDING_PAGE environment variable is set to false, in which case it will redirect to this project’s GitHub page.

If you specify a FORMAT environment variable, only this format will be returned by the proxy, ignoring the extension given in the query URL.

If you specify a CALLBACK environment variable, this callback will always be called, regardless of the callback parameter used in the query URL.

Canned queries

To define a canned query (which you can think of as a pseudo stored-procedure), create an environment variable in the Heroku dashboard called QUERYnn (where nn is any number) containing your SQL query, using !1 to !99 as replaceable parameters.

In your front-end application, set the query URL parameter to the name of the query you wish to run (e.g. QUERY3) and !1 etc as needed for the replaceable parameter values.

Limited sanitisation of the query parameters is performed, as all morph.io database access via the API is read-only.