Knowledgeone RecFind6 (Preview)

Knowledgeone RecFind6 provides table query and file upload services from external system to RecFind 6 databases.

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions except the following:      -   Azure Government regions      -   Azure China regions      -   US Department of Defense (DoD)
Power Automate	Premium	All Power Automate regions except the following:      -   US Government (GCC)      -   US Government (GCC High)      -   China Cloud operated by 21Vianet      -   US Department of Defense (DoD)
Power Apps	Premium	All Power Apps regions except the following:      -   US Government (GCC)      -   US Government (GCC High)      -   China Cloud operated by 21Vianet      -   US Department of Defense (DoD)

Contact
Name	Knowledgeone Corporation
URL	https://knowledgeonecorp.com
Email	support@knowledgeonecorp.com

Connector Metadata
Publisher	Knowledgeone Corporation
Website	https://knowledgeonecorp.com
Privacy Policy	https://knowledgeonecorp.com/general/privacystatement.htm
Categories	Business Management;Productivity

This connector is for users of RecFind 6 who wish to use Power Platform products to conduct queries on the RecFind 6 database, or upload files to RecFind 6. It is dependant on purchase and installation of the RF6Connector module on your target RecFind 6 installation.

How to get credentials

Upon installation of the RF6Connector, modify your web.config to set the Security Key value. This will be your API key to gain access to your database.

Creating a connection

The connector supports the following authentication types:

Default	Parameters for creating connection.	All regions	Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name	Type	Description	Required
Security Key	securestring	The Security Key for this api	True

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	100	60 seconds

Actions

QueryData	Provides a list of field names and values corresponding to the requested query and search parameters. Results can be paged.
QueryList	Returns a list of all predefined queries that the caller may request.
QueryTable	Provides a table of results corresponding to the requested query and search parameters.
Send File	Submit file contents and metadata for storage in the RecFind 6 database. Returns a URL to the stored file.

QueryData

Operation ID:

QueryData

Provides a list of field names and values corresponding to the requested query and search parameters. Results can be paged.

Parameters

Name	Key	Required	Type	Description
Host URL	HostUrl		string	URL of the server
User Name	UserName		string	User making the request
Name of the predefined query	QueryName		string	Query Name
Number of search results to skip	StartPosition		integer	Start position
Number of records to return	NumberOfRecords		integer	Number of records
Text to filter the search results	SearchText		string	Search Text

Returns

Name	Path	Type	Description
Records	Records	array of object	Records
RowCount	Records.RowCount	integer	Row Count
Row_id	Records.Row_id	string	Row Id
UrlView	Records.UrlView	string	Url View
UrlModify	Records.UrlModify	string	Url Modify
Row_fields	Records.Row_fields	array of object	Row Fields
Field_name	Records.Row_fields.Field_name	string	Field Name
Field_value	Records.Row_fields.Field_value	string	Field Value
LastPage	LastPage	boolean	Last Page
result	result	string	Result

QueryList

Operation ID:

QueryList

Returns a list of all predefined queries that the caller may request.

Parameters

Name	Key	Required	Type	Description
Host URL	HostUrl		string	URL of the server
User Name	UserName		string	User making the request

Returns

Name	Path	Type	Description
queries	queries	array of object	queries
QueryName	queries.QueryName	string	Query Name
FieldCount	queries.FieldCount	integer	Field Count
result	result	string	Result

QueryTable

Operation ID:

QueryTable

Provides a table of results corresponding to the requested query and search parameters.

Parameters

Name	Key	Required	Type	Description
Host URL	HostUrl		string	URL of the server
User Name	UserName		string	User making the request
Name of the predefined query	QueryName		string	Query Name
Text to filter the search results	SearchText		string	Search Text

Returns

Name	Path	Type	Description
		array of object

Send File

Operation ID:

SendFile

Submit file contents and metadata for storage in the RecFind 6 database. Returns a URL to the stored file.

Parameters

Name	Key	Required	Type	Description
Host URL	HostUrl		string	URL of the server
User Name	UserName		string	User making the request
FileContents	FileContents		string	File Contents
FileName	FileName		string	File Name
Title	Title		string	Title
CreatedDate	CreatedDate		string	Created Date
EDOCType	EDOCType		string	EDOC Type
FldName	FldName		string	Field Name
FldValue	FldValue		string	Field Value

Returns

Name	Path	Type	Description
URL	URL	string	URL
result	result	string	result