Contents
You can do it by appending this to the end of the URL: /_vti_bin/listdata.svc. For example: https://somecompany.sharepoint.com/sites/somedept/Reports/MyList/_vti_bin/listdata.svc. In Excel, choose External Data Connections > OData and enter the URL. Excel will prompt you to select the table you want.
When to use OData query operations in SharePoint rest requests?
When using these query options, take into account that paging in OData is ordinal. For example, suppose you are implementing a next page button to display SharePoint list items. You use the REST service to enable the button to return items 1 through 20 when clicked, and then items 21 through 40, and so on.
How do you use OData with Excel Services?
What is OData? How do you use OData with Excel Services? SharePoint Server 2010 introduced the REST API for use in getting and setting information in Excel Workbooks stored in SharePoint document libraries.
How to create external content type from OData?
A published external content type based on an OData source: For instructions, see How to: Create an external content type from an OData source in SharePoint. For information about setting up a SharePoint development environment, see Set up a general development environment for SharePoint.
How to create external list from OData source?
The following components are needed to create an external list from an OData source: A published external content type based on an OData source: For instructions, see How to: Create an external content type from an OData source in SharePoint.
How to add external data to SharePoint project?
For more information about hosting options, see Choose patterns for developing and hosting your SharePoint Add-in. Choose Finish to create the app. In Solution Explorer, open the shortcut menu for the project, and choose Add, Content Types for External Data Source.
The first step assumes that you have successfully created an external content type, as described in How to: Create an external content type from an OData source in SharePoint. If you just want to add a simple list to your project that reflects what is in your external content type, you can use the Visual Studio 2012 autogeneration tools.
How to create an external content type from an OData source?
On the Specify OData Source page, enter the URL of the OData service that you want to connect to. The URL should resemble the following: http://services.odata.org/Northwind/Northwind.svc/. You will show the Northwind service that is available from the producers list found on the Open Data Protocol website.
Using the following code, you can access a data stream that the OData connector can use. After you have built an external content type, you can then use it to present data inside SharePoint by using the built-in objects (external lists, Business Data web parts, or custom code).
Have you made some changes on the sharepoint permissions? Have you recreate a new connection to sharepoint in flow connections? In many cases, an error code of 403 appears in a flow fail because of an authentication error.