Loading...

RE: SiListView and Web Services [QWP 5.7 and SP2010 Enterprise]

01/08/2013 at 10:23 am #5332

Anonymous

Participant

I was able to dig out some configuration strings I used when connecting to Dynamic CRM 3.0. I hope this can be of help with your issue.

Fetch string: "<fetch mapping=\"logical\"><entity name=\"account\"><all-attribute></all-attribute></entity></fetch>"

<Catalog>
<Entity System="WA Dynamics CRM" Service="CRMService" Name="Accounts" Default="true">
    <Operation Method="Fetch" Name="GetAccounts">
      <Parameter Name="fetchXml" Type="System.String" Usage="In" Source="XML" >
         <Element Name="fetch" >
           <Attribute Source="FixedValue" Name="mapping" Value="logical"/>
           <Element Name="entity">
                   <Attribute Source="HttpRequest" SourceName="Entity" Name="name" Value="account"/>
                   <Element Name="all-attributes"/>
           </Element>
       </Element>
     </Parameter>
    </Operation>
</Entity>
</Catalog>

<Catalog>

<Entity Name="Account" System="WA Dynamics CRM" Service="CRMService">

<Operation Name="GetList" >

<Parameter Source="FixedValue" Type="System.String" Name="FetchXml" Value="<fetch mapping=’logical’ ><entity name=’account’><all-attribute/></entity></fetch>"/>

<Parameter Source="Return" Type="System.Data.DataSet, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" SourceName="result" />

</Operation>

<Operation Name="DeleteCustomer">

<Parameter Source="HTTPParameter" SourceName="UserID" Type="int" Name="UserID"/>

<Parameter Source="Session" SourceName="UserName" Type="System.String" Name="UserName"/>

<Parameter Source="RowConsumer" SourceName="UserSession" Type="System.Ojbect" Name="ListViewUser"/>

<Parameter Source="FilterConsumer" SourceName="UserFilterSession" Type="System.String" Name="ListViewUserFilter"/>

</Operation>

<Operation Name="UpdateCustomer">

<Parameter Source="Input" SourceName="FirstName" Type="System.String" Name="First Name" Value=""/>

<Parameter Source="Input" SourceName="LastName" Type="System.String" Name="Last Name"/>

<Parameter Source="RowConsumer" SourceName="AgeSession" Type="System.Integer" Name="Age" Value="ListView"/>

</Operation>

</Entity>

<Entity Name="Payment" System="WA Dynamics CRM" Service="CRMService">

<Operation name="GetPaymentByCustomer">

<Parameter Source="Input" SourceName="UserID" Type="System.String" Name="UserID" Usage="In" />

</Operation>

</Entity>

<EntityRelations>

<EntityRelation SourceEntity="Customer" SourceEntityColumn="UserID" DestinationEntity="Payment" DestinationEntityColumn="UserID"/>

</EntityRelations>

</Catalog>

<Catalog>

<Entity Name="Account" System="WA Dynamics CRM" Service="CRMService" Default="true">

<Operation Name="GetList" Default="true" Method="Fetch">

<Parameter Source="FixedValue" Type="System.String" Name="FetchXml" Value="<fetch mapping="logical"><entity name="account"><all-attributes/></entity></fetch>" Usage="In" />

</Operation>

<Operation Name="DeleteCustomer">

<Parameter Source="HTTPParameter" SourceName="UserID" Type="int" Name="UserID" />

<Parameter Source="Session" SourceName="UserName" Type="System.String" Name="UserName" />

<Parameter Source="RowConsumer" SourceName="UserSession" Type="System.Ojbect" Name="ListViewUser" />

<Parameter Source="FilterConsumer" SourceName="UserFilterSession" Type="System.String" Name="ListViewUserFilter" />

</Operation>

<Operation Name="UpdateCustomer">

<Parameter Source="Input" SourceName="FirstName" Type="System.String" Name="First Name" Value="" />

<Parameter Source="Input" SourceName="LastName" Type="System.String" Name="Last Name" />

<Parameter Source="RowConsumer" SourceName="AgeSession" Type="System.Integer" Name="Age" Value="ListView" />

</Operation>

</Entity>

<Entity Name="Payment" System="WA Dynamics CRM" Service="CRMService">

<Operation name="GetPaymentByCustomer">

<Parameter Source="Input" SourceName="UserID" Type="System.String" Name="UserID" Usage="In" />

</Operation>

</Entity>

<EntityRelations>

<EntityRelation SourceEntity="Customer" SourceEntityColumn="UserID" DestinationEntity="Payment" DestinationEntityColumn="UserID" />

</EntityRelations>

</Catalog>