Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Please note that Salesforce limits the results returned by calls to the REST-based API used by this connector to 2,000 records or 20,000 characters. When you choose the Salesforce API, you should be shown a warning about this limit: 

Image Removed

See https://help.salesforce.com/articleView?id=000181883&language=en_US&type=1 for more information.

...

  1. Setup > App Setup > Create Apps and create a new Connected App (or edit an existing connected app if you have one)
    Image RemovedImage Added

  2. Use https://aam.projectorpsa.com/en/auth/callback/SF as the Callback URL 
  3. Your e-mail address as the contact email
  4. Set OAuth Scope to:
    1. Access and manage your data (api)
    2. Perform requests on your behalf at any time (refresh_toke, offline_access)
      Image RemovedImage Added

  5. Click Save
  6. The next screen should have your Consumer Secret and Consumer Key. If it does not, you can go to App Setup | Create | Apps | Manage button
    Image Removed
  7. Image Added
  8. Copy down your Consumer Key and Consumer SecretImage Removed
  9. If you wish, you can enforce IP and token restrictions from the Policies area of your connected app.
    Image RemovedImage Added
  10. Make sure that your Oauth token does not expire prior to the next scheduled import. Edit your connected app and choose the expiration settings that make the most sense for your organization. For example, never expire or expire if not used for several months.Image Removed
  11. Wait a 2-10 minutes for the changes made to propagate through Salesforce

...

  1. Go to any data set, Data Source subsection. Click Add.
    Image RemovedImage Added
  2. Choose the Salesforce CRM connector
    Image RemovedImage Added
  3. Choose Rest API
    Image Removed
    Image Added
  4. Choose Advanced Settings
    Image Removed
  5. Image Added
  6. Enter your consumer key and consumer secret
    Image Removed
    Image Added
  7. Sign in using your Salesforce Account
  8. You'll get a data source error message, just close it.
    Image RemovedImage Added
  9. Click on the Salesforce connector again and click on Sign in using your Salesforce account (again). This time you'll see the following dialog. You can use one of the predefined queries, but keep in mind that they are very generic in terms of the data they pull. They are also not very configurable. If you have an idea of the exact data you need, see the next section of this page titles, SOQL Query and set your query directly.
  10. Save and you'll be in the import template editor.
    Image Removed
  11. Image Added


SOQL Query

If you know what you are doing, you can write your own SOQL queries as opposed to using the ones built into the Salesforce connector wizard.

Image Removed

To write your own SOQL query using Salesforce's GUI, try these steps:

  1. Go to https://workbench.developerforce.com/login.php and login
  2. Jump to = SOQL Query
  3. Object = Table you need to query
  4. Use the GUI to build your query
    Image Removed

Image Added