ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Fetching the huge size excel/csv file from ITPAM


Article ID: 225712


Updated On:


CA Process Automation Base


Is it possible to fetch large excel/csv file from ITPAM file operators?


Release : 4.3.X

Component : Process Automation


ITPAM can only store 2 MB of data in a dataset variable, so it is not possible to extract more than 2MB data and store into the dataset variable with a single get transaction.

As a workaround, you might use a xls JDBC connection to do select queries to limit the data up to 2MB with each transaction and loop it till the whole data completes.