SSIS Components for Zoho Books

Build 24.0.9060

ExportReport

Downloads report as a pdf or xls file

Execute

This supports filters of the respective report view:

EXECUTE ExportReport ReportName = accounttransactions, ReportType = pdf, Filters = 'TransactionDate = ThisQuarter', FileLocation = C:\\zohobooks

Input

Name Type Required Description
ReportName String True Name of reports.
ReportType String True FilType in which report has to be downloaded.

The allowed values are pdf, xls, xlsx.

ShowOrgName Boolean False Boolean denoting org name should be shown or not.
ShowGeneratedDate Boolean False Boolean denoting date at which report was generated should be shown or not
ShowGeneratedTime Boolean False Boolean denoting time at which report was generated should be shown or not
ShowGeneratedBy Boolean False Boolean denoting name of the user who downloaded the report should be shown or not
ShowPageNumber Boolean False Boolean denoting page number should be visible or not.
Filters String False The value can be any filterable column supported in the respective reports view.
FileLocation String False Location at which exported report should be saved.

Result Set Columns

Name Type Description
Status String Stored procedure execution status.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060