Agiloft

Manage records in Agiloft CLM

Agiloft is an enterprise contract lifecycle management (CLM) platform that helps organizations automate and manage contracts, agreements, and related business processes across any knowledge base.

With the Agiloft integration in Sim, you can:

  • Create records: Add new records to any Agiloft table with custom field values
  • Read records: Retrieve individual records by ID with optional field selection
  • Update records: Modify existing record fields in any table
  • Delete records: Remove records from your knowledge base
  • Search records: Find records using Agiloft's query syntax with pagination support
  • Select records: Query records using SQL WHERE clauses for advanced filtering
  • Saved searches: List saved search definitions available for a table
  • Attach files: Upload and attach files to record fields
  • Retrieve attachments: Download attached files from record fields
  • Remove attachments: Delete attached files from record fields by position
  • Attachment info: Get metadata about all files attached to a record field
  • Lock records: Check, acquire, or release locks on records for concurrent editing

In Sim, the Agiloft integration enables your agents to manage contracts and records programmatically as part of automated workflows. Agents can create and update records, search across tables, handle file attachments, and manage record locks — enabling intelligent contract lifecycle automation.

Usage Instructions

Integrate with Agiloft contract lifecycle management to create, read, update, delete, and search records. Supports file attachments, SQL-based selection, saved searches, and record locking across any table in your knowledge base.

Tools

agiloft_attach_file

Attach a file to a field in an Agiloft record.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts")
recordIdstringYesID of the record to attach the file to
fieldNamestringYesName of the attachment field
filefileNoFile to attach
fileNamestringNoName to assign to the file (defaults to original file name)

Output

ParameterTypeDescription
recordIdstringID of the record the file was attached to
fieldNamestringName of the field the file was attached to
fileNamestringName of the attached file
totalAttachmentsnumberTotal number of files attached in the field after the operation

agiloft_attachment_info

Get information about file attachments on a record field.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts")
recordIdstringYesID of the record to check attachments on
fieldNamestringYesName of the attachment field to inspect

Output

ParameterTypeDescription
attachmentsarrayList of attachments with position, name, and size
positionnumberPosition index of the attachment in the field
namestringFile name of the attachment
sizenumberFile size in bytes
totalCountnumberTotal number of attachments in the field

agiloft_create_record

Create a new record in an Agiloft table.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts", "contacts.employees")
datastringYesRecord field values as a JSON object (e.g., {"first_name": "John", "status": "Active"})

Output

ParameterTypeDescription
idstringID of the created record
fieldsjsonField values of the created record

agiloft_delete_record

Delete a record from an Agiloft table.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts", "contacts.employees")
recordIdstringYesID of the record to delete

Output

ParameterTypeDescription
idstringID of the deleted record
deletedbooleanWhether the record was successfully deleted

agiloft_lock_record

Lock, unlock, or check the lock status of an Agiloft record.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts")
recordIdstringYesID of the record to lock, unlock, or check
lockActionstringYesAction to perform: "lock", "unlock", or "check"

Output

ParameterTypeDescription
idstringRecord ID
lockStatusstringLock status (e.g., "LOCKED", "UNLOCKED")
lockedBystringUsername of the user who locked the record
lockExpiresInMinutesnumberMinutes until the lock expires

agiloft_read_record

Read a record by ID from an Agiloft table.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts", "contacts.employees")
recordIdstringYesID of the record to read
fieldsstringNoComma-separated list of field names to include in the response

Output

ParameterTypeDescription
idstringID of the record
fieldsjsonField values of the record

agiloft_remove_attachment

Remove an attached file from a field in an Agiloft record.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts")
recordIdstringYesID of the record containing the attachment
fieldNamestringYesName of the attachment field
positionstringYesPosition index of the file to remove (starting from 0)

Output

ParameterTypeDescription
recordIdstringID of the record
fieldNamestringName of the attachment field
remainingAttachmentsnumberNumber of attachments remaining in the field after removal

agiloft_retrieve_attachment

Download an attached file from an Agiloft record field.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts")
recordIdstringYesID of the record containing the attachment
fieldNamestringYesName of the attachment field
positionstringYesPosition index of the file in the field (starting from 0)

Output

ParameterTypeDescription
filefileDownloaded attachment file

List saved searches defined for an Agiloft table.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name to list saved searches for (e.g., "contracts")

Output

ParameterTypeDescription
searchesarrayList of saved searches for the table
namestringSaved search name
labelstringSaved search display label
idstringSaved search database identifier
descriptionstringSaved search description

agiloft_search_records

Search for records in an Agiloft table using a query.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name to search in (e.g., "contracts", "contacts.employees")
querystringYesSearch query using Agiloft query syntax (e.g., "status='Active'" or "company_name~='Acme'")
fieldsstringNoComma-separated list of field names to include in the results
pagestringNoPage number for paginated results (starting from 0)
limitstringNoMaximum number of records to return per page

Output

ParameterTypeDescription
recordsjsonArray of matching records with their field values
totalCountnumberTotal number of matching records
pagenumberCurrent page number
limitnumberRecords per page

agiloft_select_records

Select record IDs matching a SQL WHERE clause from an Agiloft table.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts", "contacts.employees")
wherestringYesSQL WHERE clause using database column names (e.g., "summary like '%new%'" or "assigned_person='John Doe'")

Output

ParameterTypeDescription
recordIdsarrayArray of record IDs matching the query
totalCountnumberTotal number of matching records

agiloft_update_record

Update an existing record in an Agiloft table.

Input

ParameterTypeRequiredDescription
instanceUrlstringYesAgiloft instance URL (e.g., https://mycompany.agiloft.com\)
knowledgeBasestringYesKnowledge base name
loginstringYesAgiloft username
passwordstringYesAgiloft password
tablestringYesTable name (e.g., "contracts", "contacts.employees")
recordIdstringYesID of the record to update
datastringYesUpdated field values as a JSON object (e.g., {"status": "Active", "priority": "High"})

Output

ParameterTypeDescription
idstringID of the updated record
fieldsjsonUpdated field values of the record

On this page