Recent Posts

    Authors

    Published

    Tag Cloud

    301 302 404 accessibility accounts ACLs advertising aggregation Agile Analytics android APP Article attachments awards backup BCM beta browser business continuity Calendar case-study categories Chrome citigroup cms codes coding standards Complaints contact management software control panel crm CSS customer management software customer relationship system customize database DataModel DDoS demo design designer device compatibility difference distribute a published article via email DND DNS documents drag & drop Editor email EOL erp event Excel featured feeds file manager file sharing file volume Firefox Firewall HA hack Handlebar how-to HTML HTML5 HTTP HTTPS iCal IE Instructions intranet iOS iPad Java JavaScript JDBC JDK Jenkins Job Track Journal JSON JVM landing-page launcher layered database layout logging login mac marketing menu meta Microsoft Outlook mobile module modules mustache navigation NTLM offline page painter password passwords PCI policy poll pricing privacy PROXY publish publisher publsher PWA redirect Redundancy release release-notes Report Tool Reports Responsive ReST RESTFul Rich text RSS Safari sandbox sanity schedule scrum search security SEO sessions setup shipping site builder source spell SQL Injection SSL SSO standards store stSoftware support survey Swagger Task template testimonial Threads timezone tinyMCE Transaction Search trigger twitter twitter bootstrap Ubuntu unit tests unsubscribe URL validation WC3 AAA web folders web services webdav windows 8 wizard workflow WYSIWYG XLS XLST XML XPath XSS
    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
    How to synchronize data between stSoftware server and an external system.

    Summary

    A client program calls the stSoftware server with the /v6/sync/{className} ReST service for the class name that is required to be sync'd to an external system. The since parameter controls which record changes will returned. Initially the program starts with a default value for since, once the result set of the changed records has been scrolled through a new value of since will be returned from the server. The returned since is the server time of the last change returned.

    For each record changed


    by:Parminder Singh - 26 Apr 2016
    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
    How to create a ReST magic number?

    To set up a new API key for a ReST service:-

    • Choose the ReST service to create the API key for ( steps 1-3)
    • Open the data entry screen for the selected service ( step 4)
    • Select the "security" tab ( step 5 )
    • Create a new magic number ( step 6)
    • Choose the user access to use for this service and press OK ( step 7-8)

    The demonstration system can be used to try out the ReST services.

    https://demo2.jobtrack.com.au/magic/3101/A5AE-9806

     Open Sync ReST service

    Edit the Sync ReST service

    Open Secuirty tab

    Save magic number

     

     


    by:Nigel Leck - 2 Feb 2016
    How to define a RESTful Web Services?

    Overview

    Representational State Transfer (ReST) has gained widespread acceptance across the Web as a simpler alternative to SOAP- and Web Services Description Language (WSDL)-based Web services.

    The resources are acted upon by using a set of simple, well-defined operations. The REST architectural style constrains an architecture to a client/server architecture and is designed to use a stateless communication protocol, using HTTP/HTTPS.
     
    The system allows a series of RESTful services to be defined. The ReST service will normally return a JSON object

    by:Nigel Leck - 4 Sep 2014
    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
    How to access ST data from Microsoft Excel via ReST web service

    Excel connection details

    1. Click the Data menu, select Import External Data/New Web Query

    2. Enter the XML REST address in the Address field, and click "Go" button, the login dialogue pops up, use your ST system user name and password to login

     

    3. You should see the XML below it once you login.

    4.Click the little yellow array on the top left of the XML to select the XML to import, then click "Import" button

    5. select the position to import the data and click "OK" button to import.

     

    6. Data imported

     


    by:Lei Gao - 26 Nov 2013