Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

POST Requests using the REST API connector?

Received Response
24
Views
1
Comments

Has anyone had success creating API calls using the POST method in OAC's REST API connector? It seems to handle GET requests since they only require a single URL string. However, a POST request that requires some parameters will not connect for me. I tried uploading a JSON file that included the parameters and I've tried a simple JSON file with just the URL, but every way I have tried I get an error (Invalid Connection Details).

Can this connector handle POST requests?

Tagged:

Answers

  • Hi,

    The "Rest API" connection type is still flagged as "preview". I believe it only does GET "by design".

    By default, an API, expects POST when creating an entity, while to read something GET is used. Therefore supporting only GET isn't shocking I would say (my opinion of course). That's why the screen doesn't mention anywhere the method, it does just send a GET.

    Have you checked in https://community.oracle.com/products/oracleanalytics/categories/idealab-oracle-analytics-cloud-server if there is maybe an idea requesting to support POST? If you find it, up-vote it and maybe post a comment supporting it (that will also bring the idea back on top of list, giving it more visibility for others to up-vote).

    If there isn't an idea yet about this, create one.

    While I imagine a majority of users are fine with GET, it could be interesting to let the user choose the HTTP method. That would also open the door to some "out of the box" usages of that connector, using it as trigger to initiate other processes by doing a POST request as result of something else, or maybe even do UPDATE and DELETE and that kind of things.