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: 
ankushdeshpande
Contributor
Contributor

JSON Dynamic Schema processing

HI All,

Do we have any capability to process JSON schema dynamically? The input JSON file will be evolved with new elements over a period of time and Talend job needs to accommodate the schema changes with least code changes. any hints are appreciated. file needs to moved from one S3 bucket to another S3 bucket. 

Labels (2)
3 Replies
Anonymous
Not applicable

Do you need some transformation? Why don't you use tS3Copy to copy the file from one bucket to another bucket?
ankushdeshpande
Contributor
Contributor
Author

Hi Shong,

We need basic transformation. but our main requirement is to dynamically extracts JSON key/value pair with minimum changes in the job. so for e.g as of today we have to extract 50 elements from JSON...later it will change to 70..100...150..and so on...so that will need change in the Job to map additional/new JSON elements. 

 

Anonymous
Not applicable

It's impossible, because we have to define the mapping between columns and the query elements when using tFileInputJson to extract data from an input json file.