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
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!
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.
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.
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?
Hi,
You can get the objecttypecode from SQL using this code:
SELECT ObjectTypeCode FROM Entity WHERE Name='account'
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (