Recent Posts

    Authors

    Published

    Tag Cloud

    How to call ReST services from Excel?

    Overview

    All the data from a stSoftware server can be fetched via the standard ReST API, all the standard ACLs and validation rules are applied whether the data is access via the standard screens or via the ReST API


    by:Nigel Leck - 16 Aug 2017
    All stSoftware's web services are published with interactive documentation.

    All stSoftware's web services are published using Swagger which gives interactive documentation, client SDK generation and discoverability.

    Below are all the standard RESTful web services and how to use them. 


    by:Nigel Leck - 30 Mar 2016
    Reporting facilities

    There are many built in reports created in the screen painter. 

    Jasper Reports can be designed and uploaded for more complex reports 

    External tools such as Open Office or Excel can be used to generate reports via JDBC or ReST web services.


    by:Nigel Leck - 13 Dec 2013
    Easily integrated with other web applications through open standards.

    Users may access all allowed data via the Web Forms or via Industry standard protocols such as:

    • ReST which returns data in both JSON and XML formats. 
    • SOAP 
    • WebDav
    • ICal 
    • GWT RPC
    • JDBC

    All requests for data or modification to data goes via the DAL ( Data Access Layer) no matter which protocol is used. There is NO direct access to the underlying data store. The DAL checks the ACLs ( Access Control Limits ) for each data request and performs all validations on each data modification. When data is modified


    by:Tina Odling - 26 Nov 2013