• prudhvi
  • NEWBIE
  • 0 Points
  • Member since 2003

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 7
    Questions
  • 11
    Replies

Hi,

 

  I am trying to change OwnerID  of an Opportunity  using update soap api call.

 I am getting following error

Unable to create/update fields: OwnerId. Please check the security settings of this field and verify that it is read/write for your profile.

 

I can able to change the owner through www.salesforce.com web page .  Please help.

Any help would be much appreciated.

 

Thanks,

Prudhvi

HI, 

  I have one custom field in opportunity object. I wrote  a java service to update the custom field using sforce 2.0 API. When I update the custom field, the probability field  in opportunity is becoming 0%.(old value was 75%). The strange thig is ,I donot even have the permissions to update the probability field and I am only updating  the custom field. Can anyone please help to solve this problem

SOAP message to update opportunity custom field

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">DgvWLp.9JdeTjunkjunkNHD5junkjunk4g0pjOnu5Z7bavh.r9_junkjunk</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:update xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">DgvWLp.9JdeTjunkjunkNHD5junkjunk4g0pjOnu5Z7bavh.r9_junkjunk</session_id>
      <type xsi:type="xsd:string">opportunity</type>
      <record href="#id1"/>
    </q1:update>
    <soapenc:Array id="id1" soapenc:arrayType="tns:mapEntry[2]">
      <Item href="#id2"/>
      <Item href="#id3"/>
    </soapenc:Array>
    <tns:mapEntry id="id3" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">id</key>
      <value xsi:type="xsd:string">00600000006veRX</value>
    </tns:mapEntry>
    <tns:mapEntry id="id2" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">cf_00N00000006onjt</key>
      <value xsi:type="xsd:string">Pending</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>

Hi All,

 I have one requirement to query all the attachement names for a given opportunity.

 I am querying attachements based on parentID( Opportunity ID). its working fine, but taking long time to process the request. Can any one please help me to tune my soap request.

any help would be much appreciated.

My Soap request is like this.

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">dgfsafgdsgsgfdsg</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">dgfsafgdsgsgfdsg</session_id>
      <scope xsi:type="xsd:string">filter</scope>
      <type xsi:type="xsd:string">attachment</type>
      <maxRows xsi:type="xsd:int">10</maxRows>
      <select href="#id1"/>
      <filter href="#id2"/>
    </q1:query>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">
      <Item>id</Item>
      <Item>name</Item>
      <Item>lastModifiedDate</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="#id4"/>
      <Item href="#id5"/>
      <Item href="#id6"/>
    </soapenc:Array>
    <tns:mapEntry id="id5" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">value</key>
      <value xsi:type="xsd:string">00600000006qJqB</value>
    </tns:mapEntry>
    <tns:mapEntry id="id4" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">field</key>
      <value xsi:type="xsd:string">parentID</value>
    </tns:mapEntry>
    <tns:mapEntry id="id6" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">operator</key>
      <value xsi:type="xsd:string">equals</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>

 

 

  • September 15, 2003
  • Like
  • 0

Hi,

 

 I wrote one java service to  retrieve all the attachments for a given opportunity.

I am doing following steps to save the attachment  in my local folder

1. Constuct the query SOAP request to with attachement ID in IDList ,  name and body element in select list.

2. invoke the soap service and get the body element from the soap response(base64 string)

3. apply base64decode to decode the attachment body(base64 string) in to bytes array

4. save the attachement with the attachment name.

My service is working fine with MS WORd and EXCEL attachment. I can able to open these downloaded attachements successfully.

But for the PDF attachments my service is not working.

when I open the these downloaded PDF attachements , I am getting an error saying that There was an error opening  this document. File Does not begin with %PDF-.

I think  I am not properly decoding the  base64 string into binarydata or

the Salesforce.com soap server API is not properly encoding the PDF file into base64 when its converting the PDF file into base64 string

Can anyone has any idea on this.

 

 

Thanks,

Prudhvi.

Hi Dave,

I am  using following soap message to pull all attachments related to an opportunity.

I am using filter query soap   call to check parentID=<givenopportunityid>.

My opporunity has 3 attachement with it.  My SOAP query request is working fine but some times its giving me  duplicate rows. I mean  I am getting 6 attachements. (for each attachment I am having two value map elements in SOAP response).

Please look at this and let me know why Iam getting this problem.

Thanks and regards,

