I had few complex ETL jobs which are working fine. However, instead of directly hitting the DB, I wish to utilize REST APIs to do that. I figured that I need to deploy the tWriteJASONField node somewhere but I am not being able to figure out how.
I envision something like:
Existing -> Job --- tMAP --- DB write
being changed to :
New -> Job --- tMAP --- tJASONWrite --- tRESTClient
Also the tJASONWrite component needs JASON tree structure to be specified. Do I have to create that manually, every time, for every job? I'm assuming there is a way to do that automatically, based on the input row schema.
So far, I've got the GET working fine and I could fetch the JASON object but I primarily need the PUSH and POST working.
Any thoughts on this would be appreciated.