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 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
------------------------------
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
      ------------------------------