I want to read data from an entity in the data service and return the data as a data table. Is there a way to do it with a ready-to-use activity or something?
I know, we could always build a data table with the custom columns, and read the records object with a for each loop, and populate the data table. But since I want to do this across several entities, I am looking for an easier way to do this with a single reusable activity. I looked in the DataServices Package but it does not have any activity like this. @sudheern ? @Vibhor.Shrivastava@Lahiru.Fernando
It is a list of the entity. If your entity is called “employee” then it is a list of employees. If the entity is “department”, then it is a list of departments and so on.
I spent some more time on this topic later and I think the way the uipath data service entities are designed, it does not lend itself to convert them into any other variable, including datatable. Each entity is a data type by itself and that is not a datatable data type. I know it is not convenient and I hope UiPath changes it in the future. What good is a relational database, that cannot be ported to other forms?
@UiPath_Community, Not sure if anyone from UiPath itself got a chance to look into this. So many people are interested in being able to convert an entity into a datatable. Both are after all two dimensional and represent data.