Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
RichB
Contributor II
Contributor II

Not all parameters are loading when using external script

Hi,

I have written a python SSE called Teal to perform geocoding on our data. The function below is executed and stored into a table from within and external script.  The script is then being called from the app like below

[External Script  File ]

GeoCode_o:

    NoConcatenate
    Load * Extension Teal.Geocode(ORIGIN_LOC_init{LOAD_ID, ORIGIN_ADDRESS, ORIGIN_CITY, ORIGIN_STATE, ORIGIN_COUNTRY, ORIGIN_ZIP});
[ End External Script File]
 
[Qlik App]
$(Must_Include='External Script')
[End Qlik App]
 
In this situation the SSE function Geocode executes fine however if anything is added after the $(Must_Include) statement it turns out that some of our parameters go missing and the function errors.
 
In other words changing the qlik app by adding even a trivial inline table  such as below causes our function to error:
 
[Qlik App]
$(Must_Include='External Script')
 
OriginTemp:
LOAD * INLINE [
LoadID, Street, City, State, Country, Zipcode
1, 4235 South Stream Blvd, Charlotte, NC, US, 28217
2, 123 Fake Street, Chicago, IL, US 98984
];
 
[End Qlik App]
 
What happens when a table like this is added is that our parameters being read by the SSE change from a full set of parameters:
                            [4, 4235 South Stream Blvd, Charlotte, NC, US , 28217]
 
to 
                             ['1', '4235 South Stream Blvd', 'Charlotte', 'NC', 'US']
or                         [4, '' ,Charlotte, NC, US , 28217]
 
Where in the later 2 either the Street address goes missing of the zipcode goes missing.
 
The SSE code the reads in the parameters is:
 
# Consume all locations
for bundled_rows in request:
      for row in bundled_rows.rows:
          params = [d.strData for d in row.duals]
          print(params)
          locations.append(params)
          print(params)
 
Does anyone know why I am seeing this strange behavior from the parameters?
 
 
Labels (1)
0 Replies