Freigeben über

AikiDocs (Preview)

  • Reference

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