Why not use the Report Writer for this? You can then use the export features.
To expand on Jeff's reply, you can:
1) create a report in reportwriter that shows the fields you want
2) on the SolarWinds website, display the report
3) add "&dataformat=xls" to the end of the URL and hit enter.
...or "TXT" or "CSV"
What you will get is the report exported to the format you specify.
UNLESS this is something you need to run programatically in the background to feed some other process. In which case your first thought (SDK) may be one of your better options.
I tried adding the &dataformat=xls and got an error. Youare talking about adding in report scheduler, correct?
No. Straight on the web server. Just like viewing a report.
do you mean something like this? (Modify target to the Orion machine and uncomment add-PSSnapin sequence in case you haven't added it yet)
$Credentials = get-credential
$swis = Connect-Swis -host $Target -Credential $Credentials
Get-SwisData $swis "Select NodeID, Caption from Orion.Nodes" | Export-Csv C:\Nodelist.txt