AnsweredAssumed Answered

Profile to pull all items in SOQL query from Salesforce?

Question asked by cathryn.crane207763 on Mar 7, 2018
Latest reply on Mar 8, 2018 by cathryn.crane207763

Hi Everyone

 

I have successfully created a SOQL query in Salesforce thanks to the help in the forum in a separate post.  Now the problem I'm having is it's not pulling all the fields in the query.  It's only pulling some of the fields.  

 

Normally there is a profile to associate with a database call but with SOQL, there isn't so I'm wondering how Boomi is determining which fields to pull vs what the query is saying to pull?  Is it cached somewhere that I need to clear out?

 

 

I've provided the process flow leading up to the call, the SOQL and the results that I get:

 

 

SOQL:

 

select Account.ID,
Opportunity_Number__c, Opportunity.Name, Opportunity.Invoice_recipient__c, Account.GP_Customer_ID__c,
Account.Name,
Account.Account_ID_18__c,
Business_Unit__c,
Account.BillingStreet,
Account.BillingCity,
Account.BillingState,
Account.BillingPostalCode,
Account.BillingCountry,
Account.ShippingStreet,
Account.ShippingCity,
Account.ShippingState,
Account.ShippingPostalCode,
Account.ShippingCountry
FROM Opportunity
WHERE Order_Verified__c = True
AND Order_Fulfilled__c = False
AND LastModifiedDate >= {1}
AND Invoice_recipient__c = {2}
AND Account.GP_Customer_ID__c = {3}
AND (Business_Unit__c = {4} OR Business_Unit__c = {5})

 

Results:

 

 

You can see that it's missing the address info and Business Unit fields.

 

Thanks!

 

Cathryn

Outcomes