trying to include the rowpermalink in my sheet export according to the API doc the ?include=rowpermalink in the URL should do it however it does not show in the row with all the other data from the sheet. any help would be greatly apprecitated.
$URL = "https://api.smartsheet.com/2.0/sheets/****************?include=rowPermalink"
$Headers = @{
Authorization = "Bearer *************************"
Accept = "application/vnd.ms-excel"
}
$MyFile = "c:\temp\TestDB.xlsx"
Invoke-WebRequest -Uri "$URL" -Method Get -Headers $Headers -OutFile $MyFile