Code Monkey home page Code Monkey logo

n8n-nodes-ninox's Introduction

Ninox Nodes for n8n

This community package contains two nodes to integrate your Ninox Database with n8n.

n8n is a fair-code licensed workflow automation platform.

It adds two nodes:

Ninox Node Ninox Trigger Node
Operations: List, read, create, update delete Records and files and run Ninox Scripts Events: on create or change of records via polling

Supported Operations
Installation
Credentials
Compatibility
Notes for an improvement
Resources
Integration Approach
About
Version History

Supported Operations

Operation Description Options
List List records of a table Return all records OR Paginate trough them, Sorting, Filtering (eq. search), Created Since Sequence, Created Since ID
Read Get record of a table by ID -
Create Create a new record in a table add all fields or define a specific subset
Update Update a record in a table by ID update all fields or define a specific subset
Delete Delete a record in a table by ID -
List Attached Files Get the attached files of a record by ID -
Download Attached File Get the actual binary of a attachment by file name -
Upload File Attachment Upload a new file to record optional: add an Attachment Field ID or Name. When defined, the file will be uploaded into the field
Delete Attached File Remove a attached file from record by file name -
Ninox Script Send and run a Ninox Script to query data or run actions on your Ninox database -

Installation

Follow the installation guide in the n8n community nodes documentation.

Credentials

Since the nodes communicate with the Ninox REST API you'll have to obtain an Ninox API Key and add it as Ninox API Credential in n8n.io.

Follow these steps as you can find in the api docs of Ninox:

  1. Visit ninox.com.
  2. Click the Start Ninox button to open the web app.
  3. If you don't see the Start Ninox button, log in with your Ninox credentials first.
  4. In the top-right corner, click the Actions gear icon.
  5. In the drop-down menu, select Integrations.
  6. In the pop-up window, click the Generate button.
  7. Copy the API key to your clipboard.
  8. Create a new Ninox API Credential in your n8n instance
  9. Add the API key.

Keep in mind: This API ley provides access to all your Ninox teams and all the Ninox databases of these teams. You should handle this key with care.

Credentials for Ninox Private Cloud & Ninox On-Premise

Basicly the same steps as for Public Cloud users. You just need to define a Custom URL in the n8n credentials for Ninox. Your URL will be something like https://mycompany.ninox.com/v1 for Private Cloud users and https://myninox.mydomain.com/v1 for On-Premise users.

Compatibility

The Latest Version of n8n. If you encounter any problem, feel free to open an issue on Github.

Notes for an improvement

Currently the Create and Update operation run a request for each Item. It would be an optimization to batch these additions in a single request since the Ninox API supports that. But at this moment I was not able to make that request in the declarative implementation in n8n of this node. I might add this in the future.

Resources

Integration Approach

This node communicates with the Ninox REST API. The CRUD Operations are simple REST-API calls. For the Trigger Node I choosed to work with the sequence id. Everytime a change is made or a record is created the sequence number in your ninox table will be incremented by one. That made it pretty easy to get the difference between two sequences.

About


Hi I'm geckse and I let your work flow! ๐Ÿ‘‹ I hope you are enyoing these nodes. If you are in need of a smooth automation, steady integration or custom code check my page: https://let-the-work-flow.com

Version History

1.1.3

  • Fix missing Record ID and File Name fields in Delete File Attachment operation

1.1.2

  • Added dynamical loaded dropdowns for TeamID, DatabaseID & TeamID

1.1.1

  • Fix wrong baseURL for Credentials testing

1.1.0

  • Upload File Attachment: new optional option "Attachment Field"
  • Credentials: added custom base url for Ninox on-prem & private cloud users

n8n-nodes-ninox's People

Contributors

geckse avatar

Stargazers

 avatar  avatar  avatar  avatar

Watchers

 avatar  avatar

Forkers

frank-wiebeler

n8n-nodes-ninox's Issues

Missing Documentation makes use of this Node super hard

Hi there,

I've tried to integrate the node into my flows and the connection worked.
Unfortunatelly, it is hard to understand how the node shall work.

I tried to add a new Entry into my NinoxDB. If I select "All fields", I get a server error 500 with the following trace:
NodeApiError: Request failed with status code 500 at RoutingNode.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/RoutingNode.js:116:23) at processTicksAndRejections (node:internal/process/task_queues:95:5) at Workflow.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-workflow/dist/Workflow.js:707:23) at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:652:53

If I deactivate the "All fields" switch, it successfully creates an empty entry in the database.
I tried to add fields by hand in the n8n node; tried many different syntaxes. Unfortunatelly none of these lead to any data inside my node.

What do I need to do to insert a real value, do you have any example for me?

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.