How to read it from Amazon S3 Bucket and Load it into Salesforce ? Expecting some sample use cases.
Thanks & Regards,
This is a loaded question.
You can move files from S3 and accordingly upsert/insert/update into SFDC.
It all depends on the data you grab from bucket.
Maybe you can manipulate the data
Put the data into SFDC
Thanks for the prompt reply, I have created a process to read the files from S3 bucket, but stuck with some error.
Correct me if am doing wrong while loading from S3. Looking for some sample process
Can you bring up the error here?
Action seems to be correct.
Connection and Operation are something that you need to configure to access the specific bucket.
I could see Parameters are set to the connector and hope those are legitimate.
NOTE: I'm assuming you are using a local atom for this test.
If yes your local atom server should be able to access the S3 URL.
Incase of cloud atom, your S3 bucket URL should be publically accessible.
Thanks for the details.
Yes. we are able to access this S3 bucket from the local atom as we are able to write files into one of the folders in this S3 bucket.
The issue is only withe Reading. We are trying to figure out how to specify the file and folder names from S3 bucket to read a specific folder (Similar to disk or FTP read operation, where we specify the file pattern in the operation). we tried with the starting step ( no data) and used 'Set properties' to specify the S3 folder and file name , but still we are not able to read the file.
Appreciate if you can provide some pointers on this.
You have all the required details in Amazon S3 operation
What was the error you see ?
Please find the error message below:
[NoSuchKey] The specified key does not exist. (Service: Amazon S3; Status Code: 404; Error Code: NoSuchKey; Request ID: 881FE85FABDE24CAB)
Maybe this thread helps you
Probable reason is that file doesn't exist with the key.
I've just posted a blog post on this topic, including a few specific examples. Please take a look and let me know if this helps: Amazon S3 Made Easy
Retrieving data ...