Export Transaction Output from Queue

orchestrator
activities
studio

#1

Hello,
I have a project in which I used the queue to do large scale data gathering using multiple bots through orchestrator. I had the scraped data put into the output for the transaction, but now I do not know how to get that data out of the transaction’s “output data” and into a spreadsheet.
I specifically need it to pull the output data from each Successful transaction, add it to a datatable, and then write the datatable to a csv.
The “specificContent” method does not seem to work.
Thank you!

transaction|690x115


#3

Thank you, @Divyashreem, for the response. However, I’m not trying to read the contents of and excel spreadsheet. I am trying to put the output data from the transaction queue into an excel spreadsheet.


#4

Sorry this post was not for this particular query, i had withdrawn the post and i dont know still how you are able to see that:|


#5

Specific Content method should work! What error is it giving?
Use a get transaction item activity…in the queue name pass the name of queue,
Then using thatvariable.SpecificContent(“Name”) you should get your information!


#6

We can see the withdrawn answers by clicking on the pencil icon on the top right corner :stuck_out_tongue:


#7

@Niket_Ghai, thank you for your response. The reason I cannot use “get transaction item” is because I am trying to get the output out of completed transactions that are set to “success,” and therefore when I try “get transaction Item,” it gives me an error that there are no transaction items to read. If I try to use “get queue item” with the SpecificContent command it tells me that SpecificContent is not a part of an IEnnumerable type.