Export SQL TO EXCELL Issue

Dears ,

i'm facing an issue when i try to Export from SQL to Excel the code doesn't have any issue but once i clock export thee page 1 appear (check attachment Figure 1)

My Code in attachment in document

the database doesn't contain any Null data also , the plugin installed to My server.

please could you help me to find what is the error.

Thanks....

  Discussion posts and replies are publicly visible

Parents
  • I have faced the same issue. The workaround I have done and worked for me
    1) Use getdatasubsetdownloadlinkfromprocess
    2) Create a process model
    3) Process Parameter - Input(text) - Unique column value which you can query from table
    4) Add a script task
    5) Create the below mentioned in the Data - Input
    fieldNames (Better create a constant and update the value)
    fieldLabels (Better create a constant and update the value)
    dataSubset (Convert the input using a!fromJson(input) and query using this input
    fileName (whatever you want)
    6) In the output node, convert the dataSubset data to ExportableDataSubset using the AC input
    7) Create a constant for process model
    8) When calling getdatasubsetdownloadlinkfromprocess
    give process constant and give input as a!toJson(input)

    Note: There is a size limitation of input data. If you get any error try to limit the input size
    community.appian.com/.../download-datasubset-plugin
Reply
  • I have faced the same issue. The workaround I have done and worked for me
    1) Use getdatasubsetdownloadlinkfromprocess
    2) Create a process model
    3) Process Parameter - Input(text) - Unique column value which you can query from table
    4) Add a script task
    5) Create the below mentioned in the Data - Input
    fieldNames (Better create a constant and update the value)
    fieldLabels (Better create a constant and update the value)
    dataSubset (Convert the input using a!fromJson(input) and query using this input
    fileName (whatever you want)
    6) In the output node, convert the dataSubset data to ExportableDataSubset using the AC input
    7) Create a constant for process model
    8) When calling getdatasubsetdownloadlinkfromprocess
    give process constant and give input as a!toJson(input)

    Note: There is a size limitation of input data. If you get any error try to limit the input size
    community.appian.com/.../download-datasubset-plugin
Children
No Data