home / github / issues

Menu
  • Search all tables
  • GraphQL API

issues: 328172521

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
328172521 MDU6SXNzdWUzMjgxNzI1MjE= 303 Support table names ending with .json or .csv 9599 closed 0     4 2018-05-31T14:53:23Z 2018-06-15T06:55:50Z 2018-06-15T06:55:50Z OWNER  

This is needed for #266 - if a table name ends with .json or .csv right now our URL pattern matching will do the wrong thing.

We should be smarter about this. This does mean we will have some URLs that look like this:

http://localhost:8001/dbname/weird.json - returning HTML, not JSON
http://localhost:8001/dbname/weird.json.json - returning JSON
http://localhost:8001/dbname/weird.json.csv - returning CSV
107914493 issue    
{
    "url": "https://api.github.com/repos/simonw/datasette/issues/303/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
  completed

Links from other tables

  • 1 row from issues_id in issues_labels
  • 4 rows from issue in issue_comments
Powered by Datasette · Queries took 1.017ms · About: github-to-sqlite