SheetLink
Searchβ¦
π
Welcome
π
Quickstart
β
FAQ
π
Security
Formulas
π
Apps
π
Functions
πͺ
"options"
Powered By
GitBook
πͺ
"options"
Control the request to and response from any application.
All "options" must be a
cell reference
(B2), a
cell range
(B2:D2), or
comma separated in double quotes
("option1","option2")
Example 1 (simple)
=HubSpot_getContacts("rawHeaders,name=Elon,/name")
API Request "options"
The below "options" are sent along with the request to your application.
"options"
API
Key
(set, reset or query)
"key=reset"
(reset API key)
"key=?"
(query API key)
**
"key=MY-KEY"
(**careful, key is saved to
sheet history
)
The alternative "
π
Authentication
" method is recommended
Payload (
JSON
format)
"{'KEY':'VALUE'}"
"{'pie':{'cook_time':'20 Min','temp_degrees':'350'}}"
Payload (
base64
encode)
"{'KEY':'<encode>VALUE</encode>'}"
cURL (or =cURL formula)
"<curl>cURL-HERE</curl>"
Headers (
JSON
format)
"headers={'KEY':'VALUE'}"
"headers={'Accept-Version':'1.0'}"
Content Type
"contentType=application/x-www-form-urlencoded"
"contentType=application/json"
(default if blank)
URL Parameters
"KEY=VALUE"
"color=blue,
[email protected]
"
Method
"method=METHOD-HERE"
"method=GET"
(default if no Payload)
"method=POST"
(default if Payload)
API Response "options"
The below "options" are used to format the app's JSON API response.
"options"
Response Headers
"rawHeaders"
(returns raw /QUERY headers)
"/QUERY"
("rawHeaders" to query)
"noHeaders"
(return data without headers)
Response Data
"inheritParents"
(inherit JSON parent elements)
"truncateValues"
(shorten response values)
"debugLocation"
(row & column with values)
Raw Response Data
(advanced)
"*"
(return raw JSON response)
"*/QUERY"
(query raw JSON response)
"*?"
(request options with response)
"$QUERY"
(JSON
Path-Plus
query)
You can try the
SheetLink pre-built app formulas
, or our
=API("options")
to interact with any application API.
Navigation
Page
π
Quick Start
β
60 second getting started guide.
β
β FAQ
β
Answers to frequently asked SheetLink questions.
π
Apps
β
Explore the apps we've already built formulas for.
π οΈ
Functions
β
Powerful functions unique to SheetLink.
π Need Help?
You can always contact us via
[email protected]
or by messaging us on Twitter
@SheetLink
β
Formulas - Previous
Functions
Last modified
10mo ago
Copy link
Outline
Example 1 (simple)
API Request "options"
API Response "options"
Navigation
π Need Help?