API Connector Tools Add-On

Read and connect APIs - HTTP, REST, GraphQL, XML or JSON, or even HTML web scraping.

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.

Das Video wird bei Klick von Youtube geladen und abgespielt. Dabei stellt Ihr Browser eine Verbindung zu den Youtube-Servern her. Es gelten die Datenschutzhinweise von Google / Youtube.

Further information

Frequently Asked Questions

How can I connect FTP, CSV, XML or APIs to API Connector Tools (Bulk Import, Bulk Export)?

Can I use Synesty for the switch or migration to API Connector Tools?

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?

Can I create backups of my data from API Connector Tools with Synesty?

What is Synesty Studio?

Is the registration really for free?

Can I test all Steps and Add-Ons before purchasing?

What 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 or call other flows. The number of Connector-Steps is limited depending on the base-pack. You can also purchase Upgrades to increase this limit. Connector-Steps are marked with the symbol.
Examples: FTPDownload, FTPUpload, GetOrders, AddOrders, GetProducts, UpdateProductData, UpdateStock, ExcelWriter, ExcelReader, ExcelSheetUpdate, FlowTrigger, FlowExecutingStep 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?

Where can I find resources and videos to learn Synesty?

I need support. What do you offer?

What can I do with the Steps contained in {addonname}?

API Connector Tools

19.99 €per month ¹

Buy now

To book this add-on you need a Base Pack.

Contractual information

No cancellation period
Testable free of charge at any time
Contract duration 1 month
Automatic renewal

Privacy and GDPR

All Informationen about how Synesty protects your data.

API Connector Tools is often integrated with

APICall

Makes an API/HTTP-Request. Supports parsing of XML/JSON responses and pagingation.

Archive

Compresses a single FILE or a FILELIST into a ZIP-archive.

ExtractArchive

Decompresses a ZIP-archive into a filelist

HTML2Spreadsheet

Extract HTML elements from a File or Spreadsheet (containing HTML-Code in one column).

HTMLParser

Can Parse HTML String and can extract certain elements from it by using CSS or jQuery style expressions and then create new String output from those extracted elements for further processing.

JSONReader

Reads JSON file into a Spreadsheet object.

SpreadsheetUrlDownload

This step can do multiple HTTP Calls based on a SPREADSHEET. Use it to connect to various kinds of webservices/APIs. Supports single calls and batch processing of multiple rows.

UrlDownload

This step accesses an URL and downloads the content. The result is String value.

WebDAVDownload

This step downloads files from a WebDAV-Server. The result is a list of files.

WebDAVRename

This step renames a single file or a list of files on a WebDAV-Server. You can also move the file(s) into a existing subfolder.

WebDAVUpload

This Step can upload files to a WebDAV-Server.

XMLReader

Reads XML file into a Spreadsheet.

What can I do with the Steps contained in API Connector Tools?

Processing Files
Processing JSON data
Processing XML data
execute and receive data by HTTP-Requests
execute and upload data by HTTP-Requests
receive or download Files
send or upload Files

Erstellung eines PDF aus eine HTML-Datei, die mit JSON-Daten gefüllt wird.

OpenText-RiskGuard Risikoanalyse für Dokumente

Commercetools - Export Products and Orders

Zeigt wie man CSV zu XML umwandeln kann.

Beispiele, wie man Daten in Datastores importiert und exportiert (Master/Child und Parent/Variant).

Aufträge aus Datastore (Master-Child) holen und als 2-stufiges XML und JSON ausgeben.

Zeigt wie Daten über eine URL importiert werden.

openTRANS Read ORDER XML

EZB Wechselkurse in Echtzeit von XML als CSV

Zeigt wie man eine JSON- oder XML Datei aus einem CSV-Spreadsheet erstellt.

JSON Daten einlesen und in eine CSV-Datei umwandeln.

Aufpreise für Artikeldaten nach verschiedenen Kriterien für versch. Kanäle und Repricing berechnen

Diese Vorlage zeigt, wie man mit Synesty eine REST-API Anbindung realisieren kann.

Einlesen und verarbeiten eine sitemap.xml Datei einer Website.

XML-Datei in eine CSV-Datei umwandeln und weiterverarbeiten.

Together we will find the perfect solution for your company.

If you still have questions about your individual application, we can advise you personally.
Simply send us a contact request and describe your problem.

With Synesty as your middleware you can build custom integrations to connect API Connector Tools to other systems and APIs without code by clicking them together via Drag & Drop.

Automate business processes and integrations like EDI data-import and export.

With Synesty you can import and export file formats like CSV, Excel (XLS/XLSX), XML or JSON into API Connector Tools and also connect via HTTP to REST- or GraphQL APIs. Customers use it for report-building, ETL-task, Bulk import or data feed optimiziation with API Connector Tools.
Our No Code Flow-Editor and Low Code Scripting Tools allow creative customization for all kinds of integrations.

Faster API Connector Tools integrations with No Code / Low Code.

Create API Connector Tools integrations faster than with programming.

Programming knowledge is not required for Synesty. Instead, visual building blocks can be plugged together and complex logics can be implemented with Low Code tools. This means that everybody can assemble and automate custom API Connector Tools-integration via simple "Steps". However, if a custom solution is needed to automate a more complex IF-THIS-THEN-THAT process, script-code can be added at any time.

Try Synesty for free

Our whitepaper for Makers: No Code Integration & Automation

Get the PDF for free

¹ All prices including VAT
²Content is the 1st hour of the normal Basic Training. If desired, the free hour can be credited when booking the paid basic training. In this case, the price of the basic training is reduced by 50%. The offer is only valid for new customers (once per company) when booking a paid basic package (Plus or Professional) for Synesty Studio for the first time. A payout of the offer is not possible and the offer is not transferable.