Get playlist tracks from a shell script

[thomas-mc-work]

Hello!

Is it possible to get the tracks of the current playlist from a shell script? Specifically it's the file path of the playlist items that I need.

[jonaski]

Yes you can use sqlite and query the playlist_items table

[thomas-mc-work]

Thank you for that hint, @jonaski !

Follow up question: The table playlist_items is referencing the items by their id (library_id). What I need is the file path of each song. This data is in the songs table. But it has no id column. There is another table songs_fts_content which has an id column (docid) – but no file path. Can you help me with this issue?

[thomas-mc-work]

Just found out that SQlite has an embedded id field in every table named rowid.