Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Iterate Through A Multi-Row JSON File

Hi
I'm new to Talend so am probably missing something simple
I'm simply trying to use tFileInputJSON to load a number of JSON objects (all the same structure and each on a single line) into SQLServer.
It all works fine unless the file contains more than a single row, at which point I get a NullPointerException:
Exception in component tFileInputJSON_1
java.lang.NullPointerException
at mfx_amq_v1.test_0_1.TEST.tFileInputJSON_1Process(TEST.java:1191)
at mfx_amq_v1.test_0_1.TEST.tFileInputFullRow_1Process(TEST.java:699)
at mfx_amq_v1.test_0_1.TEST.runJobInTOS(TEST.java:1744)
at mfx_amq_v1.test_0_1.TEST.main(TEST.java:1618)
After hours researching this on the forums and web I can't work out if this behaviour is by design. If not, how can I get it to work?
If it is by design, what's the best way of drip-feeding one object at a time. When I've tried using tIterateToFlow for this it won't compile complaining that "OnSubjobOK cannot be reolved to a variable"
I'd REALLY appreciate any help!!!!
Labels (4)
1 Reply
Anonymous
Not applicable
Author

Having this same problem. Any suggestions?