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

DeepaliG-Oracle

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?

Federico Venturin - Oracle

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

@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

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

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

Subha_Tripathy-Oracle

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