The nodes that are accessed from the General pane allow you to perform a range of essential functions, like adding data flows and models to the master flow, running SQL queries against the database, calling REST APIs, and more.
General Nodes
- Data Flow: References a data flow. Configure the node in the Data Flow tab. You can add multiple data flow nodes, with each node referencing to a different data flow.
- Data Model: References a data model.
- Execute Process: Executes external code and applications. You can use this node to run commands (cmd) on the Pyramid server.
- Rest APIs: Calls an API. Add the node and then select the API method from the dropdown list before pasting the REST API URL or writing an expression using the Expression Editor.
- Set Variable: Sets a variable. Add the node and then select the variable from the Properties panel and write an expression using the Expression Editor.
- SQL Script: Runs an SQL script. Depending on your requirements, this may be connected to another node. Add the SQL Script node and select the database and data model that you want to query using the script, then write your script.
- Wait: Delays the running of the next node. You can specify the number of seconds to wait. This can be used in conjunction with a conditional statement to check if an external process has completed.
Tip: You have the option to use the results as variables.
Pyramid Nodes
- Pyramid Event: Schedules an existing publication or data model. With the node selected, find the required publication or model in the content tree; once it's selected, you can choose to run its existing schedule or configure a new schedule.
- Pyramid On Demand: Enables on-demand scheduling for publications, alerts, and subscriptions based on a specified data model.