Robotic Process Automation

Expand all | Collapse all

System Queue

  • 1.  System Queue

    Posted 10 days ago
    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 9 days ago
    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 2 days ago
    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
    ------------------------------



  • 4.  RE: System Queue

    Posted 9 days ago
    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
    ------------------------------



  • 5.  RE: System Queue

    Posted 8 days ago
    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
    ------------------------------



  • 6.  RE: System Queue

    Posted 4 days ago
    Thanks Vinicius

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