so I m trying to extract JSON data submitted via API calls & it is working fine,
what I want to do it little bit more flexible & parse data even field names are little different to up-to certain extent,
and I know field names are case sensitive here that means even if client pass data as 'name' or 'NAME' instead of 'Name' field name, data doesn't get mapped.
Basically Is there a way to map multiple field names to one field or specify alternate field names in JSON mapping?
Here is the current field mapping,
Since the component will work on schema based approach, you will not be able to chnage field names on the fly. At the same time, you can try to replace the matching values for field names before sending the data for parsing.
For this case, you will have to do a search and replace for the values using regular expressions (Hints:- refer java regular expressions in java forums) for the entire input JSON string.
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved
Thanks Nikhil, I am referring to this (highlighted below), if we can use this by by means & mention field alternate field names
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema