Tutorials

  1. Home
  2. Docs
  3. Tutorials
  4. 63. How use conversion table as mapping formula?

63. How use conversion table as mapping formula?

Learning Objective:

After completing this unit, you’ll be able to:

  • Describe what is conversion table.
  • Comfortably use  conversion table as mapping formula.

Introduction

Conversion functions are used to convert Skyvva data elements and variables from one type to another. Here we required to convert a value from an ID to another ID. Once the conversion table is define then value can be read using the vlookup from SKYvva mapping.

What is conversion ?

conversion refers to either implicitly or explicitly changing a value from one data type storage format to another. Conversion Table is something which  system creates the active version of the table in the database and it is maintained by user.  Skyvva promote user to define the conversion rule using a customer setting.

Why we need to use conversion table as mapping formula?

To convert a value from an ID to another ID user  has to define the conversion rule using a customer setting.  For example,  from SAP the country code is 2 digits like DE but in Salesforce it is a full name like German. Therefore we need to convert DE to Germany. So to convert this value from DE to Germany we required this feature.

Pre-requisite:

we should have salesforce org with Skyvva product. Create integration in your organisation.

How to use conversion table as mapping formula?

Follow the given step to use conversion table as mapping formula:

Step1: Create custom setting in your salesforce organisation.

1. Go to Setup.
2. Click on Home =>search for ‘Custom Code’ in quick find box =>  click on Custom Settings.

3. Click on NEW button.
4. Click List of Setting Type field .

5. Click New button to Create Fields

6. Click Manage button. -> click New button to create Data. It is navigate to:

Step2: Configuration on SKYVVA IntegrationCloud

1. Create Integration
2. Create Inbound Interface
3. Do mapping

4. Add VLOOKUP formula :

VLOOKUP(CurrencySetting__c, Value__c, Name, "DE")

 Note that all fields for Formula must taken from Custom setting.

Step3: We can call data with  SoapUI, Agent or by Manual Load. Here we  used SoapUI to call data from SoapUI to  Salesforce .

1. Open SoapUI application and define data payload. Give call to salesforce as shown in screenshot:

2. We can check the result on message board. Here is the result data in message monitoring after call date from SoapUI.

3. Value is converted from DE to Germany. Here is Germany value in record detail that return from DE.

Was this article helpful to you? Yes No

How can we help?