You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using The API to Retrieve SQL View Results

I am looking to use the API to query the results of an SQL view. When I call the following endpoint, I get an error as a response. Should I be using a different endpoint, or can I give my API user more permissions to accomplish this? I do fill in {folderName}, {tableName}, and I add the fs, id, and qa parameters to the URL properly.

ENDPOINT: https://gia1quk-api.responsys.ocs.oraclecloud.com/rest/api/v1.3/folders/{folderName}/suppData/{tableName}/members

RESPONSE: {"type":"","title":"Insufficient access","errorCode":"INSUFFICIENT_ACCESS","detail":"User API@ghg does not have access to supplemental table ALL_USERS_UNSUBSCRIBE_STATUS","errorDetails":[]}

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!