Unable to load JSON file from Amazon s3

user123 — Thu, 21 Apr 2022 10:18:38 GMT

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.

Re: Unable to load JSON file from Amazon s3

Francisco_Fernandez — Mon, 25 Apr 2022 09:03:42 GMT

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

topic Re: Unable to load JSON file from Amazon s3 in Connectivity & Data Prep

Unable to load JSON file from Amazon s3

Re: Unable to load JSON file from Amazon s3