cancel
Showing results for 
Search instead for 
Did you mean: 

Querying the CDS via OData or REST

It would be fantastic if we could query CDS via OData, REST or similar from outside.

 

This would mean we could extend CDS usage to SharePoint, perhaps to Nintex Workflows, to Salesforce as external objects, to our apps.  It could really become the central part of a lot of our applications once refreshing the data is worked out.

 

I would definitely pay for this ability as a premium service, to be able to use Data Factory to upload my corporate datasets to Azure Data Lake or similar, query them using Power Query, and have a centralised data service for all my apps.

 

If it had security similar to Azure Storage Tables, so I could craft a URL to query, it'd be fantastic.

 

Ping @jonoluk

Status: Completed

We are happy to say the latest updated to the Common Data Service now supports access through OData V4.

 

To access the endpoint, you'll need your environment URL. To discover this:

 

1. Log into web.powerapps.com, and select your environment (Note, it must be created after 3/21 to include the new features, more details here.)

 

2. Use the switcher in the bottom left hand cover to change to Model Driven mode.

 

3. Click "Advanced" in the left nav.

 

4. Your URL will be in the format https://[YourUniqueEnvID].crm.dynamics.com/tools/solutions.... you need to take the "YourUnqiueEnvID" part of this URL

 

5. Your OData endpoint will be : https://[YourUniqueEnvID].api.crm.dynamics.com/api/data/v9.0/

 

We have work underway to make this easier to get to in the future, but for now ready for use. You can read more about the endpoint here : https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-web-services

Comments
Microsoft

Thanks for the idea!  Something we've been hearing from customers for sure.  At this point, we want to make sure we land the right patterns first, so we've exposed data primarily via the SDK.  We are exploring providing more native/raw access to the data via OData or REST APIs, etc. but that's not in our near term plans yet. 

 

Integration with Azure DF is also interesting and something we'd talked about with the ADF team.  But no concrete plans yet.  Please vote though!!

Power Apps
Status changed to: Under Review

Thanks Andrew - we are looking at this as a feature for the future. We will continue to update through and blog and the forums when it's available. Thanks for your feedback!

Power Apps
Status changed to: Started

This work is underway, thanks for your valuable feedback!

Power Apps
Status changed to: Completed

We are happy to say the latest updated to the Common Data Service now supports access through OData V4.

 

To access the endpoint, you'll need your environment URL. To discover this:

 

1. Log into web.powerapps.com, and select your environment (Note, it must be created after 3/21 to include the new features, more details here.)

 

2. Use the switcher in the bottom left hand cover to change to Model Driven mode.

 

3. Click "Advanced" in the left nav.

 

4. Your URL will be in the format https://[YourUniqueEnvID].crm.dynamics.com/tools/solutions.... you need to take the "YourUnqiueEnvID" part of this URL

 

5. Your OData endpoint will be : https://[YourUniqueEnvID].api.crm.dynamics.com/api/data/v9.0/

 

We have work underway to make this easier to get to in the future, but for now ready for use. You can read more about the endpoint here : https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-web-services

New Member

Hi @CWesener, If we use a service account to call the OData (read only) what licensing is required? Do we need a license just for the service account or all users?

We have an external system that we would like to interface CDS data with using OData.