Neo4j Set Business HoursInstall

Overview

This node sets or updates the regular weekly business hours for a specified business in a Neo4j graph database. It completely replaces any existing business hours for the given business with the new schedule provided. The input is a JSON array describing daily time intervals, allowing multiple segments per day to represent breaks or split shifts.

Common scenarios include:

• Automating the update of store or office opening hours in a centralized database.
• Managing complex schedules with multiple open-close periods per day (e.g., morning and afternoon sessions).
• Synchronizing business hours from external systems into Neo4j for use in applications like booking, availability checks, or analytics.

Example usage:

• Setting Monday hours as 9:00–12:00 and 13:00–17:00, Tuesday as 9:00–17:00, etc.
• Clearing old hours and applying a new weekly schedule after a policy change.

Properties

Output

The node outputs an array of JSON objects, one per input item, each containing:

• success: Boolean indicating if the operation succeeded.
• businessId: The business ID for which hours were set.
• deletedCount: Number of previous business hours records deleted.
• hoursSetCount: Number of new business hours records created.

If errors occur and "Continue On Fail" is enabled, the output includes an error object detailing the issue along with the expected input format.

No binary data is produced by this node.

Dependencies

• Requires a Neo4j database connection configured via credentials including host, port, username, password, and optionally database name.
• Uses the official Neo4j driver to connect and run Cypher queries.
• The node expects the Neo4j graph to have Business nodes identified by business_id property.
• Business hours are stored as BusinessHours nodes connected to Business nodes via HAS_HOURS relationships.

Troubleshooting

• Invalid JSON Format: If the Hours Data input is not a valid JSON array, the node will throw an error. Ensure the input is properly formatted JSON.
• Invalid Day of Week: The day_of_week must be an integer 1-7 or a valid English weekday name (case-insensitive). Invalid values cause errors.
• Invalid Time Format: start_time and end_time must be in "HH:MM" 24-hour format. Incorrect formats will trigger validation errors.
• Missing or Incomplete Credentials: The node requires fully configured Neo4j credentials; missing fields will prevent connection.
• Neo4j Connection Issues: Errors connecting to Neo4j (wrong host/port, authentication failure) will be reported.
• Empty Hours Data: If no hours are provided, the node deletes existing hours but does not create new ones.
• Multiple Input Items Warning: When processing multiple items, the node logs a warning since it sets hours individually per business ID.

To resolve errors:

• Validate JSON input externally before passing it to the node.
• Double-check day names and numeric ranges.
• Confirm time strings follow "HH:MM" format.
• Verify Neo4j credentials and connectivity.
• Use the error messages and descriptions returned by the node for guidance.

Links and References

• Neo4j Official Documentation
• Cypher Query Language Reference
• n8n Documentation on Creating Custom Nodes