First configure a REST connection:
Configure REST Connection to connect to M&D from Qlik Sense
API Call to a Task that does not have parameters
//API-call without parameters
LIB CONNECT TO 'ExecuteM&DTask_02SendReportbyEmail';
RestTable:
SQL SELECT
FROM JSON (wrap on) "Root";
Drop Table RestTable;
API Call to a Task that has parameters
//API-call with parameters using URL
LIB CONNECT TO 'ExecuteM&DTask_03SendReportbyEmailwithParameters';
Let vBrand= 'Audi';
Let vCountry= 'Austria';
RestTable:
SQL SELECT
FROM JSON (wrap on) "Root"
WITH CONNECTION (
Url "https://company .mail-and-deploy.com/Api?Method=ExecuteTaskAsync&TaskId=d0077050-92bb-4f33-ba91-cbf4f4e33d30&Delay=5&Parameters=Brand:$(vBrand)|Country:$(vCountry)"
);
Drop Table RestTable;
//API-call with parameters using QUERY
LIB CONNECT TO 'ExecuteM&DTask_03SendReportbyEmailwithParameters';
Let vBrand= 'Mazda';
Let vCountry= 'Italy';
RestTable:
SQL SELECT
FROM JSON (wrap on) "Root"
WITH CONNECTION (
QUERY "Parameters" "Brand:$(vBrand)|Country:$(vCountry)");
Drop Table RestTable;
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article