Connect Qlik to API REST

olgaavalos — Wed, 19 Mar 2025 23:02:17 GMT

Hello,

I have the connection to the REST API, when trying to send the list X and Y in the body as a variable, it gives me an error that it does not recognize the input parameter that is being sent. Your help please.

When creating the connection, I put as parameters in RequestBody:
{
"X": [1, 2, 3, 4, 5],
"and": [2, 4, 6, 8, 10]
}
and in Query headers:
Content-Type application/json
When doing a connection test: Connection succeeded
But when trying to send as a variable inside the script I'm having problems:

LIB CONNECT TO 'REST_http127.0.0.15000predict';

// Define the X and Y strings in Qlik
let X = '1,2,3,4,5';
let y = '2,4,6,8,10';

// // Convert the strings X and Y to JSON strings
// let jsonData = '{"X": [' & X & '], "y": [' & Y & ']}';

// Make the POST request to the API using RestPost()
RestConnectorMasterTable:
SQL SELECT *
FROM JSON (wrap on) "root" PK "__KEY_root"
WITH CONNECTION(
Url "$(url)",
HTTPHEADER "Content-Type" "application/json",
BODY "{"X":[$(X)],"y":[$(y)]}"
)
)
;

// Load the API results into a Qlik table
table:
LOAD *
RESIDENT RestConnectorMasterTable;

topic Connect Qlik to API REST in Data Movement & Streaming

Connect Qlik to API REST