Skip to main content
Topics#IntegrationSruthi M's Question
Sruthi M (Dev) asked in #Integration
Jun 30, 2016, 6:09 AM

Generate XML dynamically

Hi,

 I have to generate an XML to send as Request, from a list returned by a dynamic soql query.The fields to be queried from the object in the soql will be in my custom settings like name-Account,and fields to be queried in the record of account.

How do I generate XML, for dynamic object selected and its fields,suppose if I select object 'B', in my page,i should generate XML for the object B with the fields in the custom setting mapped to B or if its object A the fields for object A from the custom settings...

Thanks in Advance..
3 answers
  1. Vineet Kumar (Publicis Sapient)
    Jun 30, 2016, 8:07 AM
    Below is a pseudo code : 

    List<String> fieldNames = new List<String>();

    for(Template_Custom_Setting__c thisCs : Template_Custom_Setting__c.getValues(objectName)){

        // Keep your splitting logic for getting the fields name as is.  

        fieldNames.add(thisCs.fieldName);

    }

    for(String thisField : fieldNames){

        finalFields =+ thisField;

    }

    String queryString = 'Select Id'+finalFields+' from Account Where Id ='+' \''+CurrentPageId+'\'';

    List<sObject> sobjList = Database.query(queryString);

    // Iterate over the list of field names. 

    for(sObject thisRecord : sobjList){

        for(String thisField : fieldNames){

            system.debug('⌗⌗⌗⌗ Field Name = '+thisField);

            system.debug('⌗⌗⌗⌗ Field Value = '+thisRecord.get(thisField));

            // you can create your XML structure, with the above values.

        }

    }

    If my suggestion(s) worked, do let me know by marking the answer as "Best Answer" right under the comment.

    This will help the rest of the community should they have a similar issue in the future. 

    Thank you..
Write an answer...
0/9000