Conversion of a Blob to PDF file

[vishesh.sharma.adtalem (Vishesh Sharma)]

Hello,

I’m required to fetch some PDF documents from salesforce using API calls.
After calling the API, I’m getting a response shown in below image

I’m not sure how to handle this response in UiPath and save it as a PDF file. Please guide me on how can I convert this response into a PDF file.

Thanks

[Gokul_Jayakumar (Gokul Jai)]

@vishesh.sharma.adtalem

image1272×486 31.6 KB

Hello @vishesh.sharma.adtalem ,
Click the Save response which is top right corner, you may get some data

[Gokul_Jayakumar (Gokul Jai)]

@vishesh.sharma.adtalem
In UiPath, by using HTTP request activity, can hit the API and save the response in desired folder.
Kindly refer to this thread, you may get some idea.

API | API in UiPath | Application Programming Interface | HTTP Request | HTTP Response

API | UiPath Automation API | HTTP Request | HTTP Response | API Call in UIPath

API | UiPath API Automation

[postwick (Paul)]

He’s just showing a debug to show the data he’s receiving, he isn’t UI Automating that screen.

[postwick (Paul)]

How to Download Blob file from Oracle Database using UiPath Package

Hey @sarvesh.b Here is the workaround for you to convert binary data blob to an image, [image] PFA - nmnithinkrishna_ByteArrToImg.zip (152.1 KB) So you can perform the same for your table data. If you face any issues please let us know. Hope this helps you. Thanks #nK

[vishesh.sharma.adtalem (Vishesh Sharma)]

Hi @Gokul_Jayakumar,

I tried ‘Save Response’ option of postman and saved the response as a file (response.pdf). I got the actual PDF file.

Now in UiPath, I’ve used HTTP Request activity, which is giving same response in string. How do I save that string as a pdf file?

I’ve tried writing the string response to a file directly using ‘Write Text File’ activity with encoding ‘UTF-8’, ‘ASCII’, ‘UNICODE’, and blank. But it’s giving a blank pdf only.

@postwick I’ve also tried converting response string into Bytes array so that I can write it into a file using System.IO.File.WriteAllBytes. I used 'System.Text.Encoding.<utf8, ascii, unicode etc>.GetBytes(stringResponse), but again I’m getting blank PDF only.

[postwick (Paul)]

Sorry, I don’t really have an answer - I’ve never done that.

What I’m wondering is why you’re using the Salesforce API instead of navigating into Salesforce and directly downloading the files. That might be more straightforward, although you’re already pretty much there with the API.

You might need to do it with Invoke Code using some of this kind of vb.net code:

Creating pdf from Blob Field

[postwick (Paul)]

Some more info that might be useful.

https://social.msdn.microsoft.com/Forums/en-US/7d4f3b51-b321-495d-8e79-5564b2cd41a1/retrieve-blob-file-from-mysql-and-save-them-to-filesystem?forum=asporacle

[Gokul_Jayakumar (Gokul Jai)]

@vishesh.sharma.adtalem

Now in UiPath, I’ve used HTTP Request activity, which is giving same response in string. How do I save that string as a pdf file?

@vishesh.sharma.adtalem Try this
In properties, Filename For response add with Extension of .pdf

Environment.CurrentDirectory+"\APIoutput.pdf"        --> PDF file saved in Project loaction

[vishesh.sharma.adtalem (Vishesh Sharma)]

@Gokul_Jayakumar Yeah, that’s working. I’m able to save the response as PDF file. Thank you so much

[Gokul_Jayakumar (Gokul Jai)]

@vishesh.sharma.adtalem
Pleasure is mine

Also, you can pass the file path or API as a dynamic
Refer to this

Dynamic endpoint in HTTP Request

Assign 1: initialURL = "https://www.google.com/search?q=" [image] Assign 2: variableToSearch = "marian%20platonov" [image] Assign 3: finalURL = initialURL + variableToSearch [image] Don’t configure the dynamic URL in the Configure Editor. Leave it empty. Then you can configure manually the HTTP Request activity Properties section. Example and results: [image]

Happy Learning
Happy Automation

Regards,
Gokul Jai