XML & JSON data service

Top  Previous  Next

Data display pages can return XML or JSON data streams rather than HTML streams that are rendered  by your browser.

XML is a eXtensible Markup Language

JSON is Java Script Object Notation

 

Data of the page dataset is exported, within tags corresponding to the dataset field names.

 

To call dbQwikSite data list and data page as a web service to return JSON or XML, there is nothing you need to do in the designer, this function is automatically added to the pages.

 

Add a parameter to the URL when you call the data pages to retrieve the XML and JSON as follows:

 

For

Call

Result

XML

/products.asp?return=XML

<?xml version="1.0"?>

<root>

 <DataRow>

         <Products_ProductID>1</Products_ProductID>

         <Products_ProductName>Chai Tea</Products_ProductName>

         <Products_SupplierID>1</Products_SupplierID>

         <Products_CategoryID>1</Products_CategoryID>

         <Products_QuantityPerUnit>10 boxes x 20 bags</Products_QuantityPerUnit>

         <Products_UnitPrice>18</Products_UnitPrice>

         <Products_UnitsInStock>33</Products_UnitsInStock>

         <Products_UnitsOnOrder>0</Products_UnitsOnOrder>

         <Products_ReorderLevel>10</Products_ReorderLevel>

         <Products_Discontinued>False</Products_Discontinued>

         <Products_Description>Yummy yummy the ultimate yummy</Products_Description>

         <Products_PictureURL></Products_PictureURL>

 </DataRow>

 <DataRow>

         <Products_ProductID>2</Products_ProductID>

         <Products_ProductName