'Air flow DAG has been setup to sync data from salesforce to Big query using REST API. But now it throws the below error
The below error message in Airflow Error log Failed to process query: INVALID_FIELD: IsRichText,RelatedRecordId,InsertedById,BestCommentId from ContactFeed ^ ERROR at Row:1:Column:173 No such column 'BestCommentId' on entity 'ContactFeed'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name.
When troubleshooting this issue found salesforce added a new field "BestCommentId" to contact feed object and the integration user should have access to this field. Since this is a standard field I cannot see this field in the object manager to give permission. Can anyone please help to solve this issue?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|