Export CDT to excel

Hi RAHUL GANJI are there any specific reason why you didn't opt for "Export Data Store Entity to Excel" OOTB smart Service?

I would recommend to use "Export Data Store Entity to Excel" smart service, as it's an OOTB Smart Service, provides better performance, simple to use and provides several configurable options via it's Input Parameters.

Actually we need to get only some columns from the entity and also need to get the excel for the filtered report...Can u plz tell me how to handle this...

You can achieve all of them using this OOTB Smart Service. Following are the Input Parameters of this Smart Service which will help you:

• Selection: Optional Parameter, you can define a!querySelection() to select only set of columns
• Filters: Optional Parameter, you can define a!queryFIlter() / a!queryLogicalExpression() to define your filter conditions for extracting the rows

Also, the output document of this smart service is an excel file.

It would be worth checking this link.

Hope this will help you.

You can achieve all of them using this OOTB Smart Service. Following are the Input Parameters of this Smart Service which will help you:

• Selection: Optional Parameter, you can define a!querySelection() to select only set of columns
• Filters: Optional Parameter, you can define a!queryFIlter() / a!queryLogicalExpression() to define your filter conditions for extracting the rows

Also, the output document of this smart service is an excel file.

It would be worth checking this link.

Hope this will help you.

I need to rename the columns which would be different from my entity column names...

Anyways the Export to CDT smart service worked for me 

I also want to know the performance issues as you mentioned about this smart service

Thanks for ur reply