Setup Zoho Sheet API to get Workbook, Worksheet table data, add rows, update row, delete rows with simple API without any server setup or coding
Make GET request on this endpoint to list all workbooks with required parameters(if any required).
https://v1.nocodeapi.com/<username>/zohosheet/<token>/workbooks
Make GET request on this endpoint to list all worksheets with required parameters(if any required).
https://v1.nocodeapi.com/<username>/zohosheet/<token>/worksheets
Make POST request on this endpoint to create worksheet with required parameters(if any required).
https://v1.nocodeapi.com/<username>/zohosheet/<token>/worksheets
| Object | Description |
|---|---|
workSheetName |
[Optional] Name of the new worksheet |
Make GET request on this endpoint to fetch records with required parameters(if any required).
https://v1.nocodeapi.com/<username>/zohosheet/<token>/sheetData
| Object | Description |
|---|---|
workSheetName |
[Required] Name of the new worksheet |
header_row |
[Optional] By default, first row of the worksheet is considered as header row. This can be used if tabular data starts from any row other than the first row. |
criteria |
[Optional] Can be used to filter records. example: "Name"="Jack", "email"="[email protected]", "age">14, etc |
column_names |
[Optional] Name of the new worksheet |
render_option |
[Optional] It defines how the value should be rendered. Possible options are formatted, unformatted, and formula. |
page |
[Optional] pagination for next page |
perPage |
[Optional] It denotes the number of records. |
Make POST request on this endpoint to add records with required parameters(if any required).
https://v1.nocodeapi.com/<username>/zohosheet/<token>/sheetData
| Object | Description |
|---|---|
workSheetName |
[Required] Name of the new worksheet |
body |
[Required] JSON Array. Example : [{"Name":"Joe","Region":"South","Units":284},{"Name":"Beth","Region":"East","Units":290}]. "Name", "Region", and "Units" are the table headers. |
– Body data format example:
[
{
"Name": "Joe",
"Region": "South",
"Units": 284
},
{
"Name": "Beth",
"Region": "East",
"Units": 290
}
]Make PUT request on this endpoint to update records with required parameters(if any required).
https://v1.nocodeapi.com/<username>/zohosheet/<token>/sheetData
| Object | Description |
|---|---|
workSheetName |
[Required] Name of the new worksheet |
criteria |
[Optional] If criteria is not set all available rows will get updated. Mention the criteria as described as: example: "Name"="Jack", "email"="[email protected]", "age">14, etc |
header_row |
[Optional] By default, first row of the worksheet is considered as header row. This can be used if tabular data starts from any row other than the first row. |
first_match_only |
[Optional] If true and if there are multiple records on the specified criteria, records will be updated for first match alone. Otherwise, all the matched records will be updated. |
is_case_sensitive |
[Optional] By default it is true. Can be set as false for case incensitive search. |
body |
[Required] The JSON data that needs to be updated. Example:{"Month":"May","Amount":50} |
– Body data format example:
{
"Month": "May",
"Amount": 50
}