Quote:
Originally Posted by PeterT
I believe you also need to select based on contenttype = 6.
ContentURL appears to be the original URL
ContentID is the name of the folder within .kobo/articles
|
Thanks for the tip! I was initially thrown because it seemed like a lot of rows had ContentId that did not match any of the folders in /articles, but then I realized I need to filter to articles I had still saved on my Kobo and not archived by including isDownloaded.
For anyone else wanting to do the same thing, this query run against KoboReader.sqlite will return metadata on any Pocket articles you have downloaded on your Kobo:
"SELECT ContentID, ContentURL, Title, Description, DateAdded, WordCount from content WHERE MimeType='application/x-kobo-html+pocket' AND ContentType = 6 AND isDownloaded = 'true';