13. Open API Enhancements (Revision #9)

With the inclusion of MS Excel 2007 support, the Aqua Open APIs have been expanded to allow access to .xlsx files and their contents. Several chart enhancements have been included to assist with the new chart options. New HTML TITLE and META tag editing abilities, e-mail address reply-to content, network proxy use, SQL username and password information, Java System properties and environment variables,

For the full list of Open APIs visit http://docs.aquafold.com/ads/10.0/openapi/

New Open APIs

• AQReport
  • public void saveAsExcel2007(String fileName) - saves report in Excel 2007 format  
  • public byte[] getAsExcel2007() - returns report as a byte array in Excel 2007 format
• AQPivotDataSet
  • public void saveAsExcel2007(String fileName) - saves pivot data in Excel 2007 format
  • public void saveAsExcel2007(String fileName, AQDataSetSettings settings, AQChart chart) - save pivot data and chart in Excel 2007 format
  • public byte[] getAsExcel2007() - returns pivot data as a byte array in Excel 2007 format
  • public byte[] getAsExcel2007(AQDataSetSettings settings, AQChart chart) - returns pivot data and chart as a byte array in Excel 2007 format
• AQDataSet
  • public void saveAsExcel2007(String filename) - saves data set in Excel 2007 format
  • public void saveAsExcel2007(String fileName, AQDataSetSettings settings, AQChart chart) - saves data set  and chart in Excel 2007 format
  • public byte[] getAsExcel2007() - returns data set as a byte array in Excel 2007 format
  • public byte[] getAsExcel2007(AQDataSetSettings settings, AQChart chart) - returns data set and chart as a byte array in Excel 2007 format
• AQSqlFormatter
  • Corrected misspelling of API name: renamed setUseTabIdent to setUseTabIndent
• AQServerConnection
  • public void connect(Object password) - establishes SQL connection to the server with the provided password
  • public void connect(Object username, Object password) - establishes SQL connection to the server with the provided user credentials
• AQInputOutputFactory
  • public AQExcelWriter newExcel2007Writer() - creates new Excel 2007 file writer
• AQResponse
  • public void setTitle(String title) - sets the TITLE tag for HTML responses
  • public String getTitle() - returns the value for the TITLE tag
  • public void addMetaTag(String name, String value) - sets the META tag for HTML responses
  • public void clearMetaTags() - removes previously set meta tags
• AQRequest
  • public String getRemoteAddr() - returns the Internet Protocol (IP) address of the client or last proxy that sent the request
  • public String getRemoteHost() - returns the fully qualified name of the client or the last proxy that sent the request
• AQSystem
  • public String getProperty(String key) - retrieves the java system property indicated by the specified key
  • public String getProperty(String key, String def) - retrieves the java system property indicated by the specified key. If key is not found, def is returned
  • public String getenv(String name) - retrieves the value of the specified environment variable
• AQMailMessage
  • public void addReplyTo(String replyTo) - specifies the reply-to list of email addresses
  • public String[] getReplyTo() - retrieves the list of reply-to email addresses