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
A common mistake is 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 the RelativePath and Query options of Web.Contents. Never forget this.
Ravindra Bagale's Tip – मराठी
एक common चूक म्हणजे base address मध्येच parameter value चिकटवून URL बनवणं. Desktop मध्ये चालतं पण Service refresh अडवू शकतं. Base URL static ठेवा आणि बदलणारे भाग Web.Contents च्या RelativePath आणि Query options मध्ये टाका. हे अजिबात विसरू नका.
Ravindra Bagale's Tip – हिंदी
एक common गलती है base address में ही parameter value चिपकाकर URL बनाना. Desktop में चलता है पर Service refresh को रोक सकता है. Base URL static रखो और बदलने वाले हिस्से Web.Contents के RelativePath और Query options में डालो. यह बिल्कुल मत भूलना.