I need to call an external API to add a product on another system. For this call I need to attach a security token as an Authoization header to the POST HTTP Request (together with another Header Request information like Content-Type ...).

My code looks like this:

create or replace function AddProductAPI ("JsonLoad" long varchar)

returns long varchar

url 'http://localhost/api/v1/product'

type 'http:post:application/json'

Header 'Content-Type: application/json';-- line5

---

create or replace procedure AddProduct()

begin

call AddProductAPI ('{"Product_Name": "Mouse","ProductID": "123"}');--*line9

end;

In Web Service I can make use of the function HTTP_HEADER in order to fetch the Header information being passed to me as a Web service/server, but how I can set such header information when I am consuming an external services?

I tried to do it on line5 above! (something like):

Header 'Content-Type: application/json, Authorization' + select @MyToken; -- Syntax Error

When I try to do this using SA_SET_HTTP_HEADER(), on the line before line9, then there is no any syntax error, but also no any effect (it does nothing)!

Any ideas please!