question

lsc2021 avatar image
0 Votes"
lsc2021 asked PRADEEPCHEEKATLA-MSFT commented

How to save ADF Web Activirity(Rest Api) PDF File response to Azure Blob.

I want to download a pdf file from Salesforce using Pipeline image below and save it to Azure Blob.
The saved file is not a PDF file, the content is the text of the response image below.
How to convert the response content to PDF content(binary?)?

Please tell me. Thanks!

100282-qa1.png100291-qa2.png


azure-data-factoryazure-blob-storage
qa1.png (141.5 KiB)
qa2.png (71.5 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
0 Votes"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

Hello @lsc2021,

Thanks for the question and using MS Q&A platform.

REST API endpoints that the web activity invokes must return a response of type JSON.

I would suggest you use the HTTP connector.

HTTP connector is generic to retrieve data from any HTTP endpoint, e.g. to download file.

As per my repro, I used copy activity to copy PDF file from HTTP request to Blob storage.

Source dataset details:

100480-image.png

Sink Dataset Details:

100511-image.png

100521-image.png

100522-adf-httpendpoint.gif

Hope this helps. Do let us know if you any further queries.


Please "Accept the answer" if the information helped you. This will help us and others in the community as well.


image.png (143.3 KiB)
image.png (91.3 KiB)
image.png (1.5 KiB)
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@PRADEEPCHEEKATLA-MSFT
Thank you for your detailed answer!
I downloaded the file with the Http connector.

1 Vote 1 ·

Hello @lsc2021,

Glad to know it helped.

0 Votes 0 ·