how to display the hierarchical data in form of tree in mashup

Hi @achitters you can use Grid Advanced Widget from ThingWorx Marketplace. It contains both Grid&Tree widget allowing you to display such a hierarchy. Additionally there's a sample entity within the zip that you'll download named GridAdvancedExampleEntities-v3.0.xml this will create some demo mashups and things with services to return demo data something the attached screenshot 

Thingworx has a structure called Networks which creates that hierarchy and can be easily visualized in the Tree widget in a mashup.

What it depends on is a table that has to and from or child and parent relationships.

for example

child   |   parent

    A    |      

    1    |      A

    2    |      A

    B    |      

    3    |      B

    4    |      B

This would give you two root nodes called A and B each with two children

The only requirement to be able to use a Network is that they all have to be Things, if that is not needed, you can create a DataTable instead. Make sure you have the Child and Parent field as primary in the DataShape.