Load data from Clickhouse with REST API

fhana — Fri, 25 Jul 2025 10:17:34 GMT

Hey,

I'm trying to load data from a clickhouse instance to Qlik, and I'm keep getting empty result
0 lines fetched

I'm using Qlik Cloud

I tested the query in curl

curl -X POST -u xxx:yyy "https://host:port/?database=database" \
> -H "Content-Type: text/plain" \
> -H "Accept: application/json" \
> --data-binary "SELECT 1 AS test_value FORMAT JSON"

I'm getting usual results

when configuring the REST connector I'm setting
the URL to https link
method to POST
our auth
the query goes to the body
I'm adding header parameters like Name - Accept; Value - text/plain etc
Always HTTPS is also turned on

the connection works
in the load script i have

LIB CONNECT TO 'clickhouse test';
TestSimple:
SQL SELECT
"test_value"
FROM JSON (wrap on) "data";

what ever i do the result is always the same 0 lines fetched

topic Load data from Clickhouse with REST API in Data Movement & Streaming

Load data from Clickhouse with REST API