Skip to main content
Version: Streamsheets 3.0

HTTP.POST

Send an HTTP POST request. Used to create a resource on the server or to generally send data to the server. Please refer to https://developer.mozilla.org/en-US/docs/Web/HTTP/Methods for more information about the different HTTP methods

Syntax

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

Arguments

NameTypeDescription
URLStringThe URL to request.
Body (optional)StringThe body of the request
HeadersJSON (optional)JSONHeaders of the HTTP request.
ConfigJSON (optional)JSONA JSON with one or more of the following properties:
  • baseURL: string
  • timeout: positive number, timout in milliseconds
  • auth: object with the following properties
    • username: string
    • password: string
  • proxy: object one or more of the following properties
    • protocol: string, "http" or "https"
    • host: string, hostname or IP of the proxy server
    • port: number
    • auth: object with the following properties
      • username: string
      • password: string
Target (optional)TargetINBOX(), 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.POST() always returns a unique random request ID. Otherwise an error is displayed.

Examples

AB
1Headers
2Acceptapplication/json
3Config
4timeout3000

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