SmartSheet API call via Alteryx
Hello,
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?
Thanks,
Ram
Best Answer
-
Hi @RamPS
Yes you're correct, the baseline query of https://api.smartsheet.eu/2.0/sheets should list all sheets you have access to, including ones that you're shared to with Editor permissions. The default pagination is 100 sheets per page, so if you only have 18 they should all show in the first page.
Testing in my non-EU account, I can see thousands of sheets when using that call, so all 18 of yours should show. If it's not doing this, please contact Smartsheet Support with screen captures of your request and what you can see in the UI.
Thank you!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @RamPS
Can you clarify which part of the process only works for 8/18 sheets? Do you mean that the baseline query you noted is not pulling the sheet information for 10 of your sheets when you individually add in the Sheet ID:
https://api.smartsheet.eu/2.0/sheets/<SheetID>
Or is this the query that works, but a previous one (that gets the total sheet IDs) does not?
It would be helpful to know a bit more about the sheets themselves as well; for example, is there a commonality between the 10 that don't show up (a specific sharing permission, perhaps).
Thanks!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks for your reply. I have checked with our smartsheet administrators and can confirm that I have been set up as an editor with read/write/share privileges.
To answer your initial question, the baseline query should, in theory, extract all the sheets that I have access to, which it does, except these 10 sheets. These are all on the same .eu domain and there is nothing different/weird about them. Because the baseline doesn't extract these 10 sheets, I am able to build bespoke models for them but obviously doesn't make perfect business sense.
I'd like to know if this is indeed an API issue and what needs to be done to fix it.
Thanks,
Ram
-
Hi @RamPS
Yes you're correct, the baseline query of https://api.smartsheet.eu/2.0/sheets should list all sheets you have access to, including ones that you're shared to with Editor permissions. The default pagination is 100 sheets per page, so if you only have 18 they should all show in the first page.
Testing in my non-EU account, I can see thousands of sheets when using that call, so all 18 of yours should show. If it's not doing this, please contact Smartsheet Support with screen captures of your request and what you can see in the UI.
Thank you!
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks very much @Genevieve P.
I'll do some more testing/investigation before contacting Smartsheet support.
Cheers,
Ram
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives