Home > Appendices > API for Connector > Supported APIs
Export to PDFThe following sections list the supported APIs.
Submit records to AvePoint Opus. You need to download the JSON file of each connection from Settings > Connector to prepare the record information. You can only submit up to 15 records at a time.
Example
Request Information
| Element | Description | Type | Required |
|---|---|---|---|
| id | The ID of the connection. | GUID | Yes |
| conflictOption | The conflict resolution when there are records with the same unique key.Valid values are:Overwrite to overwrite the record information in AvePoint Opus.Skip to skip submitting the record to AvePoint Opus. | String | Yes |
| rowKey | The unique key of the record. | String | Yes |
| leafName | The internal name of the built-in Name column in the connection. | String | Yes |
| termFullPath | The internal name of the built-in Classification column in the connection.The value must be the full path of a term in AvePoint Opus. | String | No |
| timeCreated | The internal name of the built-in Created time column in the connection.The format of the value must follow the date and time format configured in Settings > General settings. | String | Yes |
| timeModified | The internal name of the built-in Modified time column in the connection. | String | Yes |
| createdBy | The internal name of the built-in Created by column in the connection. | String | No |
| modifiedBy | The internal name of the built-in Modified by column in the connection. | String | No |
AvePoint Opus supports creating custom columns of different types to meet your requirements for variable record properties. When submitting records with custom columns, enter the internal name of each custom column you have defined in the connection. Values of custom columns are optional. For details, refer to Create a Connection.
For the Single line of text type of column, value should be a single line of text.
For the Multiple lines of text type of column, value should be multiple lines of text.
For the Date and Time type of column, value should be a date and/or time.
For the Choice (single selection) type of column, value should be the numerical order of the correct option, not the option name.
For the Choice (multiple selections) type of column, value should be the numerical orders of the correct options separated by commas in square brackets.
For the Person or Group type of column, value should be the full email address of users and/or groups separated by commas in square brackets. If the user or group does not exist in AvePoint Opus, AvePoint Opus will query it in the Microsoft Entra that is authorized via the app profile in AvePoint Online Services.
For the Number type of column, value should be a number.
Response Information
| Element | Description | Type |
|---|---|---|
| Message | The request details. | String |
| FailedItems | If some records failed to be submitted to AvePoint Opus, this parameter would appear, displaying the records failed in the request.The value contains:Item is the information of the item that failed in the request.Message is the details about the failure. | Array (Object) |
Retrieve the records whose disposed due date is earlier than the specified time.
Example
Request Information
| Element | Description | Type | Required |
|---|---|---|---|
| id | The ID of the connection. | GUID | Yes |
| disposalDueDate | The disposal due date.The format of the value must follow the date and time format configured in AvePoint Opus > Settings > General settings. | String | Yes |
| startIndex | The page index of the last request. | String | No |
| itemsPerPage | The number of records that you want to request on one page.The valid value is a number between 0 and 100. | Int | Yes |
Response Information
| Element | Description | Type |
|---|---|---|
| message | The details about the action. | String |
| pageIndex | The page index of the records that are queried in the request. | String |
| queriedItems | The records that match the request information. | Array |
Update the status of records as Destroyed in AvePoint Opus. You can only update the status for up to 15 records at a time. If manual approval is enabled, after record reviewers approve or reject the records, you can use this API to update the status of the approved records as Destroyed in AvePoint Opus.
Example
Request Information
| Element | Description | Type | Required |
|---|---|---|---|
| Item RowKey | The unique ID of the record that you want to update as Destroyed in AvePoint Opus. | String | Yes |
Response Information
| Element | Description | Type |
|---|---|---|
| message | The request details. | String |
| failedItems | The items that failed in the request. | Array (["Row Key1", "Row Key2"]) |