davispeixoto/Laravel-5-Salesforce

Not all fields returning

Closed this issue · 1 comments

chorton commented

I'm executing the query:

SELECT Id, IsDeleted, MasterRecordId, Name, Type, RecordTypeId, ParentId, BillingStreet, BillingCity, BillingState, BillingPostalCode, BillingCountry, ShippingStreet, ShippingCity, ShippingState, ShippingPostalCode, ShippingCountry, Phone, Fax, AccountNumber, Website, Sic, Industry, AnnualRevenue, NumberOfEmployees, Ownership, TickerSymbol, Description, Rating, Site, OwnerId, CreatedDate, CreatedById, LastModifiedDate, LastModifiedById, SystemModstamp, LastActivityDate, AccountSource, DunsNumber, Tradestyle, NaicsCode, NaicsDesc, YearStarted, SicDesc, ExternalID__c, Status__c, Data_Quality_Description__c, Data_Quality_Score__c, Original_Created_Date__c, Wowza_User_Id_Import__c, Date_1_to_2_Upgrade_Completed__c, Note_Audit_Original_Purchase__c, Date_Received_Server_2_Destructn_Letter__c, Current_License_Level__c, Custom_Discount__c, Number_of_Zuora_Billing_Accounts__c, RecordTypeImage__c, Publicity_Consent__c, CRM_ID__c, Referral_Code__c, Child_Accounts__c, ResellerTier__c, Field_to_Update__c, Industry_Sub_Segment__c, AccountType__c, AllSubscriptionsCancelled__c, AssetChange__c, CloudSubscriptionAddOns__c, CloudSubscription__c, ComplianceStatus__c, CurrentCustomer__c, DRMAddOn__c, Expiring__c, IsCustomer__c, LastInvoiceDate__c, LastInvoiced__c, LimitedConnection__c, Record_Type_Name__c, Balance__c, StrategicAccount__c, TopAccount__c, MACLocked__c, MediaCache__c, OEMAgreementSigned__c, Maintenance_Fee__c, Maintenance_Fee_per_License__c, Flat_Maintenance_Fee__c, Maintenance_Fee_Notes__c, Total_Payments__c, Is_One_Off_Reseller__c, BillingContact__c, AccountContact__c, Contact_for_Flagged__c, OEMAgreementType__c, OEMProductOffering__c, Offline__c, PlayerSubscriptionAddOns__c, PlayerSubscription__c, PriceList__c, ResellerAgreementSigned__c, SolutionPartner__c, Standard__c, StreamLock__c, SubscriptionStatus__c, TechAlliance__c, TranscoderAddOn__c, USBv4only__c, WSELastPurchase__c, WSEMonthlyDailyAddOns__c, WSEMonthlyDaily__c, WSEPerpetualAddOns__c, WSEPerpetual__c, WorksWithWowza__c, nDVRAddOn__c, v2__c, v335andearlier__c, v3Post35__c, v4__c, Id18__c, ParentId18__c, ZuoraBillingAccountNumber__c, LoginId__c, VIP__c, WSE_AddOns__c, Transmonogrammificationator__c, Account_Manager__c, Enrollment_Date__c, Account_Size__c, Growth_Projection__c, Overall_Satisfaction_Rating__c, Primary_Wowza_Version__c, Reason_Enrolled__c, Support_Satisfaction_Rating__c, Wowza_Use_Projection__c, Active_Commercial_Keys__c, Engaged__c, Account_Name_Length__c, Import_Date__c, Import_Reason__c, RPS_Date__c, RPS_Status__c, isPartner__c, Allow_M_S_for_all_Contacts__c, No_of_WSE_4_License_Keys__c, License_Key_Count__c, Billing_Account_Total_Revenue__c, Region__c, Executive_Sponsor__c,Primary_License_Type__c FROM Account

But the results returning are only giving me the following fields:

[records] => Array
    (
        [0] => stdClass Object
            (
                [Id] => 001q000000bYsxJAAS
                [CreatedById] => 005d0000000zk6hAAA
                [CreatedDate] => 2016-09-25T21:41:57.000Z
                [IsDeleted] =>
                [LastModifiedById] => 005d0000000zQSPAA2
                [LastModifiedDate] => 2016-09-25T21:42:04.000Z
                [Name] => test
                [OwnerId] => 005d0000000zk6hAAA
                [ParentId] => 001q000000Rb7obAAB
                [SystemModstamp] => 2016-09-25T22:00:22.000Z
                [Type] => Customer
            )

    )

But yet in the __last_response value xml, I see all the fields I included in my query with their values.

