25
Has anyone written custom FetchXML reports in CRM to display errors from users doing file imports? How would you create such a report, which entity and fields, and what criteria did you use - or would I use to get just the File-Import errors?
Hi Richxyz1,
Are the Imports logs what you want ?
https://www.marksgroup.net/blog/dynamics-365-troubleshoot-import-issues/
If so, I found that these records are stored in importlog entity:
https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/entities/importlog
Then I build such fetchXML query in SSDT:
<fetch mapping="logical" version="1.0">
<entity name="importlogs">
<attribute name="logphasecode" />
<attribute name="sequencenumber" />
<attribute name="errordescription" />
<attribute name="errornumber" />
<attribute name="headercolumn" />
<order attribute="headercolumn" />
<order attribute="sequencenumber" />
<filter>
<condition attribute="headercolumn" operator="not-null" />
</filter>
</entity>
</fetch>
However, it seems that errornumber property has a different format compared with it in system view,
and data in errordescription field are null.
Currently there are only Sample data imports in my environment, you could test my query in your own environment to test whether you could see error description field/property.
Regards,
Clofly
Share
Report
All responses (
Answers (
