AikiDocs (Preview)

AikiDocs for Office Documents enables document changes that would otherwise require human interaction. Merging, Manipulating, extracting content to and from office documents can be integrated into your solutions

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	Aiki-Mind Support
URL	https://www.aiki-mind.com/Account/Support
Email	support@aiki-mind.com

Connector Metadata
Publisher	Aiki-Mind Services Inc.
WebSite	https://www.aiki-mind.com
Privacy Policy	https://www.aiki-mind.com/privacy
Categories	Content and Files;Productivity

Easily make automated changes to office documents with AikiDocs for Power Automate

Prerequisites

To use this connector, you'll need to register an account and a valid license from AikiDocs

How to get credentials

You can register account @ https://www.aiki-mind.com

You will need a valid license to use this connector. You can either purchase a license or request a trial key.

Known issues and limitations

Only Open Office Documents are supported. Older formats prior to Open Office 1.0 are not supported for example anything created with MicroSoft Office older than Office 2007.

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
API Key	securestring	The API Key for this api	True

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	100	60 seconds

Actions

Excel - Get Cell Value or Formula	Excel - Get Cell Value or Formula
Excel - Get Cells Value or Formula	Excel - Get Cells Value or Formula
Excel - Set Cell Value or Formula	Excel - Set Cell Value or Formula
Excel - Set Cells Value or Formula	Excel - Set Cells Value or Formula
Validate the connection and API Key are working	Validate the connection and API Key are working
Validate the connection and API Key are working but with a failure response	Validate the connection and API Key are working but with a failure response
Word - Append Multiple Word Documents Together	Word - Append multiple Word documents together returning a single document which represents all the documents appended together
Word - Apply the style to a document from a source document	Word - Apply the style to a document from a source document
Word - Extract Content By Bookmarks	Word - Extract Content By Bookmarks
Word - Extract Content By Heading	Word - Extract Content By Heading
Word - Extract Content By Title	Word - Extract Content By Title
Word - Insert Documents into a document at bookmark	Word - Insert Documents into a document at bookmark

Excel - Get Cell Value or Formula

Operation ID:

ExcelGetCell

Excel - Get Cell Value or Formula

Parameters

Name	Key	Required	Type	Description
documentContent	documentContent		byte
documentName	documentName		string
sheetName	sheetName		string
cellAddress	cellAddress		string

Returns

Body

ReadSpreadSheetCellResponse

Excel - Get Cells Value or Formula

Operation ID:

ExcelGetCells

Excel - Get Cells Value or Formula

Parameters

Name	Key	Required	Type	Description
documentContent	documentContent		byte
documentName	documentName		string
sheetName	sheetName		string
cellAddress	cellAddress		string

Returns

Body

ReadSpreadSheetCellsResponse

Excel - Set Cell Value or Formula

Operation ID:

ExcelSetCell

Excel - Set Cell Value or Formula

Parameters

Name	Key	Required	Type	Description
displayValue	displayValue		string
formulaValue	formulaValue		string
sheetName	sheetName		string
cellAddress	cellAddress		string
documentContent	documentContent		byte
documentName	documentName		string

Returns

Body

ModifySpreadSheetCellResponse

Excel - Set Cells Value or Formula

Operation ID:

ExcelSetCells

Excel - Set Cells Value or Formula

Parameters

Name	Key	Required	Type	Description
displayValue	displayValue		string
formulaValue	formulaValue		string
sheetName	sheetName		string
cellAddress	cellAddress		string
documentContent	documentContent		byte
documentName	documentName		string

Returns

Body

ModifySpreadSheetCellResponse

Validate the connection and API Key are working

Operation ID:

ValidateConnectGoodService

Validate the connection and API Key are working

Parameters

Name	Key	Required	Type	Description
message	message		string

Returns

Body

ValidateConnectionResponse

Validate the connection and API Key are working but with a failure response

Operation ID:

ValidateConnectBadService

Validate the connection and API Key are working but with a failure response

Parameters

Name	Key	Required	Type	Description
message	message		string

Returns

Body

ValidateConnectionResponse

