You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Retrieve PDF File from HTTP Web Request

posted on July 19, 2018

I am trying to set up a Workflow that uses the HTTP Web Request to retrieve a PDF file from SQL Server Reporting Services (SSRS).  I've set the HTTP Web Request activity up and it receives the PDF data when I test the request.  However, I don't see any activities in the toolbox that will allow me to convert the response into an actual PDF file and store it in the repository.  Is this functionality missing, or is there and activity I can use to accomplish this?

0 0
replied on July 19, 2018

Depending on the file type, I've had success using the "Attach Electronic Document" activity. The process would look something like this:

1 0
replied on July 19, 2018

Thanks Scott!  That was the thing that I needed to get it working.

Rob

0 0
replied on July 19, 2018 Show version history

Take a look at How to convert PDF Byte Array into PDF document?

Basically, you will need an SDK Script activity.  In the script, you grab the data from the HTTP Web Request activity (it will be as a Base64 string) and then convert the Base64 string to a byte array before writing it to a PDF file.

2 0
You are not allowed to follow up in this post.

Sign in to reply to this post.