Unable to load JSON file from Amazon s3

[user123]

I'm using Amazon s3 connector to connect to my s3 bucket. After the successful connection, when I am trying to add data from a json file it is not able to load it in a proper format when previewing the data, though after adding the data i tried to manipulate it using the data editor by loading all the fields (using Load * instead of Load [@1:n]) and specifying the json keyword in the last row which indicates file type but after loading data the following error occurred: There were no fields to load in the given source.

[Francisco_Fernandez]

Hi @user123 ,

Have you tried using the Rest connector? For Json files, it's a much better solution rather than using the web-file connector.

Also, I would verify that the json file is correctly formatted.

Best regards,

Francisco