Troubleshooting Salesforce Ingestion Error: 'sObject type 'CustomField' is not supported.'

ingestion
1

Original Slack Thread

Hi team, I am facing another problem with salesforce, when I execute the recipe, I am getting the following error. ERROR {datahub.entrypoints:205} - Command failed: Malformed request <https://psa-customerfirst--vision.sandbox.my.salesforce.com/services/data/v61.0/tooling/query?q=SELECT%20DeveloperName,CreatedDate,CreatedBy.Username,InlineHelpText,LastModifiedDate,LastModifiedBy.Username%20FROM%20CustomField%20WHERE%20EntityDefinitionId='Account'>. Response content: [{'message': "sObject type 'CustomField' is not supported.", 'errorCode': 'INVALID_TYPE'}]

2

Hey there! :wave: Make sure your message includes the following information if relevant, so we can help more effectively!

  1. Are you using UI or CLI for ingestion?
  2. Which DataHub version are you using? (e.g. 0.12.0)
  3. What data source(s) are you integrating with DataHub? (e.g. BigQuery)

<@U06TM7M40RK> Can you help with the questions in this thread?

:information_source: We’re experimenting with a new AI assistant for questions in the <#CUMUWQU66> channel to help you track down helpful resources more quickly. Keep in mind that responses may not always be spot-on; feel free to ask it follow-up questions and don’t forget to provide its responses a :thumbsup: or :thumbsdown: so other folks in the Community know if you’re still looking for help on the topic!

3

Hi there! To help you more effectively, could you please provide the following information?

  1. Are you using the UI or CLI for ingestion?
  2. Which DataHub version are you using? (e.g., 0.12.0)?
  3. What data source(s) are you integrating with DataHub? (e.g., BigQuery)?

Based on the error message you provided, it seems like the issue is related to the Salesforce ingestion process. Specifically, the error indicates that the CustomField sObject type is not supported. This issue has been encountered before and can be related to the permissions of the Salesforce user account being used for the ingestion.

According to the <https://github.com/datahub-project/datahub/blob/master/metadata-ingestion/docs/sources/salesforce/salesforce_pre.md|Salesforce ingestion documentation>, the account used to access Salesforce requires the following permissions for the integration to work:

  • View Setup and Configuration
  • View All Data

Please ensure that the Salesforce user account has these permissions. If the issue persists, please provide the additional information requested above so we can further assist you.

Would you like more detailed steps on how to check and update these permissions in Salesforce?

Sources: