Share via

Salesforce API Integration User unable to pull data through Azure Data Factory

Korina 0 Reputation points
2023-05-04T18:26:51.0333333+00:00

I am getting an error when running a query logged in as a Salesforce API Integration User. It works when logged in as a standard user, but as an Integration User I get this errror:

ErrorCode=UserErrorOdbcOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ERROR [HY000] [Microsoft][Salesforce] (120) SOQL_FIRST mode prepare failure: SOQL error: [Microsoft][Salesforce] (148) NOT_FOUND: The requested resource does not exist SQL error: [Microsoft][SQLEngine] (31740) Table or view not found: iOffice Inc..Opportunity,Source=Microsoft.DataTransfer.ClientLibrary.Odbc.OdbcConnector,''Type=System.Data.Odbc.OdbcException,Message=ERROR [HY000] [Microsoft][Salesforce] (120) SOQL_FIRST mode prepare failure: SOQL error: [Microsoft][Salesforce] (148) NOT_FOUND: The requested resource does not exist SQL error: [Microsoft][SQLEngine] (31740) Table or view not found: iOffice Inc..Opportunity,Source=Microsoft Salesforce ODBC Driver,'

Has anyone experienced this type of issue when running a query to pull data from Salesforce as an API Integration User?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,623 questions

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2023-05-05T22:09:20.2133333+00:00

    Hello Korina,

    Welcome to the MS Q&A platform.

    Sorry, I don't have a sales force data source to test this from my end, but below is a possible root cause:

    It seems like the Integration User may not have the necessary permissions to access the "iOffice Inc..Opportunity" table or view or the User may not have API access to the table or view. Please check the Integration User permissions and API access settings and ensure they have access to the table or view.

    I hope this helps. Please let me know if you have any further questions.

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.