Skip to main content

Custom Request Headers

In addition to the standard headers (Authorization, Content-Type, etc.), the Sheet Best API recognises a small set of custom request headers you can send to change request behaviour.

HeaderApplies toDescription
X-HTTP-Method-OverridePUTRe-route a PUT request through the PATCH handler so unspecified columns are not blanked.

X-HTTP-Method-Override​

Use this header when your HTTP client cannot issue a PATCH request — for example, older HTTP libraries, certain no-code platforms, embedded environments, or webhook tools that only support PUT.

Send the request as a PUT and add:

X-HTTP-Method-Override: PATCH

Sheet Best will treat the request as a PATCH, so columns you omit from the body are left untouched instead of being blanked out (which is what a plain PUT would do).

Example​

curl 'https://api.sheetbest.com/sheets/<api-id>/1' \
  -X PUT \
  -H 'Content-Type: application/json' \
  -H 'X-HTTP-Method-Override: PATCH' \
  -d '{"Name": "Jack Doe"}'

Rules​

  • The header is only honoured on PUT requests. On any other method (GET, POST, PATCH, DELETE) it is silently ignored.
  • The only accepted value is PATCH (case-insensitive — patch, Patch, and PATCH all work). Any other value is ignored and the request stays a PUT.
  • The header is allowed by Sheet Best's CORS policy, so browser clients can send it cross-origin.
  • Prefer sending a real PATCH when your client supports it. This header is a compatibility shim, not the recommended path.

See Updating Rows (PUT / PATCH) for the difference between PUT and PATCH semantics.