Publish Examples
Example 1
Request:
{
"dbUrl": "bolt://gg-my-sample.graphgrid.com:7687",
"credentials": "Basic xxxxxxxxxxxxxxx=",
"originIds": [
"A Few Good Men",
"Top Gun",
"A League of Their Own",
"Cast Away"
],
"index": "Movie",
"metadata": true,
"mappedIndices": {
"Movie": "title",
"DEFAULT_INDEX": "Movie",
"DEFAULT_ID_FIELD": "title",
"Person": "name"
},
"orgName": "MovieDeck",
"fileName": "2019-03-21-1730-movie-metadata.json",
"returnOnly": false
}
Response:
{
"transactionRequest": {
"statements": [
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, tagline:{tagline}, title:{title}, released:{released}};",
"parameters": {
"tagline": "I feel the need, the need for speed.",
"id": "Top Gun",
"title": "Top Gun",
"released": 1986
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {tagline:{tagline}, title:{title},
released:{released}};",
"parameters": {
"tagline": "At the edge of the world, his journey begins.",
"id": "Cast Away",
"title": "Cast Away",
"released": 2000
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {tagline:{tagline}, title:{title},
released:{released}};",
"parameters": {
"tagline": "Once in a lifetime you get a chance to do something different.",
"id": "A League of Their Own",
"title": "A League of Their Own",
"released": 1992
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {tagline:{tagline}, title:{title},
released:{released}};",
"parameters": {
"tagline": "In the heart of the nation's capital, in a courthouse of the U.S. government, one
man will stop at nothing to keep his honor, and one will stop at nothing to find the truth.",
"id": "A Few Good Men",
"title": "A Few Good Men",
"released": 1992
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {grn:{grn}, lastSearchIndexedAt:{
lastSearchIndexedAt}, tagline:{tagline}, title:{title}, released:{released}};",
"parameters": {
"grn": "grn:gg:movie:cf65536f-c34a-4021-980c-e603dbfcd385",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"tagline": "In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth.",
"id": "A Few Good Men",
"title": "A Few Good Men",
"released": 1992
},
"metadata": {
"updatedIds": [
"Cast Away",
"A Few Good Men",
"Top Gun",
"A League of Their Own"
]
}
}
]
},
"transactionRequests": null,
"fileLocation": "https://cdn.graphgrid.com/cdp/publish/MovieDeck/2019-03-21-1730-Movie-metadata.json",
"fileLocations": null,
"fileNames": null,
"error": null,
"usePrefixes": null
}
Example 2
Publish movie nodes, DIRECTED relationships, and the nodes on the other end of the DIRECTED relationships
Request:
{
"dbUrl": "bolt://gg-my-sample.graphgrid.com:7687",
"credentials": "Basic xxxxxxxxxxxxxxx=",
"originIds": [
"A Few Good Men",
"Top Gun",
"A League of Their Own",
"Cast Away"
],
"index": "Movie",
"metadata": true,
"mappedIndices": {
"Movie": "title",
"DEFAULT_INDEX": "Movie",
"DEFAULT_ID_FIELD": "title",
"Person": "name"
},
"relationships": [
"DIRECTED"
],
"orgName": "MovieDeck",
"fileName": "2019-03-21-1730-DIRECTED-with-metadata.json",
"returnOnly": false
}
Response:
{
"transactionRequest": {
"statements": [
{
"statement": "MATCH (n:Movie) USING INDEX n:Movie(title) WHERE n.title = {baseId} WITH n MATCH (n)-[r:DIRECTED]-(o) WHERE (NOT EXISTS (o.name) OR NOT o.name IN {ids_0}) DELETE r;",
"parameters": {
"baseId": "A League of Their Own",
"ids_0": [
"Penny Marshall"
]
},
"metadata": null
},
{
"statement": "MATCH (n:Movie) USING INDEX n:Movie(title) WHERE n.title = {baseId} WITH n MATCH (n)-[r:DIRECTED]-(o) WHERE (NOT EXISTS (o.name) OR NOT o.name IN {ids_0}) DELETE r;",
"parameters": {
"baseId": "Cast Away",
"ids_0": [
"Robert Zemeckis"
]
},
"metadata": null
},
{
"statement": "MATCH (n:Movie) USING INDEX n:Movie(title) WHERE n.title = {baseId} WITH n MATCH (n)-[r:DIRECTED]-(o) WHERE (NOT EXISTS (o.name) OR NOT o.name IN {ids_0}) DELETE r;",
"parameters": {
"baseId": "A Few Good Men",
"ids_0": [
"Rob Reiner"
]
},
"metadata": null
},
{
"statement": "MATCH (n:Movie) USING INDEX n:Movie(title) WHERE n.title = {baseId} WITH n MATCH (n)-[r:DIRECTED]-(o) WHERE (NOT EXISTS (o.name) OR NOT o.name IN {ids_0}) DELETE r;",
"parameters": {
"baseId": "Top Gun",
"ids_0": [
"Tony Scott"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b);",
"parameters": {
"a_id": "Rob Reiner",
"b_id": "A Few Good Men"
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b);",
"parameters": {
"a_id": "Tony Scott",
"b_id": "Top Gun"
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b);",
"parameters": {
"a_id": "Penny Marshall",
"b_id": "A League of Their Own"
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b);",
"parameters": {
"a_id": "Robert Zemeckis",
"b_id": "Cast Away"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:b873aa84-67d2-494e-84b3-a5aef7b17019",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1947,
"name": "Rob Reiner",
"index": "Person",
"id": "Rob Reiner",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:91b3088e-5f79-45eb-8147-234cb0d74de5",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1951,
"name": "Robert Zemeckis",
"index": "Person",
"id": "Robert Zemeckis",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, tagline:{tagline}, title:{title}, released:{released}};",
"parameters": {
"grn": "grn:gg:movie:76370d4f-e7cf-47e7-9751-e4ed8b2ca190",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"tagline": "I feel the need, the need for speed.",
"id": "Top Gun",
"title": "Top Gun",
"released": 1986
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, tagline:{tagline}, title:{title}, released:{released}};",
"parameters": {
"grn": "grn:gg:movie:e4799fbf-012c-4850-bae9-50723a033c87",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"tagline": "At the edge of the world, his journey begins.",
"id": "Cast Away",
"title": "Cast Away",
"released": 2000
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, tagline:{tagline}, title:{title}, released:{released}};",
"parameters": {
"grn": "grn:gg:movie:38a573e9-3946-48aa-bb6b-268adea10c6e",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"tagline": "Once in a lifetime you get a chance to do something different.",
"id": "A League of Their Own",
"title": "A League of Their Own",
"released": 1992
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:ef7d3f30-7034-49cd-b157-832f4776ac2f",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1943,
"name": "Penny Marshall",
"index": "Person",
"id": "Penny Marshall",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:7c2a2cd1-fa1a-4a3d-9487-372af20918d4",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1944,
"name": "Tony Scott",
"index": "Person",
"id": "Tony Scott",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Movie {title:{id}}) SET n:Movie, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, tagline:{tagline}, title:{title}, released:{released}};",
"parameters": {
"grn": "grn:gg:movie:cf65536f-c34a-4021-980c-e603dbfcd385",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"tagline": "In the heart of the nation's capital, in a courthouse of the U.S. government, one man will stop at nothing to keep his honor, and one will stop at nothing to find the truth.",
"id": "A Few Good Men",
"title": "A Few Good Men",
"released": 1992
},
"metadata": {
"updatedIds": [
"Cast Away",
"Tony Scott",
"Robert Zemeckis",
"A Few Good Men",
"Penny Marshall",
"Top Gun",
"Rob Reiner",
"A League of Their Own"
]
}
}
]
},
"transactionRequests": null,
"fileLocation": "https://cdn.graphgrid.com/cdp/publish/MovieDeck/2019-03-21-1730-DIRECTED-with-metadata.json",
"fileLocations": null,
"fileNames": null,
"error": null,
"usePrefixes": null
s}
Example 3
Publish DIRECTED and ACTED_IN relationships only with no node metadata and no relationship delete statements
Request:
{
"dbUrl": "bolt://gg-my-sample.graphgrid.com:7687",
"credentials": "Basic xxxxxxxxxxxxxxx=",
"originIds": [
"A Few Good Men",
"Top Gun",
"A League of Their Own",
"Cast Away"
],
"index": "Movie",
"metadata": false,
"mappedIndices": {
"Movie": "title",
"DEFAULT_INDEX": "Movie",
"DEFAULT_ID_FIELD": "title",
"Person": "name"
},
"relationships": [
"DIRECTED",
"ACTED_IN"
],
"preventCleanup": true,
"orgName": "MovieDeck",
"fileName": "2019-03-21-2224-DIRECTED-ACTED_IN-without-metadata.json"
}
Response:
{
"transactionRequest": {
"statements": [
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Rosie O'Donnell",
"b_id": "A League of Their Own",
"roles": [
"Doris Murphy"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Cuba Gooding Jr.",
"b_id": "A Few Good Men",
"roles": [
"Cpl. Carl Hammaker"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Rob Reiner",
"b_id": "A Few Good Men",
"roles": null
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Madonna",
"b_id": "A League of Their Own",
"roles": [
"\"All the Way\" Mae Mordabito"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Lori Petty",
"b_id": "A League of Their Own",
"roles": [
"Kit Keller"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "James Marshall",
"b_id": "A Few Good Men",
"roles": [
"Pfc. Louden Downey"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Tom Cruise",
"b_id": "Top Gun",
"roles": [
"Maverick"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Tom Hanks",
"b_id": "A League of Their Own",
"roles": [
"Jimmy Dugan"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Penny Marshall",
"b_id": "A League of Their Own",
"roles": null
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Kelly McGillis",
"b_id": "Top Gun",
"roles": [
"Charlie"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Bill Paxton",
"b_id": "A League of Their Own",
"roles": [
"Bob Hinson"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Meg Ryan",
"b_id": "Top Gun",
"roles": [
"Carole"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Helen Hunt",
"b_id": "Cast Away",
"roles": [
"Kelly Frears"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Kiefer Sutherland",
"b_id": "A Few Good Men",
"roles": [
"Lt. Jonathan Kendrick"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Tom Cruise",
"b_id": "A Few Good Men",
"roles": [
"Lt. Daniel Kaffee"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Tony Scott",
"b_id": "Top Gun",
"roles": null
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Aaron Sorkin",
"b_id": "A Few Good Men",
"roles": [
"Man in Bar"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Anthony Edwards",
"b_id": "Top Gun",
"roles": [
"Goose"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Kevin Bacon",
"b_id": "A Few Good Men",
"roles": [
"Capt. Jack Ross"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Val Kilmer",
"b_id": "Top Gun",
"roles": [
"Iceman"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:DIRECTED]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Robert Zemeckis",
"b_id": "Cast Away",
"roles": null
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "J.T. Walsh",
"b_id": "A Few Good Men",
"roles": [
"Lt. Col. Matthew Andrew Markinson"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Tom Hanks",
"b_id": "Cast Away",
"roles": [
"Chuck Noland"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Noah Wyle",
"b_id": "A Few Good Men",
"roles": [
"Cpl. Jeffrey Barnes"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Demi Moore",
"b_id": "A Few Good Men",
"roles": [
"Lt. Cdr. JoAnne Galloway"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Geena Davis",
"b_id": "A League of Their Own",
"roles": [
"Dottie Hinson"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Tom Skerritt",
"b_id": "Top Gun",
"roles": [
"Viper"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Christopher Guest",
"b_id": "A Few Good Men",
"roles": [
"Dr. Stone"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Kevin Pollak",
"b_id": "A Few Good Men",
"roles": [
"Lt. Sam Weinberg"
]
},
"metadata": null
},
{
"statement": "MERGE (a:Person {name: {a_id}}) WITH a MERGE (b:Movie {title: {b_id}}) WITH a, b MERGE (a)-[r:ACTED_IN]->(b) SET r = {roles: {roles}};",
"parameters": {
"a_id": "Jack Nicholson",
"b_id": "A Few Good Men",
"roles": [
"Col. Nathan R. Jessup"
]
},
"metadata": {
"updatedIds": [
"Christopher Guest",
"Kiefer Sutherland",
"Cuba Gooding Jr.",
"Rosie O'Donnell",
"Bill Paxton",
"Jack Nicholson",
"A League of Their Own",
"Noah Wyle",
"Tom Skerritt",
"Cast Away",
"Aaron Sorkin",
"Meg Ryan",
"Top Gun",
"James Marshall",
"Rob Reiner",
"Tom Cruise",
"Lori Petty",
"Kelly McGillis",
"Anthony Edwards",
"Demi Moore",
"Kevin Pollak",
"A Few Good Men",
"Robert Zemeckis",
"Penny Marshall",
"Helen Hunt",
"J.T. Walsh",
"Tom Hanks",
"Tony Scott",
"Geena Davis",
"Madonna",
"Kevin Bacon",
"Val Kilmer"
]
}
}
]
},
"transactionRequests": null,
"fileLocation": "https://cdn.graphgrid.com/cdp/publish/MovieDeck/2019-03-21-2224-DIRECTED-ACTED_IN-without-metadata.json",
"fileLocations": null,
"fileNames": null,
"error": null,
"usePrefixes": null
}
Example 4
Publish movie node metadata for all Person nodes who have ACTED_IN movies with Tom Cruise
Request:
{
"dbUrl": "bolt://gg-my-sample.graphgrid.com:7687",
"credentials": "Basic xxxxxxxxxxxxxxx=",
"originIds": [
"Tom Cruise"
],
"index": "Person",
"metadata": true,
"mappedIndices": {
"Movie": "title",
"DEFAULT_INDEX": "Movie",
"DEFAULT_ID_FIELD": "title",
"Person": "name"
},
"toLayer": [
"ACTED_IN",
"ACTED_IN"
],
"orgName": "MovieDeck",
"fileName": "2019-03-21-2231-actors-with-Tom-Cruise.json"
}
Response:
{
"transactionRequest": {
"statements": [
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:85a356b3-cbe1-475f-a12d-90282707e16c",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1958,
"name": "Kevin Bacon",
"index": "Person",
"id": "Kevin Bacon",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:72ddd508-f3f5-45d6-8f16-50d25ca5bafd",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1933,
"name": "Tom Skerritt",
"index": "Person",
"id": "Tom Skerritt",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:0c2f9e31-8826-4940-b58d-4d03b6901ac1",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1971,
"name": "Regina King",
"index": "Person",
"id": "Regina King",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:0448480b-db3f-41a1-93e1-4d8ed6d5ada1",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1970,
"name": "Jay Mohr",
"index": "Person",
"id": "Jay Mohr",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:698f8085-2bf1-4308-b219-05e10c422b5c",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1943,
"name": "J.T. Walsh",
"index": "Person",
"id": "J.T. Walsh",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:2df2b615-9977-4965-8815-f06f3d00ae83",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1962,
"name": "Anthony Edwards",
"index": "Person",
"id": "Anthony Edwards",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:5310d769-674f-4368-83a6-0de015a05c46",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1957,
"name": "Kevin Pollak",
"index": "Person",
"id": "Kevin Pollak",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:ea3e3b9f-96c6-46f4-8ce5-fd7c9c135d1b",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1969,
"name": "Renee Zellweger",
"index": "Person",
"id": "Renee Zellweger",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:8671e1d9-209e-4b52-9aa5-d60952702cc5",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1961,
"name": "Aaron Sorkin",
"index": "Person",
"id": "Aaron Sorkin",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:1dc76aa7-12db-45df-8e82-f020de116cb8",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1966,
"name": "Kiefer Sutherland",
"index": "Person",
"id": "Kiefer Sutherland",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:a1f2bd51-d126-4594-923e-5df5dbb45dfa",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1996,
"name": "Jonathan Lipnicki",
"index": "Person",
"id": "Jonathan Lipnicki",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:7db4f86a-3484-433b-8f96-8701333a8f47",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1968,
"name": "Cuba Gooding Jr.",
"index": "Person",
"id": "Cuba Gooding Jr.",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:38d0452c-afab-403d-b107-d024ab84b437",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1962,
"name": "Demi Moore",
"index": "Person",
"id": "Demi Moore",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:f740b3c9-6f27-4666-9aed-ef573f5413c1",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1957,
"name": "Kelly McGillis",
"index": "Person",
"id": "Kelly McGillis",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:c00b248f-2d83-48aa-bcac-14649b8f12d7",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1948,
"name": "Christopher Guest",
"index": "Person",
"id": "Christopher Guest",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:970a74ab-4b22-483a-b4e9-6f31f52cae7c",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1959,
"name": "Val Kilmer",
"index": "Person",
"id": "Val Kilmer",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:bb05b64e-d9a0-4811-b8e0-b1787f776624",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1962,
"name": "Kelly Preston",
"index": "Person",
"id": "Kelly Preston",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:011a8e2c-e872-4c94-adca-d9690a290efa",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1961,
"name": "Bonnie Hunt",
"index": "Person",
"id": "Bonnie Hunt",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:d83f88ec-e183-444f-b807-046dd6757e34",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1974,
"name": "Jerry O'Connell",
"index": "Person",
"id": "Jerry O'Connell",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:e50a63ad-b755-4bca-99d2-4a66223fe5d7",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1961,
"name": "Meg Ryan",
"index": "Person",
"id": "Meg Ryan",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:52d0d329-b8ab-4788-b22d-d9de20c0a026",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1967,
"name": "James Marshall",
"index": "Person",
"id": "James Marshall",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:c338f0d4-e619-4179-b1c8-34c88300ffa0",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1971,
"name": "Noah Wyle",
"index": "Person",
"id": "Noah Wyle",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": null
},
{
"statement": "MERGE (n:Person {name:{id}}) SET n:Person, n = {grn:{grn}, lastSearchIndexedAt:
{lastSearchIndexedAt}, born:{born}, name:{name}, index:{index}, updatedAt:{updatedAt}};",
"parameters": {
"grn": "grn:gg:person:df55e112-b01f-4e77-9f8f-9370711b1e52",
"lastSearchIndexedAt": "2018-07-18T12:37:59+0000",
"born": 1937,
"name": "Jack Nicholson",
"index": "Person",
"id": "Jack Nicholson",
"updatedAt": "2018-08-24T12:47:22+0000"
},
"metadata": {
"updatedIds": [
"Kelly McGillis",
"Anthony Edwards",
"Demi Moore",
"Christopher Guest",
"Kevin Pollak",
"Jonathan Lipnicki",
"Kiefer Sutherland",
"Cuba Gooding Jr.",
"Jack Nicholson",
"Kelly Preston",
"Bonnie Hunt",
"Noah Wyle",
"J.T. Walsh",
"Tom Skerritt",
"Renee Zellweger",
"Regina King",
"Aaron Sorkin",
"Meg Ryan",
"James Marshall",
"Kevin Bacon",
"Val Kilmer",
"Jerry O'Connell",
"Jay Mohr"
]
}
}
]
},
"transactionRequests": null,
"fileLocation": "https://cdn.graphgrid.com/cdp/publish/MovieDeck/2019-03-21-2231-actors-with-Tom-Cruise.json",
"fileLocations": null,
"fileNames": null,
"error": null,
"usePrefixes": null
}