Datalake Salesforce Export

[tylerlamparter]

@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.

[daveguderian]

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

[tylerlamparter]

@daveguderian the screenshot you sent doesn't match up to the error? The errors says it's an issue with a field named "CoverageCode".

[daveguderian]

Thats my fault Tyler. This is the correct error.

[tylerlamparter]

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
        }

[daveguderian]

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

[tylerlamparter]

@daveguderian can we cover in office hours next week? I'm not too sure here.