Import API Data

ETL, Sync, and Scheduler

By sfPluginsAdmin & Developer Tools

About Import API Data

Pull, push and transform most JSON API data and sync into SF

Push or pull JSON API data from almost any system into your Salesforce Org and sync within minutes to hours.

Sync and schedule as many APIs, as often as you wish, within SF limits, and connect dozens of APIs with low to no code.

This app supports:

JSON API ingestion / integration through pull ( from SF to almost any API ) or push from via an included API
Upsert, update, or insert records
Modify API data in-flight. ETL functions include: calculation, recasting, modify, validate, replace, concatenate, split, & convert an External Id into a Saleforce Id.
Basic, Custom, and Named Credentials (Oauth2 & Password ).
Customize your querystring, headers, and parameters to suit your needs.
Url-based next_url fetching when a token is passed in the body of the API JSON response.
Sync data from multiple sources into one object, or vice versa.
Comes with a preview-mode so you can see the effects of update and insert operations.
No limits on the number of APIs you can consume beyond what is constrained by Salesforce: API calls, storage, execution, governor limits, etc.

Sync data from almost JSON API, or push it from a system you control. Supports Basic, Custom Token, and Named Credentials (Oauth2 & Password ). Customize your querystring, headers, and parameters to suit your needs. Supports url-based next_url fetching.
Transform your data in real time. Match and sync Salesforce data-types or pick list values. ETL on json fields includes: calculate, recast, modify, validate, replace, concatenate, split, and even convert an External Id into a Saleforce Id.
Schedule upserts, updates, and inserts with the built-in tools or use the SDK to sync specific APIs, Objects, or All APIs via apex code or triggers. Use the power of PUSH to sync the data on-demand, enabling near real-time data updates and streaming.

Paid, from $2,500 per company per year.

Import API Data plans
Plan	Price	Billed
sfPlugins - Data Sync and ETL - Annual	$2,500 per company	Yearly
sfPlugins - Data Sync and ETL - Lifetime	$19,750 per company	One time

The most reviewed Admin & Developer Tools apps on the AppExchange, to compare before you choose.