Has anyone tried to use the Selection Node Input while configuring the exportDataStoreEntityToExcel() smart service?

I am trying to use the Selection Node Input to limit and rename the fields I want to export to Excel.  However, I can not figure out how to set this up.  The documentation is no help.  It states to use the a!querySelection() and then the a!queryColumn() functions when setting up the columns. However, the configuration input seems to have the ability to add columns, fields, alias and visible without using the functions.

I have tried to key in the fields, alias and visible into each of these inputs, but for the life of me, I can figure out how to add in more columns and adding just one selection throws an error, "Query has failed: Could not parse expression [1]. Details: Unexpected count of record variables (APNX-1-4505-005)"

I have tried to write the Jason using the a!querySelection(a!queryColumn(),a!queryColumn(),etc...) at the Selection and Columns level.  This just throws the same error as above.

a!querySelection(
  {
    a!queryColumn(
      pv!pensionContributors.rowNumber,
      "Request_Id"
    ),
    a!queryColumn(pv!pensionContributors.clergySSN, "SSN"),
    a!queryColumn(
      pv!pensionContributors.clergyFullName,
      "Name"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyStatus,
      "Clergy_Status"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyGender,
      "Clergy_Gender"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyDoBirth,
      "Date of Birth"
    ),
    a!queryColumn(pv!pensionContributors.clergyAge, "Age"),
    a!queryColumn(
      pv!pensionContributors.clergyDoOrdination,
      "Ordination Date"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyDoHire,
      "Hire_Date"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyYearsofService,
      "Years_of_Service"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyDoParticipation,
      "Particpation_Date"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyDoRetire,
      "Normal_Retirement"
    ),
    a!queryColumn(
      pv!pensionContributors.clergyPensionStatus,
      "Pension_Status"
    ),
    a!queryColumn(
      pv!pensionContributors.pensionStatusDate,
      "Status Date"
    ),
    a!queryColumn(
      pv!pensionContributors.comment,
      "Comment"
    )
  }
)

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data