I have a problem with converting a table to JSON by “Table to JSON” node. I try to put in it a long text and its transformations some metadata fields related to this text. But in the output cells I’ve got JSONs without metadata fields. Sometimes output cell doesn’t include some fields with text transformations. Input table doesn’t have missing values.
So, my question is there is length limit for JSON objects or not? Is it another problem for this case?
Hello, thor.
Thanks for your answer. But I guess that it’s not a problem with view. There is no object “MetaData” in the output on the screenshot in my first message. But there are such fields in input table: “MetaData.containerId” and “MetaData.actor.id”.
I’m attaching screenshots of the input and output for “Table to JSON” node, where I have excluded all fields with text and after that object “MetaData” has appeared in output JSON.
I’m 99% sure this is only a display problem. Your very first screenshot doesn’t show the full JSON. Try writing the results to a file and have a look there.
As i could see, you bring a loto of files to make this process… My suggestion is to use the “chunk loop” node to break the process and release the memory and files. you can set a number of rows or block of partition with it.
Other question is about the files, they have many pages? Are all of they PDF files. this is it?
If you can try this idea, I believe that can help you.
Thanks for your message. Yes, I use “Chunk loop” and take only 10 files for one iteration. There was a problem with visualization of the node output. thor was right.