Python API - results on Reports do not match manual Excel extracts
We are currently automating some processes around Smartsheet, where one of the key steps is to extract data from a Smartsheet Report (sic! Not a Sheet!). We tried the following approaches
- using the Python API
- using the Smartsheet connector for the Azure Data Factory (https://learn.microsoft.com/en-us/azure/data-factory/connector-smartsheet?tabs=data-factory)
With both approaches we get wrong results on Reports (not on Sheets, interestingly). The extracted data is just not the same as compared to a manual data export though the browser frontend. The differences appear pretty random to us: some rows seem duplicated, while others are missing.
Is this a known issue of the API or are we rather missing out on something? Any ideas?
(Side note: we don’t see those issues with the ODBC connector. However, as we cannot easily deploy ODDBC in a pure cloud environment, we would normally favor other options.)