topic Re: How can I retreive the label text from option set data type with tMicrosoftCrmInput? in Talend Studio

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

Elmar010 — Sat, 16 Nov 2024 00:40:46 GMT

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?

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

Anonymous — Mon, 08 Feb 2021 05:33:39 GMT

Hello,

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

Best regards

Sabrina

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

Elmar010 — Mon, 08 Feb 2021 14:32:41 GMT

Hello Sabrina,

My tMicrosoftCrmInput settings are:

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

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

EricMoss — Tue, 18 May 2021 07:03:13 GMT

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