Getting Data from the Web

The SaveToDB add-in extracts data from various web formats, including JSON, XML, HTML, CSV, and plain text.

Users can connect to and configure URLs using the connection wizard. Database developers can also set up these URLs within a database and configure data merging.

To set up a query, specify any schema and name, use the HTTP object type, and enter the URL with parser parameters in the TABLE_CODE field of the xls.objects table.

Here’s a sample configuration:

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}

For more information, check out these topics:

HTTP Commands
HTTP Authentication
Getting Data Using REST API
Merging Data