HTTP.REQUEST2
Create an HTTP request. Universal function to use for all HTTP methods. This function is asynchronous, therefore the resul twill be returned when it is available.
Syntax
=HTTP.REQUEST2(URL, Method, [Body], [HeadersJSON], [ConfigJSON], [Target])
Arguments
| Name | Description |
|---|---|
| URL | The URL to request. |
| Method | The HTTP-method of the request. |
| Body (optional) | The body of the request. |
| HeadersJSON (optional) | Headers of the HTTP request. |
| ConfigJSON (optional) | A JSON configuration for the HTTP request. Possible configurations are: "baseURL","timeout","auth: { username: 'secret', password: 'tops3cret' }","proxy: {protocol: 'https',host: '127.0.0.1',port: 9000, auth: {username: 'secret', password: 'tops3cret' } " |
| Target (optional) | INBOX(), OUTBOX("MsgID") or a cell range where the result will be placed. Make sure the cell range is big enough or not everything is displayed. |
Return
The function HTTP.OPTIONS() always returns a unique random request ID. Otherwise an error is displayed.
Examples
Examples for using the config and header parameter. Use a JSON() function around the cell range.