Excel To Json

[AutomationGeek]

Hey Guys,

I am designing a workflow in which i am trying to send Excel data Name, Email, Password to an Api which accepts Json So how can I convert Data table To Json. Can Anyone Help ?

Here I am attaching my Excel Data Image and my Flow.

Thanks in Advance 🙂

[TechAdmin]

Can You Please Share Your .xaml File ??

[AutomationGeek]

Sure Here I am Attaching my xaml file and sample data excel file

[TechAdmin]

Hi @AutomationGeek  We are here with your solution

 

There is one Acitvity Package present in UiPath named as “ActivitiesDatatble”

by which you can perform four type of operations

1. Datatable From Json
2. Datatable To Json
3. Datatable From XML
4. Datatable To XML

So here we can use “Datatable To Json”.

Here is Your Output will look like.

I am Attaching the Answer Xaml file Zip with this Reply.

[ManojSinha12]

Hey !! Nicely explained.

 

[Author]

Posts