Hey DevAngel!

I am having trouble with a batch update. Here is the soap request:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <soap:Header>
  <headerStruct>
   <session_id xsi:type="xsd:string">g1IZodnymEdPbz.RjxCwsmH4wGeI6ygXsruXndS3cwNZZoI_J4af7jwNuh9x1rTi_ek7G0Mnsvzbe5lYbeG83vbtzKggVlhL</session_id>
   <version xsi:type="xsd:string">2</version>
  </headerStruct>
 </soap:Header>
 <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <qry1:batch xmlns:qry1="sfconnector:SalesforceConnector" type="methodCall">
   <type xsi:type="xsd:string">account</type>
   <operation xsi:type="xsd:string">update</operation>
   <arguments href="#id1"/>
   <soapenc:Array id="id1" soapenc:arrayType="xsd:anyType[1]">
    <Item href="#2"/>
   </soapenc:Array>
   <soapenc:Array id="2" soapenc:arrayType="tns:mapEntry[2]">
    <Item href="#2A"/>
    <Item href="#2B"/>
   </soapenc:Array>
   <tns:mapEntry id="2A" xsi:type="tns:mapEntry">
    <key xsi:type="xsd:string">cf_00N30000000c27H</key>
    <name xsi:type="xsd:double">0</name>
   </tns:mapEntry>
   <tns:mapEntry id="2B" xsi:type="tns:mapEntry">
    <key xsi:type="xsd:string">id</key>
    <name xsi:type="xsd:string">000000000000000</name>
   </tns:mapEntry>
  </qry1:batch>
 </soap:Body>
</soap:Envelope>

Also, I am trying to generate an error response from the server in the above xml.

Thanx!

Hello all,

I ran a query on salesforce to acquire all accounts of a specific industry and attempted to save the results to a SQL Server DB table with a primary key constraint on "id". 

I get errors everytime I try to load these results. I took the primary key off and data loaded fine. However, when I ran some queries on the saved data it showed that id's where in the table twice.

Are there instances where an "id" maybe reused?

Hello All,

I am having trouble retrieving my custom fields via the SOAP describe method.  Anyone have any ideas on what I need to acquire these fields. Here is the request message:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <soap:Header>
  <headerStruct>
   <session_id xsi:type="xsd:string">H6efA3Lip30M2orU1.xNMPWYUhgt1Zz5s1KeNxu4r.XYpcKGUIQraAL0KR0KJ9yvJJa2cHSK.XeiHhakibmVNPbtzKggVlhL</session_id>
   <version xsi:type="xsd:string">2</version>
  </headerStruct>
 </soap:Header>
 <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <qry1:describe xmlns:qry1="sfconnector:SalesforceConnector" type="methodCall">
   <type xsi:type="xsd:string">account</type>
  </qry1:describe>
 </soap:Body>
</soap:Envelope>

Thanx!

Hello All,

I am trying to query all accounts and I'm getting an error. Would you please take a look at my SOAP message and lemme know what I'm doing wrong thanx!

Request:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <soap:Header>
  <headerStruct>
   <session_id xsi:type="xsd:string">XGd_7ULP.SCHlD9Hidxp4gqTMF1WlgtlNlHyJ9.iCf5mehNuWsT8zoblas.UB8n3Nup0UNXBACOOW3brM5mSovbtzKggVlhL</session_id>
   <version xsi:type="xsd:string">2</version>
  </headerStruct>
 </soap:Header>
 <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <qry1:query xmlns:qry1="sfconnector:SalesforceConnector" type="methodCall">
   <type xsi:type="xsd:string">account</type>
   <maxRows xsi:type="xsd:int">20</maxRows>
   <select href="#id1"/>
   <filter href="#id2"/>
  </qry1:query>
  <soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">
   <Item>id</Item>
   <Item>Account_Name</Item>
   <Item>Parent_Account_ID</Item>
   <Item>Account_Number</Item>
   <Item>Account_Type</Item>
   <Item>Industry</Item>
  </soapenc:Array>
  <soapenc:Array id="id2" soapenc:arrayType="xsd:anyType[1]">
   <Item href="#id3"/>
  </soapenc:Array>
  <soapenc:Array id="id3" soapenc:arrayType="tns:mapEntry[3]">
   <Item href="#mentry1"/>
   <Item href="#mentry2"/>
   <Item href="#mentry3"/>
  </soapenc:Array>
  <tns:mapEntry id="mentry1" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">field</key>
   <value xsi:type="xsd:string">Created_Date</value>
  </tns:mapEntry>
  <tns:mapEntry id="mentry2" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">value</key>
   <value xsi:type="xsd:dateTime">2002-01-01T00:00:00.0000000-08:00</value>
  </tns:mapEntry>
  <tns:mapEntry id="mentry3" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">operator</key>
   <value xsi:type="xsd:string">greater than</value>
  </tns:mapEntry>
 </soap:Body>
</soap:Envelope>

Response:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header/><soap:Body><soap:Fault><faultcode>1100</faultcode><faultstring>missing scope in query call</faultstring></soap:Fault></soap:Body></soap:Envelope>

Hey DevAngel!

