Forum Discussion

RyanStanford1's avatar
RyanStanford1
Qrew Captain
6 years ago

Download file directly through SSIS in SQL Server

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 ...
APIs and custom code
Data import and export
RyanStanford1's avatar
RyanStanford1
Qrew Captain
6 years ago
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
------------------------------
  • SamColburn's avatar
    SamColburn
    Qrew Trainee
    6 years ago
    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
    ------------------------------