Word - Append Multiple Word Documents Together

Operation ID:

WordAppendDocuments

Word - Append multiple Word documents together returning a single document which represents all the documents appended together

Parameters

Name	Key	Required	Type	Description
appendDocumentList	appendDocumentList		array of byte

Returns

Body

AppendDocumentResponse

Word - Apply the style to a document from a source document

Operation ID:

WordApplyStyleToDocument

Word - Apply the style to a document from a source document

Parameters

Name	Key	Required	Type	Description
documentContent	documentContent		byte
documentName	documentName		string
documentContent	documentContent		byte
documentName	documentName		string

Returns

Body

ApplyStylesResponse

Word - Extract Content By Bookmarks

Operation ID:

WordExtractContentByBookmarks

Word - Extract Content By Bookmarks

Parameters

Name	Key	Required	Type	Description
startBookMark	startBookMark		string
endBookMark	endBookMark		string
documentContent	documentContent		byte
documentName	documentName		string

Returns

Body

ExtractContentByBookMarksResponse

Word - Extract Content By Heading

Operation ID:

WordExtractContentByHeading

Word - Extract Content By Heading

Parameters

Name	Key	Required	Type	Description
documentContent	documentContent		byte
documentName	documentName		string
headingStyleName	headingStyleName		string

Returns

Body

ExtractContentByHeadingResponse

Word - Extract Content By Title

Operation ID:

WordExtractContentByTitle

Word - Extract Content By Title

Parameters

Name	Key	Required	Type	Description
documentContent	documentContent		byte
documentName	documentName		string
headingText	headingText		string
headingStyleName	headingStyleName		string
headingEscapeStyleNames	headingEscapeStyleNames		array of string

Returns

Body

ExtractSectionByTitleResponse

Word - Insert Documents into a document at bookmark

Operation ID:

WordInsertDocuments

Word - Insert Documents into a document at bookmark

Parameters

Name	Key	Required	Type	Description
documentContent	documentContent		byte
documentName	documentName		string
insertDocumentList	insertDocumentList		array of byte
bookmarkName	bookmarkName		string
deleteBookmark	deleteBookmark		boolean

Returns

Body

InsertDocumentResponse

Definitions

AddressedSpreadSheetCell

Name	Path	Type	Description
displayValue	displayValue	string
formulaValue	formulaValue	string
cellLocation	cellLocation	SpreadSheetCellLocation

AppendDocumentResponse

Name	Path	Type	Description
resultDocument	resultDocument	WordDocumentParameter
count	count	integer

ApplyStylesResponse

Name	Path	Type	Description
resultDocument	resultDocument	WordDocumentParameter
count	count	integer

ExcelDocumentParameter

Name	Path	Type	Description
documentContent	documentContent	byte
documentName	documentName	string

ExtractContentByBookMarksResponse

Name	Path	Type	Description
resultDocument	resultDocument	WordDocumentParameter

ExtractContentByHeadingResponse

Name	Path	Type	Description
resultDocuments	resultDocuments	array of WordDocumentParameter

ExtractSectionByTitleResponse

Name	Path	Type	Description
resultDocument	resultDocument	WordDocumentParameter

InsertDocumentResponse

Name	Path	Type	Description
resultDocument	resultDocument	WordDocumentParameter
count	count	integer

ModifySpreadSheetCellResponse

Name	Path	Type	Description
cell	cell	AddressedSpreadSheetCell
resultDocument	resultDocument	ExcelDocumentParameter

ReadSpreadSheetCellResponse

Name	Path	Type	Description
cell	cell	AddressedSpreadSheetCell

ReadSpreadSheetCellsResponse

Name	Path	Type	Description
cells	cells	array of AddressedSpreadSheetCell

SpreadSheetCellLocation

Name	Path	Type	Description
sheetName	sheetName	string
cellAddress	cellAddress	string

ValidateConnectionResponse

Name	Path	Type	Description
resultMessage	resultMessage	string

WordDocumentParameter

Name	Path	Type	Description
documentContent	documentContent	byte
documentName	documentName	string