topic Re: Get optionset data using tmicrosoftcrminput command. in Talend Studio

Get optionset data using tmicrosoftcrminput command.

Norberto — Sat, 28 Dec 2019 10:16:26 GMT

Dear all,
I’m starting using TOS tu get data from Microsoft Dynamics 365 CRM (cloud).
I use the tMicrosoftCrmInput command to connect to the standard entity “account”. I got the data without problem but I'm unable to retrieve the values of fields of type optionset (fields with multiple selection from a list).

Here is the error message I get :

don't support the type of <xml-fragment xmlns:c="http://schemas.datacontract.org/2004/07/System.Collections.Generic" xmlns:b="http://schemas.microsoft.com/xrm/2011/Contracts" xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns:s="http://www.w3.org/2003/05/soap-envelope" xmlns:a="http://www.w3.org/2005/08/addressing" xmlns:u="http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd">
<c:key>pdw_salesteamcode</c:key>
<c:value i:type="dptionSetValueCollection" xmlns:d="http://schemas.microsoft.com/xrm/9.0/Contracts">
<dptionSetValue>
<b:Value>100000003</b:Value>
</dptionSetValue>
</c:value>
</xml-fragment>

Could somebody help ?
Thanks in advance.
Best regards.

Re: Get optionset data using tmicrosoftcrminput command.

Anonymous — Tue, 07 Jan 2020 08:57:42 GMT

Hello,

Can you please clarify in which Talend version/edition you are?

Best regards

Sabrina

Re: Get optionset data using tmicrosoftcrminput command.

Norberto — Tue, 07 Jan 2020 09:27:34 GMT

Hi Sabrina,

I'm using Talend Open Studio for Data Integration version 7.3.1 Build id: M4.

Thanks for your help as I need to solve this otherwise I'll have to move to another ETL.

Best regards

Re: Get optionset data using tmicrosoftcrminput command.

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

Hello,

I just answered to a similar problem here: https://community.talend.com/s/question/0D53p00008SJxHTCA1/how-can-i-retreive-the-label-text-from-option-set-data-type-with-tmicrosoftcrminput?t=1621320972731

Regards,

Eric