[__last_response] => <?xml version="1.0" encoding="UTF-8"?><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns="urn:enterprise.soap.sforce.com" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:sf="urn:sobject.enterprise.soap.sforce.com"><soapenv:Body><queryAllResponse><result><done>true</done><queryLocator xsi:nil="true"/><records xsi:type="sf:Account"><sf:Id>001q000000bYsxJAAS</sf:Id><sf:AccountContact__c>003q000000WwxdDAAR</sf:AccountContact__c><sf:AccountType__c>Direct Channel</sf:AccountType__c><sf:Account_Name_Length__c>4.0</sf:Account_Name_Length__c><sf:AllSubscriptionsCancelled__c>false</sf:AllSubscriptionsCancelled__c><sf:Allow_M_S_for_all_Contacts__c>false</sf:Allow_M_S_for_all_Contacts__c><sf:BillingContact__c>003q000000WwxdDAAR</sf:BillingContact__c><sf:Billing_Account_Total_Revenue__c>0.0</sf:Billing_Account_Total_Revenue__c><sf:CRM_ID__c>001q000000bYsxJAAS</sf:CRM_ID__c><sf:CloudSubscription__c>false</sf:CloudSubscription__c><sf:CreatedById>005d0000000zk6hAAA</sf:CreatedById><sf:CreatedDate>2016-09-25T21:41:57.000Z</sf:CreatedDate><sf:CurrentCustomer__c>&lt;img src=&quot;/img/msg_icons/error16.png&quot; alt=&quot;/img/checkbox_unchecked.gif&quot; border=&quot;0&quot;/&gt;</sf:CurrentCustomer__c><sf:DRMAddOn__c>false</sf:DRMAddOn__c><sf:Data_Quality_Description__c>Missing: Industry, Rating, Complete Address, Phone,</sf:Data_Quality_Description__c><sf:Data_Quality_Score__c>40.0</sf:Data_Quality_Score__c><sf:Engaged__c>false</sf:Engaged__c><sf:Enrollment_Date__c>2016-09-25</sf:Enrollment_Date__c><sf:Expiring__c>false</sf:Expiring__c><sf:ExternalID__c>test(3981)</sf:ExternalID__c><sf:Field_to_Update__c>false</sf:Field_to_Update__c><sf:Id18__c>001q000000bYsxJAAS</sf:Id18__c><sf:IsCustomer__c>Stop</sf:IsCustomer__c><sf:IsDeleted>false</sf:IsDeleted><sf:Is_One_Off_Reseller__c>false</sf:Is_One_Off_Reseller__c><sf:LastModifiedById>005d0000000zQSPAA2</sf:LastModifiedById><sf:LastModifiedDate>2016-09-25T21:42:04.000Z</sf:LastModifiedDate><sf:LimitedConnection__c>false</sf:LimitedConnection__c><sf:MACLocked__c>false</sf:MACLocked__c><sf:MediaCache__c>false</sf:MediaCache__c><sf:Name>test</sf:Name><sf:Number_of_Zuora_Billing_Accounts__c>0.0</sf:Number_of_Zuora_Billing_Accounts__c><sf:Offline__c>false</sf:Offline__c><sf:OwnerId>005d0000000zk6hAAA</sf:OwnerId><sf:ParentId>001q000000Rb7obAAB</sf:ParentId><sf:ParentId18__c>001q000000Rb7obAAB</sf:ParentId18__c><sf:PlayerSubscription__c>false</sf:PlayerSubscription__c><sf:RPS_Date__c>2016-09-25T21:42:33.000Z</sf:RPS_Date__c><sf:RPS_Status__c>Yellow</sf:RPS_Status__c><sf:RecordTypeId>012d0000000Sy2aAAC</sf:RecordTypeId><sf:Record_Type_Name__c>Zuora</sf:Record_Type_Name__c><sf:SolutionPartner__c>false</sf:SolutionPartner__c><sf:Standard__c>false</sf:Standard__c><sf:Status__c>Active</sf:Status__c><sf:StrategicAccount__c>false</sf:StrategicAccount__c><sf:StreamLock__c>false</sf:StreamLock__c><sf:SystemModstamp>2016-09-25T22:00:22.000Z</sf:SystemModstamp><sf:TechAlliance__c>false</sf:TechAlliance__c><sf:TopAccount__c>false</sf:TopAccount__c><sf:Total_Payments__c>0.0</sf:Total_Payments__c><sf:TranscoderAddOn__c>false</sf:TranscoderAddOn__c><sf:Type>Customer</sf:Type><sf:USBv4only__c>false</sf:USBv4only__c><sf:WSEMonthlyDaily__c>false</sf:WSEMonthlyDaily__c><sf:WSEPerpetual__c>false</sf:WSEPerpetual__c><sf:WorksWithWowza__c>false</sf:WorksWithWowza__c><sf:isPartner__c>false</sf:isPartner__c><sf:nDVRAddOn__c>false</sf:nDVRAddOn__c><sf:v2__c>false</sf:v2__c><sf:v335andearlier__c>false</sf:v335andearlier__c><sf:v3Post35__c>false</sf:v3Post35__c><sf:v4__c>false</sf:v4__c></records><size>1</size></result></queryAllResponse></soapenv:Body></soapenv:Envelope>

chorton commented

I figured it out. Found the other issues where there was reference to the wsdl cache.

I added ini_set("soap.wsdl_cache_enabled", "0"); and I'm now getting all the fields.