5. Web Data, APIs and Google Sheets
5.1 The Web Connector
Home › Get data › Web opens the From Web dialog. It has two modes:
| Mode | Use it for | Fields |
|---|---|---|
| Basic | A single full URL | URL |
| Advanced | URLs built from parts, extra HTTP headers, timeouts | URL parts (add several parts that are joined), Command timeout in minutes, HTTP request header parameters (e.g. Accept: application/json) |
The same connector can read:
- HTML pages → tables detected on the page
- Files at a URL → CSV, Excel, JSON, XML (for example a published Google Sheet CSV, 5.6)
- REST APIs → JSON responses (5.4)
Ravindra Bagale's Tip
Ek common chuk mhanje building a URL with the parameter value glued into the base address. It works in Desktop but can block Service refresh. Keep a static base URL and put the changing parts in RelativePath and Query options of Web.Contents. Bilkul visru naka.