Prudhvi.

 

 

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">Q4GMyff4ow93EaHLeIwk0.Vt13WweT4OF4KAXdNRsla4pzJSjZzy4uWmqTkyV1FysKU0H19TqOU_mi4p5nFsY.btzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">Q4GMyff4ow93EaHLeIwk0.Vt13WweT4OF4KAXdNRsla4pzJSjZzy4uWmqTkyV1FysKU0H19TqOU_mi4p5nFsY.btzKggVlhL</session_id>
      <scope xsi:type="xsd:string">filter</scope>
      <type xsi:type="xsd:string">attachment</type>
      <select href="#id1"/>
      <filter href="#id2"/>
    </q1:query>
    <soapenc:Array id="id3" soapenc:arrayType="tns:mapEntry[3]">
      <Item href="#id4"/>
      <Item href="#id5"/>
      <Item href="#id6"/>
    </soapenc:Array>
    <soapenc:Array id="id2" soapenc:arrayType="xsd:anyType[1]">
      <Item href="#id3"/>
    </soapenc:Array>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">
      <Item>id</Item>
      <Item>parentID</Item>
      <Item>name</Item>
      <Item>bodyLength</Item>
      <Item>ownerID</Item>
      <Item>createdDate</Item>
      <Item>createdByID</Item>
      <Item>lastModifiedDate</Item>
      <Item>lastModifiedByID</Item>
      <Item>systemModstamp</Item>
    </soapenc:Array>
    <tns:mapEntry id="id6" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">operator</key>
      <value xsi:type="xsd:string">equals</value>
    </tns:mapEntry>
    <tns:mapEntry id="id4" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">field</key>
      <value xsi:type="xsd:string">parentID</value>
    </tns:mapEntry>
    <tns:mapEntry id="id5" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">value</key>
      <value xsi:type="xsd:string">00600000006qJqB</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>

Hi,

I am using following query soap request to fetcg the contact details whose acccountID='00300000003TLmf'.

I am getting  fault string sayig that  query bulk id value is not a string.(faultcode=1101)

I did not understand the reason for this error message. Can anyone please advise me to fix the error.

Any help woulb me much appreciated.

Thanks,

Prudhvi

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">kOjEcPmbvnYfnRNycWT5whcHV1Wjy3hDf8X5OashL03YpcKGUIQraAL0KR0KJ9yvJJa2cHSK.XeiHhakibmVNPbtzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">kOjEcPmbvnYfnRNycWT5whcHV1Wjy3hDf8X5OashL03YpcKGUIQraAL0KR0KJ9yvJJa2cHSK.XeiHhakibmVNPbtzKggVlhL</session_id>
      <scope xsi:type="xsd:string">idList</scope>
      <type xsi:type="xsd:string">contact</type>
      <maxRows xsi:type="xsd:int">5</maxRows>
      <select href="#id1"/>
      <idList href="#id2"/>
    </q1:query>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[3]">
      <Item>firstName</Item>
      <Item>lastName</Item>
      <Item>businessPhone</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="#id4"/>
      <Item href="#id5"/>
      <Item href="#id6"/>
    </soapenc:Array>
    <tns:mapEntry id="id4" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">field</key>
      <value xsi:type="xsd:string">accountID</value>
    </tns:mapEntry>
    <tns:mapEntry id="id5" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">value</key>
      <value xsi:type="xsd:string">00300000003TLmf</value>
    </tns:mapEntry>
    <tns:mapEntry id="id6" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">operator</key>
      <value xsi:type="xsd:string">equals</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>

Hi,

 I wrote one java program to fetch an opportunity details using query method.(scope is idList).

It was worked well upto yesterday.  When I run the same program Today I am getting SOAP fault with

fault string  select list not specified in query.

Please let me know whether there  is  any change in the  API?  .

I am including my soap request at the end. Please look at the message and advise me if there is any change.

any help would be much appreciated.

Thanks and regards,

Prudhvi

 

 

I am using following soap request to fetch the opp details.

Request:

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">A88zC97HIqHnZIlRhIemUk5cNamuFFrgC8.mkYiGGVDEesUfciyliy._DWGd4UrmD1qjRrjmKArOo.rZcbQUIvbtzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">A88zC97HIqHnZIlRhIemUk5cNamuFFrgC8.mkYiGGVDEesUfciyliy._DWGd4UrmD1qjRrjmKArOo.rZcbQUIvbtzKggVlhL</session_id>
      <scope xsi:type="xsd:string">idList</scope>
      <type xsi:type="xsd:string">opportunity</type>
      <maxRows xsi:type="xsd:int">1</maxRows>
      <select href="#id1"/>
      <idList href="#id2"/>
    </q1:query>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[9]">
      <Item>id</Item>
      <Item>name</Item>
      <Item>accountID</Item>
      <Item>type</Item>
      <Item>leadSource</Item>
      <Item>amount</Item>
      <Item>closeDate</Item>
      <Item>stage</Item>
      <Item>probability</Item>
      <Item>description</Item>
      <Item>closed</Item>
      <Item>won</Item>
      <Item>createdDate</Item>
      <Item>createdByID</Item>
      <Item>lastModifiedDate</Item>
      <Item>lastModifiedByID</Item>
    </soapenc:Array>
    <soapenc:Array id="id2" soapenc:arrayType="xsd:string[1]">
      <Item>00600000006qJqB</Item>
    </soapenc:Array>
  </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>ÑR</faultcode><faultstring>select list not specified in query</faultstring></soap:Fault></soap:Body></soap:Envelope>

HI, 

  I have one custom field in opportunity object. I wrote  a java service to update the custom field using sforce 2.0 API. When I update the custom field, the probability field  in opportunity is becoming 0%.(old value was 75%). The strange thig is ,I donot even have the permissions to update the probability field and I am only updating  the custom field. Can anyone please help to solve this problem

SOAP message to update opportunity custom field

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">DgvWLp.9JdeTjunkjunkNHD5junkjunk4g0pjOnu5Z7bavh.r9_junkjunk</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:update xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">DgvWLp.9JdeTjunkjunkNHD5junkjunk4g0pjOnu5Z7bavh.r9_junkjunk</session_id>
      <type xsi:type="xsd:string">opportunity</type>
      <record href="#id1"/>
    </q1:update>
    <soapenc:Array id="id1" soapenc:arrayType="tns:mapEntry[2]">
      <Item href="#id2"/>
      <Item href="#id3"/>
    </soapenc:Array>
    <tns:mapEntry id="id3" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">id</key>
      <value xsi:type="xsd:string">00600000006veRX</value>
    </tns:mapEntry>
    <tns:mapEntry id="id2" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">cf_00N00000006onjt</key>
      <value xsi:type="xsd:string">Pending</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>

Hi,

 

 I wrote one java service to  retrieve all the attachments for a given opportunity.

I am doing following steps to save the attachment  in my local folder

1. Constuct the query SOAP request to with attachement ID in IDList ,  name and body element in select list.

2. invoke the soap service and get the body element from the soap response(base64 string)

3. apply base64decode to decode the attachment body(base64 string) in to bytes array

4. save the attachement with the attachment name.

My service is working fine with MS WORd and EXCEL attachment. I can able to open these downloaded attachements successfully.

But for the PDF attachments my service is not working.

when I open the these downloaded PDF attachements , I am getting an error saying that There was an error opening  this document. File Does not begin with %PDF-.

I think  I am not properly decoding the  base64 string into binarydata or

the Salesforce.com soap server API is not properly encoding the PDF file into base64 when its converting the PDF file into base64 string

Can anyone has any idea on this.

 

 

Thanks,

Prudhvi.

I´m using the example login.java on Eclipse, but I get this exception when i put my name and password.

Which one do I have to use?

; nested exception is:

java.net.UnknownHostException: www.salesforce.com

  • August 06, 2003
  • Like
  • 0

Hi Dave,

I am  using following soap message to pull all attachments related to an opportunity.

I am using filter query soap   call to check parentID=<givenopportunityid>.

My opporunity has 3 attachement with it.  My SOAP query request is working fine but some times its giving me  duplicate rows. I mean  I am getting 6 attachements. (for each attachment I am having two value map elements in SOAP response).

Please look at this and let me know why Iam getting this problem.

Thanks and regards,

Prudhvi.

 

 

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">Q4GMyff4ow93EaHLeIwk0.Vt13WweT4OF4KAXdNRsla4pzJSjZzy4uWmqTkyV1FysKU0H19TqOU_mi4p5nFsY.btzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">Q4GMyff4ow93EaHLeIwk0.Vt13WweT4OF4KAXdNRsla4pzJSjZzy4uWmqTkyV1FysKU0H19TqOU_mi4p5nFsY.btzKggVlhL</session_id>
      <scope xsi:type="xsd:string">filter</scope>
      <type xsi:type="xsd:string">attachment</type>
      <select href="#id1"/>
      <filter href="#id2"/>
    </q1:query>
    <soapenc:Array id="id3" soapenc:arrayType="tns:mapEntry[3]">
      <Item href="#id4"/>
      <Item href="#id5"/>
      <Item href="#id6"/>
    </soapenc:Array>
    <soapenc:Array id="id2" soapenc:arrayType="xsd:anyType[1]">
      <Item href="#id3"/>
    </soapenc:Array>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">
      <Item>id</Item>
      <Item>parentID</Item>
      <Item>name</Item>
      <Item>bodyLength</Item>
      <Item>ownerID</Item>
      <Item>createdDate</Item>
      <Item>createdByID</Item>
      <Item>lastModifiedDate</Item>
      <Item>lastModifiedByID</Item>
      <Item>systemModstamp</Item>
    </soapenc:Array>
    <tns:mapEntry id="id6" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">operator</key>
      <value xsi:type="xsd:string">equals</value>
    </tns:mapEntry>
    <tns:mapEntry id="id4" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">field</key>
      <value xsi:type="xsd:string">parentID</value>
    </tns:mapEntry>
    <tns:mapEntry id="id5" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">value</key>
      <value xsi:type="xsd:string">00600000006qJqB</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>

Hi,

I am using following query soap request to fetcg the contact details whose acccountID='00300000003TLmf'.

I am getting  fault string sayig that  query bulk id value is not a string.(faultcode=1101)

I did not understand the reason for this error message. Can anyone please advise me to fix the error.

Any help woulb me much appreciated.

Thanks,

Prudhvi

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">kOjEcPmbvnYfnRNycWT5whcHV1Wjy3hDf8X5OashL03YpcKGUIQraAL0KR0KJ9yvJJa2cHSK.XeiHhakibmVNPbtzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">kOjEcPmbvnYfnRNycWT5whcHV1Wjy3hDf8X5OashL03YpcKGUIQraAL0KR0KJ9yvJJa2cHSK.XeiHhakibmVNPbtzKggVlhL</session_id>
      <scope xsi:type="xsd:string">idList</scope>
      <type xsi:type="xsd:string">contact</type>
      <maxRows xsi:type="xsd:int">5</maxRows>
      <select href="#id1"/>
      <idList href="#id2"/>
    </q1:query>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[3]">
      <Item>firstName</Item>
      <Item>lastName</Item>
      <Item>businessPhone</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="#id4"/>
      <Item href="#id5"/>
      <Item href="#id6"/>
    </soapenc:Array>
    <tns:mapEntry id="id4" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">field</key>
      <value xsi:type="xsd:string">accountID</value>
    </tns:mapEntry>
    <tns:mapEntry id="id5" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">value</key>
      <value xsi:type="xsd:string">00300000003TLmf</value>
    </tns:mapEntry>
    <tns:mapEntry id="id6" xsi:type="tns:mapEntry">
      <key xsi:type="xsd:string">operator</key>
      <value xsi:type="xsd:string">equals</value>
    </tns:mapEntry>
  </soap:Body>
</soap:Envelope>

Hi,

 I wrote one java program to fetch an opportunity details using query method.(scope is idList).

It was worked well upto yesterday.  When I run the same program Today I am getting SOAP fault with

fault string  select list not specified in query.

Please let me know whether there  is  any change in the  API?  .

I am including my soap request at the end. Please look at the message and advise me if there is any change.

any help would be much appreciated.

Thanks and regards,

Prudhvi

 

 

I am using following soap request to fetch the opp details.

Request:

<?xml version="1.0" encoding="utf-8"?>
<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>
    <tns:headerStruct id="id1">
      <session_id xsi:type="xsd:string">A88zC97HIqHnZIlRhIemUk5cNamuFFrgC8.mkYiGGVDEesUfciyliy._DWGd4UrmD1qjRrjmKArOo.rZcbQUIvbtzKggVlhL</session_id>
      <version xsi:type="xsd:string">2.0</version>
    </tns:headerStruct>
  </soap:Header>
  <soap:Body soap:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
    <q1:query xmlns:q1="sfconnector:SalesforceConnector">
      <version xsi:type="xsd:string">2.0</version>
      <session_id xsi:type="xsd:string">A88zC97HIqHnZIlRhIemUk5cNamuFFrgC8.mkYiGGVDEesUfciyliy._DWGd4UrmD1qjRrjmKArOo.rZcbQUIvbtzKggVlhL</session_id>
      <scope xsi:type="xsd:string">idList</scope>
      <type xsi:type="xsd:string">opportunity</type>
      <maxRows xsi:type="xsd:int">1</maxRows>
      <select href="#id1"/>
      <idList href="#id2"/>
    </q1:query>
    <soapenc:Array id="id1" soapenc:arrayType="xsd:string[9]">
      <Item>id</Item>
      <Item>name</Item>
      <Item>accountID</Item>
      <Item>type</Item>
      <Item>leadSource</Item>
      <Item>amount</Item>
      <Item>closeDate</Item>
      <Item>stage</Item>
      <Item>probability</Item>
      <Item>description</Item>
      <Item>closed</Item>
      <Item>won</Item>
      <Item>createdDate</Item>
      <Item>createdByID</Item>
      <Item>lastModifiedDate</Item>
      <Item>lastModifiedByID</Item>
    </soapenc:Array>
    <soapenc:Array id="id2" soapenc:arrayType="xsd:string[1]">
      <Item>00600000006qJqB</Item>
    </soapenc:Array>
  </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>ÑR</faultcode><faultstring>select list not specified in query</faultstring></soap:Fault></soap:Body></soap:Envelope>