pmenga52 opened a new issue, #5781: URL: https://github.com/apache/hop/issues/5781
### Apache Hop version? 2.16 ### Java version? 21.0.8 ### Operating system Linux ### What happened? In a JSON input transform, the Content/_Default path leaf to null_ is set to On, for json files that contains null array value 1. Inputs Here are 2 json files - (file1 = all values are set) - (file2 = the third leaf has an empty sub value SubLeaf - "SubLeaf": []) [file1.json](https://github.com/user-attachments/files/22714369/file1.json) [file2.json](https://github.com/user-attachments/files/22714371/file2.json) the pipelines file1.hpl and file2.hpl consists of a single JSON input transform with file1.json or file2.json as an input. Here are the two files (renamed in*.txt for the github repository): [file1.hpl.txt](https://github.com/user-attachments/files/22714388/file1.hpl.txt) [file2.hpl.txt](https://github.com/user-attachments/files/22714390/file2.hpl.txt) and at last, each "Fields" settings consists of two identical json paths (written with the help of "Select fields" button): Name Path Leaf $.value.*.Leaf SubLeaf $.value.*.SubLeaf.*.SubLeaf <img width="577" height="192" alt="Image" src="https://github.com/user-attachments/assets/06616f1e-6dc6-40f0-8d1f-180caa55dc83"; /> 2. output with file2.hpl, I still have the following error: _The data structure is not the same inside the resource! We found 2 values for json path [$.value.*.SubLeaf.*.SubLeaf], which is different that the number returned for path [$.value.*.Leaf] (3 values). We MUST have the same number of values for all paths._ which, I suppose should not occur, for I checked the **Default path leaf to null** flag - is the json path for fields incorrect? ($.value.*.SubLeaf.*.SubLeaf dealing with null arrays like "SubLeaf": []) - is the **Default path leaf to null** working or not? I'm struggling with standard json outputs from odata v4 requests (null array leaves as a result to null values) Pierre ### Issue Priority Priority: 3 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
