Excel 2013 has introduced a new feature to access a RESTFul web service directly from spreadsheet. This new function named "webservice()" allows the user to call a web service directly and populate the spreadsheet fields with the resulting XML output. This section shows you how to connect to our web services using Excel 2013.
Excel Webservice function allows you to invoke TRIEBRARY services directly from your excel. You need to have Microsoft office Excel 2013 or later versions. Click here to Learn more about Excel WEBSERVICE
A service request is made from the Client browser and the service response is generated by TRIEBRARY.
|Example: WEBSERVICE("https://smartwebgateway.cloudapp.net/SmartWeb.svc/ssl/GetORBasicInfoByLegalDescription/subscribercode/TOKEN/99999/TD%20#1028/91TR 1883 UT 1 FL")|
Subscriber Code (This is the code assigned to your organization)
TOKEN (Unique subscriber token)
99999 (Test FIPS code)
Verify your subscriber account
Use your login name and password to log into your account in TRIEBRARY. Click on your user name (top right corner) to manage your account. Your user account page will look similar to the window below.
Click on "My Account" to see details about your account. Your account will look similar to the window below. Note down or copy Subscriber code and Token for your account as you will need this information for all transactions with TRIEBRARY.
Make sure that you have subscribed to transactions and agreed to publisher terms. Window below shows subscribed transactions and your acceptance of the publisher terms. You will need to agree to publisher transactions and subscribe to individual transactions before you can access the set. Note: Price may vary between transactions and publishers.
Open Excel and create a new blank workbook
We will use a new blank workbook for our testing purposes. In this example, we will invoke Excel2013 function named "WEBSERVICE" and "FILTERXML" to request and process service result. We will be using TRIEBRARY service GetTaxInfo for our test purposes. This service returns the tax information for a given parcel id.
Invoke web service call
Next step is to setup the fields for invoking the web service. First, we are going to create a set of input fields and then create the formulae's for retrieving the data through webservice
Note: You can use test FIPS code as 99999 and parcel id as 0000100000
View the results
Let us create a title for our output columns first.
Note: EXCEL 2013 has a timer which returns "#VALUE" error if the WEBSERVICE function did not return any value within a period of three seconds. You may also see a "#VALUE" error if the returned XML is larger than the cell limit (32767 characters).