Is Possible to extract values from Dataservice(Entities) into Excel

[raja_ias (PALANIRAJA PARAMAN)]

I want to extract all my values from dataservice into excel…

[Gokul001 (Gokul Balaji)]

Hi @raja_ias

You can try with Data scrapping method to extract the values

Export data service list into a excel sheeet

Hello @Karan, the XAML that you uploaded here, shows some error(“The activity is missing”) after I downloaded it, can you help me with a new XAML.

Studio - Example of Using Data Scraping

Regards
Gokul

[supermanPunch (Arpan)]

Hi @raja_ias ,

There is an Example of using the fields from the Data Service in the below Documentation. With the help from below documentation, You should be able to retrieve each field as needed and add it to a Datatable as a Datarow and then Write the Datatable to an Excel.

The below Post should be the most appropriate one :

Export data service list into a excel sheeet

Hi @langsem, you can accomplish this via a process that uses the Data Service activities. To export data to an excel sheet, you will need to: Build a data table with the fields you’d like to capture from the entity Use the query entity records activity to get the list of records that you’d like to export from Data Service Note: If you have more than 1000 records, you will need to implement logic for pagination For each record in this list, create a Data Row and add it to the Data Table creat…

Let us know if you are already working with the Data Service and have a Process ready or do you need assistance with it as well.