How to execute an API call …

Hi,
I want to know how to execute an API call from SQL..?

More specifically can some one tell me how to execute an API call from a table trigger..
whenever there is an insert/update/delete on a particular table, i’d like to execute the API call from the trigger.

Many Thanks
John Bosco