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

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