# ApiIntegrationMappings: ionBIZ API Integration Mappings - Catalog: `ionBIZ` - Label: API Integration Mappings - Retrieve: true ## Table Columns The columns of the table `ApiIntegrationMappings` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `Active` | `boolean` | Active | ☐ | | | `AllowDatabaseDelete` | `boolean` | Allow Database Delete | ☐ | | | `AllowDatabaseInsert` | `boolean` | Allow Database Insert | ☐ | | | `AllowDatabaseUpdate` | `boolean` | Allow Database Update | ☐ | | | `ApiActions` | `int32` | API Actions | ☐ | | | `ApiIntegrationToolId` | `int32` | API Integration Tool ID | ☐ | | | `ApiUrl` | `string` | API URL | ☐ | | | `ApiVerb` | `int32` | API Verb | ☐ | | | `AuthorizationParameters` | `string` | Authorization Parameters | ☐ | | | `Code` | `string` | Code | ☐ | | | `CreationDate` | `datetimeoffset` | Creation Date | ☐ | | | `CreatorId` | `int32` | Creator ID | ☐ | | | `Id` | `int32` | ID | ☑ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `ModifiedById` | `int32` | Modified by ID | ☐ | | | `ModifiedDate` | `datetimeoffset` | Modified Date | ☐ | | | `Name` | `string` | Name | ☐ | | | `OAuthTokenId` | `int32` | Oauth Token ID | ☐ | | | `TableWithHistoryId` | `int32` | Table with History ID | ☐ | | | `Where` | `string` | Where | ☐ | |