Hello,
I’m pretty new working with Integration services and manual triggers in Studio Web.
How do i get this format into a data table so i can create queues? Should i open in Studio desktop and build a data table from there?
Here is where i’m stuck now.
You dont need studio desktop to do this. You can do it on cloud only.
Drag “Build datatable actiivty”, then define columns in it. Then using add datarow you can add the data… Then using for each row in datatable, add queue items.
build datatable is not available for cross platform
you can still create one using generate datatable from text and give your columsn in comma separation..
cheers
Hello @carlos.henrique
If you are referring as to where you would setup a scheduled run of your RPA Workflow, and not the data type datatable itself, then you should publish your workflow to Orchestrator.
Then within Orchestrator you are able to define Triggers for when it should run.
This could be based on different actions - receiving a mail, creating a file - or simply time.
Regards
Soren
Hi Anil.
I was able to get an array to work. But how do I get the output from the trigger result and put in a format that add to queue will work? The output format on the trigger doesn’t looks like a classic Json file. It shows a dropdown Curated opportunity A. And if i have more than one record, it shows Curated opportunity B and so on. Actually, every value in the output, it’s a variable.
It would be like a json array right?
so you can loop on array and get each set
cheers
Hi Anil.
Take a look at my screenshot. It doesn’t looks like a Json array. I get a Json array if i use the API workflow, but using an RPA workflow i get this format that looks like one variable to each value on the output.
if you do mainvariable. is it not showing you the values
can you click on the type of the variables..looks like they are like properties of that variables so should be accessible
cheers
I asked Co-pilot which kind of variable was that. Here is the response.
the variable type shown in your screenshot is a custom class generated by UiPath Integration Service for the Dynamics 365 trigger.
Here’s what’s happening:
opportunities_TriggerUiPath.IntegrationService.Activities.Models under the hood.new UiPath.Integrat... indicates it’s a class instance.opportunityid, name, statuscode, etc.).So, it’s not a JObject or Dictionary—it’s a strongly typed object generated from the Dynamics 365 connector metadata.
So are the types coming with name of your keys?
if yes is there a pattern for key?
strong type is what it generates yes. but for every strong type there would be some methods to convert…to explore methods
take the outputvariable and type in the expression editor and then hit a dot after it ..if there are any methods we can check and use them
cheers
exactly…try to use select or where to get specific itesm or filter etc..so can you tell whats the output values ..lets take one for now..do you need all acound ids?
or soemthign else?
cheers
I was able to extract from the key customer ID:
But how to get the information from opportunities B?
ideally the trigger will trigger for once for each oppurtunity..its not like you would get multiple..
as the steps would be same for any..you can use either.
cheers
What if the trigger more than one result? Let’s say by the interval the trigger will run we have two opportunities closed. Is there a way the RPA will process both?
I see.
On my debug tests, it only processes the first one. So what i need to do is create a datatable with the keys I extract from the trigger output?
yes what all values you need just store all those…the same process would trigger for each oppurtunity..you dont need to loop or do anything…even datatable if you need would be a single row datatable ..
cheers
Thank You Anil.
I’ll do more tests here and let you know the results. I appreciate all your help.
