Kento | Programming language with a C # interpreter | Interpreter library

Your code was long and I found it easier to re-write it with a few extra tools such as getDataRange, push and splice and forEach.

It seemed you were calling the methods in the right way, but since you were having to repeat yourself in a few places and keep track of many arrays and indices, it is likely that a small mistake came up.

This is a working script adapted from yours:

Your line_json = json.dumps(line) returns "class string". Use line_json = dict(line) instead as this returns a "class dict". You can then satisfy the required parameters for insert_rows_json method

insert_rows_json accepts the following parameters:

insert_rows_json(table, json_rows, row_ids=None, skip_invalid_rows=None, ignore_unknown_values=None, template_suffix=None, retry=, timeout=None)[source]

json_rows requires a dictionary

json_rows (Sequence[Dict]) – Row data to be inserted. Keys must match the table schema fields and values must be JSON-compatible representations.

You have multiple issues with your data file. Among them are:

1. Your Cypher code expects personality_result to be a list of JSON objects. It is not.

   (a) It is a single string, not a list.

   (b) That string seems to consist of the truncated start of a stringified JSON object (that includes a lot of extra pretty-printing whitespace).

   So, everything in your Cypher query starting at the FOREACH will not work.

2. In your next-to-last MERGE, personality_result.personality should probably be just personality.

You may have other issues, but it is hard to tell until you fix your data file and code.