Export static worksheet with dynamics 365 web api

(0) Share

Report

Posted on by Randy Marsh

Is it possible to download static worksheet via dynamics 365 web api?

I know that you can export saved view to a Office Excel static worksheet, but is it possible to download exact same worksheet via Dynamics 365 web api?

You can get it in JSON format by sending GET request:

https://{domain}/crm/api/data/v8.2/{entity logicalname}?userQuery={user query guid}

After that you can surely convert JSON to excel file. I don't like this approach because before converting JSON to excel file i have to go through every lookup attribute (if any) and find display name for that attribute.

CRM info: version 8.2 on-premises