# Datalake Salesforce Export **URL:** \ **Category:** Integrator.io\ **Tags:** scheduling, amazon-s3, export, salesforce, flow-builder\ **Created:** [March 22, 2024, 5:23pm UTC](https://connective.celigo.com/t/datalake-salesforce-export/187 "2024-03-22T17:23:17Z")\ **Posts on this page:** 7\ **Page:** 2
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 19, 2024, 3:59pm UTC](https://connective.celigo.com/t/datalake-salesforce-export/187/21 "2024-04-19T15:59:03Z")
@daveguderian is that field deprecated in Salesforce? I don't have any field filters now, but it could be easily added. I'm curious what is different about that specific field that makes it ineligible to query. ---
**Author:** ![daveguderian](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@daveguderian](https://connective.celigo.com/u/daveguderian)\ **Post date:** [April 19, 2024, 9:08pm UTC](https://connective.celigo.com/t/datalake-salesforce-export/187/22 "2024-04-19T21:08:19Z")
Tyler - I believe its because of the child relationship. For example, in order to return values I have to query: select id, (Select id from RenewedInsurancePolicies) from insurancepolicy ![5301043caa20740200000001-c5c671381d174afcaf3271dff94ea6de.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/c/c860935e1f78e7ae7fc08e972b8bea192a11bf95.png) ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 25, 2024, 2:16am UTC](https://connective.celigo.com/t/datalake-salesforce-export/187/23 "2024-04-25T02:16:50Z")
@daveguderian the screenshot you sent doesn't match up to the error? The errors says it's an issue with a field named "CoverageCode". ---
**Author:** ![daveguderian](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@daveguderian](https://connective.celigo.com/u/daveguderian)\ **Post date:** [April 25, 2024, 2:19am UTC](https://connective.celigo.com/t/datalake-salesforce-export/187/24 "2024-04-25T02:19:20Z")
Thats my fault Tyler. This is the correct error. ![5301043caa20740200000001-e4a5ccce5e7d46ea99656ab27164e416.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/2/24eb593c229f6862248815670d1911ebf3ddfbf3.png) ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 25, 2024, 2:36am UTC](https://connective.celigo.com/t/datalake-salesforce-export/187/25 "2024-04-25T02:36:20Z")
What's the api name for that field? I have a similar field setup and it works fine. Here is my field from the describe lookup call. Can you do the describe call for this object and send me what the metadata for that field looks like? ``` { "aggregatable": true, "aiPredictionField": false, "autoNumber": false, "byteLength": 18, "calculated": false, "calculatedFormula": null, "cascadeDelete": false, "caseSensitive": false, "compoundFieldName": null, "controllerName": null, "createable": true, "custom": true, "defaultValue": null, "defaultValueFormula": null, "defaultedOnCreate": false, "dependentPicklist": false, "deprecatedAndHidden": false, "digits": 0, "displayLocationInDecimal": false, "encrypted": false, "externalId": false, "extraTypeInfo": null, "filterable": true, "filteredLookupInfo": null, "formulaTreatNullNumberAsZero": false, "groupable": true, "highScaleNumber": false, "htmlFormatted": false, "idLookup": false, "inlineHelpText": null, "label": "Contact", "length": 18, "mask": null, "maskType": null, "name": "ContactCustom__c", "nameField": false, "namePointing": false, "nillable": true, "permissionable": true, "picklistValues": [], "polymorphicForeignKey": false, "precision": 0, "queryByDistance": false, "referenceTargetField": null, "referenceTo": ["Contact"], "relationshipName": "ContactCustom__r", "relationshipOrder": null, "restrictedDelete": false, "restrictedPicklist": false, "scale": 0, "searchPrefilterable": true, "soapType": "tns:ID", "sortable": true, "type": "reference", "unique": false, "updateable": true, "writeRequiresMasterRead": false } ``` ---
**Author:** ![daveguderian](https://avatars.discourse-cdn.com/v4/letter/d/ce7236/32.png) [@daveguderian](https://connective.celigo.com/u/daveguderian)\ **Post date:** [April 25, 2024, 2:51am UTC](https://connective.celigo.com/t/datalake-salesforce-export/187/26 "2024-04-25T02:51:18Z")
Will this work? I used a little different method.... not as pretty I know. Let me know, and I can do the describe call if not. ``` All available metadata for "RenewedFromPolicyId" ``` | ``` Key ``` | ``` Value ``` | | --- | --- | | ``` 🔍 desc.aggregatable ``` | ``` true ``` | | ``` 🔍 desc.aiPredictionField ``` | ``` false ``` | | ``` 🔍 desc.autoNumber ``` | ``` false ``` | | ``` 🔍 desc.byteLength ``` | ``` 18 ``` | | ``` 🔍 desc.calculated ``` | ``` false ``` | | ``` 🔍 desc.calculatedFormula ``` | ``` (Blank) ``` | | ``` 🔍 desc.cascadeDelete ``` | ``` false ``` | | ``` 🔍 desc.caseSensitive ``` | ``` false ``` | | ``` 🔍 desc.compoundFieldName ``` | ``` (Blank) ``` | | ``` 🔍 desc.controllerName ``` | ``` (Blank) ``` | | ``` 🔍 desc.createable ``` | ``` true ``` | | ``` 🔍 desc.custom ``` | ``` false ``` | | ``` 🔍 desc.defaultValue ``` | ``` (Blank) ``` | | ``` 🔍 desc.defaultValueFormula ``` | ``` (Blank) ``` | | ``` 🔍 desc.defaultedOnCreate ``` | ``` false ``` | | ``` 🔍 desc.dependentPicklist ``` | ``` false ``` | | ``` 🔍 desc.deprecatedAndHidden ``` | ``` false ``` | | ``` 🔍 desc.digits ``` | ``` 0 ``` | | ``` 🔍 desc.displayLocationInDecimal ``` | ``` false ``` | | ``` 🔍 desc.encrypted ``` | ``` false ``` | | ``` 🔍 desc.externalId ``` | ``` false ``` | | ``` 🔍 desc.extraTypeInfo ``` | ``` (Blank) ``` | | ``` 🔍 desc.filterable ``` | ``` true ``` | | ``` 🔍 desc.filteredLookupInfo ``` | ``` (Blank) ``` | | ``` 🔍 desc.formulaTreatNullNumberAsZero ``` | ``` false ``` | | ``` 🔍 desc.groupable ``` | ``` true ``` | | ``` 🔍 desc.highScaleNumber ``` | ``` false ``` | | ``` 🔍 desc.htmlFormatted ``` | ``` false ``` | | ``` 🔍 desc.idLookup ``` | ``` false ``` | | ``` 🔍 desc.inlineHelpText ``` | ``` (Blank) ``` | | ``` 🔍 desc.label ``` | ``` Insurance Policy ID ``` | | ``` 🔍 desc.length ``` | ``` 18 ``` | | ``` 🔍 desc.mask ``` | ``` (Blank) ``` | | ``` 🔍 desc.maskType ``` | ``` (Blank) ``` | | ``` 🔍 desc.name ``` | ``` RenewedFromPolicyId ``` | | ``` 🔍 desc.nameField ``` | ``` false ``` | | ``` 🔍 desc.namePointing ``` | ``` false ``` | | ``` 🔍 desc.nillable ``` | ``` true ``` | | ``` 🔍 desc.permissionable ``` | ``` true ``` | | ``` 🔍 desc.polymorphicForeignKey ``` | ``` false ``` | | ``` 🔍 desc.precision ``` | ``` 0 ``` | | ``` 🔍 desc.queryByDistance ``` | ``` false ``` | | ``` 🔍 desc.referenceTargetField ``` | ``` (Blank) ``` | | ``` 🔍 desc.referenceTo.0 ``` | ``` InsurancePolicy ``` | | ``` 🔍 desc.relationshipName ``` | ``` RenewedFromPolicy ``` | | ``` 🔍 desc.relationshipOrder ``` | ``` (Blank) ``` | | ``` 🔍 desc.restrictedDelete ``` | ``` false ``` | | ``` 🔍 desc.restrictedPicklist ``` | ``` false ``` | | ``` 🔍 desc.scale ``` | ``` 0 ``` | | ``` 🔍 desc.searchPrefilterable ``` | ``` true ``` | | ``` 🔍 desc.soapType ``` | ``` tns:ID ``` | | ``` 🔍 desc.sortable ``` | ``` true ``` | | ``` 🔍 desc.type ``` | ``` reference ``` | | ``` 🔍 desc.unique ``` | ``` false ``` | | ``` 🔍 desc.updateable ``` | ``` true ``` | | ``` 🔍 desc.writeRequiresMasterRead ``` | ``` false ``` | | ``` 🔍 part.attributes.type ``` | ``` EntityParticle ``` | | ``` 🔍 part.attributes.url ``` | ``` /services/data/v60.0/tooling/sobjects/EntityParticle/InsurancePolicy.RenewedFromPolicy ``` | | ``` 🔍 part.QualifiedApiName ``` | ``` RenewedFromPolicyId ``` | | ``` 🔍 part.Label ``` | ``` Insurance Policy ID ``` | | ``` 🔍 part.DataType ``` | ``` reference ``` | | ``` 🔍 part.ReferenceTo.referenceTo.0 ``` | ``` InsurancePolicy ``` | | ``` 🔍 part.Length ``` | ``` 18 ``` | | ``` 🔍 part.Precision ``` | ``` 0 ``` | | ``` 🔍 part.Scale ``` | ``` 0 ``` | | ``` 🔍 part.IsAutonumber ``` | ``` false ``` | | ``` 🔍 part.IsCaseSensitive ``` | ``` false ``` | | ``` 🔍 part.IsDependentPicklist ``` | ``` false ``` | | ``` 🔍 part.IsEncrypted ``` | ``` false ``` | | ``` 🔍 part.IsIdLookup ``` | ``` false ``` | | ``` 🔍 part.IsHtmlFormatted ``` | ``` false ``` | | ``` 🔍 part.IsNillable ``` | ``` true ``` | | ``` 🔍 part.IsUnique ``` | ``` false ``` | | ``` 🔍 part.IsCalculated ``` | ``` false ``` | | ``` 🔍 part.InlineHelpText ``` | ``` (Blank) ``` | | ``` 🔍 part.FieldDefinition.attributes.type ``` | ``` FieldDefinition ``` | | ``` 🔍 part.FieldDefinition.attributes.url ``` | ``` /services/data/v60.0/tooling/sobjects/FieldDefinition/InsurancePolicy.RenewedFromPolicy ``` | | ``` 🔍 part.FieldDefinition.DurableId ``` | ``` InsurancePolicy.RenewedFromPolicy ``` | | ``` 🔍 part.EntityDefinition.attributes.type ``` | ``` EntityDefinition ``` | | ``` 🔍 part.EntityDefinition.attributes.url ``` | ``` /services/data/v60.0/tooling/sobjects/EntityDefinition/InsurancePolicy ``` | | ``` 🔍 part.EntityDefinition.DurableId ``` | ``` InsurancePolicy ``` | ---
**Author:** ![tylerlamparter](https://sea1.discourse-cdn.com/flex001/user_avatar/connective.celigo.com/tylerlamparter/32/9204_2.png) [@tylerlamparter](https://connective.celigo.com/u/tylerlamparter)\ **Post date:** [April 26, 2024, 4:09pm UTC](https://connective.celigo.com/t/datalake-salesforce-export/187/27 "2024-04-26T16:09:57Z")
@daveguderian can we cover in office hours next week? I'm not too sure here. [Previous page](https://connective.celigo.com/t/datalake-salesforce-export/187.md?page=1)