Apex Code Development You need to sign in to do that
Don't have an account?
Juan Romero Query behavior
Hi again,
I am issuing a query to the server with 50 fields to retrieve on a select struct.
The server response contains only 16 fields. What am I doing wrong?
Here is the request: (I will post the response in a nother message)
<?xml version="1.0"?>
<methodCall>
<methodName>sfdc.query</methodName>
<params>
<param>
<value>
<struct>
<member>
<name>select</name>
<value>
<array>
<data>
<value>
<string>ownerID</string>
</value>
<value>
<string>name</string>
</value>
<value>
<string>00N30000000VPsr</string>
</value>
<value>
<string>00N30000000G3Tj</string>
</value>
<value>
<string>00N30000000YHdi</string>
</value>
<value>
<string>00N30000000byNQ</string>
</value>
<value>
<string>00N30000000G5vW</string>
</value>
<value>
<string>url</string>
</value>
<value>
<string>sales</string>
</value>
<value>
<string>industry</string>
</value>
<value>
<string>00N30000000D3zr</string>
</value>
<value>
<string>employees</string>
</value>
<value>
<string>rating</string>
</value>
<value>
<string>00N30000000G5X8</string>
</value>
<value>
<string>00N30000000G5XQ</string>
</value>
<value>
<string>00N30000000CKdy</string>
</value>
<value>
<string>00N30000000G5Wc</string>
</value>
<value>
<string>00N30000000G5WK</string>
</value>
<value>
<string>00N30000000G5Wp</string>
</value>
<value>
<string>00N30000000bnLX</string>
</value>
<value>
<string>00N30000000aLsJ</string>
</value>
<value>
<string>00N30000000aLt0</string>
</value>
<value>
<string>00N30000000aLuh</string>
</value>
<value>
<string>00N30000000aLsY</string>
</value>
<value>
<string>00N30000000aLrG</string>
</value>
<value>
<string>00N30000000aO4j</string>
</value>
<value>
<string>00N30000000LEys</string>
</value>
<value>
<string>00N30000000boRp</string>
</value>
<value>
<string>00N30000000boS0</string>
</value>
<value>
<string>00N30000000aLqy</string>
</value>
<value>
<string>00N30000000boRu</string>
</value>
<value>
<string>00N30000000boRv</string>
</value>
<value>
<string>00N30000000buei</string>
</value>
<value>
<string>00N30000000buej</string>
</value>
<value>
<string>00N30000000buek</string>
</value>
<value>
<string>00N30000000buel</string>
</value>
<value>
<string>00N30000000CKds</string>
</value>
<value>
<string>00N30000000CKdw</string>
</value>
<value>
<string>00N30000000G5UU</string>
</value>
<value>
<string>00N30000000G5YO</string>
</value>
<value>
<string>00N30000000bnLZ</string>
</value>
<value>
<string>00N30000000aLrd</string>
</value>
<value>
<string>00N30000000aLtC</string>
</value>
<value>
<string>00N30000000aLup</string>
</value>
<value>
<string>00N30000000aLrS</string>
</value>
<value>
<string>00N30000000aLsj</string>
</value>
<value>
<string>00N30000000LEyk</string>
</value>
<value>
<string>00N30000000aLqh</string>
</value>
<value>
<string>00N30000000boRq</string>
</value>
<value>
<string>00N30000000boRo</string>
</value>
<value>
<string>00N30000000GAJI</string>
</value>
</data>
</array>
</value>
</member>
<member>
<name>filter</name>
<value>
<array>
<data>
<value>
<struct>
<member>
<name>operator</name>
<value>
<string>equals</string>
</value>
</member>
<member>
<name>field</name>
<value>
<string>id</string>
</value>
</member>
<member>
<name>value</name>
<value>
<string>00130000000OmMaAAK</string>
</value>
</member>
</struct>
</value>
</data>
</array>
</value>
</member>
<member>
<name>version</name>
<value>
<string>2.0</string>
</value>
</member>
<member>
<name>type</name>
<value>
<string>account</string>
</value>
</member>
<member>
<name>scope</name>
<value>
<string>filter</string>
</value>
</member>
<member>
<name>useCaseSafeIDs</name>
<value>
<boolean>1</boolean>
</value>
</member>
</struct>
</value>
</param>
</params>
</methodCall>
Here is the response I get:
<?xml version="1.0" encoding="UTF-8"?>
<methodResponse>
<params>
<param>
<value>
<array>
<data>
<value>
<struct>
<member>
<name>sales</name>
<value><double>169036000.0</double></value>
</member>
<member>
<name>name</name><value>1-800 Contacts Inc</value>
</member>
<member>
<name>00N30000000CKdy</name><value>0</value>
</member>
<member>
<name>url</name><value>www.1800contacts.com</value>
</member>
<member>
<name>00N30000000aLt0</name><value>Yes</value>
</member>
<member>
<name>00N30000000G5Wp</name><value>- / - / -</value>
</member>
<member>
<name>00N30000000boRv</name><value>59619916</value>
</member>
<member>
<name>00N30000000D3zr</name><value>Office Supplies</value>
</member>
<member>
<name>ownerID</name><value>00530000000A1TZAA0</value>
</member>
<member>
<name>00N30000000boRu</name><value>38270000</value>
</member>
<member>
<name>00N30000000VPsr</name><value>May</value>
</member>
<member>
<name>00N30000000byNQ</name><value>Cold Call</value>
</member>
<member>
<name>00N30000000G5vW</name><value>ZapData 5961 B2B I</value>
</member>
<member>
<name>employees</name><value><int>382</int></value>
</member>
<member>
<name>industry</name><value>Business to Business</value>
</member>
<member>
<name>00N30000000aLqy</name><value>Yes</value>
</member>
<member>
<name>00N30000000GAJI</name><value><double>11787.0</double></value>
</member>
</struct>
</value>
</data>
</array>
</value>
</param>
</params>
</methodResponse>
Hi Juan,
If there is no data for any records that match the query for one of the fields that you put in the select list, you will not recieve that field in the response.
So, if there is a field called "Marlins Win" and none of the records have a value in this field, you will not get this field returned in the response.
Yes, thank you DevAngel,
I realized this about 30 seconds before you replied : ), lol
By the way, could you please check the message board? Sometimes, when I submit a posting or a rating (any submission), it shows me an error page, although it has in fact posted the information, so when I hit back on the browser, the thread now contains my submission.
Not much of a problem, rather an annoyance, to have to go back and foward.
Thanks!