This example uses Excel's WEBSERVICE() function to merge currency exchange API, Customers, Accounts Payable, and Inventory data. | Select a Customer from the drop-down selector to look-up the account's address, credit limit, current accounts payable, and available credit. | Select a Currency from the drop-down selector to query the currency API to retrieve U.S. dollar-based exchange rates for over 180 countries. | Select a Product # from the drop-down selectors to add the product to the form and look-up product description, quantity-on-hand, and price. | Adjust quantities to run calculations and update totals, double-order or add more products than are on-hand to see error-checking constraints. | Select Adjust Inventory to decrement inventory using a SQL transaction, click Print to preview the invoice, click Submit to view the output array. |
|
|