@baymax277 , The problem with your file is not the square brackets ([ ]). The issue is that single quotes are not a valid JSON quote. The correct JSON would be: [
{"a":1,"b":2},
{"a":3,"b":4}
] The content above is processed correctly by NiFi if you use record-based processors (like, for example QueryRecord). Ideally your source data should be fixed to provide a valid JSON. For example, if those files are being generated by a Python script like this: my_object = [{'a': 1, 'b': 2}, {'a': 3, 'b': 4}]
print(my_object) The Python script should be updated to do this instead: import json
my_object = [{'a': 1, 'b': 2}, {'a': 3, 'b': 4}]
print(json.dumps(my_object)) If you cannot have the source data fixed, you can try to replace the single quotes with double quotes using a ReplaceText processor with the following configuration. This is a simplistic approach, though, and can cause problems in some complex JSON objects if you have strings with unexpected sequences of characters in them. Cheers, André
... View more
