Responsys API, Get SQL View

Nafsika

Hello community!

I have searched to documentation if there is an API in order to get an SQL view from Responsys, but I didn't find something relative.

Have I missed something or there is no way to retrieve this info?

Thanks a lot.

Nafsika

Codrin Teiu

Hi @Nafsika ,

The API documentation for Responsys is here

https://docs.oracle.com/en/cloud/saas/marketing/responsys-rest-api/

If what you mean by getting the SQL view is gaining access to Responsys's "inner" data model SQL tables which hold the application and its data then the answer is that access is not provided for that at the SQL view level.

You can see more about the data model below, which would help you around ways to tap into the data.

https://docs.oracle.com/en/cloud/saas/marketing/responsys-develop/API/GetStarted/Overview/overview-data-model.htm

I hope this helps,

Codrin Teiu

Lead Consultant

Logarithmic Solutions

https://hub.logarithmicsolutions.com/