Have a question regarding the Export SQL and Report Data to EXCEL - V2 plugin by

nicholasw over 8 years ago

Have a question regarding the Export SQL and Report Data to EXCEL - V2 plugin by Tom Ryan.
forum.appian.com/.../summary

It appears the documentation is a little out of date with the current version and would like to better understand the 4 new fields and when to use them:
1. Document_name_to_create - now called New_document_folder
2. Document_save_directory - now called New_document_name
3. Excel_base_template - same name
4. Document_to_overwrite - same name

Question: Are these fields now used mutually exclusively? And what is the best practice to use them in the same workflow.

To me it would make sense to provide fields 1-3 above for the first usage, then only 4 for the subsequent calls (via passing in the document object) but the actual testing breaks on this...can anyone clear this up?

Discussion posts and replies are publicly visible

0 Tom Ryan
Appian Employee
over 8 years ago

Which smart service is this for?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Richard over 8 years ago

These are the data inputs for the Export to Excel Smart Service
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tom Ryan
Appian Employee
over 8 years ago

It looks like you are looking at the wrong section of the documentation for that smart service - make sure you are looking at the section ## Export to Excel Usage (Report), or in the documentation pdf (available at the page you linked), which contains some further information regarding which inputs are required.

Based on the documentation in the pdf, the properties New_document_folder, New_document_name, and Excel_base_template will always be required.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel