Salesforce - Data Export error when selecting all fields
I am receiving an error that looks to be related to selecting "all fields" from an object when exporting from Salesforce and using the "Delta" export. Is this not supported, or perhaps do I need to change something in my configuration/flow.
-
Dave Guderian the fields(all) option in Salesforce is pretty limiting. Even if you had this working, then the limit requirement forces only 200 returned results and there isn't a way to get the next 200 results without having another query. I would suggest generating a query that explicitly has every field in the SOQL query itself to avoid this issue and to be able to pull more than 200 results. Something like below:
SELECT ID,ISDELETED,MASTERRECORDID,NAME,TYPE,RECORDTYPEID,PARENTID,BILLINGSTREET,BILLINGCITY,BILLINGSTATE,BILLINGPOSTALCODE,BILLINGCOUNTRY,BILLINGLATITUDE,BILLINGLONGITUDE,BILLINGGEOCODEACCURACY,BILLINGADDRESS,SHIPPINGSTREET,SHIPPINGCITY,SHIPPINGSTATE,SHIPPINGPOSTALCODE,SHIPPINGCOUNTRY,SHIPPINGLATITUDE,SHIPPINGLONGITUDE,SHIPPINGGEOCODEACCURACY,SHIPPINGADDRESS,PHONE,FAX,ACCOUNTNUMBER,WEBSITE,PHOTOURL,SIC,INDUSTRY,ANNUALREVENUE,NUMBEROFEMPLOYEES,OWNERSHIP,TICKERSYMBOL,DESCRIPTION,RATING,SITE,OWNERID,CREATEDDATE,CREATEDBYID,LASTMODIFIEDDATE,LASTMODIFIEDBYID,SYSTEMMODSTAMP,LASTACTIVITYDATE,LASTVIEWEDDATE,LASTREFERENCEDDATE,JIGSAW,JIGSAWCOMPANYID,CLEANSTATUS,ACCOUNTSOURCE,DUNSNUMBER,TRADESTYLE,NAICSCODE,NAICSDESC,YEARSTARTED,SICDESC,DANDBCOMPANYID,CUSTOMERPRIORITY__C,SLA__C,ACTIVE__C,NUMBEROFLOCATIONS__C,UPSELLOPPORTUNITY__C,SLASERIALNUMBER__C,SLAEXPIRATIONDATE__C,CELIGO_SFNSIO__CHANNEL_TIER__C,CELIGO_SFNSIO__TEST_MODE_RECORD__C,YTD_SALES__C,X18_DIGIT_SF_ID__C,SBQQ__ASSETQUANTITIESCOMBINED__C,SBQQ__COTERMEDCONTRACTSCOMBINED__C,SBQQ__COTERMINATIONEVENT__C,SBQQ__CONTRACTCOTERMINATION__C,CELIGO_SFNSIO__ACCOUNT_BALANCE__C,CELIGO_SFNSIO__CREDIT_HOLD__C,CELIGO_SFNSIO__CREDIT_LIMIT__C,CELIGO_SFNSIO__DAYS_OVERDUE__C,CELIGO_SFNSIO__NETSUITE_ID__C,CELIGO_SFNSIO__NETSUITE_RECORD__C,CELIGO_SFNSIO__NETSUITE_SYNC_ERROR__C,CELIGO_SFNSIO__OVERDUE_BALANCE__C,CELIGO_SFNSIO__SKIP_EXPORT_TO_NETSUITE__C,CELIGO_SFNSIO__UNBILLED_ORDERS__C,SBQQ__DEFAULTOPPORTUNITY__C,SBQQ__IGNOREPARENTCONTRACTEDPRICES__C,SBQQ__PRESERVEBUNDLE__C,SBQQ__PRICEHOLDEND__C,SBQQ__RENEWALMODEL__C,SBQQ__RENEWALPRICINGMETHOD__C,SBQQ__TAXEXEMPT__C,PRICE_LEVEL__C,SHOPIFY_ID__C,HUBSPOT_ID__C,ACUMATICA_CUSTOMER_ID__C,CELIGO_MSBC__BUSINESS_CENTRAL_ID__C,ACTIVE_OPPORTUNITIES__C,ACTIVE_OPPORTUNITY_AMOUNT__C,IS_ADVISOR__C,CELIGO_MSBC__SKIP_EXPORT_TO_BUSINESS_CENTRAL__C,SALESFORCE_URL__C,EXTERNAL_SYSTEM_ID__C,STRIPE_CUSTOMER_LINK__C,REPORTING_LOCATION__C,BRANCH__C,CELIGO_BYD__ACCOUNT_ID__C,CELIGO_BYD__SKIP_EXPORT_TO_SAP_BYD__C FROM ACCOUNT
To get the list of fields available, you could download from object manager, build a SOQL query such as the one below, or use Salesforce api to describe the object.
SELECT EntityDefinition.QualifiedApiName, QualifiedApiName, DataType
FROM FieldDefinition
WHERE EntityDefinition.QualifiedApiName IN ('Account')
0 -
Thanks Tyler! I went with exporting the object fields and then putting them in a massive query like you have and it worked perfectly! It would be nice if there wasn't the limitation when selecting all fields, but I realize that is a Salesforce constraint and not Celigo.
Thanks again!
0
Please sign in to leave a comment.
Comments
2 comments