locked
CRM Adapter 4.0 - ExecuteFetch Request doesn't support Chinese Characters or other characters RRS feed

  • 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..

    - <ns0:Response xmlns:ns0="http://schemas.microsoft.com/crm/2007/BizTalkAdapter/OrgName/Response">
    - <Header>
      <ReturnCode>1</ReturnCode>
      <ErrorCode />
      <ErrorString />
      <Retryable />
      </Header>
    - <Body>
    - <Message>
    - <prefix:ExecuteFetchResponse xmlns:prefix="http://[ServerName]/schemas.microsoft.com/crm/2007/OrgName/ExecuteFetchResponse">
      <FetchXmlResult><resultset morerecords="0" paging-cookie="&lt;cookie page=&quot;1&quot;&gt;&lt;accountid last=&quot;{176D02DD-E571-DE11-AA8D-005056A71048}&quot; first=&quot;{176D02DD-E571-DE11-AA8D-005056A71048}&quot; /&gt;&lt;/cookie&gt;"><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>&lt;prefix:ExecuteFetchResponse xmlns:prefix="http://nrwvn01/schemas.microsoft.com/crm/2007/OrgName/ExecuteFetchResponse"&gt;&lt;FetchXmlResult&gt;&amp;lt;resultset morerecords="0" paging-cookie="&amp;amp;lt;cookie page=&amp;amp;quot;1&amp;amp;quot;&amp;amp;gt;&amp;amp;lt;accountid last=&amp;amp;quot;{176D02DD-E571-DE11-AA8D-005056A71048}&amp;amp;quot; first=&amp;amp;quot;{176D02DD-E571-DE11-AA8D-005056A71048}&amp;amp;quot; /&amp;amp;gt;&amp;amp;lt;/cookie&amp;amp;gt;"&amp;gt;&amp;lt;result&amp;gt;&amp;lt;accountid&amp;gt;{176D02DD-E571-DE11-AA8D-005056A71048}&amp;lt;/accountid&amp;gt;&amp;lt;emailaddress1&amp;gt;email@email.com&amp;lt;/emailaddress1&amp;gt;&amp;lt;address1_line1&amp;gt;122&amp;lt;/address1_line1&amp;gt;&amp;lt;address1_postalcode&amp;gt;1200&amp;lt;/address1_postalcode&amp;gt;&amp;lt;address1_city&amp;gt;Makati&amp;lt;/address1_city&amp;gt;&amp;lt;new_address1_countryid name="Philippines" dsc="0"&amp;gt;{FC90C717-801F-DE11-98FD-001A4BFF83CD}&amp;lt;/new_address1_countryid&amp;gt;&amp;lt;new_language name="English" formattedvalue="5"&amp;gt;5&amp;lt;/new_language&amp;gt;&amp;lt;statuscode name="Suspect"&amp;gt;3&amp;lt;/statuscode&amp;gt;&amp;lt;statecode name="Active"&amp;gt;0&amp;lt;/statecode&amp;gt;&amp;lt;name&amp;gt;?????????????????&amp;lt;/name&amp;gt;&amp;lt;new_ad_username&amp;gt;CR_DEV_000214&amp;lt;/new_ad_username&amp;gt;&amp;lt;/result&amp;gt;&amp;lt;/resultset&amp;gt;&lt;/FetchXmlResult&gt;&lt;/prefix:ExecuteFetchResponse&gt;</Message></Body></ns0:Response>


    • Marked as answer by R Paulo Thursday, August 13, 2009 9:02 AM
    • Unmarked as answer by R Paulo Thursday, August 13, 2009 9:02 AM
    • Edited by R Paulo Thursday, November 12, 2009 1:00 PM
    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