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
  • Eduardo, I believe I have this issue fixed. When passing dates in the JSON string for multiple parameters I used the tostring on the input and the todatetime on the output. But what I noticed with this is that I don't get the same results from the rule. Within the report I get more results than with the excel export rule. I believe this has to do with the conversion from Mean time within the report and not converting in the excel export plugin.
Reply
  • Eduardo, I believe I have this issue fixed. When passing dates in the JSON string for multiple parameters I used the tostring on the input and the todatetime on the output. But what I noticed with this is that I don't get the same results from the rule. Within the report I get more results than with the excel export rule. I believe this has to do with the conversion from Mean time within the report and not converting in the excel export plugin.
Children
No Data