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:

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

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

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

See additional topics: