/providers/{NamespaceID}/{ProviderID}/FactData

This endpoint returns the fact data for the specified provider.

Using this fact data endpoint, you can also create a new subscription for that specific model, by including the OData header Prefer set to odata.track-changes. This lets the Data Export Service know that you want to track data changes on a given model.

API Request Details

URL	`{BaseURL}/providers/{NamespaceID}/{ProviderID}/FactData` Note Make sure to replace `{NamespaceID}` and `{ProviderID}` with the correct IDs.
Request Type	GET
Content Type	application/json
Required Header
Name	Prefer
Value	odata.track-changes

The reponse can also be generated in .CSV format using the $format=text/csv parameter in the request.

Additional Parameters

$select: use this parameter to specify columns to select. For example, $select=MyColumn1,MyColumn2
$filter: use this parameter to filter the result set according to the filter string. For example, MyColumn1 eq 'myColumn1'.

Note

You can also create a subscription using a POST request. This is useful if you want to specify an ExternalID by which to reference the subscription chain and a description to indicate the changes the subscription is tracking, or to filter or perform selections on the results. If you use $select, make sure to select all dimensions as they are mandatory. Only measures are optional. These fields can be specified in the JSON body of the post request, which should also include the NamespaceID, ProviderID, and the EntitySetName. For more information, see /administration/Subscriptions (POST).

Sample Response

{ 
    "@odata.context": "$metadata#FactData", 
    "value": [ 
        { 
            "Version": "actual", 
            "Account": "400000", 
            "Region": "USA", 
            "Product": "Mountain_Bike", 
            "Currency": "CAD", 
            "Time": "202201", 
            "MyMeasure1": 10.11 
        } 
},

    "@odata.deltaLink": "{BASE_URL}/providers/{namespaceID}/{providerID}/FactData?deltaid={deltaID}" 

}