Tutorials References Menu

AppML Reference - Data Files


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.