1. How to export the ContentVersion with the AGENT as XML/JSON and BINARY format (NEW AGENT)?
Introduction
We already learned about how to export binary data to Salesforce. Now we will learn about How to export attachments to an Account's business by using ContentVersion. Sometimes, the user wants to import only attachments to the Account business. SKYVVA has a limitation which can push file (Base64) around 1.6MB per transition. So if the user wants to import many files to the Account.
How to export Attachment to Account by using ContentVersion?
Pre-require
- Create a MetaData provider and repository for the upload message type
- Connection destination and create an adapter
- Create Integration and Outbound Interface
Case A: Configuration of pushing SObject and attachment in the XML, JSON file.
Step 1: We need a Repository to upload the structure for mapping. For instructions on how to create a MetaData provider, repository, and message type, refer to the following guide for metadata providers.
[su_box title="Note" box_color="#2a8af0" title_color="#000000"]First, we need to upload the XML structure that is the same as the data we want to export to Salesforce.[/su_box]
- Create Repository
Create Message Type
- sObject: Type Plain structure
- Account: Type Salesforce sObject
- ContentVersion: Type Salesforce sObject
- sObjectRepository is created
- Message Type is also created and it looks and feels in a hierarchical arrangement with sObject Account & ContentVersion
Step 2: We go to the Agent control board to connect the destination. How to use the Agent control board.
– How to use Agent Control Board (New)?
- Connection Destination in Agent Control board
Step 3: Create an Adapter in the Agent control board, We need the Adapter to transfer the data from one System to another system or computer. Here's an example below.
- Go to the Adapter on the Agent Control Board
- Create Agent Adapter property
- filetype: XML, JSON
- filename(extensions): XML, JSON
- Hit button Ping Connection
The adapter (outbound) is created successfully
Step 4: we need an Outbound Interface for exporting data from Salesforce.
- Create Integration and Outbound Interface with Message Types that we had uploaded.
- Put an adapter, MetaData Provider, Repository, and Message Type, and click the button save.
[su_box title="Note" box_color="#2a8af0" title_color="#000000"] Source Name we choosing ContentVersion. [/su_box]
- Scroll down to Outbound Adapter
- Open Mapping
- Account (Source) to Account (Target)
- Name
- ContentVersion (Source) to ContentVersion (Target)
- FileExtension, PathOnClient, VersionData (required fields)
- Select ExId's
- Save
- Select your Interface
- Click on the Manual Process button
- Select the Radio button "Manually select the sObject using the Query Builder?"
- Click on Next
- Select the Account Object and Name field related to it
- Write Query SELECT Name FROM Account
- Scroll down to Execute Query Result
- Select your Account
- Click on ok
[su_box title="Note" box_color="#2a8af0" title_color="#000000"]User Account having Note & Attachment file.[/su_box]
- Now click on the Send Button
Go to Message Monitor
- Select your Integration & Interface
- Click on the search button
- Output Result for XML file
- Output Result for JSON file
- Copy this link
iVBORw0KGgoAAAANSUhEUgAAADwAAAA8CAYAAAA6/NlyAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAACvZJREFUeNrkWwlwE+cVfiutJMuSjQ0B7NJMOWzaQnpg2pRAg+kk03SAcoVgCNBymZqQcMyEBAbMHUjBYGghgGmmIU1sjrQhBrdNaYcrk5QkctKm7Qw4HGmL7RCCjQ5Lu9Lu9r1fh7WSbUmrdWfc/p43Xq3+/9//e+997/2HloOoMsk/JQf/bUCZgjIQena5gXISZVOt6WRr+CYXBXYe/qtEIdBg9BnB2mTpkUi9+QJIGVL4I4FdiaBfigAOgf0lXduvZ8KAun5gbc7o0eb15vng5oRb4B7UFr41n0BzITe+TpbNrc+Ge1/Lg/+l8q/pzdBS5AxbehAf4myO7ZoVBhzvBzL+dWfxDPaqPmcgbYxeQ7c9jzCJOX56LotPfChAQf/aPiArSrc8lPj06aTPwTXMA5I1XqE5jizoeyYXTC2mbnk+Ybu24t90OYUADzSghs03Td1iXeELIvyzrKlDoJGoMtLFlJF/7B6w/92m+xgIG+fmQLErA3nmVo1mkGX9wcoI8hMEK1sT900KaSy5DYOfs4BBZxdX0HP5Gwbw3ycBH76hdAPgW5PuJAU2WkHUpn9Nb13HIQYCECYrH3mYzvz1FgjgvN+TcjtqY383E6wf6zcHEP3+yHXEwnq79O2prWm1HfDTvvoETMQlSRLDqLawjoCd32sDcYBfu0WwbWuxG7LPZqZvXVFUYQtaWEfAgT4y3B3vSrsf6iPzHQxgbZz2YIXiJ/6SdZVoDpNL68Th1ukuDD7p90V9tDzqgtyXszT3QWClkCEVUNQW1iNKC0P94P2GoBs12h7wgfVtM1iumDS7sxJjyHYL6wC4dZ5b99TmnOGBPpuzU6eWLKkwqYKWHhz2TMYlWR/9c7n/XgncD/kg84w5Rev6O8SkC4cJaNvDAnRX8UzygeUiD5w3uQBGvA1IUsxsC/RLS55ZPlAylW4DTH17JqOVqy1Jczcej8KW/2m7dOCrMohFgW5f1/q+7wfTRSMYP+l6nk04KDp3VgzRLq1F2koF+G8V7+NiwvHQNJKtDTqQtNOSMC0A8j2pu7LhsyAX5b5K6t70XbT0BWPS3O08aKUImAYrPippW58eDA7YV546FYS5ATC8xwHn6XiR0BkOJbSBp5nDQpk2zhtpsH9TItfSt5UUAxgCmyaB6QgXb90uuAsKp53DgW/JIA/TEJXRKvx+iPRD1+DRECjH4wroS7JqTILYNb9VQSts4aQkAzU5T1sKMh7H57iV9r7wmu5pmpD8uL2fcBpSupIQaEN0OE9GpAkY8TQsVZkbn4rvj+5x1zXk5uHoxsUKW+tSGpIVuUtRWzi0xZNIKCLLJRqXay923i+8qC34yQs4EC2BkHWVrkWVhwGS4q6yTOPmWo0EyjW5834/QtC1GoIgbXDONCQ1dlC5tKIkdGXlfqx3nwbr3sK+3wgkpku1X1MA46fg0nFQYkpCrIUTaZIr5bXNgw8HkgPiCdXVktfLkj8HSwow9ziC7Ze6dZU/y0ySrv8n5PJHqbu24es4xx7N6wR4ME4UJhk15VwtFpP3aLWyBTg7lz5gwyKNrlwdYPzVwnmlJvWozfU3AD/VnB5g7iG07Nc0ROZrOOhabamGKesNbcoyzTEz4NoApxGo5L3a96TTDWCWpzMSA1bCk48o4WbxwTyXsnUw516VO12TJivyO1JKAS86gBkeMMb3GWth1UJ5EAaqyakHKuVTnOq9KqYNNixSlYjWTt21LUsymLFUmNRzafWDDIu17QPTABW3ohvgQGMAxF8LmgKYiQJYGGjcaklp1wb3sBE4DYFK/qsE8tsB/cDSogAX9MIRL0hXUw+A5h+hlftzqu2dDl3aONusIcjgAHf5dAQbwBWQnx2P0J9vf5u23DzNEumjUw5z/VOfUQVex/Vos6wLWDq89gcklTcGPvSD+Gbqrm0oMMZ6dDyH5RTdh+r7XxbSj8q4ZhXQhcNnubHi3edh8SGlmNIQ6DhoRXNYPOBN7UgD66cdjeUgWFnu3Etklwxt+5I/uyLleF9qS8xh6cMA+DYk1iZ9T/WofrrBie0ly4nrCr/zgXu7M7HXNUvgXN7ClBSbh/lowBFOviUy3pgeMQM/JjhdM+QZGE/lqwGQ/oI8exNzpFv78QoNgcDKcmp9EGj/ByKYH7Qw4QtMbNFAIAPowuJbAqvT9b40KHHnqOBC937Nx0TvQnz104a5Rn1JTRJ4j7cxSV7D0ScPCqg2uux2OxQUFqrqNzc1Q3NzE7v+5ogR8HFDA7jdak7l5eVDXn7wt5r0HdWJ3Q232jJhyJAhQZ263NDQcKXTMRYVFUFTUxOTjordngVDhxbClSs0FhcY7OiF7q6no8Yvr//KRnJV8fdBSz61bBls3b4dCgoKYNjw4QwcyZN4Py8/Hy5euADHTpyAS5cuoRLaBzJ/wQJst40pi/aIn9u2DRXUjIAaQruiCmRYM2Df/v0watQoMJvNsGLlSjhz5g8IPP43IWOLi6Fyzx7IysqC+vp6EIT4tPTs6mdh4aJFcOzYUeC+A9D3SA7YSqzg+6PA+BtdMh6xAv9FPp7D02fMgLWr18DFixdUDUYg6L379sG2rVsjLkJt8lEJz6GCSBnR7dwIYs3atazOqVOnwGazw/4XXmDfPbHkCXChRciC69avx89LVM/KQsuVl5fDsaNHGXACVVlZGWf98RMmwJbNmzGUuKHf8txgFEY+Zy+3weernXFHLaqzpTBgcsWCwgJ0o8aIdaiQlh8cPTrymVyeZP7ChfABfvfU0ieZW4XLb+vqWLpZhwOn4EQDtKO15s6ew8BS2b27Eg4cPABjx46F8+fPR9quWLkC67jhcNVhcDgcsGPnTjh9+jS6brv7l6Oi6h317H72QhsY89sXOxljMaCNMIFQL8Yh5qOXh1R+VrkHHptZwoDEliCwpez6B+PHM+sSv7Zt2RoBEXZfAltbW8ty6/oNG5jbLikrA6erXfMOx/twtKaGDd4xeTKrM3LkSJgwcSKsenoVq3vu3DkE5mB15syezdqVli5mzy77SRkYMXtkLwquYz11XjAXmsA0lIfcdVnQNPV2nI3j8jAFnTXPPANjkGfRMn3qVBiBViI+U9mLLjZv7lzmuide/w08VlISPPbwY8qSgicBYXcmKxGwy5cvx+XWqqoq1t+i0lL2mZRzHkGeO3c2UmfTxk0MYCnWycfAWLq4FK1fBY2NN6F3efAHLzJmlZbdLmipDCqUR4uT5TucePCFfOSLBcgXctXYgdkwGEWHd/rf2NgIS5F/v8CHL0CP+DlylBTW0UF09GwuWpxOJwLaCLNmzYKdFRUs6O2q2KWqcxOB1VTXwEyqs6sCmvC5hw4dAiu6rqUouNhpqbwLkgvTlUMA9+ngbDFrZiZwtuCKyTjYFHHpG5zdMNBYwGPi9sNWDALP79jRYUivQ76QtcIApNAm969eeQUuvfsebNq0EV6trsYBVzDLqr2pg1wfKmfPngXH+w4YN24ca0sAY8uhQwdh4g8nYhoaCovRpdlCJ7RL6XOI4DrVnpPv7LoLmcXB34MY8w3A+Q3A92Ecv0HvPFD4WyHWC9Cy9LPkJg4hjirQfT9k0bP0rugLtmLG8z2qlzy8dR64u+VOpxMV4qUky9CTSq9VvaHXjF50/M9e8oh7jYcs7axsAf8Vsf2QLep8tacUHjmbs7w3ZI6xhd/OCr7GE64Q+6IWzVSEf/hA6VkGDe50FJrBmGsEzsjgtYbAnmT7XdEV/x9exfuPAAMA9OtPwEmPWQAAAAAASUVORK5CYII=
Go to Base64 to File on the web browser
- Paste the link here (Base 64*)
- The attached file is shown here
Case B: Configuration of pushing SObject and attachment binary (base 64 data) type File, jpg, png, pdf file.
Follow the same above steps till mapping (step 2)
Step 3: Create an Adapter in the Agent control board, We need the Adapter to transfer the data to an outbound file folder. Here's an example below.
- Go to the Adapter on the Agent Control Board
- Create Agent Adapter property
- Content Format: Binary
- filetype: Binary
- Check: Create Reference File
- Hit button Ping Connection
The adapter (outbound) is created successfully
- Open Mapping
- Account (Source) to Account (Target)
- Name
- ContentVersion (Source) to ContentVersion (Target)
- FileExtension, PathOnClient, VersionData
- Select ExId's
- Save
- Select your Interface
- Click on the Manual Process button
- Select the Radio button "Manually select the sObject using the Query Builder?"
- Click on Next
- Select the Account Object and Name field related to it
- Write Query SELECT Name FROM Account
- Scroll down to Execute Query Result
- Select your Account
- Click on ok
[su_box title="Note" box_color="#2a8af0" title_color="#000000"]User Account having Note & Attachment file.[/su_box]
- Select the Radio button "Use the SOQL statement on the interface to select the sObject"
- Now click on the Send Button
- Go to Message Monitor
- Select your Integration & Interface
- Click on the search button
- Output Result
Summary
In this tutorial, we have learned about How to export files to ContentVersion in Salesforce. This function is useful for users who want to export files to Business sObject. We need to follow four steps to this function