Skip to main content
Question

Download file directly through SSIS in SQL Server

  • October 14, 2019
  • 0 replies
  • 66 views
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
------------------------------

  • RyanStanford1
  • Author
  • Registered
  • October 15, 2019
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
------------------------------
Terms & ConditionsAccessibility statement