Solved

Web Connections - Salesforce When you use a Custom Domain for Salesforce in FME, how do you check that FME adds the appropriate suffix?

  • 17 December 2021
  • 4 replies
  • 12 views

Badge +5

When I add a custom domain for Salesforce in FME, FME is not adding or permitting the ?locale=au suffix. The formatted string should be https://p-2576944.my.salesforce.com/?locale=au but FME looks like it is using https://p-2576944.my.salesforce.com.Salesforce Suffix

icon

Best answer by danminneyatsaf 21 December 2021, 21:22

View original

4 replies

Userlevel 2
Badge +10

Hi @philipwhitten​, unfortunately it's not possible to check if FME has added the appropriate suffix. You say that it looks like FME is using https://p-2576944.my.salesforce.com, does this mean you are encountering errors when trying to connect to your Salesforce account through the Web Service Authentication?

Badge +5

Hi @philipwhitten​, unfortunately it's not possible to check if FME has added the appropriate suffix. You say that it looks like FME is using https://p-2576944.my.salesforce.com, does this mean you are encountering errors when trying to connect to your Salesforce account through the Web Service Authentication?

I can't connect to my Salesforce account through the FME Web Connection. When I attempt to connect with FME I get an "OAuth error". I can connect successfully connect to Salesforce using the Chrome browser from the same computer. So I am trying to understand why FME can't connect and at the momment and FME feels a bit like a black box - I don't know what tests to perform to learn what is going wrong.

Userlevel 2
Badge +10

I can't connect to my Salesforce account through the FME Web Connection. When I attempt to connect with FME I get an "OAuth error". I can connect successfully connect to Salesforce using the Chrome browser from the same computer. So I am trying to understand why FME can't connect and at the momment and FME feels a bit like a black box - I don't know what tests to perform to learn what is going wrong.

@philipwhitten​ In this case you may need to check with your salesforce administrator if you have granted API access to your Salesforce account. This may require you creating a Connected App in Salesforce. To create a Connected App in Salesforce I have provided some instructions below.

 

For this you require a Client ID (Consumer Key in SF) and a Client Secret. To generate these, you'll need to get your SF admin to create a Connected App in SF (Setup > Apps > App Manager; there's a button New Connected App). You do need to be a Salesforce admin to create the Connected App. 

salesforce-connected-appOnce the app is created in SF you should have a Consumer Key (Client Id) and Secret. The last thing to obtain from your SF Admin is the Authorization URL for your SF. By default it's set to https://login.salesforce.com/services/oauth2/authorize?response_type=code&scope=refresh_token full

 

Next, in FME, go to FME Options > Web Connections and Manage Services and create a new service from the Salesforce template we have. Here you want to populate a new Web Service Name; the Client Id (which is the SF Consumer Key); the Client Secret; and the URL domain to hit for the required URLs

salesforce-web-connection

Badge +5

I can't connect to my Salesforce account through the FME Web Connection. When I attempt to connect with FME I get an "OAuth error". I can connect successfully connect to Salesforce using the Chrome browser from the same computer. So I am trying to understand why FME can't connect and at the momment and FME feels a bit like a black box - I don't know what tests to perform to learn what is going wrong.

Thanks so much. Our connection is working now. In addition to your instructions, we had to change the URL's in FME because we are using a sandbox (test environment) and then we had to change the refresh token expiry policy in Salesforce to get it to work.

Reply