SharePoint Input V2.5 Designer Desktop getting Expected error on column when switched typ

Question

Was wondering if anyone has seen this below im now running into issues with loading in excel files from the SharePoint Input tool i can get the Excel file but if a certain column the "type" changes it throws an error (see below)

i narrowed it down to a specific cell ( so i load in that 1 column and cells 1 to 149) those load in fine but as soon as i go to cell 150 it throws the below error. Even if i manually change the type in Excel it still throws the error and changing the entire column will not get rid of the error.

Was wondering if anyone has seen this or has had a fix for it its not plausible to go into every sheet every week and adjust all the cells.

Below screenshot s the error

This is the error - Error: SharePoint Input (1): ("Expected bytes, got a 'int' object", 'Conversion failed for column NOTES with type object')

Was wondering if anyone has seen this or has a fix for it

SP Input Error.png

SP Input Selections.png

Nmassarone · Answer

i reverted back to version 2.4 and have not had any issue since i have been using this until there is a solid update

dparker · Answer

Fix was released for V2.6.2  and reads files properly.  However now the read only list of full paths no longer works.  Error reads:

Error: SharePoint Input (1): ("Could not convert <ItemType.FILE: 'file'> with type ItemType: did not recognize Python value type when inferring an Arrow data type", 'Conversion failed for column Type with type object')

peterr_h · Answer

@abhilash_t @Nmassarone @radhikakg Hi all,

I have heard from Alteryx Support that this is due to be fixed in release 2.6.2 of the connectors.

Once this is released, we will need to download the newest version of the connectors and use these instead.

This is due to be released soon.

Fingers crossed!