# 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. 

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/gWSu5IbV7AC8Okm2oZBJ/grafik.png" alt=""><figcaption></figcaption></figure>

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

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/w9m6MtgmsgOcGodzR4lw/grafik.png" alt=""><figcaption></figcaption></figure>

#### 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).

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/jIBcyYZx5YWGhhj0miMF/grafik.png" alt=""><figcaption><p>The CALLURL button references the REST api button in its Connection formula</p></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/zpVehVPeAqpcMvkta2hB/grafik.png" alt=""><figcaption><p>The query can then be sent using the CALLURL function</p></figcaption></figure>