Connecting to the portal https://www.econda.de/en/ is possible via the standard Adverity Web Connect Connection, and the econda REST-API.
STEP 1: ENABLE API REQUESTS IN ECONDA
In order to be able to use the econda webservice API, you will first to have request the API services to be enabled for your econda account. This might include additional fees for your econda account.
STEP 2: GENERATE A LINK FOR A REPORT IN ECONDA
Create the report you need in the econda interface, and then follow the instructions in the econda help center to generate a REST-URL (currently only available in German, and only for logged-in users).
An example for such a URL might be:
STEP 3: ADD A WEB CONNECT DATASTREAM IN ADVERITY
Once you have a report and a link available, add a new Datastream.
- Connect > + Add new datastream > Web Connect
- Go to Settings in the left hand menu, and configure as follows:
- Name: Add a datastream name
- Connection: leave this blank
- URL: paste the URL from the econda interface
- Request method: GET
- Date format: %Y-%m-%d %H:%M
- Parser: CSV (with semicolon delimiter)
- Encoding: UTF-8
OPTIONAL: USING START AND END PLACEHOLDERS FOR FLEXIBLE DATES
The above link will always generate a static report, e.g. from 2018-01-01 - 2018-03-21. Instead of pulling a static report, it is possible to use placeholders for start and end date and choose flexible dates when fetching in DataTap.
This means that the URL would instead look like this: