Skip to Content
1
Sep 11, 2019 at 09:39 AM

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

292 Views

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,

Attachments

hci.png (17.9 kB)