xml to json conversion

Use case


    To convert the XML file to JSON file using node.js

    Consider sample XML file name as test.xml which contains the following information

<groceryShop>
<ownerName>xxxx</ownerName>
<name>DepartmentalStore</>
<address>bangalore</address>
<pincode>562320</pincode>
</groceryShop>

    There are different methods to convert XML to JSON .but here we will see customized JSON format where will see only required information details. we will create a JSON structure.

output:

var groceryitems = {
ownerName: xxxx,
name: DepartmentalStore,
address: bangalore,
pincode: 562301
};

// required modules:

const fs = require('fs'),
xml2js = require('xml2js');
//Step 1: To read file using fs.readfile syntax in node.js.it will fetch all the information
    and store it into one variable
var data = fs.readFileSync('test.xml', 'utf-8');
//Step 2: Convert it into string
var doc = new dom().parseFromString(data.toString());
//Step 3: To extract information by using xpath ,select or known methods example,
var name = select('//FormName:name/text()', doc)[0].nodeValue;
var ownerName = select('//FormName:ownerName/text()', doc)[0].nodeValue;
var address = select('//FormName:address/text()', doc)[0].nodeValue;
var pincode = select('//FormName:pincode/text()', doc)[0].nodeValue;

//name will contain name of the groceryShop,
//ownerName will contain ownerName of the groceryShop,
//address will contain address of the groceryShop,
//pincode will contain pincode of the groceryShop,
//Step 4: To map with json variables
var groceryitems = {
GroceryownerName: ownerName,
Groceryname: name,
Groceryaddress: address,
Grocerypincode: pincode
};



Popular posts from this blog

salesforce questions and answers

Image
1. What is Lightning? A lightning Component framework is a UI framework for developing responsive web apps, Single Page Application FrameWork, It Supports partitioned multi-tier component development that bridges the client and server, It uses JavaScript on the client-side and Apex on the server-side. 2. What is the use of Lightning Component Framework? Out-of-the-box set of components, Event-driven Architecture, Framework optimized for performance. 3. What is a component?  Self-contained and reusable units of an app, A single line of code can use the entire app wherever want. 4. What is an aura framework? Aura is an open-source framework. Enables building apps completely independent of your data in Salesforce. 5. What is lightning App Builder? The Lightning App Builder, To build apps visually, without code, quicker than ever before using off-the-shelf and custom-built Lightning components. Make your Lightning components available in the ...
Read more

How to clone a record using custom button in salesforce

Image
USE CASE  A user wants to create new records by mirroring the existing records with minimal clicks using the “Button” (Cloning the records). SOLUTION  Create the custom button where all the user-requested fields will be mapped. Add created a custom button on the page layout. Create a Custom Button  Go to Setup  - Object - Buttons, Links, and Actions Section -- Click New button or Link ->  Enter Label Name(Account Transfer) Select Display Type as “Detail Page Button” and Content Source as “ URL ” Add all the user-requested fields with their IDs and add the  return URL  with the Object id. If the field is Lookup, Prefix  CF  with field id (See the below Image) Finally  Save  all the works you did. 6.       Add created “ Custom Button ” on the Page Layout. 7.            When Clicking on the “ Account Transfer ” Button, Whatever the mapped fields in the button will...
Read more

How to extract information from xml using node.js

There are plenty of methods available to extract information from an XML file and I have used the XPath select method to fetch the tag values. The following modules have to install using the NPM install Method. var fs = require ( 'fs' ), xml2js = require ( 'xml2js' ); const parser = new xml2js . Parser (); const xpath = require ( 'xpath' ), dom = require ( 'xmldom' ). DOMParser ; sample XML file name as test.xml. < groceryShop > < ownerName > xxxx </ ownerName > < name > DepartmentalStore </> < address > bangalore </ address > < pincode > 562320 </ pincode > </ groceryShop > The above modules will drive the process to fetch the information. //To read the file by using the readFile method which may be sync or async function fs . readFile ( 'test.xml' , function ( err , data ){ if ( err ){ //display error } else { // d...
Read more