Ravindra BagaleCourses & study guides

5. Web Data, APIs and Google Sheets

By Last updated:

Aata aapan internet varcha data aanuya – web pages, APIs aani Google Sheets. Ya module madhe Web connector, HTML table scraping (वेबपेजवरून डेटा गोळा करणे), pagination (डेटा अनेक पानांवर विभागलेला असणे), JSON aani Google Sheets he sagla step by step baghu. Aani ho, website chya terms respect karne he suddha shikayla hava.

What you will learn in this module

  • The Web connector: Basic and Advanced (URL parts, headers)
  • Scraping HTML tables with the Navigator and Add table using examples
  • Reading many pages with a parameter + custom function (pagination)
  • Calling JSON APIs with Web.Contents and Json.Document
  • Connecting to Google Sheets (connector and published CSV link)
  • Refresh rules and the legal/ethical side of web data

Concepts in this chapter

  1. 5.1The Web Connector
  2. 5.2Scraping an HTML Table (Worked Example)
  3. 5.3Many Pages: Pagination with a Parameter and a Custom Function
  4. 5.4JSON APIs with Web.Contents and Json.Document
  5. 5.5Google Sheets Connector
  6. 5.6Alternative: Publish a Google Sheet as CSV and Use the Web Connector
  7. 5.7Refreshing Web Data and Ethics

The chapter recap is at the end of the last concept page.