Can we request for REST API from Azure PostgreSQL database (Version 11) function or Store procedure directly?

Question

I want to request REST API from Azure PostgreSQL database (Version 11) using function or Store procedure.
Upon some RND , I found that plpython2u or Perl can be used as language in function but Azure PostgreSQL does not support those extension.
Can anyone suggest or has any idea as in how can i manage to request REST API call from Azure PostgreSQL

Answer 1

Hi @sappu solanki ,
Thanks for sharing this information.
I have received confirmation from products team that calling REST API is not supported for both Single and Flexible server as

• Single Server does not allow calling outside of the service so this wont be supported.
• Extensions for these are not supported yet on flexible servers. It will be evaluated in future releases.

You may have to call the API from your application outside of postgreSQL. Please let me know if you have any questions.

Thanks
Saurabh

----------

Please do not forget to "Accept the answer" wherever the information provided helps you to help others in the community.