Skip to main content

Posts

Showing posts from November, 2017

How to create new (missing) columns for entities in your Data Export Service Azure SQL database

Retrieve Object Type Codes via WebAPI Url

To quickly retrieve the object type codes you can add the following URL part to your CRM instance URL:/api/data/v8.2/EntityDefinitions?$select=LogicalName,ObjectTypeCode&$filter=ObjectTypeCode%20gt%209999The output looks like this:{ "@odata.context":"https://orgname.crm4.dynamics.com/api/data/v8.2/$metadata#EntityDefinitions(LogicalName,ObjectTypeCode)","value":[ { "LogicalName":"msdyn_quotebookingproduct","ObjectTypeCode":10076,"MetadataId":"eabdb23d-67d9-4c20-b72e-7358079a1afd" },{ "LogicalName":"msdyn_requirementresourcepreference","ObjectTypeCode":10017,"MetadataId":"d63ce867-9bd1-45ee-aedc-459394bedf35" },{ "LogicalName":"msdyn_rmareceiptproduct","ObjectTypeCode":10086,"MetadataId":"5b57cb66-3728-4987-8b95-ab78d5dfcf9a" },{ "LogicalName":"audi…