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

  • Genevieve P.
    Genevieve P. Employee Admin
    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

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    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

  • RamPS
    RamPS ✭✭

    Hi @Genevieve P.

    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

  • Genevieve P.
    Genevieve P. Employee Admin
    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

  • RamPS
    RamPS ✭✭

    Thanks very much @Genevieve P.

    I'll do some more testing/investigation before contacting Smartsheet support.

    Cheers,

    Ram