Answered by:
CRM Adapter 4.0 - ExecuteFetch Request doesn't support Chinese Characters or other characters

Question
-
Hi,
Setup is BizTalk Server 2006 R2 64Bit and CRM Adapter 4.0 to retrieve account information from CRM.
I'm using ExecuteFetchRequest to query CRM (fetchxml) and using the CRMAdapter Response for the results.
However, when i tried to get account information with Chinese Name or other characters the result inside the CRM Adapter Response
is in ????????? (Garbage data).
Anyone has the same problem?
Is there a workaround for this one?
- Edited by R Paulo Thursday, November 12, 2009 1:00 PM
Wednesday, August 12, 2009 11:48 AM
Answers
-
Thanks for the help, I think i found a workaround on this one... I just use crm sdk instead of the adapter..
- Marked as answer by R Paulo Thursday, August 13, 2009 9:03 AM
Thursday, August 13, 2009 9:03 AM
All replies
-
This sample result:
The one in ?????????????????????????? should be chinese..
<ReturnCode>1</ReturnCode><ErrorCode /><ErrorString /><Retryable /></Header>- <prefix:ExecuteFetchResponse xmlns:prefix="http://[ServerName]/schemas.microsoft.com/crm/2007/OrgName/ExecuteFetchResponse"><FetchXmlResult><resultset morerecords="0" paging-cookie="<cookie page="1"><accountid last="{176D02DD-E571-DE11-AA8D-005056A71048}" first="{176D02DD-E571-DE11-AA8D-005056A71048}" /></cookie>"><result><accountid>{176D02DD-E571-DE11-AA8D-005056A71048}</accountid><emailaddress1>emailaddress@email.com</emailaddress1><address1_line1>122</address1_line1><address1_postalcode>1200</address1_postalcode><address1_city>Makati</address1_city><new_address1_countryid name="Philippines" dsc="0">{FC90C717-801F-DE11-98FD-001A4BFF83CD}</new_address1_countryid><new_language name="English" formattedvalue="5">5</new_language><statuscode name="Suspect">3</statuscode><statecode name="Active">0</statecode><name>?????????????????</name><new_ad_username>CR_DEV_000214</new_ad_username></result></resultset></FetchXmlResult></prefix:ExecuteFetchResponse></Message></Body></ns0:Response>- Edited by R Paulo Thursday, November 12, 2009 12:59 PM
Wednesday, August 12, 2009 1:23 PM -
THis is the actual data the one above is copied thru IE.
<ns0:Response xmlns:ns0="http://schemas.microsoft.com/crm/2007/BizTalkAdapter/OrgName/Response"><Header><ReturnCode>1</ReturnCode><ErrorCode></ErrorCode><ErrorString></ErrorString><Retryable></Retryable></Header><Body><Message><prefix:ExecuteFetchResponse xmlns:prefix="http://nrwvn01/schemas.microsoft.com/crm/2007/OrgName/ExecuteFetchResponse"><FetchXmlResult>&lt;resultset morerecords="0" paging-cookie="&amp;lt;cookie page=&amp;quot;1&amp;quot;&amp;gt;&amp;lt;accountid last=&amp;quot;{176D02DD-E571-DE11-AA8D-005056A71048}&amp;quot; first=&amp;quot;{176D02DD-E571-DE11-AA8D-005056A71048}&amp;quot; /&amp;gt;&amp;lt;/cookie&amp;gt;"&gt;&lt;result&gt;&lt;accountid&gt;{176D02DD-E571-DE11-AA8D-005056A71048}&lt;/accountid&gt;&lt;emailaddress1&gt;email@email.com&lt;/emailaddress1&gt;&lt;address1_line1&gt;122&lt;/address1_line1&gt;&lt;address1_postalcode&gt;1200&lt;/address1_postalcode&gt;&lt;address1_city&gt;Makati&lt;/address1_city&gt;&lt;new_address1_countryid name="Philippines" dsc="0"&gt;{FC90C717-801F-DE11-98FD-001A4BFF83CD}&lt;/new_address1_countryid&gt;&lt;new_language name="English" formattedvalue="5"&gt;5&lt;/new_language&gt;&lt;statuscode name="Suspect"&gt;3&lt;/statuscode&gt;&lt;statecode name="Active"&gt;0&lt;/statecode&gt;&lt;name&gt;?????????????????&lt;/name&gt;&lt;new_ad_username&gt;CR_DEV_000214&lt;/new_ad_username&gt;&lt;/result&gt;&lt;/resultset&gt;</FetchXmlResult></prefix:ExecuteFetchResponse></Message></Body></ns0:Response>Wednesday, August 12, 2009 1:28 PM -
Thanks for the help, I think i found a workaround on this one... I just use crm sdk instead of the adapter..
- Marked as answer by R Paulo Thursday, August 13, 2009 9:03 AM
Thursday, August 13, 2009 9:03 AM