TheSession-data icon indicating copy to clipboard operation
TheSession-data copied to clipboard

Vercel app JSON query returning empty record.

Open abalter opened this issue 4 years ago • 1 comments

This may not be the correct place to post this.

I navigated here:

https://thesession.vercel.app/thesession?sql=select+*+from+tunes+where+name+like+%22%25wise+maid%25%22%0D%0A

The query in the box shows

select * from tunes where name like "%wise maid%"

and the page displays results. If I click on the "This data as JSON" button, I get an empty record. This is the generated HTML REST query:

https://thesession.vercel.app/thesession.csv?sql=select%20*%20from%20tunes%20where%20name%20like%20%22%wise%20maid%%22&_size=max

I created a little app for myself a couple of months ago and it was working then, but stopped sometime in the last month.

Note: CSV queries also seem to come back empty.

https://thesession.vercel.app/thesession?sql=select+*+from+tunes+where+name+like+%22%25wise+maid%25%22

abalter avatar Aug 14 '21 21:08 abalter

Hmm ...sorry about that! Sounds like it might be an issue with the datasette tool I'm using to generate that view of the data.

I've filed an issue over here: https://github.com/simonw/datasette/issues/1437

adactio avatar Aug 17 '21 08:08 adactio