I am having trouble with a batch update. Here is the soap request:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <soap:Header>
  <headerStruct>
   <session_id xsi:type="xsd:string">g1IZodnymEdPbz.RjxCwsmH4wGeI6ygXsruXndS3cwNZZoI_J4af7jwNuh9x1rTi_ek7G0Mnsvzbe5lYbeG83vbtzKggVlhL</session_id>
   <version xsi:type="xsd:string">2</version>
  </headerStruct>
 </soap:Header>
 <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <qry1:batch xmlns:qry1="sfconnector:SalesforceConnector" type="methodCall">
   <type xsi:type="xsd:string">account</type>
   <operation xsi:type="xsd:string">update</operation>
   <arguments href="#id1"/>
   <soapenc:Array id="id1" soapenc:arrayType="xsd:anyType[1]">
    <Item href="#2"/>
   </soapenc:Array>
   <soapenc:Array id="2" soapenc:arrayType="tns:mapEntry[2]">
    <Item href="#2A"/>
    <Item href="#2B"/>
   </soapenc:Array>
   <tns:mapEntry id="2A" xsi:type="tns:mapEntry">
    <key xsi:type="xsd:string">cf_00N30000000c27H</key>
    <name xsi:type="xsd:double">0</name>
   </tns:mapEntry>
   <tns:mapEntry id="2B" xsi:type="tns:mapEntry">
    <key xsi:type="xsd:string">id</key>
    <name xsi:type="xsd:string">000000000000000</name>
   </tns:mapEntry>
  </qry1:batch>
 </soap:Body>
</soap:Envelope>

Also, I am trying to generate an error response from the server in the above xml.

Thanx!

Hello all,

I ran a query on salesforce to acquire all accounts of a specific industry and attempted to save the results to a SQL Server DB table with a primary key constraint on "id". 

I get errors everytime I try to load these results. I took the primary key off and data loaded fine. However, when I ran some queries on the saved data it showed that id's where in the table twice.

Are there instances where an "id" maybe reused?

Hello All,

I am having trouble retrieving my custom fields via the SOAP describe method.  Anyone have any ideas on what I need to acquire these fields. Here is the request message:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <soap:Header>
  <headerStruct>
   <session_id xsi:type="xsd:string">H6efA3Lip30M2orU1.xNMPWYUhgt1Zz5s1KeNxu4r.XYpcKGUIQraAL0KR0KJ9yvJJa2cHSK.XeiHhakibmVNPbtzKggVlhL</session_id>
   <version xsi:type="xsd:string">2</version>
  </headerStruct>
 </soap:Header>
 <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <qry1:describe xmlns:qry1="sfconnector:SalesforceConnector" type="methodCall">
   <type xsi:type="xsd:string">account</type>
  </qry1:describe>
 </soap:Body>
</soap:Envelope>

Thanx!

Hello All,

I am trying to query all accounts and I'm getting an error. Would you please take a look at my SOAP message and lemme know what I'm doing wrong thanx!

Request:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
 <soap:Header>
  <headerStruct>
   <session_id xsi:type="xsd:string">XGd_7ULP.SCHlD9Hidxp4gqTMF1WlgtlNlHyJ9.iCf5mehNuWsT8zoblas.UB8n3Nup0UNXBACOOW3brM5mSovbtzKggVlhL</session_id>
   <version xsi:type="xsd:string">2</version>
  </headerStruct>
 </soap:Header>
 <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
  <qry1:query xmlns:qry1="sfconnector:SalesforceConnector" type="methodCall">
   <type xsi:type="xsd:string">account</type>
   <maxRows xsi:type="xsd:int">20</maxRows>
   <select href="#id1"/>
   <filter href="#id2"/>
  </qry1:query>
  <soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">
   <Item>id</Item>
   <Item>Account_Name</Item>
   <Item>Parent_Account_ID</Item>
   <Item>Account_Number</Item>
   <Item>Account_Type</Item>
   <Item>Industry</Item>
  </soapenc:Array>
  <soapenc:Array id="id2" soapenc:arrayType="xsd:anyType[1]">
   <Item href="#id3"/>
  </soapenc:Array>
  <soapenc:Array id="id3" soapenc:arrayType="tns:mapEntry[3]">
   <Item href="#mentry1"/>
   <Item href="#mentry2"/>
   <Item href="#mentry3"/>
  </soapenc:Array>
  <tns:mapEntry id="mentry1" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">field</key>
   <value xsi:type="xsd:string">Created_Date</value>
  </tns:mapEntry>
  <tns:mapEntry id="mentry2" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">value</key>
   <value xsi:type="xsd:dateTime">2002-01-01T00:00:00.0000000-08:00</value>
  </tns:mapEntry>
  <tns:mapEntry id="mentry3" xsi:type="tns:mapEntry">
   <key xsi:type="xsd:string">operator</key>
   <value xsi:type="xsd:string">greater than</value>
  </tns:mapEntry>
 </soap:Body>
</soap:Envelope>

Response:

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/" xmlns:tns="salesforce" xmlns:types="salesforce/encodedTypes" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Header/><soap:Body><soap:Fault><faultcode>1100</faultcode><faultstring>missing scope in query call</faultstring></soap:Fault></soap:Body></soap:Envelope>