Taking an attachment from one sheet and adding it to another

Andrew Skaggs

Hello,

Currently I'm doing some testing with Bridge in hopes of using the Call API module to add an attachment to a row. Currently the attachment is on one sheet (Sheet 1 "Repository"), and I am hoping to be able to "see it", then copy it over to another sheet (Sheet 2 "UI Sheet) Ultimately, the goal is to have a user input a piece of equipment (Truck, Dozer, etc…) and then have a pdf spec sheet populate on that newly added line-item.

Currently in testing, my Bridge workflow can reach out to the correct line-item in the repository and can get the attachment from that line-item. However when it then gets to the Call API module, I keep getting a timeout error

I think I don't have something configured correctly, but for the life of me I can't figure it out. Here's my Call API module configuration.

I based this configuration off of the documentation in the Smartsheet Official API and SDK documentation.

https://smartsheet.redoc.ly/tag/attachments#operation/row-attachments-attachFile

Any help or insight into this would be most appreciated.

Thanks

jmyzk_cloudsmart_jp

Hi @Andrew Skaggs

Unfortunately, Bridge currently cannot add attachments to a Smartsheet sheet.

Adding attachments to a Smartsheet sheet is not directly supported as a module in Bridge.

https://community.smartsheet.com/discussion/102586/

Currently Bridge cannot pass attachments or files.

https://community.smartsheet.com/discussion/119711/

So, you need to use Smartsheet API to take an attachment from one sheet and add it to another.

As the code snippet using the Smartsheet Python SDK shows, you need a file on your computer or server.

    # Attach file to target row
    updated_attachment = smartsheet_client.Attachments.attach_file_to_row(
        target_sheet_id,
        target_row.id,
        (file_name, open(file_path, 'rb'), file_attachment.mime_type)
    )

This short video showcases a Smartsheet solution leveraging the Smartsheet API to copy an attachment from one sheet to another.

https://youtu.be/MNfFoNiXYak