Export Dataview query results to CSV from command line

[erikjandevries]

Things I have tried

I’ve managed to export a CSV from Dataview using the GUI as described in the following:

Export Dataview tables to CSV with DataviewJS

Continuing the discussion from Dataview - Exporting Table as CSV and based on my answer to another post here, I’ve come up with an imperfect way to save dataview tables as csv fies, if that’s something you’d find useful. This code does the following: Grab the data you want Select the columns you want in the table Export the table as a CSV file Example Note: dataviewjs must be appended for code block // ----- Gather data and specify table columns ----- // Grab all relevant notes/pages let p…

What I’m trying to do

I would like to do something similar from the command line, so I can automate the export of a CSV in a continuous integration pipeline.

I am using Git source control for my vault and I would like to set up a CI/CD pipeline that triggers on pushed commits (to a specific branch) and updates a CSV file (to be deployed elsewhere) with the results of a DataviewJS query. What I have in mind is: creating a Docker image which contains Obsidian and Dataview, so that I can run the DataviewJS query and export the CSV, but without the GUI interface, and fully automated.

How can I run a script to export the CSV from DataviewJS (without having a GUI interface to open a file)?