topic RE: Covert Json Response to Required Data Formats in Product Forum

Covert Json Response to Required Data Formats

vinodchinthakin — Wed, 07 Jul 2021 05:15:00 GMT

Hi All,

I would like to convert Json response to required data formats.

1. I am using an API, which compresses image and output response will be in Json(Text) format. How can I convert Response content into Image(Binary) data type?
2. I am using an API which converts HTML to PDF and output response will be in Json(Text) format. How can I convert response content into PDF(Binary) data type?

Note: we have utility JSON which helps in converting Json to Collection. But we need to convert Json to other formats, do we have any Assets or Codes for that?

Any suggestions!
Thanks in advance.
VINOD

------------------------------
vinod chinthakindi
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Wed, 07 Jul 2021 05:32:00 GMT

Hi Vinod,

If you can share examples for both then it will be helpful to look into possible solutions.

For 1 - Does the JSON has a base64 encoded text?
For 2 - Does the JSON has any server path to the PDF file?

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Covert Json Response to Required Data Formats

vinodchinthakin — Wed, 07 Jul 2021 06:36:00 GMT

Thanks for quick reply shashank.

Pls find below screenshots.

1.find response content. We dont see any base64 encoded text

2. there is no any server path to the PDF file

Query: If the output of the API response is Image/PDF, how can we download/store in local system from API?

------------------------------
vinod chinthakindi
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Wed, 07 Jul 2021 06:47:00 GMT

Hi Vinod,

1 - This seems to be in binary format. What does the API documentation say? Utility - HTTP has an action called HTTP Request File which you can use for this.

2 - What does the API documentation say about the response body and response content? If it's binary already(which seems likely to me) then you can use the same action HTTP Request File

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Covert Json Response to Required Data Formats

vinodchinthakin — Wed, 07 Jul 2021 12:53:00 GMT

Hi shashank,

API documentation doesn't says anything on API response.
I don't see any HTTP Request File in HTTP Request VBO.
Can you name the action and inputs params to be provided?

------------------------------
vinod chinthakindi
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Thu, 08 Jul 2021 04:39:00 GMT

Hi Vinod,

You can download the latest version of HTTP Utility from DX https://digitalexchange.blueprism.com/dx/entry/3439/solution/utility---http

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Covert Json Response to Required Data Formats

vinodchinthakin — Thu, 08 Jul 2021 09:46:00 GMT

Hi Shashank,

I tried with HTTP Request file by passing URL and method, but getting an error "empty path is not legal"

------------------------------
vinod chinthakindi
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Thu, 08 Jul 2021 09:51:00 GMT

Hi Vinod,

Did you pass the FilePath in the input parameter?

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Covert Json Response to Required Data Formats

vinodchinthakin — Thu, 08 Jul 2021 10:09:00 GMT

Yes I included Url of File within API for testing
http://api.pdflayer.com/api/convert?access_key=access_key&document_url=https://pdflayer.com/downloads/invoice.html&secret_key=secret_key

------------------------------
vinod chinthakindi
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Thu, 08 Jul 2021 10:17:00 GMT

Hi Vinod,

FilePath is another parameter in the action. This is the pdf file path where the binary data response from the API will be written into. For example - C:\myfile.pdf

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Covert Json Response to Required Data Formats

vinodchinthakin — Thu, 08 Jul 2021 10:28:00 GMT

After including file path getting an error "No conversion available from Text to Collection"

------------------------------
vinod chinthakindi
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Thu, 08 Jul 2021 13:24:00 GMT

Must be something wrong on your end. Screenshot would help to debug. Check the data type of the output parameters that you have configured.

Just ran a test and it worked. I had passed URL, method and FilePath only.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Covert Json Response to Required Data Formats

vinodchinthakin — Fri, 09 Jul 2021 12:33:00 GMT

Hi Shashank,

Issue got resolved. Basically process got corrupted. I tried same action in a new process, it worked.
Can we handle same thing in API, by writing some code. Do you have any code for that?

------------------------------
vinod chinthakindi
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Mon, 12 Jul 2021 02:50:00 GMT

Hi Vinod,

Current implementation of WebAPI doesnt support binary responses. Utility - Http is the way to go for such scenarios.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------

RE: Covert Json Response to Required Data Formats

Amruthasimplify — Mon, 13 Mar 2023 05:31:00 GMT

Hello Shashank,

I appreciate your feedback.

I have come across the same situation where I am receiving a binary response for a PDF file as text via Web Api and I need to download/store this pdf in local system. Following your advice, I attempted to resolve the issue using HTTP Request File VBO, but I encountered an error. Interestingly, I received a binary response in Postman and a binary as text response in WEB API using the same input configuration, indicating that there is no authentication issue. I have included screenshots for your reference.

I would greatly appreciate your assistance and guidance in resolving this issue.

------------------------------
Amrutha Sivarajan
------------------------------

RE: Covert Json Response to Required Data Formats

shashank.kumar280 — Mon, 13 Mar 2023 11:03:00 GMT

HI @Amrutha Sivarajan

If you could post a screenshot from POSTMAN that would be useful to pinpoint the issue.

------------------------------
Shashank Kumar
DX Integrations Partner Consultant
Blue Prism
Singapore
+6581326707
------------------------------