Copy Sheet w API doesn't copy over "Cope Rows" Automation action

ArielDB
ArielDB โœญโœญโœญโœญ
edited 12/18/24 in API & Developers

I am using the Smartsheet SDK

When I copy a sheet using the API (either by copying a template w/ client.Workspaces.create_sheet_in_workspace_from_template or client.Sheets.copy_sheet) I can use the "include" query parameter to capture conditional formatting, forms, and automations copy over, but a specific COPY ROWS action does not copy correctly!

Code:

{8704EC77-004E-407C-955E-A9CC0A0B94E7}.png


Faulty Result:

{77A6BF9B-B1EC-467C-9CDD-E85577C92E49}.png {DF8ABBAB-9A1E-45CD-A1FB-00D5C4CB5922}.png



vs when I copy manually I do not have this issue.

{2DB4D21B-290D-409F-90DB-FE57A28A08EC}.png

I am using my own API Key so its not a permissions issue. Is this a bug? am I missing something? hoping someone can helP!

Thanks!

Answers

  • Leibel S
    Leibel S Community Champion

    @ArielDB

    Does the user 'Dowbuilt Automation' have access to the destination sheet in your copy row automation?

  • ArielDB
    ArielDB โœญโœญโœญโœญ
    edited 12/18/24

    Hi Leibel, I was also hoping that was the issue, but when I log in as "Dowbuilt Automation" and manually copy sheet as new, it works without issue. I also verified that "Dowbuilt Automation" is an admin on the new sheet. Wondering if anyone else has seen this behavior.

    {E5BF3F16-E76D-4571-BFA4-CF15E69614B1}.png
NEW Smartsheet API Documentation - bookmark the updated link! https://developers.smartsheet.com