I'm using the Download DataSubset (on-premise) plugin in order to export dat

I'm using the Download DataSubset (on-premise) plugin in order to export data to excel. I am using the JSON strings to pass multiple input parameters to the export rule. I am passing 2 DateTime paramters and a Text parameter. My input parameter is a type Text and I use the todatetime function to convert the 2 DateTime parameters from string to date within the export rule. I continue to get a 500 error. Any help would be appreciated.

Here is the call to the export rule:
local!ruleURI3: getdatasubsetdownloadlinkfromrule(rule: rule!ruleURI3, input: a!toJson({receivedDateTimeStart: local!receivedDateTimeStart, receivedDateTimeEnd: local!receivedDateTimeEnd, filter: local!PMNameFilter})),

Here is the export rule:
=with(
local!search: a!fromJson(ri!input),
'type!{urn:appian:plugin:datasubsetdownload:types}ExportableDataSubset'(
filename: "CA Event by Estimated Processing Date Exported Data",
fieldNames: {
"caEventId",
...

OriginalPostID-141800

OriginalPostID-141800

  Discussion posts and replies are publicly visible

Parents
  • ..."securityId",
    "ticker",
    "electionTypeDescription",
    "actionTypeDescription",
    "subActionTypeDescription",
    "estimatedProcessingDate",
    "expirationDate",
    "exDate",
    "effectiveDate",
    "currentStatus"
    },
    fieldLabels: {
    "Event ID",
    "Security ID",
    "Ticker",
    "Election Type",
    "Action Type",
    "Sub Action Type",
    "Est. Processing",
    "Expiration",
    "Ex Date",
    "Effective",
    "Current Status"
    },
    datasubset: rule!SO_CA_GetCAEventDetailsWithPMIsProcessingCompleteFalseBlankEstProcDate(receivedDateTimeStart: todatetime(local!search.receivedDateTimeStart),receivedDateTimeEnd: todatetime(local!search.receivedDateTimeEnd),a!pagingInfo(startIndex: 1, batchSize: -1))
    )
    )
Reply
  • ..."securityId",
    "ticker",
    "electionTypeDescription",
    "actionTypeDescription",
    "subActionTypeDescription",
    "estimatedProcessingDate",
    "expirationDate",
    "exDate",
    "effectiveDate",
    "currentStatus"
    },
    fieldLabels: {
    "Event ID",
    "Security ID",
    "Ticker",
    "Election Type",
    "Action Type",
    "Sub Action Type",
    "Est. Processing",
    "Expiration",
    "Ex Date",
    "Effective",
    "Current Status"
    },
    datasubset: rule!SO_CA_GetCAEventDetailsWithPMIsProcessingCompleteFalseBlankEstProcDate(receivedDateTimeStart: todatetime(local!search.receivedDateTimeStart),receivedDateTimeEnd: todatetime(local!search.receivedDateTimeEnd),a!pagingInfo(startIndex: 1, batchSize: -1))
    )
    )
Children
No Data