Forum Discussion

colmcag's avatar
colmcag
New Member
3 years ago
Solved

API request 405 Method not Allowed Error

Hi,   I am getting a 405 error when trying to connect to Open FIGI:     The request is similar to the below postman query:     This is what I've tried in PowerQuery (I've also tri...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi colmcag 

     

    I don't have this problem in my Excel. It works well too. Did you select Anonymous for the data source like below? If not, go to Home > Data source settings and clear all permissions. Then select Anonymous for it. 

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

     

ams1's avatar
ams1
Responsive Resident
3 years ago

Hi colmcag 

 

From your screenshots I see that in Postman you are doing a POST request, but using "From Web" in PowerQuery you're doing a GET request.

 

Either lookup how to do a POST request in PowerQuery OR post the Postman-generated cURL request here (after you remove confidential information from it!) and we'll try to help you out.

 

Please mark this as answer if it helped.