WHERE Statement in REST Connection

[Anonymous]

Hello,

After loading data using a REST Connector I need to include a WHERE statement as follows, but it's not working. It returns an error that i can't understand. Is it possible to include a WHERE there?

RestConnectorMasterTable:

SQL SELECT

"Status",

"High",

"Low",

"Open"

FROM XML "StockQuote"

WHERE [Status]='SUCCESS';

[StockQuote]:

LOAD [Status],

[High],

[Low],

[Open]

RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

I've tried many options, please, help.

Thanks,

Alazne.

[PrashantSangle]

Try below

1 : RestConnectorMasterTable:

Load * Where Status='SUCCESS';

SQL SELECT

"Status",

"High",

"Low",

"Open"

FROM XML "StockQuote"

WHERE [Status]='SUCCESS';

2:

SQL SELECT

"Status",

"High",

"Low",

"Open"

FROM XML "StockQuote";

[StockQuote]:

LOAD [Status],

[High],

[Low],

[Open]

RESIDENT RestConnectorMasterTable

where Status = 'SUCCESS';

DROP TABLE RestConnectorMasterTable;

Regards,

[Anonymous]

Thanks, it seems that preceding load works, but i undestand that preceding load filters data after loading it.

What I need, because of the data volume, is to filter data while loading (SQL SELECT) and thus reduce the volume of downloaded data. Is that possible?

[PrashantSangle]

Hi,

I did not remember properly Some where I read that you can't write where clause on XML data...

Regards,