Dela via


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

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

Excel - Get Cells Value or Formula

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

Excel - Set Cell Value or Formula

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

Excel - Set Cells Value or Formula

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

Validate the connection and API Key are working

Validate the connection and API Key are working

Parameters

Name Key Required Type Description
message
message string

Returns

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

Parameters

Name Key Required Type Description
message
message string

Returns

Word - Append Multiple Word Documents Together

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

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

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

Word - Extract Content By Bookmarks

Word - Extract Content By Bookmarks

Parameters

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

Returns

Word - Extract Content By Heading

Word - Extract Content By Heading

Parameters

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

Returns

Word - Extract Content By Title

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

Word - Insert Documents into a document at bookmark

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

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