Qlik Community

App Development

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

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Ericga
Contributor II
Contributor II

Connecting to S3 using Web Connectors

I am attempting to extract data from a csv file stored in an Amazon S3 bucket utilizing the Qlik Amazon S3 Web Connector.  i can connect successfully with the Web Connectors dashboard.  And I can do a GetRawObjectAsText and in the Data Preview pane and I see the data as expected.  Comma separated Header on first row and the comma separated data on the rows after that.   

The issue comes when i try to use the connection in the Qlik Sense script.  When I run the script below, it returns an error "There were no fields to load in the given source".  I can change LOAD * to LOAD <FieldName> and it gives the error "Field <FieldName> Not Found".  

Why won't "LOAD *" return any data?  is there another syntax i should be using to load data with?

Thanks

let vQwcConnectionName = 'lib://WebConnectors';
AmazonS3Connector_GetRawObjectAsText:
LOAD
*
FROM [$(vQwcConnectionName)]
(URL IS [http://MYSERVERNAME:5555/data?connectorID=AmazonS3Connector&table=GetRawObjectAsText&accessKey=sta_gen_1%3a2CUOdHj20j5uMLPK0bSZ3Q%3d%3d%3aDJcC47nVGnN1yBT%2b%2ffch%2b%2f0rxDGtC4UQWCsalMYFxXs%3d&secretKey=sta_gen_1%3aGxssUVLcNOVden2wqB2U3A%3d%3d%3aIWeNTcBbAIyymDKMdUb5COyegrR3DLOuIVUo4LiGF0RUvtfret9viZLCKT8t3P1&region=us-east-1&bucketName=theS3Bucketnamehere&objectKey=KeyName%2fFILENAME.csv&appID=], qvx);

 

 

1 Solution

Accepted Solutions
Ranganath_DR
Support
Support

Hi,

Refer to below link and check if everything correctly is correctly set.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Conne...

 

Regards,

Ranga

View solution in original post

2 Replies
Ranganath_DR
Support
Support

Hi,

Refer to below link and check if everything correctly is correctly set.

https://help.qlik.com/en-US/connectors/Subsystems/Web_Storage_Provider_Connectors_help/Content/Conne...

 

Regards,

Ranga

View solution in original post

Ericga
Contributor II
Contributor II
Author

Ranga,

the link you sent helped me solve the issue.  i thought what it was showing only applied to saas but that is not the case. in my example above based on another post i created my connection with only the first portion of the url which is http://MYSERVERNAME:5555 instead of the whole url.  When i created the web connection with the full URL and did a Select data it created the script i needed.

Thanks