//Query: Neo4j Cypher HTTP API Template
let
    __URL = "http://localhost:7474/db/YourDatabaseName/tx/commit", //Replace "YourDatabaseName" with the name of your Neo4j Database
    __AuthKey = "Basic bmVvNGo6bmVvNGo=", //Replace this with the Basic Auth string you get from the [Basic Auth without parms] query
    QueryPrep = "{""statements"": [ {""statement"": """,
    __CypherQuery = "MATCH (n) RETURN n LIMIT 10", //This is where you paste in your cypher query
    QuerySuffix = """ } ] }",
    StatementCheck = QueryPrep & __CypherQuery & QuerySuffix, //This shows the HTTP API body full statement text
    Neo4jData = Json.Document(Web.Contents(__URL,[Headers = [#"Content-Type"="application/json", #"Authorization"=__AuthKey], Content = Text.ToBinary(QueryPrep & __CypherQuery & QuerySuffix)])), //This executes the query and gets the json results
    results = Neo4jData[results],
    results1 = results{0},
    data = results1[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"row"}, {"Column1.row"}),
    #"Ready to Expand Graph Columns" = Table.ExpandListColumn(#"Expanded Column1", "Column1.row")
in
    #"Ready to Expand Graph Columns"

//Query: Basic Auth without parameters

//This is a Python Script that uses the Neo4j database URL to get generate the Basic Authentication token
//Change the portion of the URL from 'YourDatabaseName' to the name of your Neo4j database
//Change the username and password from 'neo4j' to whatever your username and password is
//The following is the actual Python Script

// # Get AuthKey from local neo4j server
// import requests
// import pandas
//
// url = 'http://localhost:7474/db/datel/tx/'
// username = 'neo4j' 
// password = 'neo4j'
//
// r = requests.post(url, auth=(username, password) )
// a = r.request.headers.get('Authorization')
// Basic_Auth = pandas.DataFrame(a.splitlines(), columns="Basic Auth".splitlines() )
// Basic_Auth

let
    Source = Python.Execute("# Get AuthKey from local neo4j server#(lf)import requests#(lf)import pandas#(lf)#(lf)url = 'http://localhost:7474/db/YourDatabaseName/tx/'#(lf)username = 'neo4j' #(lf)password = 'neo4j'#(lf)#(lf)r = requests.post(url, auth=(username, password) )#(lf)a = r.request.headers.get('Authorization')#(lf)Basic_Auth = pandas.DataFrame(a.splitlines(), columns=""Basic Auth"".splitlines() )#(lf)Basic_Auth"),
    Basic_Auth1 = Source{[Name="Basic_Auth"]}[Value],
    #"Changed Type" = Table.TransformColumnTypes(Basic_Auth1,{{"Basic Auth", type text}}),
    #"Basic Auth1" = #"Changed Type"[Basic Auth]
in
    #"Basic Auth1"