Archives

Categories

No-Code Salesforce API Data Sync & ETL


Start Syncing Data In Minutes – Schedule and Modify Data In-Flight



Pull data from almost JSON API, or push it from a system you control, into your Salesforce Org and get up and running in as little as 15 minutes.

Sync and schedule as many APIs, as often as you wish, within SF limits, and connect dozens of third-party systems with no code ( knowledge of APIs and JSON is extremely helpful ).

Transform your data in real time with included transformations, such as: calculate, recast, modify, validate, replace, concatenate, split, and even convert an External Id into a Saleforce Id.

Up to two-hours of complimentary support is provided with each purchase of the app. This should be enough time to set up a sample use case (or two) with a standard API ( that you have verified ).



A typical Salesforce data-integration can cost tens to hundreds of thousands of dollars. Often times consisting of thousands of lines 100% custom apex code that likely needs to be updated any time your Salesforce Objects change, or anything on the third-party API changes.



Our package allows you to pull data from almost any API or push almost any type of data into Salesforce, for as many APIs as your server can handle, syncing as many objects and fields as Salesforce will allow. It does all of this with no code required from your side (in most cases). Push or pull data into Salesforce with relative ease.






Features:

Feature sfPlugins Consultant
No Code Data Sync
  • Get up and running in minutes or hours – instead of weeks or months – pulling data from many common JSON APIs:
    • Market Prices
    • Finance Data
    • HR and User Profile Synchronization
    • Almost any API you have access to!
  • Sync one, ten, or even 100 different APIs with one tool for the same cost ( see limitations at the bottom of this page )
No
Transform Your Data
  • Perform ETL data transformations in real-time as you sync your data and perform:
    • Data validation
    • Calculations
    • Multiple & regex replace operations
    • Data-casting / typing / conversion
    • Text-transforms: uppercase, lowercase, title case, etc.
    • Join or concatenate many API fields to one Salesforce field
    • Split fields ( API field to many Salesforce fields, or partial API field to one Salesforce field )
    • Lookups / Master-Detail / References – convert API field value to a Salesforce ID ( sfid )
$$$$
Data On Your Schedule
  • PULL sync allows you to import data into Salesforce on a click, a trigger, or on your own schedule – out of the box
  • PUSH sync provides the ultimate in on-time, as-needed, data integration for APIs that you control – out of the box
  • APIs that you don’t directly control can easily be wrapped and turned into a real-time push-sync ( if you have some experience with and the ability to create your own web server )
$
Synchronize or Reconcile Data Into Any Accessible Salesforce Object + Field
  • You can sync the Salesforce fields of your choice, for almost any object type (the Object and Field must be accessible by the managed package and the sync user)
  • Want to send data from one API to two objects? Ten? No problem
  • Want to sync data from 10 APIs into one Object? No problem
  • * Always test in a sandbox and back up your data
$$$$
PULL data from almost API
  • The package supports: Basic, Token, and Salesforce Named Credential Authentication ( Oauth2, Password, etc. )
  • User-definable headers, query parameters, and request body allow for a nearly unlimited range of options for GET and POST requests
  • Built-in Token auth will make a call to your Token provider, grab the token and contsruct the Authorization header for the actual API call
$$$$
PUSH data into Salesforce from an API you control
  • Send data directly to the built-in sync manager and update a few to thousands of records at a time
  • Wrap third-party API responses and forward them to the push-sync manager
$$$$
Accelerate Sync Deployment
  • Control data on your schedule
  • API sync on demand: ALL APIs, by Salesforce Object Name, by Sync Option set
  • Schedulable sync: included apex scheduler to get your APIs running weekly, nightly, etc.
  • Trigered sync: write simple apex code to trigger a sync on changes to a record
No
Get Support And Advice With Your Specific Integration
  • We will always try to answer quick, straightforward questions about the tool without charge
  • While we have endeavoured to create a managed package that will consume almost ANY API, the reality of JSON and APIs in general, is that their structure is entirely dependent on the whims of the API programmer. Therefore, if you run out of free support, we are available for paid support and consulting should you run into any problems
$$ $$$$
Security
  • No data ever comes to or goes through sfPlugins
    • All sync happens between your Salesforce Org and the APIs you use
  • The app never talks to any third party servers except for the APIs you configure
  • SLL ( https ) is enforced by the application – http-only endpoints cannot be synced at this time
  • Only Salesforce Admins should have access to the Sync Manager UI
  • The app itself is username and password locked, helping to protect your settings and sensitive data from accidental disclosure
  • Salesforce Named Credentials for maximum security – Password & Oauth2 are supported
???
Formats, Options, & Technical Specifications
  • JSON APIs only
  • GET & POST methods are supported for API retrieval
  • Basic / Token / Ouath2 Support
  • Request Headers – send custom headers with your API request
    • Authorization
    • AWS x-api-key
    • Content-Type / Accept
    • etc.
  • Request Paramaters – send custom query string parameters with your API request
  • Request Body – for POST requests
  • Pagination is supported for the following cases, see limitations & workarounds for more info:
    • next-token based pagination
    • limit / offset based pagination
  • Unique querystring paramater – send a Salesforce field’s value as part of your
  • querystring. Examples: /users/<custom_id__c>?fields=id,email OR /users?id=<custom_id__c>
    • (There are many more possible combinations)
  • Upsert, Insert, and update modes are supported
  • All records in a salesforce object can be synced or only the records that are explicitly allowed to sync
  • More than 50 user-configurable options for each API
Every feature here would take you days, weeks, or months of custom coding, testing, and fixes. And then more fixes…

Book a Live Demo Today:


Support:

Every subscription comes with two hours of free support, additional support is available through our contact page at industry standard rates:

  • This should be enough to get a few APIs syncing in your Sandbox environment
    • Always test in Sandbox
    • Please read the documentation and go through the demos before using your support hours to get the best possible use of support hours
    • Please test your APIs with a tool like cURL or Postman before contacting support
      • Generally speaking, if your API call works in cURL or Postman, it can be configured for the Sync Engine and synced into Salesforce
  • For push APIs, you should have access to a web server and a developer who can write simple http requests. All that is needed for push syncing is a web service capable of:
    • obtaining a token from Salesforce ( see documentation )
    • making a second call with the token and posting a JSON body like: String_1 + String+2 + String_3
    • it’s really that straightforward

Workarounds & Known Limitations:

The following is a list of known limitations, some of these may be removed in future updates, all subscribers are eligible for free upgrades as allowed by Salesforce App Exchange policies and prodecures:

  • This application respects Salesforce governor limits, which can be referenced here:
    • Our documentation contains a troubleshooting guide with advice for working around these limits
  • No more than 100 “pages” of an API ( for paginated APIs ) can be synced in a single operation, but there are workarounds to this limit.
  • Use of Salesforce Query String Sync Option is generally an inefficient way to sync, but is supported to 5000 records due to limitations in Salesforce, but there are workarounds to this limit.
  • Endpoints / URLs / URIs – must use the https format for security reasons. Servers that do not accept https connections cannot be synced at this time.
  • Only JSON based APIs are supported at this time.
  • Custom headers are supported in V1, dynamic headers are not – dynamic means they change at run-time or vary from call to call
  • Custom query string parameters are supported, but only the “time” and “salesforce field query” parameters are dynamic at this time – dynamic means they change at run-time or vary from call to call
  • Sync configuration is deigned to be portable across environments – future upgrades will always work toward backward compatibility, however, it’s not possible to guarantee 100% compatibility between versions – please contact us if you have any questions or concerns before upgrading
  • Please refer to the App Exchange terms and conditions for additional terms and limitations