REST Connector

[Anonymous]

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

    I

    UPS

];

Thanks

[jaumecf23]

Hi,

Try this code:

MyStocks:

LOAD * INLINE [

    MySymbols

    IBM

    I

    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;au...";

RestConnectorMasterTable:

SQL SELECT

"Symbol",

"Open"

FROM XML "StockQuote";

[StockQuote]:

LOAD [Symbol],

[Open]

RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

next vCountIndex;

[Anonymous]

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

[jaumecf23]

Hi,

I have attached the document.

[Anonymous]

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

Any idea?

[jaumecf23]

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,

[Anonymous]

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.