Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

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
61
Views
5
Comments
DeepaliG-Oracle
DeepaliG-Oracle Rank 3 - Community Apprentice
in Oracle Analytics Forum

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 - Oracle
    Federico Venturin - Oracle Mod
    edited Dec 6, 2023 9:50AM

    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 - Oracle
    Federico Venturin - Oracle Mod

    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 Mod

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

  • Subha_Tripathy-Oracle
    Subha_Tripathy-Oracle Mod
    edited Dec 15, 2023 5:08AM

    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).