I'm currently only able to retrieve non-boolean columns from a SOQL query when using the SforceEnterpriseClient. In the below query Columns1 and Column2 fail to return data to me.
SELECT Column1__c, Column2__c, Column3__c, Column4__c, Column5__c, Column6__c
FROM Table__c
where Column5__c >= 2016-09-29
If I execute the same query in WorkBench it works fine so I think it must be a setting I'm missing. Column1 and Column2 are booleans.
Full code usage:
try {
$salesforce = new SforceEnterpriseClient();
$salesforce->createConnection('salesforce_connector/soapclient/enterprise.wsdl.xml');
$salesforce->login('user', 'pass');
$query = 'SELECT Column1__c, Column2__c, Column3__c, Column4__c, Column5__c, Column6__c
FROM Table__c
where Column3__c >= ' . date('Y-m-d');
$options = new QueryOptions(2000);
$salesforce->setQueryOptions($options);
$response = $salesforce->query($query);
die(print_r($response));
Response (Single example):
[1878] => SObject Object
(
[type] =>
[fields] =>
[Column3__c] => 2016-12-31
[Column4__c] => 0022000000abcHcAAI
[Column5__c] => 43892
[Column6__c] => 2013-06-01
)
SforceBaseClient.php
hasprotected $version = '20.0';
.Field-level security
it is set tovisible
for all users. The only other option there isread-only
though so maybe I'm looking at the wrong place? I'm inCustom Field Definition Detail
.