Thanks for your reply!
When I add the argument --csv to the 'get' command, I get an error *** Unrecognized option: --csv
This option works for 'export' command. However, it still gives me a csv file with XML code in it and not the data.
However, after a few trial and error attempts, I did find the correct answer.
I used the 'export' command and in the Tableau server parameter, I used the part of the URL after '"/views'
Also, at the end, I specified the site parameter (-t) to explicitly specify the site
Command which worked for me -
tabcmd export "/workbook/dashboard" --csv -f "\\UNCPath\test.csv" -t prd