UsedRangeRequestBuilder.GetAsync uses DefaultQueryParameters

[kevinib]

I'm trying to specify the "Select" QueryParameters in the GetAsync, but since it is using the DefaultQueryParamters, I can not use it.

In the Graph Explorer, I used the following query:
https://graph.microsoft.com/v1.0/me/drive/items/{drive-item-id}/workbook/worksheets('Sheet1')/usedrange?$select=address

In the Code snippets, it generates the following code:

var result = await graphClient.Drives["{drive-id}"].Items["{driveItem-id}"].Workbook.Worksheets["{workbookWorksheet-id}"].UsedRange.GetAsync((requestConfiguration) =>
{
	requestConfiguration.QueryParameters.Select = new string []{ "address" };
});

But this is not available in the SDK.

[andrueastman]

Thanks for raising this @kevinib

This looks to be an issue with the API metadata used to generate the SDK that lacks the information to generate the $select parameter.

You can however work around this using the WithUrl as below.

            var result = await graphClient.Drives["{drive-id}"].Items["{driveItem-id}"].Workbook.Worksheets["{workbookWorksheet-id}"].UsedRange
                                .WithUrl("https://graph.microsoft.com/v1.0/me/drive/items/{drive-item-id}/workbook/worksheets('Sheet1')/usedrange?$select=address")
                                .GetAsync();