Getting Data from the Web
The SaveToDB add-in getting data from the web extracting data from JSON, XML, HTML, CSV, and plain text.
Users can connect and configure URLs using the connection wizard.
Database developers can configure such URLs in a database and even configure merging data.
To configure the query, use any schema and name, the HTTP object type, and place the URL with parser parameters into the TABLE_CODE field of the xls.objects table.
Here is a sample:
| ID | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | TABLE_CODE | INSERT_OBJECT | UPDATE_OBJECT | DELETE_OBJECT |
|---|---|---|---|---|---|---|---|
| stocks | Historical Prices | HTTP | https://some-service?s={Symbol=APPL} |
Alternatively, you can configure queries in the query list views. For example:
| ID | TABLE_SCHEMA | TABLE_NAME | TABLE_TYPE | TABLE_CODE | INSERT_PROCEDURE | UPDATE_PROCEDURE | DELETE_PROCEDURE | PROCEDURE_TYPE |
|---|---|---|---|---|---|---|---|---|
| stocks | Historical Prices | HTTP | https://some-service?s={Symbol=APPL} |
See additional topics: