Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

cancel
Showing results for 
Search instead for 
Did you mean: 
kdaniels-obrien
Partner
Partner

Load * from a REST Connection creates __extra field

Hi,

I have a load script that requests data from a web service using a REST connection. Below is a small sample of my script.. 

TableName:
Load
*;
Sql Select
Col1,

Col2

From
JSON (wrap on) "root"
With connection (
URL "my/URL/here"
);

 

When I use the Load *, I get this field named __extra in my data model. If I specify the column names instead of a Load *, I do not get this __extra field.  For my use case and logic, I must be able to use a Load *. Right now my work around is to just drop that field but I really would like to understand:

1. Why  this field, __extra, is coming into my data model?

2.  What is this field? (It seems to always be null) 

3. Is there a way to use a load * without getting this __extra field? (with out a drop field) 

 

Thank you!! 

0 Replies