Getting Data from the Web
Special offer: 50% discount ($1440) for ODataDB Enterprise until June 24, 2024

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:

stocksHistorical PricesHTTPhttps://some-service?s={Symbol=APPL}

Alternatively, you can configure queries in the query list views. For example:

stocksHistorical PricesHTTPhttps://some-service?s={Symbol=APPL}

See additional topics: