How to Sync Joplin Notes with a Custom Dashboard Using SQL Server?

Hello

I am working on a side project where I want to sync selected Joplin notes with a custom web dashboard that displays key tasks and tags. For storage & querying, I am using Microsoft SQL Server. :upside_down_face:

I have written a small script that extracts data from the resources & notes folders via the Joplin API and pushes it to a SQL table. However; I am running into challenges with keeping the sync reliable and filtering out deleted / encrypted notes efficiently. :thinking:

The main goal is to create a live dashboard (maybe in Power BI or a Flask app) for weekly review meetings. But the problem is; sometimes note updates don’t reflect in the database in real time, and I’m not sure if the issue is with the webhook I am using / a delay in Joplin’s data exposure. Has anyone tried a similar setup using Microsoft SQL Server or other relational databases?

Also; I am documenting this as part of a broader guide I am preparing on what is Microsoft SQL Server, for non-tech users using Joplin in small teams. Any thoughts or guidance on optimizing the sync pipeline, or even contributing to a plugin idea, would be appreciated! :slightly_smiling_face:

Thank you !!

1 Like

What do you do to check for updates?