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':'\
cURL (or =cURL formula)
"\
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=
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)
| {% hint style="success" %} You can try the [SheetLink pre-built app formulas](/formulas/apps.md), or our [=API("options")](/formulas/functions.md) to interact with any application API. {% endhint %} ### 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