Is it possible to export the results of a query to CSV via the API or fleetctl? The option is available in the GUI, but I can't figure out a way to automate it...

Via fleetctl you get the JSON which you can redirect to a file. From there it's probably not too hard to convert to CSV. Will that work for you?

Yeah, that should be good, I'll poke around with that, thanks!