On using import excel to database smart service getting this error : Incorrect integer value: '' for column `Appian`.`tablename`.`palletqtyno` at row 1???

Question

I am trying to use import excel to database smart service for importing my data from excel into appian table.

In my CDT i have columns of text and integer type. But when trying to use the excel file with integer column as blank it is throwing me error as:

Incorrect integer value: '' for column `Appian`.`testBT`.`palletqtyno` at row 1???

where testBt is my tablename and palletqtyno is my column name whose data type is defined as integer in CDT

csteward · Accepted Answer

Ah yes, my sample code needs adjustment - as you have found, the result is actually a list of text string within local!data.result.values, vs a list of dictionary. fv!item.values[2] or index(fv!item.values,2,null) would be the way to go.

a!localVariables(
  local!data: fn!readexcelsheet(cons!CHRIS_TEST_SP_DOC,0,2), /* get the data */

  if(
    local!data.success, 
    a!forEach( 
      items: local!data.result,
      expression: 'type!{urn:com:gdit:types}COE_Sample_CDT'(
        id: null,
        approval: index(fv!item.values,1,null),
        requestByName: index(fv!item.values,2,null),
        requestById: index(fv!item.values,3,null),
      )
    ),
    {}
  )
)

csteward · Answer

Is your palletqtyno field configured to allow null values at the DB level?

Sign up

Login with SSO

Login to the community

Login with SSO