I am not really sure what christianlangkamp talked about.
He asked in two old threads, this one about a LS hosted installation and the other one about direct querying the database (how to query to replace SGQA codes with question codes).
But he didn't mention where his installation is hosted.
So I answered to more or less both questions in one answer.

Joffm

I am in the hosted Limesurvey one. The commercial package so to speak.

At the moment once a week I go in and download a CSV. That is OK for now, but a bit of a nuisance.

But it would be so much more convenient to be able to just use a SQL Query node in KNIME or so and just click the update button...

The RemoteControl API is the way to go at the moment.

1. In the long run: KNIME extension for LimeSurvey
2. Shortcut: Check interfaces of other languages, which might already have a toolchain into KNIME.
LimeSurvey via R: LimeR: github.com/cloudyr/limer
LimeSurvey via Python: Limepy : pypi.org/project/limepy/

Hi Jelo
This is great - thanks for pointing to this. R and Python might be enough, though a KNIME node (maybe even using one of those packages) might be even better.
I will put it onto the KNIME Forum.
Thanks