The "data" Property
The "data" property defines a data file as the data source. It has the following sub properties:
| Element | Description |
|---|---|
| "type" | The type of data file ("csvfile", "xmlfile", or "jsonfile") |
| "filename" | The name of the file |
| "record" | The name of the XML data node (if xmlfile) |
| "items" | The data items |
Data From a Text File
This model fetches records containing Title, Artist, and Price (as item 1, 2, and 5) from a comma separated text file:
Model
{
"data": {
"type" : "csvfile",
"filename": "cd_catalog.txt",
"items" : [
{"name": "Title", "index": 1},
{"name": "Artist","index": 2},
{"name": "Price", "index": 5}
]
}
}
Try It Yourself »
Example explained: Case Text Files.
Data From an XML File
This model fetches records containing Title, Artist, and Price from CD nodes in an XML file:
Model
{
"data": {
"type" : "xmlfile",
"filename": "cd_catalog.xml",
"record" : "CD",
"items" : [
{"name": "Artist",
"nodename": "ARTIST"},
{"name": "Title", "nodename": "TITLE"},
{"name": "Country","nodename": "COUNTRY"}
]
}
}
Try It Yourself »
Example explained: Case XML Files.
Data From a JSON File
This model fetches records containing Title, Artist, and Price from an array of CD objects in a JSON file:
Model
{
"data" : {
"type" : "jsonfile",
"filename" : "cd_catalog.js",
"record" : "cd",
"items" : [
{"name" : "Title",
"nodename" : "title"},
{"name"
: "Artist", "nodename" : "artist"},
{"name" : "Price", "nodename" : "price"}
]
}
}
Try It Yourself »
Example explained: Case JSON Files.