File Adapter

Agent File adapter uses to integrate data from file to SFDC and from Salesforce to file. The File type that Agent support is CSV, XML, and Excel that can be integrated with their content.

A File Adapter is an object used to manage file-based information through Clarify. File Adapters aid in the management of file-based resources: they can create, edit, delete, read, or write files on the local file system or on mapped network drives.

How Agent File Works

Business Processes use Agent File Adapter to perform file-based operations on data. Writing data immediately after transformation activity is the most common use of File Adapter. In addition to the data, Business Processes can supply runtime directions to the adapter. For example, a user may want to supply the name of a file to be written to the local file system. The Business Process can supply the file name (and other common runtime values) to the File write Adapter.

Prerequisites

• The user has to assign a SkyvvaAllPermissions set to the current user.
• The user has to add skyvvasolutions namespace inside callout logic.
• Supports Asynchronous mode, Asynchronous mode is a switching technique used by SKYVVA that uses asynchronous time-division multiplexing to encode data into small, fixed-sized cells.  An Asynchronous mode is working as when you make a request and whatever the result. Whether you failed or succeed just call the function SKYVVA gonna give you a call back code. So Asynchronous never waits for a call to come back in order to execute the rest of the code.

Cache → Object Name → Integration Name → Filter → Push → Developer Console → Execute

1. Adapter Section: Choose Adapter Type (File) → Name Adapter.
2. Adapter Properties:

• FileProtocol → Local
• Content_Format → Text
• Filetype → CSV
• Folder → File
• filename → File.csv
• upload_mode → Override
• adapter_instance → akashtest-integrationORG2
• Separator → (,),(;),(Tab),(I)

3. Click “Ping Source Connection” to test the connection to the specified folder and file.
4. Click Save.

–How to use Agent File Adapter For Producer?

Introduction

Agent File Adapter For Producer, we will learn how Agent File Adapter works for Producer. Agent File adapter for producer uses for writing a file from salesforce to file. Agent file adapter for Producer means outbound Agent File Adapter. To use the Agent File adapter for Producer, we need to configure the Agent Control Board, and we need to create an Agent File Adapter. In this chapter, we will learn how to use the Agent File adapter for the producer, and we will know how to do outbound with CSV, Excel file type.

Prerequisites

Firstly, you need to have some required step before you can use the Agent File adapter:

• Create Metadata Provider, Istructure Repository

• Create Integration and Configure a new agent control board
• Create Agent File Adapter (Outbound) on new Agent Control Board
• Create an Outbound interface
• Checking Cache monitoring status
• Callout  to new Agent

Since the user now completely understand; How to use the File Adapter For Producer, Agent Control Board, by hitting the upper link, now we understand the Architect of the Agent Control Board.

Namespace in an XML file is used to validate the schema

xsi:schemaLocation=”http://schema.infor.com/InforOAGIS/2 http://schema.infor.com/2.12.x/InforOAGIS/BODs/SyncCustomerPartyMaster.xsd”

xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns=”http://schema.infor.com/InforOAGIS/2″>

–How to use Agent File Adapter For Consumer?

Introduction

Agent File Adapter For Consumer, we will learn how Agent File Adapter works for consumer. Agent File Adapter for consumer means Inbound Agent File Adapter. We use Inbound Agent File adapter for reading using the new event-driven mode with the consumer. We have an event-driven listener who is a camel consumer. We don’t need a scheduler. We add the real-time and event-driven feature to pick up immediately. To use the agent file for consumer, we need to configure the Agent Control Board, and we need to create an Agent File adapter.

Prerequisites

Firstly, you need to have some required step before you can use the Agent File adapter:

• Create Metadata Provider, Istructure Repository

• Create Integration and Configure a new agent control board
• Create Agent File Adapter(inbound) on new Agent Control Board
• Create Inbound interface
• Checking Cache monitoring status

Upload CSV file on consumer folder. Example: MyAccount.csv