We are trying to set up a nightly read of two separate folders in a OneDrive location to get a list of the files in the directories. There are several thousand files in each directory. Sometimes the routine will run and report less than 500 records and then when you immediately run it again it will read all of the 5,000+ records.
Is there something I am not aware of on the OneDriveConnector that would be causing it to give such wildly differing results. I am so accustomed to consistent, bulletproof results when running FME routines that unpredictable, inconsistent results is quite disconcerting.
We are needing to write an inventory of files to SQL Server to use for linking in a GIS system.