Hi all, I'm having some trouble with the Read Excel Spreadsheet t

Hi all,

I'm having some trouble with the Read Excel Spreadsheet to CDT smart service. It isn't throwing an alert when executed but the application logs are saying that there's a mismatch of types, see below:

ERROR com.appiancorp.suiteapi.common.TypedValueParameterConverter - Cannot convert TypedValue
com.appiancorp.suiteapi.common.exceptions.AppianException: Invalid Type: com.appiancorp.kougar.mapper.exceptions.ParameterException: Record value length (33) does not match instance property length (13) unable to convert <4974> of type <class java.lang.Long> to type <class [Ljava.lang.Object;> (APNX-1-4047-000)

The CDT has only text and date fields, and I've tried forcing the Excel to format the cells as text/date where appropriate, and the column headers match the CDT fields exactly. This means I'm getting null values in my output CDT.

Is there something obvious that I'm doing wrong? How would I go about resolving this?

Thanks!...

OriginalPostID-100845

OriginalPostID-100845