Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community ,( mto )
I'm trying to use direct discovery with qlik rest connector.
This is my script to connecte to my web service:
LIB CONNECT TO 'Post Alert';
RestConnectorMasterTable:
SQL SELECT
"alertName",
"dateCreation",
"dateValidation",
"utcodeValidator"
FROM JSON (wrap on) "root" WITH CONNECTION(
BODY "$(vRequestBody)"
);
[root]:
LOAD [alertName] AS [alertName],
[dateCreation] AS [dateCreation],
[dateValidation] AS [dateValidation],
[utcodeValidator] AS [utcodeValidator]
RESIDENT RestConnectorMasterTable;
DROP TABLE RestConnectorMasterTable;
Here's an example of direct discovery:
ODBC CONNECT32 TO [Tutorial;DBQ=D:\Database\TUTORIAL_DATA_7200.mdb];
[DirectDiscovery]:
DIRECT QUERY
dimension
CALL_CTR_ID,
CUST_CITY_ID
detail
COMMENT
measure
GROSS_DOLLAR_SALES
FROM CITY_CTR_SLS;
Now, the question is, can I implement that, not with an ODBC connection.. but with a REST CONNECTOR like in my case?
Thanks !
Hi Omar - The REST Connector is not a supported connector with Direct Discovery.
Limitations when using Direct Discovery ‒ Qlik Sense
Let me know if you have further questions.
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Regards,
Michael Tarallo (@mtarallo) | Twitter
Qlik