When I am creating api query profile, I am able to see my data in response, but not in data perview, I am getting Exception testing table: HTTP protocol error. 405 Method Not Allowed

Matillion ETL
1

When i try to get data from api query component I am getting error 405 Method not allowed..

Kindly do the needful.

2

@mukunthan394​ I have noticed this similar issue / bug if you are trying to hit a POST API request (anything other than GET). When the RSD is generated it adds a GET tag by default.

The work around is to save the API, navigate to "Advanced Mode" and open up the RSD. You can then remove the additional tag <api:set attr="method" value="GET"/>. There should be another one for POST already available.

3

Hi Ramalingam @ramalingam​

Thanks for the response, I removed the additional post tag, but now I'm getting HTTP protocol error. 500 Internal Server Error.

Is there any work around for this.