Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to set up a connection using REST. The same I tried using Postman which works well.
It says "Method not found"
I am using the same version of the Qlik REST connector 2.11 and I have tried connecting to two different API's without any issue.
One API was a test one that I built and the other is below -
https://data.gov.uk/api/action/package_search?q=fish
A few options below -
1) Not really a solution , but may be try deleting the existing REST connector and create a new one.
2) Try upgrading QS Desktop to June 2019.
3) Use Qlik Sense in browser by keeping the desktop open and going to http://localhost:48484/hub on Chrome/IE (preferably Chrome). And Use Developer Tools to check what is happening when you send the request and receive a response.
Apart from that, it is difficult to diagnose this issue without connecting to your API.
Best
Chirag
Hi,
Did you check the log? It may give more info as to what went wrong.
I could not understand it. If it could identify schema, I believe it should also publish data. Logs are following:
20190705T072602.515+02:00 RST [1] 2.11.0 INFO LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip (null) (null) (null) (null) REST Configuring connector
20190705T072602.811+02:00 RST [1] 2.11.0 INFO LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip (null) (null) (null) (null) REST Running server
20190705T072602.884+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip (null) (null) (null) (null) REST Server.Run(), executionMode=AppClient, pipeName=\\.\pipe\00002944_00001E50_7F19EB83_00224178.pip parentWindow=0000000000000000
20190705T072602.889+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip (null) (null) (null) (null) REST Command pipe '\\.\pipe\00002944_00001E50_7F19EB83_00224178.pip' connected...
20190705T072602.890+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip (null) (null) (null) (null) REST GetRequest() calling
20190705T072602.912+02:00 QVX [1] 2.11.0 WARN LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip (null) (null) (null) (null) REST UserId was not passed!
20190705T072602.913+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip (null) (null) (null) (null) REST GetRequest() returned
20190705T072602.916+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST RECEIVED: QvxRequest {Command=QVX_GENERIC_COMMAND, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
20190705T072602.921+02:00 SDK [1] 2.11.0 INFO LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST Handling QVX_GENERIC_COMMAND (JsonRequest, getPreview).
20190705T072602.926+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST HandleGenericCommand is about to process command=JsonRequest
20190705T072602.928+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST HandleGenericCommand is about to run HandleJsonRequest with command=JsonRequest, method=getPreview, userId=
20190705T072602.932+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST Already in session, method=getPreview, client user id=NA, client session id=49cd3230-519c-4ef7-8a0e-1d41450d4b9a.
20190705T072602.934+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST Executing QVX_GENERIC_COMMAND (JsonRequest, getPreview) for connection string provider=QvRestConnector.exe;url=http://localhost:63662/api/studentretrive;timeout=30;method=GET;httpProtocol=1.1;isKeepAlive=true;bodyEncoding=UTF-8;sendExpect100Continue=true;autoDetectResponseType=true;checkResponseTypeOnTestConnection=true;keyGenerationStrategy=0;authSchema=anonymous;skipServerCertificateValidation=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;addMissingQueryParametersToFinalRequest=false;PaginationType=None;allowResponseHeaders=false;allowHttpsOnly=false;.
20190705T072602.935+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST JsonRequestHandlerBase.HandleJsonRequest(), Executing GetPreviewCommand...
20190705T072603.000+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST Initialize: Could not get actual credentials connection string.
20190705T072603.001+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST Initialize: Actual credentials was null or empty, did not apply credentials.
20190705T072603.027+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST GetCache - TableInfo cache for session 49cd3230-519c-4ef7-8a0e-1d41450d4b9a
20190705T072603.035+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST GetCache - TableInfo cache for session 49cd3230-519c-4ef7-8a0e-1d41450d4b9a
20190705T072603.052+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST Initialize: Could not get actual credentials connection string.
20190705T072603.053+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST Initialize: Actual credentials was null or empty, did not apply credentials.
20190705T072603.056+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST JsonRequestHandlerBase.HandleJsonRequest(), Executed GetPreviewCommand successfully.
20190705T072603.063+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST SENDING: QvxReply {Result=QVX_OK}
20190705T072603.066+02:00 QVX [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST SendReply(reply:QVX_OK)
20190705T072603.068+02:00 QVX [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST SendPacket()
20190705T072603.069+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST GetRequest() calling
20190705T072603.071+02:00 QVX [1] 2.11.0 WARN LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST UserId was not passed!
20190705T072603.071+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 eb99e277-c406-45cd-8185-ea3d1937df99 REST GetRequest() returned
20190705T072603.072+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 b433a177-5153-47ee-9940-0d0ccfd1da86 REST RECEIVED: QvxRequest {Command=QVX_TERMINATE, Options={AllowPrompt=False, AutoCommit=False, ConnectTimeoutSec=, IsEmpty=True, LoginTimeoutSec=, Provider=, ReadOnly=False}}
20190705T072603.073+02:00 SDK [1] 2.11.0 INFO LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 b433a177-5153-47ee-9940-0d0ccfd1da86 REST Handling QVX_TERMINATE.
20190705T072603.075+02:00 SDK [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 b433a177-5153-47ee-9940-0d0ccfd1da86 REST SENDING: QvxReply {Result=QVX_OK}
20190705T072603.076+02:00 QVX [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 b433a177-5153-47ee-9940-0d0ccfd1da86 REST SendReply(reply:QVX_OK)
20190705T072603.077+02:00 QVX [1] 2.11.0 DEBUG LAP013318 \\.\pipe\00002944_00001E50_7F19EB83_00224178.pip Personal\Me J:\Qlik\Sense\Apps\REST_Connection.qvf 3 b433a177-5153-47ee-9940-0d0ccfd1da86 REST SendPacket()
It seems the REST connector is receiving a response but unable to parse it, possibly?
What version of the REST connector or QS Desktop are you using? Also, if you call the api in a browser window, are you getting the json correctly?
Yes I am getting JSON output properly in browser.
I am using the same version of the Qlik REST connector 2.11 and I have tried connecting to two different API's without any issue.
One API was a test one that I built and the other is below -
https://data.gov.uk/api/action/package_search?q=fish
A few options below -
1) Not really a solution , but may be try deleting the existing REST connector and create a new one.
2) Try upgrading QS Desktop to June 2019.
3) Use Qlik Sense in browser by keeping the desktop open and going to http://localhost:48484/hub on Chrome/IE (preferably Chrome). And Use Developer Tools to check what is happening when you send the request and receive a response.
Apart from that, it is difficult to diagnose this issue without connecting to your API.
Best
Chirag
I have updated version and it worked. Thanks.. 🙂