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:
0