Unanswered

SDK/API available for Excel export/import

(0) Share

Report

Posted on by Suchism Microsoft Employee

If we want to build a custom UI with CDS as backend and implement excel import/export functionality (as in model-driven app), does the CDS sdk/api have support for the same?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

David Jennaway 716 on at

Like (0)

Report

The API supports data import - see https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/data-import-entities as a starting point. However, there's no equivalent for the export functionality

Was this reply helpful? Yes No
Suchism Microsoft Employee on at

Like (0)

Report

Thanks @DavidJennaway for your response ! I was looking more in terms of how its from the Model-Driven UI , for example given the View name the api/sdk method should be able to export the records to excel file and upon updating the excel importing back , the api/SDK method should write it back to the entity.

Was this reply helpful? Yes No
David Jennaway 716 on at

Like (0)

Report

There is no documented functionality available in the API to export records to Excel. It might be possible to find out what calls are made in the model-driven UI to export to Excel, and to replicate these, but as they are not documented, this approach would be unsupported.
The import functions in the API (as per my previous post), should work for importing from Excel, but the problem you have is that you'll need to have generated the Excel file in exactly the format that CDS expects

Was this reply helpful? Yes No
Joel CustomerEffective 3,224 on at

Like (0)

Report

something like this may work https://dreamingincrm.com/2016/11/10/export-to-excel-using-dynamics-365-sdk/, and you could also look at how Natraj does it in his XrmToolBox tool https://github.com/rajyraman/mscrmexporttoexcel

Was this reply helpful? Yes No