# CALLURL #### Syntax **CALLURL**(url; *method*; *body*; *header*) * *url* - the url to which the request is sent - ***Value type**: text* * *method* - the http request method ("GET", "POST", "DELETE", ...) - ***Value type**: text (optional, default: "GET")* * *body* - the body data of the http request - ***Value type**: text (optional, default: empty)* * *header* - the header of the http request - ***Value type**: text (optional, default: empty)* #### Remarks * The function returns the result of the http request as text. * If the url request returns any mime type other than text/…, application/javascript, application/json, application/xml, the function returns !ERROR. #### Linking the CALLURL function with a database widget It is possible to use an authentication for the CALLURL function that is stored in a REST or Essbase connection. This allows requests to be sent directly to a REST api with corresponding authentication or to the REST api of an Essbase server, for example. The widget for which the connection is defined is stored as a reference in the connection formula. #### Example 1 After clicking on the CallURL button, the url from the top cell widget is sent, and the result is assigned to the bottom cell.

In this example, a post request is sent to a url, including body and header information.

#### Example 2 - ChatGPT Communication The "CALLURL" button uses the "REST api" button as a reference in the connection formula. When a request is sent with the CALLURL function, the authentication of the connection is used, in this case a bearer token (which is required by ChatGPT).