💪"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=[e-mail]"
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 [e-mail] or by messaging us on Twitter @SheetLink