issue_comments: 544318343

This data as json

html_url issue_url id node_id user created_at updated_at author_association body reactions issue performed_via_github_app
https://github.com/simonw/datasette/issues/588#issuecomment-544318343 https://api.github.com/repos/simonw/datasette/issues/588 544318343 MDEyOklzc3VlQ29tbWVudDU0NDMxODM0Mw== 9599 2019-10-21T01:47:11Z 2019-10-21T01:47:11Z OWNER

I think I see what's gone wrong here. Here's your example re-indented: json { "databases": { "MYDB": { "tables": { "MYFIRSTTABLE": { "source": "Test", "source_url": "https://www.google.com", "queries": { "Query 1": { "sql": "select * from MYFIRSTTABLE", "title": "Query 1", "description": "This is the first query" } } }, "MYSECONDTABLE": { "source": "Test2", "source_url": "https://www.google.com", "queries": { "Query 2": { "sql": "select * from MYSECONDTABLE;", "title": "Query 2", "description": "This is the second query" } } } } } } }

The `"queries" section isn't supported at the table level - it only works at the database level. So that example should look like this:

json { "databases": { "MYDB": { "tables": { "MYFIRSTTABLE": { "source": "Test", "source_url": "https://www.google.com" }, "MYSECONDTABLE": { "source": "Test2", "source_url": "https://www.google.com" } }, "queries": { "Query 1": { "sql": "select * from MYFIRSTTABLE", "title": "Query 1", "description": "This is the first query" }, "Query 2": { "sql": "select * from MYSECONDTABLE;", "title": "Query 2", "description": "This is the second query" } } } } }

 
{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
 505512251