How do we select required fields from an Attributes using the rest api

(0) Share

Report

Posted on by Prabhakar paliwal

We are using the rest api robomqdev.crm.dynamics.com/.../EntityDefinitions(LogicalName='account')/Attributes to get the attributes of account. Now after getting the result we want to know which field is required or not. There is 'IsRequiredForForm' which we are getting from the result but when we match it with crm by login into the UI its getting the wrong result. So in our case 'IsRequiredForForm' is not working. Any one can help us to identify how we can know which field is required.

Thanks in advanced.

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

Kokulan 18,054 on at

Like (1)

Report
Copy link

Link copied!
Hi

AttributeMetadata.RequiredLevel is the field you need to get or set what you want

This property is required for the CreateAttributeRequest message.

It can be specified for the UpdateAttributeRequest message.

The following values are valid when you create an attribute.

None - Means Optional

Recommended

ApplicationRequired

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg307513%28v%3dcrm.8%29

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg327644(v%3Dcrm.8)

The IsRequiredForForm property you mentioned, seems to have been introduced only on V9. And the property is listed and but the documentation does not describe the purpose of use of it. I think at least for now this field only for internal use and its most likely that based on this property CRM form designer may not allow removing certain fields from the form.

https://docs.microsoft.com/en-us/dotnet/api/microsoft.xrm.sdk.metadata.attributemetadata?view=dynamics-general-ce-9

Was this reply helpful? Yes No
Prabhakar paliwal 15 on at

Like (0)

Report
Copy link

Link copied!

Thanks a lot it works!!

Few more questions want to know about

1. How to know which field is valid for update. Like for Accout there is AccountNumber which is not supposed to update by User. Again 'IsValidForUpdate' is not work as exptected.

2. How to know the id fields for the lookup tables.

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (1)

Report
Copy link

Link copied!

Hi

Please see below

1. How to know which field is valid for update. Like for Accout there is AccountNumber which is not supposed to update by User. Again 'IsValidForUpdate' is not work as expected.

AccountNumber field can be updated and IsValidForUpdate is the correct attribute for this.

[View:https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/developers-guide/gg307510(v%3Dcrm.8):750:50]

I have tried updating AccountNumber using Bulk Data Updater plugin on XrmToolBox and it updates the account number.

2. How to know the id fields for the lookup tables.

(logicalname + "id") -> will always be the id column name of the entity referenced by the lookup field

Was this reply helpful? Yes No
Prabhakar paliwal 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for quick response.

For the second one after checking I think its (EntityLogicalName + "id"). Please correct if I am wrong.

Was this reply helpful? Yes No
Kokulan 18,054 on at

Like (0)

Report
Copy link

Link copied!

Yes that's correct

Was this reply helpful? Yes No
Prabhakar paliwal 15 on at

Like (0)

Report
Copy link

Link copied!

One another question related to Privilege. Since there are so many entities in dynamics365 (around 500+) but users have limited access to these entities. Is there any field so we can identify that for particular entity user have not sufficient privilege.

Was this reply helpful? Yes No