API Home >> Sheet >> API Reference >> books

Get a list of public workbooks associated with a tagname.

Request URL :

                                XML : http://sheet.zoho.com/api/public/xml/books/tag/[tag name]?apikey=[API Key]

                                JSON : http://sheet.zoho.com/api/public/json/books/tag/[tag name]?apikey=[API Key]

Request parameters

Field	Description
start-from [optional]	[integer] - Sets the initial workbook number from which the public workbooks with a specific tag name will be listed. If there are 10 publlc workbooks and start-from value is set to 3, then the workbooks will be listed from the 3rd workbook.
limit [optional]	[integer] - Sets the number of workbooks to be listed. If the limit value is set to 5 then the number of public workbooks with a specific tag name listed is 5.

Response fields

The schema document for the API response is located at: http://sheet.zoho.com/schema/publicbooks.xsd

Field	Description
workbookId	Unique ID associated with each public workbook in the list.
workbookName	Name of one of the public workbooks that is being listed.
authorName	Displays the name of the author of the public workbook.
permaLink	Displays the link of a public workbook.
embedLink	Displays the link that can be used for embedding this workbook in other web pages.

Sample Response

The following is the sample XML response for the above method:

<?xml version="1.0" encoding="UTF-8" ?>
<response uri="/api/public/xml/books/tag/sales">
  <result>
    <publicWorkbooks>
      <publicWorkbook>
        <workbookId>16883000000002013</workbookId>
        <workbookName>Monthly Sales</workbookName>
        <authorName>billrigg</authorName>
        <permaLink> <![CDATA[http://zohosheet/public.do?docurl=Monthly+Sales&name=ER4OKJyDUI4%3D]]>
        </permaLink>
        <embedLink> <![CDATA[http://zohosheet/publish.do?docurl=Monthly+Sales&name=ER4OKJyDUI4%3D]]>
        </embedLink>
         </publicWorkbook>
      <publicWorkbook>
        <workbookId>3786000000002011</workbookId>
        <workbookName>Land Sale</workbookName>
        <authorName>timmorton</authorName>
        <permaLink>
<![CDATA[http://zohosheet/public.do?docurl=Land+Sale&name=PdmGsnVvhxI%3D]]>
        </permaLink>
        <embedLink>
<![CDATA[http://zohosheet/public.do?docurl=Land+Sale&name=PdmGsnVvhxI%3D]]>
        </embedLink>
      </publicWorkbook>
     </publicWorkbooks>
  </result>
</response>

Equivalent JSON response

{
  "response":
   {
        "uri": "/api/public/json/books/tag/sales",
        "result":
        {
           "publicWorkbooks":
            {
                "publicWorkbook":
                [
                    {
                        "workbookId":"16883000000002013",
                        "workbookName":"Monthly Sales",
                        "authorName":"billrigg",
                        "permaLink": "<![CDATA[http://zohosheet/public.do?docurl=Monthly+Sales&name=ER4OKJyDUI4%3D]]>",
                        "embedLink": "<![CDATA[http://zohosheet/publish.do?docurl=Monthly+Sales&name=ER4OKJyDUI4%3D]]>"
                     },
                     {
                        "workbookId":"3786000000002011",
                        "workbookName":"Land Sale",
                        "authorName":"timmorton",
                        "permaLink": "<![CDATA[http://zohosheet/public.do?docurl=Land+Sale&name=PdmGsnVvhxI%3D]]>",
                        "embedLink": "<![CDATA[http://zohosheet/publish.do?docurl=Land+Sale&name=PdmGsnVvhxI%3D]]>"
                     }
                ]
            }
         }
    }
}  

Errors

Displaying list of public workbooks with a specific tag name method may return general & input errors.