usesql / roadmap

Use SQL across your CSVs, Google Sheets, APIs, Airtables, and more!
https://www.usesql.com
1 stars 0 forks source link

JSON data source and documentation #16

Open dylanroy opened 3 years ago

dylanroy commented 3 years ago

💡 For general support requests and bug reports, please email support@usesql.com or check docs.usesql.com

Is your feature request related to a problem? Please describe. The ability to use a JSON data source is available in a limited way, but can be extended to fully support JSON APIs as a source, and should be documented appropriately

Example Query 1

select
  json_extract(value, '$.iso.code') as code,
  json_extract(value, '$.iso.number') as num,
  json_extract(value, '$.name') as name,
  json_extract(value, '$.units.major.name') as unit
from
  "https://example.com/api/currency/"