Entity Table ObjectTypeCode

(0) Share

Report

Posted on by Jayakumar

390

Hi,

As a Dynamics crm user we cannot query the entity table directly in database nor there is filtered view for entity table like FilteredEntity. Is there any way to get the objecttypecode of the entity using sql query by an crm user?

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Temmy Wahyu Raharjo 2,916 on at

Like (0)

Report
Hi,
You can get the objecttypecode from SQL using this code:

SELECT ObjectTypeCode FROM Entity WHERE Name='account'

Was this reply helpful? Yes No
Jayakumar 390 on at

Like (0)

Report

That is my actual issue. I am getting select permission denied Error on Entity Table. I am a dynamics crm user with Admin Role. Still I cannot retrieve the data from this table in database. I dont want to give explicit select permission in database level for this user. Is there any way?

Was this reply helpful? Yes No
Jayakumar 390 on at

Like (0)

Report

Please note there is no filtered view for the Entity table else I would have able to retrieve it.

Was this reply helpful? Yes No
Suggested answer

Kalpavruksh D365 CoE 2,545 on at

Like (0)

Report

Hi Jaya,

Querying the database directly is not supported in Dynamics 365. You can access the metadaservice to get entity-specific details and it is also possible to get the same using the correct source code of javascript. Please let us know the exact functionality you want to achieve so that I can share appropriate information.

Was this reply helpful? Yes No
Suggested answer

Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Another way you can probably get this is by querying the StringMap table:

SELECT DISTINCT AttributeValue, Value FROM [StringMapBase]

WHERE AttributeName = 'objecttypecode'

ORDER BY Value

Again, not supported, but you can get directly from SQL.

I would suggest getting your data by querying the metadata using webapi.

You can also get the metadata browser plugin from XrmToolbox if you need this:

docs.microsoft.com/.../browse-your-metadata

Hope this helps.

Was this reply helpful? Yes No
Inogic 713 on at

Like (0)

Report

Hi,

You can use the below SQL query to get the Object Type code.

SQL Query:

select Name, ObjectTypeCode from EntityView order by ObjectTypeCode

And if you want to get the object type code using Web API then use below code:

[org service root URL]/EntityDefinitions?$select=LogicalName,ObjectTypeCode

You can get the service root URL from Developer resource area. For this, navigate to Settings àCustomizations à Developer Resources, as shown in below screenshot:

Please mark as verified if the answer is helpful.

Thanks!

Was this reply helpful? Yes No