Open
Description
Low priority, but if we're going to set and clear dropdown lists, maybe we should be able to get them as well?
$uri = "https://sheets.googleapis.com/v4/spreadsheets/$spreadSheetID`?ranges=$sheetName&includeGridData=true"
$result = Invoke-RestMethod -Method GET -Uri $uri -Headers @{"Authorization"="Bearer $accessToken"}
if($result.sheets[0].data[0].rowData[1].values[2].dataValidation) {write-host "contains validation"}
Metadata
Metadata
Assignees
Labels
No labels