Can we browse a Data Entity ?

(0) Share

Report

Posted on by Community Member

Hi all,

As subjected, can we use the usual "mi=SysTableBrowser…." to browse Data Entity ?

I'm trying to browse one of D365 standard entity : EcoResReleasedDistinctProductEntity, but it returns me an error saying :

The form datasource 'EcoResReleasedDistinctProductEntity' is bound to an unsupported entity type.

Please advice.

Thanks,

I have the same question (0)

All responses (15)

Answers (4)

Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (0)

Report

You can not do that using table browser . If you want to see data go to SQL and just query using entity name to see the data.

Was this reply helpful? Yes No
Juanse 660 on at

Like (0)

Report

Hello,

why don't you use the dynamics.com/data/EcoResReleasedDistinctProductEntity in a web browser to browse the data in that entity

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

table browser cannot be used for data entity rather one needs to use the syntax as sugsted by Juan

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Rahul/Juan,

I'm sorry, I think I'm loosing you both. Not sure what does it mean and how it works.

Thanks,

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (0)

Report

Hi WWwong,

Just to summarize all possible options:

1. If you have access to DB, you can connect to the database and find the view with entity name and select data via SQL management studio

2. Use oData if it's supported for the entity, but it will work too slow if you will have a lot of data (Juan)

3. Use "Data management" and export data to Excel (or whatever supported type you like)

Table browser doesn't support entities viewing

Was this reply helpful? Yes No
SThakur 412 on at

Like (0)

Report

Have a look at the below link for future reference.

docs.microsoft.com/.../config-key-entities

Thanks,

Shilpi

Was this reply helpful? Yes No
Verified answer

Rahul Mohta 21,032 on at

Like (0)

Report

and access to DB in cloud world is only for non-production enviornments

best is to use OData browsing URL as suggested earlier or data management

Was this reply helpful? Yes No
Suggested answer

Sukrut Parab 71,710 Moderator on at

Like (1)

Report

Hi WWwong ,

Take a look at below link to get more details about how to use odata endpoint to query data from data entities which are public.

https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/data-entities/odata

As I said in my earlier reply don't use table browse for entities , if you have SQL access then you can directly query those because those are views.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,032 on at

Like (0)

Report

OData is the way to go to browse rather than the entity itself

but sounds like a good idea

Was this reply helpful? Yes No
Verified answer

SThakur 412 on at

Like (0)

Report

I agree with Rahul and Sukrut if it is a single entity Odata [HTTP]is the way to go, but for exposure and consumption of high volume of data entities you can make use of the data management framework.

Thanks,

Shilpi

Was this reply helpful? Yes No