Robotic Process Automation (RPA)

 View Only
  • 1.  System Queue

    Posted Wed October 13, 2021 09:30 AM
    Hello Team, We want to insert each DataTable row data into System Queue, We need column header as well, So, I've tried to Enqueue DataTable with single row but it doesn't work. Is there any other way in IBM RPA? Thanks for your help.

    Regards
    Saran

    ------------------------------
    Saran Perumal
    ------------------------------


  • 2.  RE: System Queue

    Posted Thu October 14, 2021 10:35 AM
    Hi Saran..

    You can't specify columns header when you enqueue records in a queue.

    What you have to do is :

    1) Create the Queue
    2) COnnect to your queue using the commando "Connection to Queue Server System"
    3) Enqueue the records using the command "Enqueue" and your JSON variable which contais your datas.

    It must work.

    REgards.

    ------------------------------
    Eduardo Gameiro
    ------------------------------



  • 3.  RE: System Queue

    Posted Thu October 14, 2021 05:19 PM
    Hi Eduardo, 
    Thank you very much for your reply. I did create Queue and COnnection to Queue Server System. Is there anyway to convert DataTable (collection) to JSON? I can see a command to convert JSON to DataTable. Thanks

    Regards
    Saran


    ------------------------------
    Saran Perumal
    ------------------------------



  • 4.  RE: System Queue

    IBM Champion
    Posted Fri October 15, 2021 08:52 AM
    Hi Saran!

    I believe you would have to define the structure of the JSON (key-value pairs) yourself, defining the JSON string you want to enqueue in a "for each row" loop. Maybe you could even define the columns dynamically but it probably would have to be done on a loop as well.

    Regards,

    ------------------------------
    Vinicius Marques
    ------------------------------



  • 5.  RE: System Queue

    Posted Tue October 19, 2021 03:36 PM
    Thanks Vinicius

    ------------------------------
    Saran Perumal
    ------------------------------



  • 6.  RE: System Queue

    IBM Champion
    Posted Fri October 22, 2021 10:41 AM
    Just saw this on the Ideas portal and it might be interesting to you: https://dba.ideas.ibm.com/ideas/WDGRPA-I-114

    Seems that if it were already implemented it could help in your use case as well.

    ------------------------------
    Vinicius Marques
    ------------------------------