3. Import JSON File Using Amazon s3 Adapter

In this tutorial, you will learn how to do Manual Process with a JSON file via an Amazon S3 adapter.

Note: We have made changes to the message structure starting from version 2.50.13. We have added the File Message to cover business messages created from files. Everything else remains the same. For more details on the File Message, please refer to this document link: (link not available))

Pre-requisite

• Create Integration and Inbound interface with operation upsert
• Create a message type
• Link a message type for the inbound interface
• Mapping

• Click save mapping
• Enter to integration detail page
• Click the link Amazon Control Board on the Custom Link section
• You will arrive at the Amazon Control Board
• Click Adapter tab
• Click the New button to create the adapter

Fill Name adapter

• Choose Amazon S3 on Type
• Choose Inbound as the direction
• Choose Status
• Choose Salesforce Type = Salesforce Authentication Provider
• Fill Named_Credentials (Note: Please follow the link to create the Named_Credentials #article/2-named-credentials-to-access-the-aws-s3)
• Select JSON on File Type
• Fill Folder Path
• Fill File Name
• Source Encoding UTF-8

• Click Save Button
• Link this adapter to the interface

Here is the sample payload

Here is the screenshot of the CSV file in the folder of the AWS S3 service

• Click the interface Tab on Amazon Control Board
• Select an interface
• Click the Manual Process Button
• It will display the Manual Execute Option pop-up screen
• Check the Read files from amazon s3 and push record to salesforce.

• Click Read button

The record of the XML file will import to Salesforce and create the completed message as screenshot below