Menu

Query Data as XML, JSON or CSV formats

​

There are number of ways data can be queried and returned as XML, JSON and CSV.
One way is the Command Line and other is via the Web Channel Restful service.

 

 
You will still need to transform the XML format into the final XML format based on what is required by the for target application.
 

 

Please note all these queries can take filter parameters

 

 
Web Channel

 

Help on how to get data via the Restful Service in various formats
 

 

Simple Report example
 
 

 

The Report data As XML
 
 

 

 
Command Line

 

 

 

Sample XML
 

 

<?xml version=”1.0″ encoding=”utf-16″?>
< QueryDataResults>
<Columns xmlns=”Query.DataSimple”>
<Column caption=”Order Date” header=”Sales Order Header” uniqueCode=”/OrdDat:DateYearMonth” dataType=”String” dataTypeBase=”String” total=”None” hidden=”false” attr=”” />
<Column caption=”Budget” header=”” uniqueCode=”/SubTot:Sum” dataType=”Currency” dataTypeBase=”Number” total=”Sum” hidden=”false” attr=”” />
<Column caption=”Actual” header=”” uniqueCode=”/TotDue:Sum” dataType=”Currency” dataTypeBase=”Number” total=”Sum” hidden=”false” attr=”” />
<Column caption=”Variance” header=”” uniqueCode=”/TaxAmo:Sum” dataType=”Currency” dataTypeBase=”Number” total=”Sum” hidden=”false” attr=”” />
</Columns>
<Rows xmlns=”Query.DataSimple”>
<Row cat=””>
<Cell>2002/01</Cell>
<Cell>1453196.5440</Cell>
<Cell>1605782.1915</Cell>
<Cell>116255.7246</Cell>
</Row>
<Row cat=””>
<Cell>2002/02</Cell>
<Cell>2833324.0076</Cell>
<Cell>3130823.0378</Cell>
<Cell>226665.9211</Cell>
</Row>
<Row cat=””>
<Cell>2002/03</Cell>
<Cell>2391928.5692</Cell>
<Cell>2643081.0798</Cell>
<Cell>191354.2865</Cell>
</Row>
<Row cat=””>
<Cell>2002/04</Cell>
<Cell>1724736.5587</Cell>
<Cell>1905833.9088</Cell>
<Cell>137978.9258</Cell>
</Row>
<Row cat=””>
<Cell>2002/05</Cell>
<Cell>3401202.9714</Cell>
<Cell>3758329.2949</Cell>
<Cell>272096.2387</Cell>
</Row>
<Row cat=””>
<Cell>2002/06</Cell>
<Cell>2304182.7607</Cell>
<Cell>2546121.9618</Cell>
<Cell>184334.6218</Cell>
</Row>
<Row cat=””>
<Cell>2002/07</Cell>
<Cell>3422514.9861</Cell>
<Cell>3781879.0708</Cell>
<Cell>273801.2010</Cell>
</Row>
<Row cat=””>
<Cell>2002/08</Cell>
<Cell>4917293.5116</Cell>
<Cell>5433609.3426</Cell>
<Cell>393383.4834</Cell>
</Row>
<Row cat=””>
<Cell>2002/09</Cell>
<Cell>3839563.5380</Cell>
<Cell>4242717.7166</Cell>
<Cell>307165.0844</Cell>
</Row>
<Row cat=””>
<Cell>2002/10</Cell>
<Cell>2180745.7914</Cell>
<Cell>2409724.1002</Cell>
<Cell>174459.6636</Cell>
</Row>
<Row cat=”{T:}_format:coltext[1,1]=Total:”>
<Cell>Total:</Cell>
<Cell>28468689.2387</Cell>
<Cell>31457901.7048</Cell>
<Cell>2277495.1509</Cell>
</Row>
</Rows>
< /QueryDataResults>
 
Published: 21/01/2014 8:47 PM

Related Posts