10

Where is the official documentation for the URL parameters/arguments?

There are things like /preview, /copy, /export, #headings, ?something question mark, that I stumbled on tips and tricks articles on the web.

Where is the Official URL API that explains ALL of them?

10

There is no official Google documentation for this. Let's have unofficial one:

/copy
/export
/edit
/preview
/create
/pub?
/fm?id=
/tq?tqx=out:html
&key=[ID]
&gid=[#]
&single=[true|false]
&range=[CellAddress|CellAddress1:CellAddress2]
&embedded=[true|false]
&widget=[true|false]
&output=[html|txt|csv|pdf]
&gridlines=[false]
&rm=[minimal|embedded|full|demo|?]
&ui=2 (interface version)
&chrome=[false] (full screen mode)
&width=[width]
&height=[height]
&frameborder=[size of border]
&q=[Search Query]
&viewer?
&start=
&channel=
&ibd=
&client=
&fmcmd=12
&size=0
&fzr=[true]
&portrait=[false]
&fitw=[true]
&printtitle=[true]
&sheetnames=[true]
&pagenum=[CENTER]
&attachment=[true]
&alt=[rss]
&tq=[query params here]

You may also be interested in this related question and answer about how to construct a specific URL to copy a template file into a specific folder. https://webapps.stackexchange.com/a/139589/266240

3
  • 1
    &copyDestination=[Drive FolderID]
    – katriel
    May 20 '20 at 12:19
  • Can you help me with Google slides too?
    – Code Guy
    Nov 21 '20 at 1:18
  • 1
    There is also userstoinvite which takes a string of emails separated by commas Dec 19 '20 at 20:37
1

For Google Slides, I also use:

/embed
&loop=true
&delayms=[#]
&start=[true|false]
0

Basically, no. It seems like it is difficult to find information on this because of the different versions. I couldn't find any page ever mentioning Google Sheets API v2 or v1, so I'm going to believe only v3 and v4 exist. When this question was posted, I believe it was only v3.

The top answer gives a pretty good list of your options, so here I'm just trying to find an official link for it.

Check this question out also, it's quite similar.

Currently this is the main/only documentation we've got. Within that, this is the exact page you want, but it only offers 3 query parameters. I've tried many others on my own sheets, so this definitely does not include everything. The ones here were working yesterday, but not today.

The other option seems to be the reference for Drive API (not specifically Sheets API). There is a Drive API v2 and v3. I haven't actually tried this out - some of the queries look familiar but may not actually work.

https://developers.google.com/drive/api/v2/about-files https://developers.google.com/drive/api/v3/fields-parameter https://developers.google.com/drive/api/v3/reference/files?hl=en https://developers.google.com/drive/api/v3/manage-downloads https://developers.google.com/drive/api/v3/ref-search-terms

Tidbits from these links that look interesting:

webContentLink  string  A link for downloading the content of the file in a browser. This is only available for files with binary content in Google Drive.  
webViewLink string  A link for opening the file in a relevant Google editor or viewer in a browser.

This guide for migration seems to be better than the documentation itself for what you want.

Lastly, there have been some promising lists in the Docs API, but if you have to go looking in sister products it's far from a useful reference link.

Posting as a draft, not sure when/if I'll get back to this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.