Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

"Method Not Allowed" Error in invoking OAC API "Reload data for a dataset"

Received Response
51
Views
5
Comments
DeepaliG-Oracle
DeepaliG-Oracle Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

We have OAC as PaaS instance. When trying to invoke following REST API, getting “Method Not Allowed”.

https://docs.oracle.com/en/cloud/paas/analytics-cloud/acapi/op-20210901-catalog-datasets-datasetid-actions-reload-post.html

Can anyone help please?

Answers

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach
    edited December 2023

    Hi @DeepaliG-Oracle ,

    Can you share the command that you are using to invoke the API?

    Which type of dataset are you trying to reload?

  • DeepaliG-Oracle
    DeepaliG-Oracle Rank 3 - Community Apprentice

    @Federico Venturin

    As the API doc also says, I am invoking following, with nothing in the body.

    /api/20210901/catalog/datasets/{datasetId}/actions/reload

  • Federico Venturin
    Federico Venturin Rank 7 - Analytics Coach

    Hi @DeepaliG-Oracle ,

    I meant the full curl command (or equivalent) that you are using to invoke the API (of course, you can mask sensitive information). This error usually happens when you do not specify the protocol or the method is not supported.

    Are you using it to reload a dataset created from a subject area/database connection? Please note that it will not work when your dataset has been created from a file

  • GabriellePrichard-Oracle
    GabriellePrichard-Oracle Rank 3 - Community Apprentice

    @DeepaliG-Oracle Following up on this. Please provide the curl command you are using, including the request method.

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Rank 6 - Analytics Lead
    edited December 2023

    Hi @DeepaliG-Oracle

    Please make sure - The object ID of the dataset with Base64 encoding.

    base64 <<< 'User1'.'Dataset1

    Also make sure Dataset us Automatic Caching enabled. Follow How To Set Data Access to Live or Automatic Caching in DV (Doc ID 2949208.1)

    This will not work for file-based dataset (Excel, CSV, TXT).