• Contact Us
  • facebook

  • twitter

  • linkedin

stSoftware logo stSoftware sustainable technology
Services
  • Solution Design
  • Legacy System Migration
  • Training
  • Penetration Testing
  • Selenium Automated Web Testing
  • AWS Consultancy
  • Work-From-Home Solutions
Products
  • JobTrack for SMEs
  • CloudBlocks
  • Franchise Systems
  • E-Commerce
Case Studies
  • Legacy Cloud Migration
  • Member Track
Modules
  • Content Management System
  • Email Marketing
  • Cloud CRM
  • Cloud File Manager
  • Web Forms
  • ReST API
  • Progressive Web Apps
How We Work
  • Continuous Improvement Program
    • Cloud Hosted
    • Self Hosted
  • Agile Development Lifecycle
Pricing
  • Professional Dev & Support

How to call ReST services from Excel?

How to call ReST services from Excel?

Example spreadsheet to fetch data from an ST server

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

Example Excel Spread Sheet

Click here to download an example Excel spread sheet which shows how to fetch data from an ST Server into Excel.

How to use

1. Open spreadsheet and click "Enable Macros".

Enable Macros

2. Click "add-ins" menus

add-ins menu

3. Click "Login" icon

Login button

4. Enter connection details

Enter the connection details for your own server or use one of the demo systems by using the host https://demo2.jobtrack.com.au and the user name user with the password user

Please note the demo servers are reset daily ( don't store anything you want to keep). 

Login form

5. Click on the query button

Query button

6. Enter the fields, class and filer for the data to be fetched. 

There are a number of predefined templates which can be chosen or enter  the fields "Class", "Fields" and "Where" directly. 

Query form

 

Tags: Excel ReST

Recent Posts

  • Do you have a process to manage complaints?
  • What is your Business Continuity Management Policy or process?

Authors

  • Alison Leck(4)
  • Angus Leck(1)
  • Harry Shaw(10)
  • Lei Gao(23)
  • Liam Itzhaki(17)
  • Nigel Leck(106)
  • Parminder Singh(2)
  • Tina Odling(79)

Published

  • Jan 2021(2)
  • Oct 2018(2)
  • Sep 2018(1)
  • Aug 2018(1)
  • Apr 2018(1)
  • Feb 2018(5)
  • Jan 2018(1)
  • Nov 2017(1)
  • Aug 2017(2)
  • Oct 2016(1)
  • Jun 2016(5)
  • May 2016(1)
  • Apr 2016(2)
  • Mar 2016(3)
  • Feb 2016(1)
  • Jan 2016(1)
  • Nov 2015(2)
  • Oct 2015(2)
  • Sep 2015(3)
  • Aug 2015(5)
  • Mar 2015(3)
  • Dec 2014(1)
  • Oct 2014(2)
  • Sep 2014(3)
  • Aug 2014(2)
  • Jul 2014(4)
  • Jun 2014(4)
  • May 2014(3)
  • Apr 2014(9)
  • Mar 2014(12)
  • Feb 2014(4)
  • Jan 2014(6)
  • Dec 2013(14)
  • Nov 2013(10)
  • Sep 2013(13)
  • Aug 2013(13)
  • Jul 2013(6)
  • Jun 2013(1)
  • May 2013(4)
  • Apr 2013(17)
  • Mar 2013(57)
  • Feb 2013(3)
  • Jan 2013(1)
  • Dec 2012(1)
  • Aug 2009(1)
  • Aug 2007(3)
  • Aug 2004(1)
  • Sep 2002(1)
  • May 2001(1)

Tag Cloud

accessibility ACLs Agile APP Article awards Calendar cms coding standards control panel crm CSS customize DDoS designer difference DNS documents email event Excel featured feeds HA how-to HTML iCal Java JavaScript Journal JSON landing-page menu meta mobile password policy publish publisher PWA release Responsive ReST RSS search security SEO setup spell SSL SSO store stSoftware template testimonial Threads tinyMCE twitter unsubscribe validation web folders webdav workflow XML XSS
About Us
History
Mission
Values
Team
stSoftware is a technology company specializing in cloud solutions.

We provide high-performance websites, online business systems, and professional IT services to deliver exceptional solutions; from highly complex multi-national systems to rapid startup hosted solutions.

Latest News
  • Do you have a process to manage complaints?
    by: Tina Odling - 18 Jan 2021
  • What is your Business Continuity Management Policy or process?
    by: Tina Odling - 17 Jan 2021
  • Updates for Tablet Devices
    by: Harry Shaw - 30 Oct 2018
Contact Us

Street Address: Suite 223/117 Old Pittwater Road
Brookvale, New South Wales 2100 Australia
Phone: 1300 78 73 78
International: +1 917 267 7607
Email: sales@stsoftware.com.au

About stSoftware
  • About us
  • History
  • Mission
  • Values
  • Team
FAQs
  • Cloud Conversion
  • Cloud Hosting
  • AWS Email Service Terms
  • Complaints Handling Policy
  • Business Continuity Management Policy
  • CMS Functions
  • Security
  • Support
  • Service Level Agreement (SLA)
  • Cloud File Manager
  • Email Marketing
  • CRM
  • WebForms
  • Policies
Feeds Menu
  • Feeds
  • Blog
  • Site Map
Links
  • Testimonials
  • Demonstrations
  • Professional services
  • Terms of Use
  • Security
  • Privacy Policy
Powered by AWS Cloud Computing
Powered by stSoftware

top

  • facebook

  • twitter

  • linkedin

  • github

© Copyright 2021 stSoftware. All Rights Reserved. Powered by stSoftware.