topic Re: REST Connector in QlikView

REST Connector

Anonymous — Wed, 30 May 2018 15:23:49 GMT

How can I query a rest API based on a qlikview table.

For example using the site example given in the Qlik REST documentation :

http://dev.markitondemand.com/MODApis/Api/v2/Quote?symbol=UPS

How do I query "Open" and "Symbol" from the 3 stocks that are in the below table?

MyStocks:

LOAD * INLINE [

MySymbols

IBM

UPS

];

Thanks

Re: REST Connector

jaumecf23 — Wed, 30 May 2018 15:35:28 GMT

Hi,

Try this code:

MyStocks:

LOAD * INLINE [

MySymbols

IBM

UPS

];

LET vSymbol = FieldValueCount('MySymbols')-1;

FOR vCountIndex = 0 to $(vSymbol)

LET vActualSymbol = Peek('MySymbols', $(vCountIndex),'MyStocks');

CUSTOM CONNECT TO "Provider=QvRestConnector.exe;url=http://dev.markitondemand.com/MODApis/Api/v2/Quote?symbol%2$(vActualSymbol);timeout=30;method=GET;autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;PaginationType=None;XUserId=NRdFVaB;XPassword=DFVYeRD;";

RestConnectorMasterTable:

SQL SELECT

"Symbol",

"Open"

FROM XML "StockQuote";

[StockQuote]:

LOAD [Symbol],

[Open]

RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

next vCountIndex;

Re: REST Connector

Anonymous — Wed, 30 May 2018 15:37:21 GMT

thank you, could you attach qvd, copy and paste did not work.

Re: REST Connector

jaumecf23 — Wed, 30 May 2018 15:39:49 GMT

Hi,

I have attached the document.

Re: REST Connector

Anonymous — Wed, 30 May 2018 15:42:35 GMT

thank you but I get same error I was getting when copy paste, but for you guess working.

Any idea?

Re: REST Connector

jaumecf23 — Wed, 30 May 2018 15:51:50 GMT

Hi,

Are you able to create the Rest Connection without any problem? The error only appears when you try to read and specific table?

Thanks and Regards,

Re: REST Connector

Anonymous — Wed, 30 May 2018 15:57:27 GMT

Yes I can do Rest calls, for example the attached here do work for me, but yours no, very strange.

I am using version 11, maybe related.