none
BizTalk CRM Adapter 4.0 - CRMAdapterResponse support for Chinese characters / non-english letters RRS feed

  • Question

  • Hi,

    I'm using BizTalk Server 2006R2 and CRM Adapter 4.0 to query account information.

    I'm using the ExecuteFetchRequest (FetchXml) to query and parsing the response using CRMAdapterResponse, but the result inside the message
    when chinese characters is present is displayed as ??????????????, i think the adapter wasn't able to properly encode the message inside the XML?

    Any workaround on this one? has anybody used CRM Adapter 4.0 ExecuteFetchRequest to retrieve data from CRM with Chinese chars. works?

    I'm surprise the adapter wasn't able to handle this, also tried the Encoding pipeline but didnt got it to work..


    • Edited by R Paulo Thursday, November 12, 2009 1:01 PM
    Wednesday, August 12, 2009 12:08 PM

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:02 AM
    Thursday, August 13, 2009 9:01 AM

All replies

  • Sample result:

    The one in ?????????????????????????? should be in chinese characters..

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

    Wednesday, August 12, 2009 1:24 PM
  • Sample result:

    The one in ?????????????????????????? should be in chinese characters..

    - <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 1:02 PM
    Wednesday, August 12, 2009 1:25 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:02 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:02 AM
    Thursday, August 13, 2009 9:01 AM