topic Re: Rest Connector Data extraction issue in QlikView

Rest Connector Data extraction issue

vijetas42 — Tue, 21 Feb 2017 06:31:30 GMT

Hi All,

I am able to connect successfully to an api via rest qlikview connector 1.0 but not able to see records on Select.

The same api link on Browser gives me data

but, on select in Qlikview it shows only one column(col1, probably header) and that too says custom read failed

I am getting below script with only 1 column which seems to be incorrect

RestConnectorMasterTable:

SQL SELECT

"col_1"

FROM CSV (header off, delimiter ",", quote """") "CSV_source";

[CSV_source]:

LOAD [col_1]

RESIDENT RestConnectorMasterTable;

DROP TABLE RestConnectorMasterTable;

Please suggest your opinions.

Thanks,

Vijeta

Re: Rest Connector Data extraction issue

petter — Tue, 21 Feb 2017 06:35:36 GMT

In the preview it is necessary that you make a checkmark in all the levels that you intend to include and all the "columns" too that you need to bring into the load script. It seems from you explanation that you haven't done that....

Re: Rest Connector Data extraction issue

Anonymous — Mon, 05 Jun 2017 19:54:30 GMT

Hi vijeta and Petter , have you figured out a solution or walk-around now?

I meet similar issue when I try to load csv data source with Qlik sense REST connector.

Petter , there are 3 lines as header in my csv data source. Actually, 'columns' do not show in preview, as the data starts from the 4th line in csv data source.

Could you please give any suggestion?

Thanks!