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, Do you have any idea why the conversion on the dates is different? If I use a range of 03/12/2015 12:00 pm - 03/19/2015 12:00pm in the report I get 41 records dates from 03/12/2015 12:30 pm - 03/19/2015 6:40am. But when I export them to excel using the rule I get 37 records and the datetime are not converted to the datetime in the report but are straight from the table. How do I convert the datetime to local time on the export?
Reply
  • Eduardo, Do you have any idea why the conversion on the dates is different? If I use a range of 03/12/2015 12:00 pm - 03/19/2015 12:00pm in the report I get 41 records dates from 03/12/2015 12:30 pm - 03/19/2015 6:40am. But when I export them to excel using the rule I get 37 records and the datetime are not converted to the datetime in the report but are straight from the table. How do I convert the datetime to local time on the export?
Children
No Data