{"id":36107,"date":"2025-10-20T15:27:05","date_gmt":"2025-10-20T13:27:05","guid":{"rendered":"https:\/\/www.graviton.at\/letterswaplibrary\/datasets-into-managed-apis-self-promotion\/"},"modified":"2025-10-20T15:27:05","modified_gmt":"2025-10-20T13:27:05","slug":"datasets-into-managed-apis-self-promotion","status":"publish","type":"post","link":"https:\/\/www.graviton.at\/letterswaplibrary\/datasets-into-managed-apis-self-promotion\/","title":{"rendered":"Datasets Into Managed APIs [self-promotion]"},"content":{"rendered":"<p><!-- SC_OFF --><\/p>\n<div class=\"md\">\n<p>Hi datasets!<\/p>\n<p>We have been working on <a href=\"https:\/\/tapintodata.com\/\">https:\/\/tapintodata.com\/<\/a>, which lets you turn raw data files into managed, production-ready APIs in seconds. You upload your data, shape it with SQL transformations as needed, and then expose it via documented, secured endpoints.<\/p>\n<p>We originally built it when we needed an API from the Scottish Energy Performance Certificate dataset, which is shared as a zip of 18 CSV files totalling 7.17 GB, which you can now access freely here: <a href=\"https:\/\/epcdata.scot\/\">https:\/\/epcdata.scot\/<\/a><\/p>\n<p>It currently supports CSV, JSONL (optionally gzipped), JSON (array), Parquet, XLSX &amp; ODS file formats for files of any size. The SQL transformations allow you to join across datasets, transform, aggregate and even geospatial indexing via H3.<\/p>\n<p>It\u2019s free to sign up with no credit card required and has generous free tier (1 GB or storage and 500 requests\/month). We are still early and are looking for users that can help shape the product or any datasets you require as APIs that we can generate for you!<\/p>\n<\/div>\n<p><!-- SC_ON -->   submitted by   <a href=\"https:\/\/www.reddit.com\/user\/hedgehogsinus\"> \/u\/hedgehogsinus <\/a> <br \/> <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1obhqvn\/datasets_into_managed_apis_selfpromotion\/\">[link]<\/a><\/span>   <span><a href=\"https:\/\/www.reddit.com\/r\/datasets\/comments\/1obhqvn\/datasets_into_managed_apis_selfpromotion\/\">[comments]<\/a><\/span><\/p><div class='watch-action'><div class='watch-position align-right'><div class='action-like'><a class='lbg-style1 like-36107 jlk' href='javascript:void(0)' data-task='like' data-post_id='36107' data-nonce='65e0e39b87' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.graviton.at\/letterswaplibrary\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-36107 lc'>0<\/span><\/a><\/div><\/div> <div class='status-36107 status align-right'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Hi datasets! We have been working on https:\/\/tapintodata.com\/, which lets you turn raw data files into managed,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[85],"tags":[],"class_list":["post-36107","post","type-post","status-publish","format-standard","hentry","category-datatards","wpcat-85-id"],"_links":{"self":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/36107","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/comments?post=36107"}],"version-history":[{"count":0,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/posts\/36107\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/media?parent=36107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/categories?post=36107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.graviton.at\/letterswaplibrary\/wp-json\/wp\/v2\/tags?post=36107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}