Agiloft
App · 13 actions
Search Agiloft records, create and update contracts and other records, discover tables and fields, read attachment details and resolve choice IDs.
Actions
| Action | What it does |
|---|---|
| Create record | Create record. |
| Delete record | Delete record. |
| Get choice id | Get choice id. |
| Get record | Get record. |
| Get record lock | Get record lock. |
| Get table | Get table. |
| List record attachments | List record attachments. |
| List saved searches | List saved searches. |
| List tables | List tables. |
| Search records | Search records. |
| Select record ids | Select record ids. |
| Update record | Update record. |
| Upsert record | Upsert record. |
Create record
Create record.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Fields
fieldsobjectRequired - Record fields by logical name. Choice fields take their displayed text.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Delete record
Delete record.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Record id
record_idtextRequired - The record id.
- Delete rule
delete_ruletextRequired - Fail if dependent records exist, or unlink dependent records. Cascading deletion is not offered.One of:
ERROR_IF_DEPENDANTS(Error if dependants),APPLY_UNLINK(Apply unlink).
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Get choice id
Get choice id.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Field
fieldtextRequired - The field.
- Value
valuetextRequired - The value.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Get record
Get record.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Record id
record_idtextRequired - The record id.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Get record lock
Get record lock.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Record id
record_idtextRequired - The record id.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Get table
Get table.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Include linked info
include_linked_infotrue/false - The include linked info.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"tables": []
},
"success": true
}
}List record attachments
List record attachments.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Record id
record_idtextRequired - The record id.
- Field
fieldtextRequired - The field.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": [],
"success": true
}
}List saved searches
List saved searches.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": [],
"success": true
}
}List tables
List tables.
Inputs
- Skip columns info
skip_columns_infotrue/false - The skip columns info.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"tables": []
},
"success": true
}
}Search records
Search records.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Query
querytextRequired - A search expression, such as summary~='test'.
- Field
fieldlist - Logical field names to return.
- Page
pagenumber - The page.At least 0.
- Limit
limitnumber - The limit.From 1 to 1000.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Select record ids
Select record ids.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Where
wheretextRequired - An Agiloft SQL condition, such as id=123.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Update record
Update record.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Record id
record_idtextRequired - The record id.
- Fields
fieldsobjectRequired - Record fields by logical name. Choice fields take their displayed text.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}Upsert record
Upsert record.
Inputs
- Table name
table_nametextRequired - Select the logical table name. Names are case sensitive.
- Match query
match_querytextRequired - A unique match, such as external_id='CRM-123'.
- Fields
fieldsobjectRequired - Record fields by logical name. Choice fields take their displayed text.
Outputs
responseobject- The complete service response, including resource data and pagination fields.
Example output
{
"response": {
"message": "",
"result": {
"id": 12
},
"success": true
}
}