Rocketadmin
rocketadminSave months of work developing custom admin panels with our secure solution for your MySQL, PostgreSQL, MSSQL, Oracle DB or MongoDB project.
Acciones disponibles (19)
Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.
Check API KeyROCKETADMIN_CHECK_API_KEYAcciónTool to validate whether an API key is legitimate and active. Use when you need to verify that the current API key is valid before performing other operations.
ROCKETADMIN_CHECK_API_KEYAcciónTool to validate whether an API key is legitimate and active. Use when you need to verify that the current API key is valid before performing other operations.
Parámetros de entrada
Sin parámetros.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Delete Table Row by Primary KeyROCKETADMIN_DELETE_TABLE_ROWAcciónTool to delete a single row from a database table by primary key. Use when you need to remove a specific row identified by its ID. This is an API+ feature.
ROCKETADMIN_DELETE_TABLE_ROWAcciónTool to delete a single row from a database table by primary key. Use when you need to remove a specific row identified by its ID. This is an API+ feature.
Parámetros de entrada
idanyObligatorioThe primary key value of the row to delete. Can be a string or integer depending on the table schema.
tableNamestringObligatorioThe name of the table from which the row will be deleted.
connectionIdstringObligatorioThe unique identifier for the database connection where the deletion will occur.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Verify Company Invitation LinkROCKETADMIN_GET_COMPANY_INVITE_VERIFYAcciónTool to check if a company invitation verification link is available and valid. Use when you need to verify a company invitation token before accepting the invitation.
ROCKETADMIN_GET_COMPANY_INVITE_VERIFYAcciónTool to check if a company invitation verification link is available and valid. Use when you need to verify a company invitation token before accepting the invitation.
Parámetros de entrada
verificationStringstringObligatorioA unique verification token string used to validate the company invitation link and check if it is still available and valid.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get All ConnectionsROCKETADMIN_GET_CONNECTIONSAcciónTool to retrieve all database connections where the user has access. Use when you need to discover available connections in the user's workspace.
ROCKETADMIN_GET_CONNECTIONSAcciónTool to retrieve all database connections where the user has access. Use when you need to discover available connections in the user's workspace.
Parámetros de entrada
Sin parámetros.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Connection TablesROCKETADMIN_GET_CONNECTION_TABLESAcciónTool to retrieve all tables from a database connection. Use when you need to discover available tables in a specific connection.
ROCKETADMIN_GET_CONNECTION_TABLESAcciónTool to retrieve all tables from a database connection. Use when you need to discover available tables in a specific connection.
Parámetros de entrada
connectionIdstringObligatorioThe unique identifier for the database connection to query tables from.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Connection Tables V2ROCKETADMIN_GET_CONNECTION_TABLES_V2AcciónTool to retrieve all tables in a database connection organized with category information. Use when you need to discover available tables in a specific connection.
ROCKETADMIN_GET_CONNECTION_TABLES_V2AcciónTool to retrieve all tables in a database connection organized with category information. Use when you need to discover available tables in a specific connection.
Parámetros de entrada
connectionIdstringObligatorioThe unique identifier for the database connection to query tables from.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Validate Connection TokenROCKETADMIN_GET_CONNECTION_TOKENAcciónTool to validate if connection agent token is valid. Use when you need to check if the current connection token is still authorized and active.
ROCKETADMIN_GET_CONNECTION_TOKENAcciónTool to validate if connection agent token is valid. Use when you need to check if the current connection token is still authorized and active.
Parámetros de entrada
Sin parámetros.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get HelloROCKETADMIN_GET_HELLOAcciónTool to retrieve a hello greeting message from the Rocketadmin API. Use when testing API connectivity or getting a simple greeting response.
ROCKETADMIN_GET_HELLOAcciónTool to retrieve a hello greeting message from the Rocketadmin API. Use when testing API connectivity or getting a simple greeting response.
Parámetros de entrada
Sin parámetros.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get SaaS Users by EmailROCKETADMIN_GET_SAAS_USERS_EMAILAcciónTool to retrieve user information by email address. Use when you need to get details about a specific user by their email.
ROCKETADMIN_GET_SAAS_USERS_EMAILAcciónTool to retrieve user information by email address. Use when you need to get details about a specific user by their email.
Parámetros de entrada
user_emailstringObligatorioThe email address of the user to retrieve information for
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Table Row by Primary KeyROCKETADMIN_GET_TABLE_ROWAcciónTool to retrieve a single row from a database table using its primary key. Use when you need to fetch specific row data by its ID from a RocketAdmin connection.
ROCKETADMIN_GET_TABLE_ROWAcciónTool to retrieve a single row from a database table using its primary key. Use when you need to fetch specific row data by its ID from a RocketAdmin connection.
Parámetros de entrada
idanyObligatorioThe primary key value of the row to retrieve. Can be a string or integer depending on the table schema.
tableNamestringObligatorioThe name of the database table to query.
connectionIdstringObligatorioThe unique identifier for the database connection.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get All Table RowsROCKETADMIN_GET_TABLE_ROWSAcciónTool to retrieve all rows from a database table with support for pagination, filtering, and sorting. Use when you need to fetch multiple rows from a RocketAdmin connection table.
ROCKETADMIN_GET_TABLE_ROWSAcciónTool to retrieve all rows from a database table with support for pagination, filtering, and sorting. Use when you need to fetch multiple rows from a RocketAdmin connection table.
Parámetros de entrada
pageintegerPagination page number for retrieving specific page of results.
emailstringUser email filter parameter for filtering rows by email.
limitintegerMaximum number of records to return (default: 500).
orderstringSort order for results (ASC for ascending, DESC for descending).
dateTostringFilter end date for date-based filtering. Use ISO date format.
offsetintegerStarting position for results, used for pagination.
perPageintegerNumber of results per page for pagination.
dateFromstringFilter start date for date-based filtering. Use ISO date format.
tableNamestringObligatorioThe name of the database table to query rows from.
connectionIdstringObligatorioThe unique identifier for the database connection.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Get Table StructureROCKETADMIN_GET_TABLE_STRUCTUREAcciónTool to retrieve the structural information of a database table including columns, data types, constraints, and relationships. Use when you need to understand the schema of a specific table in a RocketAdmin connection.
ROCKETADMIN_GET_TABLE_STRUCTUREAcciónTool to retrieve the structural information of a database table including columns, data types, constraints, and relationships. Use when you need to understand the schema of a specific table in a RocketAdmin connection.
Parámetros de entrada
tableNamestringObligatorioThe name of the database table to retrieve structure for.
connectionIdstringObligatorioThe unique identifier for the database connection.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Verify User EmailROCKETADMIN_GET_USER_EMAIL_VERIFYAcciónTool to verify a user's email address using a verification token. Use when you need to confirm a user's email address after registration or email change.
ROCKETADMIN_GET_USER_EMAIL_VERIFYAcciónTool to verify a user's email address using a verification token. Use when you need to confirm a user's email address after registration or email change.
Parámetros de entrada
verificationStringstringObligatorioA unique verification token string used to authenticate and validate the user's email address during the verification process.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Export Table as CSVROCKETADMIN_POST_TABLE_CSV_EXPORTAcciónTool to export table data as a CSV file from RocketAdmin. Use when you need to download table data in CSV format. This is an API+ feature that exports the specified table with optional filtering, pagination, and sorting.
ROCKETADMIN_POST_TABLE_CSV_EXPORTAcciónTool to export table data as a CSV file from RocketAdmin. Use when you need to download table data in CSV format. This is an API+ feature that exports the specified table with optional filtering, pagination, and sorting.
Parámetros de entrada
pageintegerPage number for pagination, must be >=1.
emailstringFilter by user email address.
limitintegerMaximum records to return. Default is 500 if pagination is not used. Must be >=1.
orderstringSorting parameter (e.g., 'ASC' for ascending, 'DESC' for descending).
dateTostringEnd date for date range filtering (ISO8601 format).
perPageintegerNumber of records per page, must be >=1.
dateFromstringStart date for date range filtering (ISO8601 format).
tableNamestringObligatorioSpecifies which table to export.
connectionIdstringObligatorioThe unique identifier for the database connection.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Add Row to TableROCKETADMIN_POST_TABLE_ROWAcciónTool to add a new row to a database table in RocketAdmin. Use when you need to insert data into a specific table. This is an API+ feature that creates a new row with the provided field values.
ROCKETADMIN_POST_TABLE_ROWAcciónTool to add a new row to a database table in RocketAdmin. Use when you need to insert data into a specific table. This is an API+ feature that creates a new row with the provided field values.
Parámetros de entrada
row_dataobjectObligatorioThe row data to insert. Keys should match table column names and values should match expected data types. The structure depends on the target table schema.
tableNamestringObligatorioThe name of the database table where the row should be inserted.
connectionIdstringObligatorioThe unique identifier for the database connection where the row will be added.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Find Table Rows with FiltersROCKETADMIN_POST_TABLE_ROWS_FINDAcciónTool to retrieve all rows from a database table with filter parameters in the request body. Use when you need to fetch rows with complex filtering conditions. This is an API+ feature that supports advanced filtering with operators like equals, greater than, less than, like, in, etc.
ROCKETADMIN_POST_TABLE_ROWS_FINDAcciónTool to retrieve all rows from a database table with filter parameters in the request body. Use when you need to fetch rows with complex filtering conditions. This is an API+ feature that supports advanced filtering with operators like equals, greater than, less than, like, in, etc.
Parámetros de entrada
pageintegerPagination page number for retrieving specific page of results.
filtersobjectFilter parameters to apply to the table rows query. Structure: {column_name: {operator: value}}. Operators include 'eq' (equals), 'ne' (not equals), 'gt' (greater than), 'gte' (greater than or equal), 'lt' (less than), 'lte' (less than or equal), 'like' (pattern matching), 'in' (in list), 'notin' (not in list), 'isnull' (is null), 'isnotnull' (is not null).
perPageintegerNumber of results per page for pagination.
tableNamestringObligatorioThe name of the database table to query rows from.
connectionIdstringObligatorioThe unique identifier for the database connection.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update Table Row by Primary KeyROCKETADMIN_PUT_TABLE_ROWAcciónTool to update a row in a database table by its primary key. Use when you need to modify existing row data in a RocketAdmin connection. This is an API+ feature.
ROCKETADMIN_PUT_TABLE_ROWAcciónTool to update a row in a database table by its primary key. Use when you need to modify existing row data in a RocketAdmin connection. This is an API+ feature.
Parámetros de entrada
idanyObligatorioThe primary key value of the row to update. Can be a string or integer depending on the table schema.
row_dataobjectObligatorioThe row data to update. Keys should match table column names and values should match expected data types. Only include fields that need to be updated.
tableNamestringObligatorioThe name of the database table containing the row to update.
connectionIdstringObligatorioThe unique identifier for the database connection where the row will be updated.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Delete Multiple Table RowsROCKETADMIN_PUT_TABLE_ROWS_DELETEAcciónTool to delete multiple rows from a table by primary key. Use when you need to batch delete rows identified by their primary keys. This is an API+ feature.
ROCKETADMIN_PUT_TABLE_ROWS_DELETEAcciónTool to delete multiple rows from a table by primary key. Use when you need to batch delete rows identified by their primary keys. This is an API+ feature.
Parámetros de entrada
rowsobject[]ObligatorioArray of objects containing the primary key field(s) and their values for rows to be deleted. Each object must include the primary key field name(s) that identify the row.
tableNamestringObligatorioThe name of the table from which rows will be deleted.
connectionIdstringObligatorioThe unique identifier for the database connection where the deletion will occur.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not
Update Multiple Table RowsROCKETADMIN_PUT_TABLE_ROWS_UPDATEAcciónTool to update multiple rows in a table by primary key. Use when you need to batch update rows identified by their primary keys with the same new values. This is an API+ feature.
ROCKETADMIN_PUT_TABLE_ROWS_UPDATEAcciónTool to update multiple rows in a table by primary key. Use when you need to batch update rows identified by their primary keys with the same new values. This is an API+ feature.
Parámetros de entrada
newValuesobjectObligatorioObject containing the field names and new values to be set for all identified rows. Keys should match table column names.
tableNamestringObligatorioThe name of the table where rows will be updated.
primaryKeysobject[]ObligatorioArray of objects containing the primary key field(s) and their values for rows to be updated. Each object must include the primary key field name(s) that identify the row.
connectionIdstringObligatorioThe unique identifier for the database connection where the update will occur.
Parámetros de salida
dataobjectObligatorioData from the action execution
errorstringError if any occurred during the execution of the action
successfulbooleanObligatorioWhether or not the action execution was successful or not