Unable to connect via REST

[dnyaneshwark]

I am trying to set up a connection using REST. The same I tried using Postman which works well.

It says "Method not found"

[ChiragPradhan]

Hi,

Did you check the log? It may give more info as to what went wrong.

[dnyaneshwark]

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()

[ChiragPradhan]

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?

[dnyaneshwark]

Yes I am getting JSON output properly in browser.

[ChiragPradhan · Accepted solution]

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

[dnyaneshwark]

I have updated version and it worked. Thanks.. 🙂