Information Communication Technology ICT – 20 Spreadsheets | e-Consult

The student could use a web API (Application Programming Interface) as an external data source. Many online retailers provide APIs that allow developers to access their product data, including prices. A suitable data source would be the API provided by a popular price comparison website like PriceRunner or CamelCamelCamel. The student would use a function like VLOOKUP or IMPORTDATA (depending on the spreadsheet software) to retrieve the latest price data from the API. VLOOKUP would be used if the API provides data in a structured format (e.g., JSON or XML) that can be parsed and linked to the phone model in the spreadsheet. IMPORTDATA might be suitable if the API provides a simple text-based data format. The function would be configured to fetch the relevant data from the API based on the phone model and update the price in the spreadsheet.