cancel
Showing results for 
Search instead for 
Did you mean: 

convert json to Excel/CSV

kirtish.trivedi
Level 5
Hi Community 

I am using HTTP advanced utility to POST a request

As a result I am getting json data. I wanted to check if we have any utility which will export this JSON data in csv format/excel format(rows and columns).

Thanks

------------------------------
Kirtish Trivedi
------------------------------
1 BEST ANSWER

Helpful Answers

Hi,

You can use the below steps to achieve your desired results:

1) Once you get the JSON data, use the 'JSON To Collection' action from 'Utility - JSON' VBO. It will return you a data table.

2) You can the pass this collection to 'Get Collection As CSV' action from 'Utility - Strings' VBO which will return you a text value with the parsed collection data.

3) Finally use the 'Write Text File' action from 'Utility - File Management' VBO where you can pass the CSV file path and the parsed collection data from the previous action.

In case you want to write data to an excel file, no need to follow step 2 and 3, instead use the Excel VBO actions in the order 'Create Instance', 'Create Workbook', 'Write Collection' and the 'Close Instance' with the Save As Flag as True

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.

View answer in original post

1 REPLY 1

Hi,

You can use the below steps to achieve your desired results:

1) Once you get the JSON data, use the 'JSON To Collection' action from 'Utility - JSON' VBO. It will return you a data table.

2) You can the pass this collection to 'Get Collection As CSV' action from 'Utility - Strings' VBO which will return you a text value with the parsed collection data.

3) Finally use the 'Write Text File' action from 'Utility - File Management' VBO where you can pass the CSV file path and the parsed collection data from the previous action.

In case you want to write data to an excel file, no need to follow step 2 and 3, instead use the Excel VBO actions in the order 'Create Instance', 'Create Workbook', 'Write Collection' and the 'Close Instance' with the Save As Flag as True

------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily

Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com

----------------------------------
------------------------------
---------------------------------------------------------------------------------------------------------------------------------------
Hope this helps you out and if so, please mark the current thread as the 'Answer', so others can refer to the same for reference in future.
Regards,
Devneet Mohanty,
SS&C Blueprism Community MVP 2024,
Automation Architect,
Wonderbotz India Pvt. Ltd.