Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

JSON format

Note that there is a separate overview of how to use the database harvester. This page is reference information.

...

Code Block
titleSource.database object
{
	"databaseType" : "string", // String, type of DB to connect to, i.e.: 

					// eg: mysql, db2, oracle, mssqlserver, sybase
	"hostname" : "string", // String, hostname of database server to connect to
	"port" : "string", // String, port database server is listening for connections on
	"databaseName" : "string", // String, name of database containing the data to be extracted
	"query" : "string", // String, SQL query used to retrieve full dataset from source (the first time the source is added)
	"deltaQuery" : "string", // String, SQL query used to retrieve updates from source after the first time through
	"deleteQuery" : "string", // String, not implemented in beta releasecurrently implemented
	"primaryKey" : "string", // String, primary key field in data set, used to help identify 		// whether a record is new or previously harvested

	"title" : "string", // String, populates the document's title field
	"snippet" : "string", // String, populates the document's description field
	"publishedDate" : "string", // String, populates the document's published date field
}