SMS77.SEND

This is a premium feature.

Sends an SMS message to specified contact. In its simplest form only text and recipient number are required. But for more advanced settings it is also possible to pass a JSON object containing additional parameters. Please refer to https://www.sms77.io/en/docs/gateway/http-api for more information about available and supported options (as of 2021-05-17).

Syntax

=SMS77.SEND(APIKey, TextOrJSON, [ToContact], [ResponseTarget])

Arguments

Name	Description
APIKey	An API key to authorize against SMS77 service
TextOrJSON	The text to send or a JSON which contains the text and additional required or optional parameters
ToContact (optional)	The recipient number or name to send message to. Not required if specified within passed JSON
ResponseTarget (optional)	Specify inbox, outbox, cell or cell-range to write any response to

Return

A unique random request ID which can be used with REQUESTINFO to check the state of the request. In case of an error the corresponding error-code is returned.

Examples

	A	B
1	to	Mr. Doe
2	text	hello
3	ttl	60

Formula	Result	Comment
=SMS77.SEND("123key","hello","Mr. Doe")		Sends "hello" to Mr. Doe
=SMS77.SEND("123key",JSON(A1:B3))		Same as before but using JSON to specify required information and set optional ttl value to 1h