Tour

The purpose of TheWebService is to make it easy for anybody using any software to manage and share data. This quick guide demonstrates how to quickly upload a stock list to allow partners to update it and customers to access it.

Upload from Excel, a web form or code

TheWebService is based on MyTables. The Excel data loader makes it easy to put data into a MyTable. Login to your account and click "Import Data" and choose your stock list. Select your file and click "Import":

That's it, your data is live and you can preview it online in My Account:

Alternatively, if your list is particularly large or not available in Excel or CSV format, you can use code to upload it to your MyTable . Firstly, you need to create a table to hold the data. Go to My Account and click "Add new table" and enter its name and description:

Click "Save" and then define your table columns:

You'll notice that you can define types and indexes in the same way as a database engine (the Excel data loader would have done this for you). Your MyTable is now ready, so click "Done"

Documentation and code

Here's the special bit. After your data has been uploaded TheWebService generates web services with 13 different end points and 12 different code samples for performing CRUD operations on the data. You can view these in the "MyTables" section of the "Web Services" tab:

Our partners will leverage the "MyTables_Insert" web service and our customers will implement the "MyTables_Select" web service. Fire up your IDE but don't get ready to write code, we've done this for you! Click on the "MyTables_Insert" web service. Here you'll see the link to the WSDL, full documentation, error codes, code samples and the ability to test the web service. Click the examples tab, choose the language of your choice and copy and paste into your IDE!

Generate a key

All that's left is to generate a key to access the data. Keys are designed to allow different users to have different access rights to the data. Go to My Account and click "Add a new key". Here we'll create a key for our partners and limit them to the "MyTables_Insert" web service:

We can also restrict access to the IP addresses of our partners' servers. This means that if anybody gets hold of the key our data is still safe! As many IP addresses as you like can be added:

Consume our web services

MyTables is only one part of TheWebService, we have hundreds of other datasets for you to create mash-ups with your own applications. Why not try the multi-day multi-vehicle route optimization to manage your fleet or sales team, or the Dun and Bradstreet business data to profile your customers and manage your leads more effectively? There are plenty of high class web services available for you to use as you wish.