How to create excel file from json response

[Namrata_Butch]

Hello,
I have invoke a REST API and able to deserialize the JSON.
My response is having inputstream/blob
I want to generate xlsx file out of this response. How can I create it?

[Srini84 (Srinivas Kadamati)]

@Namrata_Butch

Check below link for your reference

Convert database BLOB (excel/word/..) for saving to local file system

I created a ticket in the UiPath techical support and got this solution, that works splendidly! Create a memory stream variable (Variable type System.IO.MemoryStream), call it memoryStreamdoc. Then, connect to DB and execute query that returns a datatable, where one column is of type BLOB. Loop through each myRow (row) in the datatable Within the loop: Create an assign: memoryStreamdoc=new memoryStream(CType(myRow.item(1),System.Byte())). You need to replace the myRow.item(1) with t…

Hope this helps you

Thanks

[Cristian_Negulescu]

Hello Namrata,
In this video I do a lot of stuff with JSON (Chapter included) :

UiPath Tutorial for JSON Parsing and Creation | 8 UseCase

0:45 Install Deserialize JSON
1:10 Present all types of JSON that will use
1:35 Deserialize simple JSON
2:50 Deserialize a JSON with an Object inside
3:55 Deserialize a JSON with Array inside
6:00 When we use Deserialize JSON Array activity
7:00 Deserialize a JSON with a List of Strings inside
9:45 Create a simple JSON
11:05 Create a JSON with an Object inside
12:17 Create a JSON with Array inside
14:05 Create a JSON with a List of Strings inside
15:55 Datatable to JSON
17:50 JSON to Datatable

Thanks,
Cristian Negulescu