API Home >> Sheet >> API Reference

APIs LIST

The API methods are clubbed into different categories based on the operations that they perform. The two main categories that the API methods have been segregated are - private & public.

private - As the name suggests, the private API URIs are used for getting user specific details the results of which are only available to the particular Zoho Sheet user. The URIs for getting private details start with "api/private"

public - The public API URIs are used for getting workbook related details that has already been made public and hence available for all the users to view. These URIs start with "api/public" and no authentication is required for them. It means that we need not pass a "ticket" as one of the query parameters for accessing them.


books

private

• Get list of workbooks created by user
• Get list of workbooks tagged with a particular tag name
• Get list of trashed workbooks
  
• Get list of sheets available in a particular workbook
• Rename an existing workbook
• Save an existing workbook with a new version
• Trash a workbook
• Restore a workbook from trash
• Permanently delete a workbook
  

public

• Get list of public workbooks available in Zoho Sheet
  
• Get list of public workbooks tagged with a particular tag name
• Get list of public workbooks created by user
  
• Get list of sheets available in a public workbook

sharing


private

• Get list of workbooks shared to you.
  

tags


private

• Get list of tags associated with a particular workbook
  
• Add set of tags to a particular workbook
  
• Remove set of tags associated with a workbook
  

public

• Get list of tags associated with a public workbook
  

download

private

• Download a workbook in xls format
  
• Download a workbook in sxc format
• Download a workbook in pdf format
• Download the first sheet of a workbook in csv format
• Download a specific sheet of a workbook in csv format
• Download a specific sheet of a workbook with a sheet name in csv format
• Download a specific cell range within a sheet in csv format by sheet index value
• Download a specific cell range within a sheet in csv format by sheet name

public

• Download a public workbook in xls format
  
• Download a public workbook in sxc format
• Download a public workbook in pdf format
• Download the first sheet of a public workbook in csv format
• Download a specific sheet of a public workbook in csv format
• Download a specific sheet of a public workbook with a sheet name in csv format
• Download a specific cell range within a sheet of a public workbook in csv format by sheet index value
• Download a specific cell range within a sheet of a public workbook in csv format by sheet name
  

upload


private

• Upload new workbooks into Zoho Sheet
  

content

private

• Get content of entire workbook
• Get content of a specific sheet with index
• Get content of a specific sheet with name
• Get content of a range within a specific sheet with index
• Get content of a range within a specific sheet with name
  

public

• Get entire content of a public workbook
• Get content of a specific sheet with index of a public workbook
  
• Get content of a specific sheet with name of a public workbook
• Get content of a range within a specific sheet with index of a public workbook
• Get content of a range within a specific sheet with name of a public workbook