Actions98
- Admin Actions
- Get Users Details
- Get User Permissions
- Update Users
- Create Users
- Get All Groups
- Get Group Members
- Get Groups
- Create Groups
- Update Groups
- Get Permissions
- Get Permission
- Create Permission
- Update Permission
- Get Configuration Rules
- Get Rule Product Groups
- Get Tables
- Get Configuration Rule
- Add or Update Configuration Rule
- Add Rule Product Groups
- Update Rule Product Groups
- Get Configuration
- Save Configuration
- Save Quote Types
- Get Currency Conversions
- Get Object Names Meta Data
- Get Customer Languages
- Get Layout Fields By Object
- Get Data Values
- Get Field Columns
- Add Currency Conversion
- Update Currency Conversion
- Delete Currency Conversion
- Save Translation Meta Data
- Save Translation Data
- Set Customer Languages
- Get Properties
- Get Locations
- Get Flows
- Get Flow By ID
- Create Flow
- Update Flow
- Set Up Customer Profile for Salesforce
- Request Free Trial
- Get Categories
- Get All Categories
- Get Category Products
- Get Non-Associated Category Products
- Get Category Pricebooks
- Get Non-Associated Pricebooks
- Get Category Details
- Get Category Discounts
- Get Category Discount By ID
- Add Categories
- Update Category
- Add Products to Category
- Delete Category Products
- Update Category Pricebooks
- Add Pricebook to a Category
- Add or Update Category Discounts
- Delete Category Discounts
- Get Price Books
- Get Based On Price Books
- Get Price Book Associated Products
- Get Price Book Available Products
- Pricebook Line Items
- Get Pricing Customer Lookup
- Add Price Book
- Update Price Book
- Add Price Book Associated Products
- Update Price Book Associated Products
- Get Deal Guidances
- Add Deal Guidance
- Update Deal Guidances
- Get Table Schemas
- Get Approvals
- Get Group Users
- Add or Update Approval
- Get Objects
- Get Object Details by ID
- Get Data Types
- Add Objects
- Update Objects
- Import Data
- Get Functions
- Get Template List
- Insert or Update Templates
- Get Layout Fields
- Get Layouts
- Get Layouts By Layout ID
- Add Layouts
- Delete Layouts
- Get Product Activity Timeline
- Get Price Book Activity Timeline
- Get Price Book Item Activity Timeline
- Get Rule Activity Timeline
- Get All Product UOMs
- Get All Product UOM Conversions
- Get Products
Overview
This node integrates with the ScaleFluidly API, allowing users to perform various operations across multiple resources such as Admin, Quote, Configure, Pricing, and MCP. Specifically, for the Admin resource with the Get Table Schemas operation, the node fetches schema information about database tables or data structures managed by ScaleFluidly. This can be useful for administrators or developers who need to understand the structure of data tables for reporting, integration, or configuration purposes.
Common scenarios include:
- Retrieving metadata about tables to dynamically build UI forms or reports.
- Validating data structures before performing data migrations or updates.
- Automating documentation generation for internal APIs or databases.
Example: An admin user wants to get the schema details of certain tables in the ScaleFluidly system to prepare a data export or integration with another system.
Properties
| Name | Meaning |
|---|---|
| Environment | The target environment URL for the ScaleFluidly API. Options are: - Dev (development environment) - QA (quality assurance environment) - Local (local instance) |
| Resource | The category of API actions to perform. For this context, it is "Admin". |
| Operation | The specific action to execute under the selected resource. Here, "Get Table Schemas". |
The provided input properties JSON only includes the Environment property because the Resource and Operation are fixed by your selection.
Output
The node outputs an array of JSON objects representing the response from the ScaleFluidly API for the requested operation. For the Get Table Schemas operation, the output JSON will contain schema details of tables, such as column names, types, constraints, and other metadata describing the table structure.
If the API returns binary data (not indicated here), it would typically represent files or documents related to schemas, but this node primarily handles JSON responses.
Dependencies
- Requires access to the ScaleFluidly API endpoint corresponding to the chosen environment.
- May require an API authentication token (bearer token) passed via HTTP headers; the node expects this token to be present in the input data's authorization header on the first item or uses configured credentials.
- No explicit external libraries beyond n8n core helpers are used.
Troubleshooting
- Bearer token not found: If the authorization token is missing in the first input item's headers and no credential is configured, the node will throw an error. Ensure that the token is provided either in the input data or via node credentials.
- Operation not found: If the specified operation does not exist in the intent-to-URL mapping, the node throws an error indicating the operation is invalid. Verify the operation name matches supported values.
- API request failures: Network issues, incorrect environment URLs, or invalid tokens may cause request errors. Check connectivity and authentication details.
- Empty or malformed response: If the API returns unexpected data, verify the request body and parameters.
Links and References
- ScaleFluidly API Documentation (QA environment)
- ScaleFluidly Developer Portal (Dev environment)
- n8n Documentation on Creating Custom Nodes
This summary focuses on the static analysis of the node's execute() method and its configuration relevant to the Admin resource and Get Table Schemas operation.