This template requires you to install RSSBus.SalesforceOps.

<rsb:info title="Sync SharePoint Contacts from SalesForce Leads." description="Syncs a SharePoint Contact list from a SalesForce Leads Table.">
  <input name="user" description="Your SalesForce account login." />
  <input name="password" style="password" description="Your SalesForce account password." />
  <input name="list" description="The name of the SharePoint Contact list to sync." required="true"/>
</rsb:info>

<div style="padding-left:5px;padding-top:5px;">
<rsb:check attr="_request.clickedSync.x">
  
  <!-- import any necessary data connector -->
  <rsb:import lib="RSSBus.SalesforceOps"/>
 
  <!-- get all the items from my SP list -->
  <rsb:call op="spListItems" out="myitemout" save="myspitems" >
    <rsb:call op="spGetItem?id=[sp:id]" >
      <rsb:set attr="myitemout.lastname" value="[sp:last_name]"/>
      <rsb:set attr="myitemout.firstname" value="[sp:first_name]"/>
      <rsb:set attr="myitemout.fullname" value="[sp:full_name| def(' ')]"/> 
      <rsb:set attr="myitemout.phone" value="[sp:business_phone]"/>
      <rsb:set attr="myitemout.email" value="[sp:e-mail_address]" />
      <rsb:set attr="myitemout.company" value="[sp:company | def('')]" />
      <rsb:set attr="myitemout.spid" value="[sp:id]" />
    </rsb:call>
  </rsb:call>

  <!-- get all the items from my salesforce leads -->
  <rsb:set attr="user" value="[user]"/>
  <rsb:set attr="password" value="[password]"/>

  <rsb:call op="salesforceSelectLead" save="mysfitems">
     <!-- set any attributes I want to sync -->
    <rsb:set attr="lastname" value="[sf:lastname]"/>
    <rsb:set attr="firstname" value="[sf:firstname]"/>
    <rsb:set attr="fullname" value="[sf:name]"/>
    <rsb:set attr="phone" value="[sf:phone]"/>
    <rsb:set attr="email" value="[sf:email]"/>
    <rsb:set attr="company" value="[sf:company]"/>
    <rsb:set attr="sfid" value="[sf:id]" />
  </rsb:call>

  <!-- now find out what is in salesforce leads that is not in the sharepoint list, using email address as the filter -->
  <rsb:set attr="diff.base" value="[_feeds.myspitems]"/>
  <rsb:set attr="diff.feed" value="[_feeds.mysfitems]"/>
  <rsb:set attr="diff.filter" value="email"/>
  <rsb:set attr="diff.list" value="[list]"/>
  <rsb:call op="feedDiff" in="diff">
    <!-- for everything not in the sp list, add it!  -->
    <rsb:set attr="name#" value="First Name"/>
    <rsb:set attr="value#" value="[firstname]"/>
    <rsb:set attr="name#" value="Last Name"/>
    <rsb:set attr="value#" value="[lastname]"/>
    <rsb:set attr="name#" value="Full Name"/>
    <rsb:set attr="value#" value="[fullname]"/>
    <rsb:set attr="name#" value="Business Phone"/>
    <rsb:set attr="value#" value="[phone]"/>
    <rsb:set attr="name#" value="Email"/>
    <rsb:set attr="value#" value="[email]"/>
    <rsb:set attr="name#" value="Company"/>
    <rsb:set attr="value#" value="[company]"/>
    <rsb:call op="spAddItem"/>
    <b>[fullname]</b> Successfully imported from SalesForce.<br>
  </rsb:call>

  <!-- now find out what is in the sharepoint list that is not in the salesforce leads, using email address as unique key -->
  <rsb:set attr="diff.base" value="[_feeds.mysfitems]"/>
  <rsb:set attr="diff.feed" value="[_feeds.myspitems]"/>
  <rsb:set attr="diff.filter" value="email"/>
  <rsb:set attr="diff.user" value="[user]"/>
  <rsb:set attr="diff.password" value="[password]"/>
  <rsb:set attr="diff.list" value="[list]"/>
  <rsb:call op="feedDiff" in="diff" out="diffout">
    <!-- for everything not in the salesforce list, delete it from sp!  -->
    <rsb:call op="feedGet?feed=[_feeds.myspitems | urlencode]" out="spout">
      <rsb:equals attr="spout.email" value="[diffout.email]">     
        <rsb:call op="spDeleteItem?id=[spout.sp:id]">
         <b>[fullname]</b> Successfully deleted from SharePoint.<br>
        </rsb:call>
      </rsb:equals>
    </rsb:call>
  </rsb:call>

  <input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
  Sync Complete!

<rsb:else>
  <input type="image" src="Picture Library/icons/refresh.ico" width="16px" name="clickedSync" />
  Sync!
</rsb:else>

</rsb:check>

</div>