Ninox icon

Ninox

Read, create, update and delete data from Ninox

Actions30

File → Ninox Script

AI-generated

Overview

This node executes custom Ninox Script queries on a specified Ninox team, database, and optionally table. It allows users to run read-only or modifying queries using Ninox's scripting language, enabling complex data retrieval or manipulation within Ninox databases. Common use cases include fetching specific records, performing calculations, or automating data updates in Ninox.

Use Case Examples

  1. Run a Ninox Script to retrieve email addresses from a contacts table.
  2. Execute a read-only Ninox Script query to fetch aggregated data without modifying the database.
  3. Split script results into individual items for further processing in a workflow.

Properties

Name Meaning
Ninox Team The ID of the Ninox team to access, selectable from a list or specified by URL or ID.
Ninox Database The ID of the Ninox database to access, selectable from a list or specified by URL or ID.
Ninox Table The ID of the Ninox table to access, selectable from a list or specified by URL or ID. Required for certain operations.
Read Only Queries Boolean flag to use GET method for read-only queries instead of POST, suitable for queries that do not modify data.
Ninox Script The Ninox Script query to execute, allowing custom data retrieval or manipulation.
Parse As JSON Whether to parse the entire response as JSON and return it as a single item, useful for complex data structures.
Split Into Items Whether to split the script results into separate items if the result is an array, each element becomes an individual item.
Fetch As Records When splitting into items, treat array values as record IDs and fetch each record individually. Errors if values are not valid record IDs.

Output

JSON

  • data - The main response data from the Ninox Script query, which can be a single object or an array of objects depending on the query and options.

Dependencies

  • Ninox API with API key credential

Troubleshooting

  • Ensure the Ninox Team, Database, and Table IDs are correct and accessible with the provided API credentials.
  • If using read-only queries, enable the 'Read Only Queries' option to use GET method; otherwise, use POST for modifying queries.
  • When enabling 'Split Into Items' and 'Fetch As Records', ensure the script returns valid record IDs to avoid errors.
  • Check Ninox Script syntax carefully as errors in the script will cause query failures.
  • If parsing as JSON, ensure the response is valid JSON to prevent parsing errors.

Links

Discussion