topic DELETE method in Qlik Sense REST API in Connectivity & Data Prep

DELETE method in Qlik Sense REST API

madhuparnadhar — Thu, 23 Dec 2021 13:23:26 GMT

Hi All,

I need to use DELETE method in Qlik Sense REST API connection. When I am creating the data connection, it gives options for only GET and POST. Is there any way to use DELETE method in Qlik Sense ?

Looking forward to the replies!

Thanks and Regards,

Madhuparna Dhar

Re: DELETE method in Qlik Sense REST API

Ricardo_Gerhard — Mon, 27 May 2019 13:37:18 GMT

By default, the Qlik Sense Rest Connector doesn´t provide data manipulation, only read data:

"The Qlik REST Connector enables Qlik Sense and QlikView to efficiently load data into Qlik apps from a REST data source"

https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/REST-connector.htm

Re: DELETE method in Qlik Sense REST API

Lech_Miszkiewicz — Wed, 29 May 2019 03:50:53 GMT

Hi,

you can't set up DELETE method directly in connection but you can override POST method using solution presented below (HTTPHEADER "X-HTTP-Method-Override" "DELETE", ).

I use it in scripts calling NPrinting API via Qlik RESTFull connector (look here if you are interested)

Let vDeleteUserURL = 'https://$(vNPrintingServer):4993/api/v1/users/'&'$(vUserId)';
Trace Deleting user: $(vDeleteUserURL);

LIB CONNECT TO '$(vConnection_POST)';

RestDeleteUserTable:
SQL SELECT
"__KEY_data"
FROM
JSON (wrap off) "data" PK "__KEY_data"
WITH
CONNECTION( URL "$(vDeleteUserURL)",
HTTPHEADER "Content-Type" "application/json",
HTTPHEADER "X-HTTP-Method-Override" "DELETE",
HTTPHEADER "cookie" "$(vCookie)")
;

Cheers

Lech

Re: DELETE method in Qlik Sense REST API

matheuzzy — Wed, 19 Jun 2019 16:50:44 GMT

Thanks for you reply!

The name of this connector is wrong!
How can you name a connector "REST" and do not allow all the Representational State Transfer methods?

It should be called "only read REST".