Home Forums UiPath Excel To Json

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #1695
    AutomationGeekAutomationGeek
    Participant

    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 🙂

    #1699
    TechAdminTechAdmin
    Keymaster

    Can You Please Share Your .xaml File ??

    #1703
    AutomationGeekAutomationGeek
    Participant

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

    #1708
    TechAdminTechAdmin
    Keymaster

    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.

    #1713
    ManojSinha12ManojSinha12
    Participant

    Hey !! Nicely explained.

     

Viewing 5 posts - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.