How to GET values from an external system with API REST, then insert values into a HANA DB

[MohamedAharchi]

Hello Guys,

I'm new in SAP Cloud Platform Process Integration. I explain my issue. I'm trying to GET values from an external system by using an API REST as json format and then insert values into a HANA DB with SCP-PI.

So I used the feature Request-reply, then I have a Content-Modifier in order to make an SQL Statement to the HANA DB by using JDBC connection. Currently the SQL Statement via JDBC connection is working fine. But I don't now how to catch response of Request-Reply and how to implement JSON response inside an SQLSCRIPT.

Help please !

Regards,

[MohamedAharchi]

Hello,

Yep! Thanks again for your support.

Regards,

Mohamed.