The API-Connector-Tools add-on includes Steps, which can be used to connect to almost any HTTP API (e.g. REST API or SOAP-web services).
This is especially handy if there is no Add-On or Step in Synesty Studio for an API or web service yet. This way you can still connect your supplier, ERP, PIM, Marketplace or other system with Synesty.
With these Steps you can address an API via URL (HTTP Request) and evaluate the responses (XML or JSON) yourself. This way API connections to any system can be realized, as long as they can be reached from the outside via HTTP. It is a bit more technical than using a ready-made Add-On, but it also gives you full control over all transferred data and fields.
Application examples
- Access to HTTP-based REST APIs, GraphQL connectors or web services (also supports APIs with OAuth Authorization)
- Reading and writing XML data such as. BMECat or openTRANS
- Reading content from web sites by parsing HTML code (Web Scraping)
- Conversion of API data to tables / spreadsheets such as CSV or Excel
- Create or unpack compressed files (e.g. ZIP, TAR, GZ, 7Z archives)
An example
Imagine you have a spreadsheet with 100 articles. For each article you want to request or update the current stock via an API.
With the SpreadsheetURLDownloader step you can make one HTTP request per row. Request body and header can be built together individually for each API (APIs usually expect XML or JSON documents).
The API response, usually also XML or JSON can be processed further and combined with other Synesty Add-Ons.
Mostly you need the step APICall or SpreadsheetURLDownload in combination with the steps XMLReader or JSONReader to process the HTTP response.
Video - How can I connect a REST API with Synesty?
This tutorial playlist shows how to connect any REST API with JSON as data exchange format using Synesty base building blocks, if Synesty does not yet provide an add-on for this or an add-on does not yet have a suitable step.
What systems have customers connected to it?
Systems typically include APIs from third-party systems such as:
- Product Information Management Systems (PIM) (e.g. Akeneo
- ERP / enterprise resource planning (e.g. SAP, Microsoft Dynamics, Salesforce)
- Supplier, shipping and logistics systems (e.g. Paqato)
- Finance and accounting (e.g. DATEV, Stotax)
- E-commerce systems such as online stores, marketplaces, online marketing tools or data feeds for paid ads platforms
for which Synesty does not provide an own Add-On. Through this API-Connector tools this is no problem and the integration is still possible.
See how Microsoft Dynamics 365 was integrated with the help of Synesty in the following video of a case study.
Frequently Asked Questions
How can I query and connect to an API?
With our tutorial
REST API integration with Synesty you will learn step by step how to connect to any REST API with Synesty steps using HTTP and JSON as data exchange format.
How can I connect FTP, CSV, XML or APIs to API Connector Tools (Bulk Import, Bulk Export)?
With Synesty Studio you can connect API Connector Tools to all common data formats, data sources and systems like HTTP(S), (S)FTP, Dropbox, Google Drive and file formats like CSV data feeds, Excel XLS, XML or JSON. Synesty is particularly strong in the area of mass import, mass export, bulk updates or processing of mass data. All add-ons also offer steps for reading and writing data from the corresponding systems. Among them are e.g. e-commerce shop systems, ERP, Dropshipping suppliers, BME-Cat, marketplaces or online marketing software. This makes you extremely flexible and able to connect a wide variety of systems to API Connector Tools - mostly very simple due to ready-made building blocks (no code).
Steps like
Mapper and
Filter give you powerful tools to manipulate, filter or enrich the data to create any imaginable target format. This allows to do rather simple things (e.g. when a CSV file is enough) but also more complex use cases like XML files, REST API or GraphQL integrations. Through the integrated scripting language Freemarker you have the full power like IF-THEN-ELSE logics and loops to customize your integration.
Can I use Synesty for the switch or migration to API Connector Tools?
Yes, Synesty is ideally suited for transitioning or migrating to API Connector Tools. The platform boasts a plethora of tools and features designed specifically to efficiently transform and integrate external data into API Connector Tools. Here are some of the benefits and aspects you should consider:
Data Integration: Synesty supports numerous data formats and source systems. This means that no matter where your data originates from, you can effortlessly convert it into a format suitable for API Connector Tools.
Data Cleansing: Before migrating data, it's often essential to cleanse or normalize it. Synesty provides tools to eliminate duplicates, correct inconsistencies, and ensure that your data is accurate and uniform.
Automation: After the initial migration, you can utilize Synesty to automate recurring data transfers. This is especially beneficial if you need to regularly synchronize data between API Connector Tools and other systems.
Logging and Monitoring: Synesty offers detailed logs and notifications. This allows you to closely monitor the migration process and be instantly notified if any issues arise.
Scalability: Whether you're migrating a modest amount of data or vast databases, Synesty is designed to meet scalability demands, ensuring consistent performance. In summary, Synesty not only provides the tools for a successful migration to API Connector Tools, but it also ensures this process is smooth, secure, and efficient. After completing the migration, you can continue to rely on Synesty to manage all facets of data integration and automation.
Can I connect API Connector Tools with other APIs and tools (e.g. REST API, GraphQL, CSV) when there is no Synesty Add-On for my system?
Yes, if there is no dedicated Add-On yet, API Connector Tools can be connected and integrated via the
API-Connector-Tools. In other words, if there is an HTTP API or a file-based data exchange exists (e.g. (S)FTP or Cloud-Storage), then the connection is possible. Our tutorial
REST API Integration with Synesty shows how to do this.
Can I create backups of my data from API Connector Tools with Synesty?
Yes, Synesty offers powerful features to create backups of your data from API Connector Tools. With the specific Steps in the Add-On, you can not only export data from API Connector Tools but also convert it into various file formats, including CSV, XML, JSON, and ZIP. This provides you with the flexibility to choose the file format that best suits your requirements. Another advantage of Synesty is its integration with numerous external storage solutions. In addition to popular services such as S3, Dropbox, Google Drive, and FTP(S), Synesty also supports many other cloud and on-premise storage solutions. This ensures that you always have a reliable option to securely store your backups. Automation is another core aspect of the backup process with Synesty. You can set up automated backup scenarios, for example, to perform daily data backup in the late evening hours. This minimizes the risk of data loss and ensures that you always have up-to-date backup copies on hand. In addition to pure data backup, these backups can also be used for various business requirements. Whether it's for disaster recovery, to respond quickly to an emergency, for compliance purposes, to ensure you meet all legal requirements, or for synchronization purposes to match data between different systems or locations. Lastly, redundancy is another critical aspect for many businesses. With Synesty, you can not only secure data on a primary storage location but also on secondary (Cold or Hot-Standby) systems. This offers an additional layer of security, especially in high-availability environments where data availability is crucial.
What is Synesty Studio?
Synesty is a cloud-middleware for automating processes and connecting systems. It is a
No Code Connector which allows you to connect your Cloud-apps and APIs without programming with a simple drag&drop interface.
Learn more about
Use-cases.
Is the registration really for free?
Yes. You start with the free trial period. As long as you do not actively purchase anything, no costs will apply. The free trial period also ends as soon as you start purchasing a base-pack or Add-Ons.
More information about the FREE Trial.
Can I test all Steps and Add-Ons before purchasing?
Yes. Within this unlimited trial period for new customers you can try and play around with
all Add-Ons and Steps for free without purchasing anything. Only functionality is limited, so that productive use is not possible (e.g. limitation to max. 25 rows and records which can be processed)
Also after the free trial period you can test each Add-On in your
Sandbox, before purchasing.
More information about the FREE TrialWhat are Flows, Steps, Datastores und Upgrades?
- Base-packs, Add-Ons, Upgrades: You need at least one base-pack. A base-pack contains a basic setup of features and limits. Add-Ons contain new steps, functions and features for creating flows and automations. Upgrades can be purchased to increase your limits when you have exceeded them.
- Flow: is an executable automated process you create. It contains steps. A flow is comparable to receipe in a cookbook, containing instructions which are executed sequentially.
- Connector-Steps read input-data or write output-data e.g. files, APIs and external systems. The number of Connector-Steps is limited depending on the base-pack. You can also purchase Upgrades to increase this limit. Other step-types (Processing) are NOT limited. Connector-Steps are marked with the symbol.
Examples: FTPDownload, FTPUpload, GetOrders, AddOrders, GetProducts, UpdateProductData, UpdateStock, ExcelWriter, ExcelReader, ExcelSheetUpdate etc. are typical Connector-Steps.
Exceptions are e.g.: CSVReader, CSVWriter, JSONReader, VisualJSONReader, HTMLParser, Datastore Steps
- Run: is a single execution of a flow. If you run a single flow 1 x per day you need 31 runs per month.
- Traffic: The amount of data you transfer between by running flows (incoming and outgoing) will be counted per month. Each base pack contains a monthly limit of inclusive traffic.
- Datastore-storage: You can store data in Datastores, if you want to store data inside Synesty Studio. The number of records you can store is limited by your base pack. Records are stored in datastores and datastores are basically like databases or tables with rows and columns. The columns can be customized to store any kind of textual or numerical data like product data with 'title', 'description', 'stock', 'price' etc. You can use Flows to save, update and read from datastores. But: the rows you are reading from external sources, processing or exporting are unlimited (Except during the FREE test period).
If you have exceeded certain limits (depending on your base pack), flows will stop to run. When that happens you can try to remove any of the above to get below your limits again or you can purchase a higher base pack or
Upgrade.
How does Synesty handle privacy / GDPR?
Alle Daten werden in einem Rechenzentrum in Deutschland gespeichert. You always have full control over all stored data in your account. You are the data owner (data ownership). There are several export-functions you can use at any time, to backup and delete ALL your data.
More information about how Synesty handles privacy can be found
here.
Where can I find resources and videos to learn Synesty?
Our
Help page collects all important information on how you can acquire knowledge about Synesty. Under
Videos you can find our Quick Tips, Tutorials or User Stories.
I need support. What do you offer?
Synesty provides you with all the tools to do everything yourself: e.g. connecting systems, APIs and automating processes. In the Support-area of your account you find many ways to get support like user-manual, cookbooks, forum and knownledge-base.
Is there any training or course for beginners? Yes, in our
Basic Training you will learn step by step how to automate processes and build integrations with Synesty Studio.
I have issues setting up a flow. I need support. If you need individual support and consulting we offer various
Services
Partner-Network You can also contact one of our
verified partners to get a quote.