Skip to main content
Version: Streamsheets 2.5

HTTP.GET

Create an HTTP GET request. Retrieve information from the server. Should not modify the data on the server. The HTTP GET method requests a representation of the specified resource. This function is asynchronous, therefore the result will be returned when it is available.

Syntax

=HTTP.GET(URL, [HeadersJSON], [ConfigJSON], [Target])

Arguments

NameDescription
URLThe URL to 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.GET() always returns a unique random request ID. Otherwise an error is displayed.

Examples

Select

Examples for using the config and header parameter. Use a JSON() function around the cell range.

FormulaResultComment
=HTTP.GET("https​://anapioficeandfire.com/api/characters/583",,,INBOX())
Request to the APIA request has been made and put the response into the inbox.