SmartSheet API call via Alteryx
I have recently built an Alteryx model to extract data from various smartsheets that I have access to. While the model does what it needs to do, the API call seems to work only on a random selection smartsheet IDs.
As a first step, I am extracting the details of the smartsheets that I am given access to (just the name and ID of the sheet). Next I pipe the ID into another model to extract the data. This is cloned for all the IDs that the baseline model extracts.
Of a total of 18 smartsheets that I have access to, this process extracts data only for 8.
For the ones that aren't extracted by the baseline model I am able to build individual bespoke models for the remaining sheets and extract the data.
Issue is that I want this to be a set and forget model and I am 100% confident about the Alteryx side of things and need clarity on the API call itself. Baseline query is simply -> https://api.smartsheet.eu/2.0/sheets/<SheetID>. This combination of bespoke and a generalised model is sub-optimal.
I have replicated this process using Postman and have exactly the same results. Clearly this seems to be an API issue rather than the platform.
Note that all of the sheets I have access to are on the .EU instance
Has anyone encountered something like this and if so do you have any suggestions?