Should we introduce a CSV output mode?

[plamber]

While reading #2544 I was thinking that introducing a CSV output mode might become useful when exporting results from the CLI.

In every shell you can than take this output and pipe it directly to a file. This might become an interesting alternative to the JSON output mode when scripting.

If we consider introducing such a command we might also think in providing the ability to do some basic configurations in the CLI settings by specifying the CSV delimiter or some other options that might come up.

Cheers

[waldekmastykarz]

I'm all for it. If it would be helpful, we should definitely consider it 👍

[arjunumenon]

You read my mind @plamber . I am totally in for this approach. There were couple of scripts which I had been developing last day and exporting would have been a real blessing if we want to reuse for other scripts. Let us load it up. 🚀

[garrytrinder]

Great idea! +1

[Adam-it]

yes 👍👍 I believe that might be helpful 🤔. Just by checking the script sample repositories there are already 18 samples with the CSV keyword

so it seems it is needed. Usually the PnPPowershell and CLI sample then share the same couple of lines where you convert and Export-Csv.
Just think how cool it would be when in PnP Powershell you have the:

1. connect
2. get data
3. convert data
4. export to csv data

and now in CLI you would have

1. ensure connect
2. get data with export to csv file 🤯🤯🤯

I like it 👍 I think it is needed👍

[waldekmastykarz]

Sold!