DataManager and JSON File

Question

Hello!I would like to use Datamanager with treeGrid.Scenario 1 - JSON file on the serverI have a JSON file on the server.I would like to use DataManager to get the JSON file and deliver to the datasource attribute of the ejTreeGrid control.How does one do that most simply using DataManager?Scenario 2 - JSON file on the server and a PHP file that will echo a JSON fileI have a JSON file on the server and a simple PHP file that will echo the JSON file when called.I would like to use DataManager to get the JSON file and deliver to the datasource attribute of the ejTreeGrid control.How does one do that most simply using DataManager?Thanks,Derrick

Jayakumar Duraisamy · Answer

Hi Derrick, 
Please find the response below. 
Query 1: I would like to use DataManager to get the JSON file and deliver to the datasource attribute of the ejTreeGrid control.How does one do that most simply using DataManager? 
Answer: We can directly get the data from the JSON file by pass the server address to the ej.DataManager(). 
Please refer following code snippet, 




$(function () { 
            var data = ej.DataManager({ 
                url: "http://Syncfusion.com/***/**/treeGridData.js", 
            }); 
            $("#treegrid").ejTreeGrid({ 
                dataSource: data, 
            }); 
        }); 
Please refer following link to know more about TreeGrid remote data binding, 
Doc Link:  https://help.syncfusion.com/js/treegrid/data-binding#remote-data-binding  
 
Query 2: I have a JSON file on the server and a simple PHP file that will echo the JSON file when called. 
Answer:  In PHP, we have a method file_get_contents(), by using this method, we can read data from the JSON file and decode the data to JSON format. 
Please refer following code snippet, 




// Read data from the JSON file 
        $jsonData = file_get_contents(“http://Syncfusion.com/***/**/treeGridData.json”);  
 
        // Decode the data as JSON data 
        $treeGridData = json_decode($jsonData, true); 
 
        function getData(){ 
            echo json_encode($treeGridData); 
        } 


$(function () { 
            var data = ej.DataManager({ 
                url: "http://Syncfusion.com/***/**/crud.php/?action=getData", 
            }); 
            $("#treegrid").ejTreeGrid({ 
                dataSource: data, 
            }); 
        }); 

Please refer the following KB to know more about CRUD operation with MySQL database in PHP platform.  
PHP KB: https://www.syncfusion.com/kb/7038/how-to-perform-crud-operation-in-treegrid-using-php  
Please let us know, if you need any other assistance. 
Regards, 
Jayakumar D

Dee · Answer

Thanks, Jayakumar.So, just pass in the name of the file or source. Kool.And thanks for the code samples.Cheers.

Jayakumar Duraisamy · Answer

Hi Derrick, 
Thanks for the update. 
Regards, 
Jayakumar D