I am creating a generic transformation with Pentaho which would call any API and load data into RDBMS table. The transformation consists of Generate Rows, Rest Client, Json Input and Table Output.
So far so good. Now what I really want is to dynamically pass the name of the fields and Json path at runtime instead of entering them manually in Json Input Step. Because, if a different API is called at some other point of time, which would have a different structure, I dont have to manually edit the fields names and Json paths. I can directly pass them during the runtime.
I tried with lot of options along with ETL Metadata Injenction but wasnt able to succeed. Can someone from the team guide me through the right path so that I can built a generic transformation which would be able to parse json irrespective of the json structure ?