How can I retreive the label text from option set data type with tMicrosoftCrmInput?

[Elmar010]

In Talend I receive the value (864640000) instead of the label (Not to plan) by using schema name (hso_salesstatus):

I also tried the following schama names for this field, but it did work:

_hso_salesstatus

_hso_salesstatus_formatted

_hso_salesstatus_label

_hso_salesstatus_value

My setup in CRM:

How can i get the label text instead of the value?

[Anonymous]

Hello,

What's CRM version and Authentication are you using? Could you please post your component setting screenshot on community?

Best regards

Sabrina

[Elmar010]

Hello Sabrina,

My tMicrosoftCrmInput settings are:

• Authentication Type: ONLINE
• API Version v2016 (odata)
• Registered application type: Native App

[EricMoss]

Hello,

We were confronted to the same problem.

We finally found a workaround. We use a tRestClient component to generate a Bearer token and then perform a Get request to retrieve from metadata entity a JSON mapping between value and label for the different optionset fields.

 

URL for the token generation (POST) : https://login.microsoftonline.com/XXX/oauth2/v2.0/token"

URL to get JSON mapping (GET) : https://XXX/api/data/v9.1/EntityDefinitions(LogicalName='xxx')/Attributes/Microsoft.Dynamics.CRM.PicklistAttributeMetadata?$select=LogicalName&$expand=OptionSet($select=Options),GlobalOptionSet($select=Options)"

Hope this can help you and other users.

Regards,

Eric