Write, Bureaucrats, Administrators
3,296
edits
Difference between revisions of "Consolidation OData Feed"
no edit summary
| Line 5: | Line 5: | ||
They assist with the consolidation process by removing the need to append data from multiple data files into one table in Power Query. | They assist with the consolidation process by removing the need to append data from multiple data files into one table in Power Query. | ||
For the most part, the [[Endpoints]] access via a consolidation | |||
== Differences in the Consolidation OData Feed == | |||
For the most part, the [[Endpoints]] access via a consolidation odata feed work the same as those for individual [[Data Files|data files]]. Both include a DataFiles fields including a DataFileID. | |||
There are some slight differences, however. | |||
The Consolidation OData feed includes additional [[Function Endpoints|'''Functions''']]. These functions are present for functions that include IDs as parameters, such as BudgetID, TrackingCategoryID, etc. Since IDs are specific to a single [[Data Files|Data File]], an additional DataFile parameter must be included. These specialised functions are those whose name ends with the word DataFile (e.g. BudgetAmounts vs BudgetAmountsDataFile). | |||
| Line 11: | Line 18: | ||
== OdataLink Report Templates require Consolidation OData Feeds == | == OdataLink Report Templates require Consolidation OData Feeds == | ||
Standard OdataLink Report | [https://odatalink.com/templates/ Standard OdataLink Report Remplates] we create are typically designed and require '''Consolidation''' OData Feeds to extract data as they make use of the [[#Differences in the Consolidation OData Feed|specialised functions mentionned in 'Differences in the Consolidation OData Feed']] | ||
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. | 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. | ||
Using any OData feed other than '''Consolidation''' OData Feed can result in errors while refreshing the Standard report template. | |||