Mapping fields for syncing

Question

I am developing a project which allows to sync Salesforce data with it.

Steps: 1. User select module i.e. Leads, Contacts 2. Displaying all column from my database and salesforce in dropdown

Now what I want to do in step 2 is that sort and mirror the column so user don't misplace data.

In my leads table columns are: FullName, Designation, Contact, Mail,

Salesforce's leads table columns are: Name, Title, Mobile, Email

So when user select FullName from the dropdown then select another dropdown of salesforce column with Name and vice versa and same with others columns

So the thing is that columns remain dynamic so what would be the better approach ?

Thanks

Answer 1

On the Salesforce side, you can use Schema.getGlobalDescribe to find all the SObjects (tables) in the org:

// Fully dynamic
Map<String, SObjectType> gd = Schema.getGlobalDescribe();
SObjectType type = gd.get('Lead');

or just hard code some of them:

// Hardcoded for a speficic SObject
SObjectType type = Lead.SObjectType;

and from the SObjectType token you can find the details of all the fields:

// Find the fields
SObjectField[] fields = type.getDescribe().fields.getMap().values();
for (SObjectField field : fields) {
    DescribeFieldResult dfr = f.getDescribe();
    ...
}

Whatever system you are syncing with is likely to have a similar type of API.