18.3. Calling PostgreSQL Functions

• URL:cf

• POST data:{"n":"function name","p":[[parameter type#,parameter value]]}

  Table 18-1. parameter type#

  parameter type	parameter type#
  company code	491
  user account	38
  language code	87
  characters	79
  number	457
  boolean	467

• returns:(values returned by called PostgreSQL function)

example:

• request:

  curl -v -H "Content-Type:Application/json" -H 'Authorization:abHEi47obYMiCi193xjEiWIFpOouNmkd' -H 'X-Auth-Database:dev5' -d '{"n":"CloseBook","p":[[491,"1"],[457,2019],[457,12],[79,"en"]]}' https://34.terarows.com/fastcgi/api/cf

  This request can be imagined as sending in this SQL command to be performed on database dev5: SELECT CloseBook('1',2019,12,'en')

• response:

  "@362 \"8\", @364 \"9\""