extend JSON to push to endpoint; add htsql endpoint