How to pull in data from Amazon AWS S3 and save it in salesforce object. I have a requirement to automatically pull or push data daily once from a CSV file in Amazon AWS S3 bucket to an object in Salesforce. What would be the options and approach to take to achieve this?
Arrived at this approach for connecting Salesforce with AWS S3 and accessing/reading a CSV file:
Use Named Credentials in Salesforce to establish an authenticated connection between Salesforce and AWS S3. This way we don't have to worry about managing Authorizations, Tokens, Signatures, etc.
Get 1. Access Key Id, 2. Secret Access Key and 3. URL from AWS S3 to configure the Named Credentials.
Once successfully connected to S3, with a REST request GET method, pull in the data in JSON format in the response body.
Parse the JSON data and save the records in the Salesforce Object.
