Loading...

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

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

Home Forums QuickApps Forum SiListView and Web Services [QWP 5.7 and SP2010 Enterprise] RE: SiListView and Web Services [QWP 5.7 and SP2010 Enterprise]

#5332
Anonymous
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="&lt;fetch mapping=’logical’ &gt;&lt;entity name=’account’&gt;&lt;all-attribute/&gt;&lt;/entity&gt;&lt;/fetch&gt;"/>

      <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="&lt;fetch mapping=&quot;logical&quot;&gt;&lt;entity name=&quot;account&quot;&gt;&lt;all-attributes/&gt;&lt;/entity&gt;&lt;/fetch&gt;" 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>