Consolidation OData Feed: Difference between revisions
added information on Standard templates and consolidation endpoints |
|||
| Line 8: | Line 8: | ||
'''Note''' that consolidation endpoints must be enabled in order to be used. See [[Enabling / disabling OData access to the consolidation endpoints for the model|enabling access to the consolidation endpoints for the model]] for more information. | '''Note''' that consolidation endpoints must be enabled in order to be used. See [[Enabling / disabling OData access to the consolidation endpoints for the model|enabling access to the consolidation endpoints for the model]] for more information. | ||
== Standard OdataLink Templates == | |||
Standard OdataLink templates utilize '''Consolidation''' Feeds to extract data. | |||
Since Consolidation feeds are available for both '''single-organisation''' and '''multi-organisation accounts''', using Consolidation feeds in the standard templates ensure that they are '''compatible''' with all accounts. | |||
The consolidation endpoint functions contain a company field ('''DataFile ID''') as a parameter, which is not available in standard company endpoints. | |||
Thus, using a '''Company Odata Feed''' instead of '''Consolidation''' will result in errors while refreshing the report. | |||
== Related Topics == | == Related Topics == | ||
:[[Endpoints]] | :[[Endpoints]] | ||
:[https://odatalink.com/templates/ OdataLink Report Templates] | |||
== Key Words == | == Key Words == | ||
Revision as of 19:40, 28 October 2024
Overview
Consolidation Endpoints are specialised endpoints that allow you to pull all data from data files assigned to the model as a single feed.
They assist with the consolidation process by removing the need to append data from multiple data file specific end points into the one table in Power Query
The consolidation Endpoints created by model are the same as those for individual data files. Both include a Data File ID
Note that consolidation endpoints must be enabled in order to be used. See enabling access to the consolidation endpoints for the model for more information.
Standard OdataLink Templates
Standard OdataLink templates utilize Consolidation Feeds to extract data.
Since Consolidation feeds are available for both single-organisation and multi-organisation accounts, using Consolidation feeds in the standard templates ensure that they are compatible with all accounts.
The consolidation endpoint functions contain a company field (DataFile ID) as a parameter, which is not available in standard company endpoints.
Thus, using a Company Odata Feed instead of Consolidation will result in errors while refreshing the report.
Related Topics
Key Words
Consolidate
Consolidated End Points
Consolidate Xero Organisations
Consolidate MYOB Companies
Consolidate multiple data files