I have developed an SSIS package to read Smartsheet data, and then export the data into SQL database. I managed to export the data but noticed the Task Name, % Complete, Status fields are returning NULL values. This doesn't make sense because these fields are populated with data on Smartsheet.
Please assist.