OData.Feed

This function retrieves a table of OData feeds provided by an OData service from a specified serviceUri and headers. Users can also specify options using a boolean value to enable concurrent connectio...

Syntax

OData.Feed(serviceUri as text, optional headers as nullable record, optional options as any) as any.

About

This function retrieves a table of OData feeds provided by an OData service from a specified serviceUri and headers. Users can also specify options using a boolean value to enable concurrent connections or provide additional parameters through a record parameter called options. Query: Adds query parameters to the URL without needing to escape them. Headers: Supplies extra headers to an HTTP request by specifying a value as a record. ExcludedFromCacheKey: Excludes specified HTTP header keys from being included in the caching data calculation. ApiKeyName: Specifies the name (not the value) of the API key parameter required by the target site, with the actual key value provided in the credentials. Timeout: Adjusts the timeout duration for an HTTP request (default is 600 seconds). EnableBatch: Determines whether an OData $batch request is allowed when the MaxUriLength limit is exceeded (default is false). MaxUriLength: Sets the maximum length of a URI sent to an OData service to trigger the $batch endpoint if e

Explanation

To access the TripPin OData service, you can use Power Query in Excel. Simply insert the following code: MOData.Feed("https://services.odata.org/V4/TripPinService"). This will allow you to retrieve data from the service and display it in a table format.