Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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

  • Question
    Sign in to vote
    0
    Sign in to vote
    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote
    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