HANA DB to REST API Synchronous(Two way) Graph

[rajeshps]

Hello Team

Is it possible to orchestrate the data pipeline from Read HANA DB to Open API client operator (two way mode) synchronously? There is no conversion from table to string and where to define the API json fields for map.? Is data transformation required here?

READ HANA Table (table1) -> To String Convertor -> Python3 -> DATA TRANSFORM ->  Python3  -> To message convertor -> Open API Client (response) -> To String Convertor ->  Python3 -> DATA TRANSFORM -> Table Producer (table 2)-> Terminator

Requesting for your valuable inputs on above approach.

Thanks and Regards,

Rajesh PS

[ansharm71]

Hi Rajesh,

As per your requirement, below can be the design of your DI pipeline :

Requirement is read hana column table (table1) and then map & call an external API and get the API response and eventually map & send the API response to Hana table(table2).

Thanks,

Ankit

[rajeshps]

ansharm7 wow looks great thanks alot. ☺️

Could you please help me with the code on CP_POSTMAN. Also defining json fields and map hana fields with API json field mapping happens in python operator?

Thanks much ansharm7