MobileRead Forums - View Single Post

MoreEbooks · 06-13-2022, 01:30 PM

Ah, that gets me almost there - I can get a JSON file of all the annotations. However, it looks to be a dump of just the 'annotations' table in the database and lacks the actual book titles that are over in the 'books' table. The 'title' field in a 'bookmark' annotation is not the book title, but the selected text. Maybe this is a bug. I see that if I request the output in markdown format, the book title is included.

For now, I will write a short lua program to query the database directly doing the JOIN between the two tables.

06-13-2022, 01:30 PM	#3
MoreEbooks Member Posts: 11 Karma: 10 Join Date: Jun 2022 Device: Kindle 10th gen	Ah, that gets me almost there - I can get a JSON file of all the annotations. However, it looks to be a dump of just the 'annotations' table in the database and lacks the actual book titles that are over in the 'books' table. The 'title' field in a 'bookmark' annotation is not the book title, but the selected text. Maybe this is a bug. I see that if I request the output in markdown format, the book title is included. For now, I will write a short lua program to query the database directly doing the JOIN between the two tables. Last edited by MoreEbooks; 06-13-2022 at 01:33 PM.