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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.nedyx.com/version-1.52-preview/clearlines-functions/database-functions/callurl.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.