I am trying to read a Json file into knime. After I have chosen the path for my json file, when I want to see the json table, i am promted with "No data available". Also when I execute, I get the error "Execute failed: Expected end of input, but there were content: START_OBJECT".
In that case it would be helpful if you could provide a more detailed example of your data, because your previous example does not conform this standard. If you have sensible data you can replace the values with random strings/numbers, only the structure is important.
...which is not JSON standard.
You can not have multiple root elements.
To convert this to proper JSON and read it into KNIME you have to convert it to this format:
Trying to read in a json array and only getting a single row. I would think that there would be two rows. However it's adding each object in the array to it's own column.
I would like each array element to be it's own row, so I can loop through them.
I am not sure how did you try, for me, the $[*] JSONPath work well for your example (it has been created two rows with the proper JSON objects within, without the array outside). Do you have some other use case, when the array should be present for both? (In that case I would recommend the JSON Transformer node to add the extra array.)