# Ragic

Ragic is a web-based database builder that allows users to create and manage databases as easily as creating a spreadsheet.

- **Category:** databases
- **Auth:** API_KEY
- **Composio Managed App Available?** N/A
- **Tools:** 7
- **Triggers:** 0
- **Slug:** `RAGIC`
- **Version:** 20260223_00

## Tools

### Delete Entry

**Slug:** `RAGIC_DELETE_ENTRY`

Tool to delete an entry from a Ragic sheet. Use when you need to remove a specific record from a sheet by its record ID.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `server` | string | No | Ragic server subdomain (e.g., 'na5', 'www', 'ap5', 'eu2'). If provided, overrides the default server. Check your Ragic URL to find your server. |
| `record_id` | integer | Yes | The record ID of the entry to delete. |
| `tab_folder` | string | Yes | The tab folder path for the sheet (e.g., 'ragic-setup' or 'sales'). |
| `sheet_index` | integer | Yes | The sheet index number. |
| `account_name` | string | Yes | Your Ragic account name (the subdirectory in your Ragic URL, e.g., 'composio' from 'https://na5.ragic.com/composio/...'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Download File

**Slug:** `RAGIC_DOWNLOAD_FILE`

Tool to download uploaded files, images, or email attachments from Ragic. Use the file reference returned from API responses (e.g., from record fields).

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `server` | string | No | Ragic server subdomain (e.g., 'na5', 'www', 'ap5', 'eu2'). If provided, overrides the default server. Check your Ragic URL to find your server. |
| `account_name` | string | Yes | Your Ragic account name (the subdirectory in your Ragic URL, e.g., 'composio' from 'https://na5.ragic.com/composio/...'). |
| `file_reference` | string | Yes | The file reference as returned from API responses (e.g., 'Ni92W2luv@My_Picture.jpg'). This is the encoded filename with hash prefix. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Action Buttons

**Slug:** `RAGIC_GET_ACTION_BUTTONS`

Tool to retrieve the list of available action buttons on a Ragic sheet. Returns action button IDs and names. Use category=massOperation to get buttons available for mass operations.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `server` | string | No | Ragic server subdomain (e.g., 'na3', 'www', 'na5', 'ap5', 'eu2'). If provided, overrides the default server. Check your Ragic URL to find your server. |
| `category` | string | No | Filter action buttons by category. Use 'massOperation' to get buttons available for mass operations on multiple records. If not provided, may return HTTP 500 error on some sheets. |
| `tab_folder` | string | Yes | The tab folder path in the Ragic sheet structure. |
| `sheet_index` | integer | Yes | The sheet index number identifying the specific sheet. |
| `account_name` | string | Yes | The Ragic account name (the subdirectory in your Ragic URL, e.g., 'RSDemo' from 'https://na3.ragic.com/RSDemo/...'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Custom Print Report

**Slug:** `RAGIC_GET_CUSTOM_PRINT_REPORT`

Tool to retrieve a custom print report for a Ragic record in various formats (pdf, png, docx). Use when you need to generate and download a formatted report using a specific template.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `server` | string | No | Ragic server subdomain (e.g., 'na5', 'www', 'ap5', 'eu2'). If provided, overrides the default server. Check your Ragic URL to find your server. |
| `record_id` | integer | Yes | The ID of the record to retrieve the custom print report for. |
| `fileFormat` | string ("pdf" | "png" | "docx") | Yes | Output format for the custom print report. |
| `tab_folder` | string | Yes | The tab folder path in your Ragic sheet URL. |
| `sheet_index` | integer | Yes | The sheet index number from your Ragic sheet URL. |
| `account_name` | string | Yes | Your Ragic account name (the subdirectory in your Ragic URL, e.g., 'composio' from 'https://na5.ragic.com/composio/...'). |
| `fileNameRefDomainId` | integer | No | Optional field ID to use as the filename for the downloaded report. |
| `ragicCustomPrintTemplateId` | integer | Yes | The custom print template ID to use for generating the report. |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Entry

**Slug:** `RAGIC_GET_ENTRY`

Tool to retrieve a single entry from a Ragic sheet by its record ID. Use when you need to fetch specific record data including field values and optional subtable data.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `v` | string | No | API version (e.g., '3' or 'version=2025-01-01'). Recommended to use '3' for v3 API. |
| `info` | boolean | No | Set to True to add 'Create Date' and 'Create User' information to the response. |
| `server` | string | No | Ragic server subdomain (e.g., 'na5', 'www', 'ap5', 'eu2'). If provided, overrides the default server. Check your Ragic URL to find your server. |
| `comment` | boolean | No | Set to True to add comment thread information related to this record to the response. |
| `history` | boolean | No | Set to True to add edit history related to this record to the response. |
| `record_id` | integer | Yes | The record ID of the entry to retrieve. |
| `subtables` | boolean | No | Set to False to exclude subtable data from the response. If True or not provided, subtables are included by default. |
| `tab_folder` | string | Yes | The tab folder path for the sheet (e.g., 'ragic-setup', 'sales'). |
| `sheet_index` | integer | Yes | The sheet index number (e.g., 1, 2). |
| `account_name` | string | Yes | Your Ragic account name (the subdirectory in your Ragic URL, e.g., 'composio' from 'https://na5.ragic.com/composio/...'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Get Record as PDF

**Slug:** `RAGIC_GET_RECORD_AS_PDF`

Tool to retrieve a PDF version of a Ragic record. Use when you need to export or download a record in PDF format. The PDF will contain the full record data in a formatted document.

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `server` | string | No | Ragic server subdomain (e.g., 'na5', 'www', 'ap5', 'eu2'). If provided, overrides the default server. Check your Ragic URL to find your server. |
| `record_id` | integer | Yes | The record ID to retrieve as PDF. |
| `tab_folder` | string | Yes | The tab folder path in your Ragic account. |
| `sheet_index` | integer | Yes | The sheet index number (numeric identifier for the sheet). |
| `account_name` | string | Yes | Your Ragic account name (the subdirectory in your Ragic URL, e.g., 'composio' from 'https://na5.ragic.com/composio/...'). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |

### Search Records

**Slug:** `RAGIC_SEARCH_RECORDS`

Search Records

#### Input Parameters

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `info` | boolean | No | Set to True to add 'Create Date', 'Create User' information to the response. |
| `bbcode` | boolean | No | Set to True to retrieve the raw BBCode value saved to the field instead of being translated to HTML. |
| `server` | string | No | Ragic server subdomain (e.g., 'na5', 'www', 'ap5', 'eu2'). If provided, overrides the default server. Check your Ragic URL to find your server. |
| `comment` | boolean | No | Set to True to add the comment thread related to this record to the response. |
| `history` | boolean | No | Set to True to add the edit history related to this record to the response. |
| `listing` | boolean | No | Set to True to only include fields in the Listing Page. |
| `reverse` | boolean | No | Set to True to reverse the default ordering of the listing page response. |
| `approval` | boolean | No | Set to True to add the approval information related to this record to the response. |
| `subtables` | boolean | No | Set to False to not include subtable information in the response. If True or not provided, subtables are included by default. |
| `ignoreMask` | boolean | No | When True, the field value of 'Masked text' will be unmasked if you are in the viewable groups. |
| `sheet_path` | string | Yes | Path to the Ragic sheet in format 'tab_folder/sheet_index' (e.g., 'ragic-setup/1' or 'sales/2'). |
| `account_name` | string | Yes | Your Ragic account name (the subdirectory in your Ragic URL, e.g., 'composio' from 'https://na5.ragic.com/composio/...'). |
| `conversation` | boolean | No | Set to True to add the email conversation information related to this record to the response. |
| `search_query` | string | Yes | The full-text search query to find matching records. |
| `ignoreFixedFilter` | boolean | No | When True, the fixed filter on this sheet will be ignored (requires SYSAdmin privilege). |

#### Output

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `data` | string | Yes | Data from the action execution |
| `error` | string | No | Error if any occurred during the execution of the action |
| `successful` | boolean | Yes | Whether or not the action execution was successful or not |