"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"
"key=reset" (reset API key)
"key=?" (query API key)
"{'KEY':'VALUE'}"
"{'pie':{'cook_time':'20 Min','temp_degrees':'350'}}"
"{'KEY':'<encode>VALUE</encode>'}"
cURL (or =cURL formula)
"<curl>cURL-HERE</curl>"
"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=hi@sheet.link"
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)
You can try the SheetLink pre-built app formulas, or our =API("options") to interact with any application API.
Navigation
Page
60 second getting started guide.
Answers to frequently asked SheetLink questions.
Explore the apps we've already built formulas for.
Powerful functions unique to SheetLink.
🚑 Need Help?
You can always contact us via support@sheet.link or by messaging us on Twitter @SheetLink
Last updated
Was this helpful?