# Agiloft

> Search Agiloft records, create and update contracts and other records, discover tables and fields, read attachment details and resolve choice IDs.

App · 13 actions. Web page: https://docs.lodol.com/docs/integrations/agiloft

## Actions

### Create record

Create record.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Fields (`fields`, object, required): Record fields by logical name. Choice fields take their displayed text.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Delete record

Delete record.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Record id (`record_id`, text, required): The record id.
- Delete rule (`delete_rule`, text, required): 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**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Get choice id

Get choice id.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Field (`field`, text, required): The field.
- Value (`value`, text, required): The value.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Get record

Get record.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Record id (`record_id`, text, required): The record id.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Get record lock

Get record lock.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Record id (`record_id`, text, required): The record id.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Get table

Get table.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Include linked info (`include_linked_info`, true/false): The include linked info.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "tables": []
    },
    "success": true
  }
}
```

### List record attachments

List record attachments.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Record id (`record_id`, text, required): The record id.
- Field (`field`, text, required): The field.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": [],
    "success": true
  }
}
```

### List saved searches

List saved searches.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": [],
    "success": true
  }
}
```

### List tables

List tables.

**Inputs**

- Skip columns info (`skip_columns_info`, true/false): The skip columns info.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "tables": []
    },
    "success": true
  }
}
```

### Search records

Search records.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Query (`query`, text, required): A search expression, such as summary~='test'.
- Field (`field`, list): Logical field names to return.
- Page (`page`, number): The page. At least 0.
- Limit (`limit`, number): The limit. From 1 to 1000.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Select record ids

Select record ids.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Where (`where`, text, required): An Agiloft SQL condition, such as id=123.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Update record

Update record.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Record id (`record_id`, text, required): The record id.
- Fields (`fields`, object, required): Record fields by logical name. Choice fields take their displayed text.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```

### Upsert record

Upsert record.

**Inputs**

- Table name (`table_name`, text, required): Select the logical table name. Names are case sensitive.
- Match query (`match_query`, text, required): A unique match, such as external_id='CRM-123'.
- Fields (`fields`, object, required): Record fields by logical name. Choice fields take their displayed text.

**Outputs**

- `response` (object): The complete service response, including resource data and pagination fields.

**Example output**

```json
{
  "response": {
    "message": "",
    "result": {
      "id": 12
    },
    "success": true
  }
}
```
