You need to sign in to do that
Don't have an account?
Unable to filter on ownerID
Hello,
I'm trying to do a query and filter on the ownerID. I grab the ownerID from the login response and send it in the query below. Instead of getting only the recordds for the owner I get all of the records.
<?xml version="1.0"?>
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:SOAP-ENC="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-ENV:Header>
<tns:headerStruct id="id1">
<session_id xsi:type="xsd:string">Y2yEm260JcBXwX.6IxHVST03gigYRpU2jpM7zsrJOEV4dh2tbEampE.tzWjidzk0qxfkZmVvHYFWA2ID7R7JFPbtzKggVlhL</session_id>
<version xsi:type="xsd:string">2.0</version>
</tns:headerStruct>
</SOAP-ENV:Header>
<SOAP-ENV:Body SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<q1:query xmlns:q1="sfconnector:SalesforceConnector">
<scope xsi:type="xsd:string">filter</scope>
<type xsi:type="xsd:string">account</type>
<maxRows xsi:type="xsd:int">100</maxRows>
<select href="#id1"/>
</q1:query>
<SOAP-ENC:Array id="id1" SOAP-ENC:arrayType="xsd:string[6]">
<Item>name</Item>
<Item>billingCity</Item>
<Item>accountPhone</Item>
<Item>ticker</Item>
<Item>id</Item>
<Item>ownerID</Item>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="id2" SOAP-ENC:arrayType="xsd:anyType[1]">
<Item href="#id3"/>
</SOAP-ENC:Array>
<SOAP-ENC:Array id="id3" SOAP-ENC:arrayType="tns:mapEntry[3]">
<Item href="#id4"/>
<Item href="#id5"/>
<Item href="#id6"/>
</SOAP-ENC:Array>
<tns:mapEntry id="id4" xsi:type="tns:mapEntry">
<key xsi:type="xsd:string">field</key>
<value xsi:type="xsd:string">ownerID</value>
</tns:mapEntry>
<tns:mapEntry id="id5" xsi:type="tns:mapEntry">
<key xsi:type="xsd:string">value</key>
<value xsi:type="xsd:string">00530000000bzOA</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>
<useCaseSafeIDs xsi:type="xsd:boolean">1</useCaseSafeIDs>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
Thanks,
Greg
Hi scoop,
Did this get resolved? If not can you send me the username you use to login so I can do some research? Thanks
Dave,
I still have not got this to work. The username of the account I'm logging into is greg@insidescoop.com, it is a developer version. It seems that no matter what ownerid I put in I get all of the accounts back. The other username I tried is cbadger@insidescoop.com.
Thanks.