Post and Commit neo4j Transaction

This node is a proof-of-concept which allows you to post one transaction to a local instance of a neo4j database. It's currently designed to post and commit a single transaction; it's not tested for multiple transactions. However, please note that multiple statements can be included in a single transaction.

A transaction is structured as a single JSON blob with one or more Cypher statement(s) which are then submitted to the neo4j transaction endpoint as a POST request.

Here is an example of a single statement:

{
"statements" : [ {
"statement" : "create (Row0: Person {firstName:'john', lastName:'doe'})"
}]
}

The statement above would create a new Person node with firstName and lastName attributes.

Notice that there is a "statements" property in the JSON body which contains an array of "statement" propert(ies). It's easy to concatenate multiple statements into a single transaction like so:

{
"statements": [{
"statement": "create (Row0: Person {firstName:'santa', lastName:'claus'})"
}, {
"statement": "create (Row1: Person {firstName:'yankee', lastName:'doodle'})"
}, {
"statement": "create (Row2: Person {firstName:'chuck', lastName:'norris'})"
}]
}

This node assumes your neo4j database is running on http://localhost:{{some_port_number}} and also assumes that you're using basic credentials (username and password) to authenticate with your neo4j database. If you have authentication disabled you may need to alter the node accordingly.

Details on how to create a neo4j database, create a user, assign it a role, and documentation on the Cypher syntax can all be found here: https://neo4j.com/docs/

Input ports

1. Type: Table
   JSON Request
   A JSON request structured similarly to the one in the description above.

Output ports

1. Type: Table
   POST Results
   Results of both the creation of the transaction and the act of committing the transaction.