The initial part of the URL is called the service root and remains the same for every OData request that you make to a SharePoint server except for the name of the server. The URL uses the system query option $top to specify the number of rows to return.Looking closely at the URL, you can see its three part structure: the service root URI the resource path and the query options. This sample OData request is structured so that it gets the first 20 rows from a table named Table1 in the workbook ProductSales.xlsx which is stored in the Documents folder on the contoso1 server. The following URL shows what a typical OData request looks like: You craft the URL in a specific way, using query options, to return the information that you are requesting. OData uses URLs to request information from a resource. For Office 365 Education, Business, and Enterprise accounts, use the Excel REST APIs that are part of the Microsoft Graph endpoint. The Excel Services REST API applies to SharePoint and SharePoint 2016 on-premises.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |