function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
JuiceJuice 

Query using Filter Fails

I'm trying to retrieve an opportunity using a modified version of the sample from the API document.  This used to work for me, but it stopped working for me this evening.  I receive an error saying that the select list is not specified.

The SOAP request is as follows:

<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">{SessionID}</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">

<type xsi:type="xsd:string">opportunity</type>

<maxRows xsi:type="xsd:int">200</maxRows>

<scope xsi:type="xsd:string">filter</scope>

<select href="#id1"/>

<filter href="#id2"/>

</q1:query>

<soapenc:Array id="id1" soapenc:arrayType="xsd:string[4]">

<Item>id</Item>

<Item>ownerID</Item>

<Item>name</Item>

<Item>accountID</Item>

<Item>type</Item>

<Item>leadSource</Item>

<Item>amount</Item>

<Item>expectedAmount</Item>

<Item>closeDate</Item>

<Item>nextStep</Item>

<Item>stage</Item>

<Item>probability</Item>

<Item>campaignID</Item>

<Item>description</Item>

<Item>closed</Item>

<Item>won</Item>

<Item>forecastCategory</Item>

<Item>createdDate</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="id4" xsi:type="tns:mapEntry">

<key xsi:type="xsd:string">field</key>

<value xsi:type="xsd:string">{Field}</value>

</tns:mapEntry>

<tns:mapEntry id="id5" xsi:type="tns:mapEntry">

<key xsi:type="xsd:string">value</key>

<value xsi:type="xsd:{ValueType}">{Value}</value>

</tns:mapEntry>

<tns:mapEntry id="id6" xsi:type="tns:mapEntry">

<key xsi:type="xsd:string">operator</key>

<value xsi:type="xsd:string">{Operator}</value>

</tns:mapEntry>

</soap:Body>

</soap:Envelope>

JuiceJuice

Tarak:

It looks like your post was cut off for some reason?  Are you having the same problem?
Tarak SilliniTarak Sillini

Hi, I am having the same issue. a "filter" query to the campaignMember table worked yesterday but today it returns the "select list not specified in query" error. My selectList is there and populated with 2 fields. Something strange is that the faultcode is "ÑR"... this is supposed to be a 1xxx number....

thanks,

Tarak Sillini
Kaydara Inc.
DevAngel2DevAngel2

Hi Juice,

The problem is not your code.  There is a problem on our side from a build last night.  We are working on a new build as we speak.
Tarak SilliniTarak Sillini

I am using vb.net and a modified version of the simplequery sample to test this. here is the query

<?xml version="1.0" encoding="utf-8" ?>

<soap:Envelope xmlnssoap="http://schemas.xmlsoap.org/soap/envelope/" xmlnssoapenc="http://schemas.xmlsoap.org/soap/encoding/"

xmlnstns="salesforce" xmlnstypes="salesforce/encodedTypes" xmlnsxsi="http://www.w3.org/2001/XMLSchema-instance"

xmlnsxsd="http://www.w3.org/2001/XMLSchema">

<soap:Header>

<tns:headerStruct id="h_id1">

<session_id xsitype="xsd:string">-wasremoved-</session_id>

<version xsitype="xsd:string">2.0</version>

</tns:headerStruct>

</soap:Header>

<soap:Body soapencodingStyle="http://schemas.xmlsoap.org/soap/encoding/">

<q1:query xmlnsq1="sfconnector:SalesforceConnector">

<scope xsitype="xsd:string">filter</scope>

<type xsitype="xsd:string">campaignMember</type>

<maxRows xsitype="xsd:int">0</maxRows>

<select href="#id1" />

<filter href="#id2" />

<ifModifiedSince xsitype="xsd:dateTime">0001-01-01T00:00:00.0000000-05:00</ifModifiedSince>

<useCaseSafeIDs xsitype="xsd:boolean">false</useCaseSafeIDs>

</q1:query>

<soapenc:Array id="id1" soapencarrayType="xsd:string[2]">

<Item>contactID</Item>

<Item>campaignID</Item>

</soapenc:Array>

<soapenc:Array id="id2" soapencarrayType="xsd:anyType[1]">

<Item href="#id3" />

</soapenc:Array>

<soapenc:Array id="id3" soapencarrayType="tns:mapEntry[3]">

<Item href="#id4" />

<Item href="#id5" />

<Item href="#id6" />

</soapenc:Array>

<tns:mapEntry id="id4" xsitype="tns:mapEntry">

<key xsitype="xsd:string">field</key>

<value xsitype="xsd:string">contactID</value>

</tns:mapEntry>

<tns:mapEntry id="id5" xsitype="tns:mapEntry">

<key xsitype="xsd:string">value</key>

<value xsitype="xsd:string">00300000003ZBQM</value>

</tns:mapEntry>

<tns:mapEntry id="id6" xsitype="tns:mapEntry">

<key xsitype="xsd:string">operator</key>

<value xsitype="xsd:string">equals</value>

</tns:mapEntry>

</soap:Body>

</soap:Envelope>

 
Tarak SilliniTarak Sillini
here's the response

<soap:Envelope xmlnssoap="http://schemas.xmlsoap.org/soap/envelope/" xmlnssoapenc="http://schemas.xmlsoap.org/soap/encoding/"

xmlnstns="salesforce" xmlnstypes="salesforce/encodedTypes" xmlnsxsi="http://www.w3.org/2001/XMLSchema-instance"

xmlnsxsd="http://www.w3.org/2001/XMLSchema">

<soap:Header />

<soap:Body>

<soap:Fault>

<faultcode>ÃÅ</faultcode>

<faultstring>select list not specified in query</faultstring>

</soap:Fault>

</soap:Body>

</soap:Envelope>
DevAngel2DevAngel2

Hello All,

The issue with query filter has been resolved.
JuiceJuice

Okay, it seems to be working now.  Thanks!
DevAngelDevAngel

Phew!

I was getting worried!