API (Application Programming Interface) is a way for an information system to communicate with other systems. It works similarly to a browser request of a webpage, but instead of the webpage a server returns a formatted data.
For example, if your system needs to know the current weather conditions, you can retrieve this information from a weather API. OpenWeatherMap is an example of a weather API (Links to an external site.). This API supports different parameters to specify the data you request.
A request like this one will return a current weather condition for the given ZIP in JSON format. You can test it in your browser. Appid parameter serves to control who is accessing the data (the ID in the given example is used for test purposes). You may also read the API docs for this API to get an idea about the structure of the data and the list of acceptable parameters.
Based on the topic of your Course Project, find a relevant public API and submit the following information about it:
A short one paragraph summary on how this API will benefit the system proposed in the project.
A sample request to this API; download the result of the request and provide either a visual or statistical summary of the data.
For example, if you use an API that returns a list of geographical coordinates, you may import them to Google maps (Links to an external site.).
If you are familiar with Excel or other statistical software, you can produce either a meaningful chart or a simple statistical analysis of the data. For example, if your data consist weather information for 30 days, you can compute an average weather, or draw a chart of the weather for that period.
Most likely, you will need to convert a JSON data into CVS (or Excel) you can always use tools like this JSON Converter (Links to an external site.). (Links to an external site.) Note that not every object can be converted into a meaningful spreadsheet. Most likely you will want to have a list  on the top level of the JSON structure, in order for each of its elements to be converted to a row.