Rest Connector Data extraction issue

[vijetas42]

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

[petter]

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....

[Anonymous]

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!