Discussions

Expand all | Collapse all

Download file directly through SSIS in SQL Server

  • 1.  Download file directly through SSIS in SQL Server

    Posted 10-14-2019 12:05
    Hello everyone,

    I've been able to create a PDF file, generated in the QB environment, and now I'm wanting to kick it further down the workflow which means it getting downloaded using SSIS on a SQL server.

    I know about doing an API_DoQuery&fmt=structured to get the URL for the individual file... which works great in a browser with a current session of QB already working... I've attempted using a usertoken with this URL, but that didn't work either.

    Does anyone know the URL structure to accomplish this on a SQL Server?

    ------------------------------
    Ryan Stanford
    ------------------------------


  • 2.  RE: Download file directly through SSIS in SQL Server

    Posted 10-15-2019 09:09
    My team and I were able to work this out...

    It is a simple GET Request, however, the "Allow access to this file attachment from a Quick Base link without signing in" must be checked.

    ------------------------------
    Ryan Stanford
    ------------------------------



  • 3.  RE: Download file directly through SSIS in SQL Server

     
    Posted 01-14-2020 16:07
    I know you already resolved this issue, but I thought I should mention that by enabling that option you are allowing anyone who gets access to that link to download your attachment files.

    To authenticate your requests you also need an apptoken if that is enabled for that application. You can also try using Request Headers that include your authentication credentials rather than using just a URL.

    ------------------------------
    Sam C
    ------------------------------