30 Jun’19

UncategorizedHow to Retrieve Complete Image and not the Truncated one

While fetching images using fetch xml there is a possibility that you will not able to get the complete image. You will also notice that this issue generally happens when you are using the multiple internal entities.


We were working on a project where we displaying the records notes using the multiple entities, we noticed that it is not showing the complete images, but it is truncated or incomplete.

Let’s see the actual query and the output

Scenario 1:

In the below query we are getting the incomplete images as a base 64 string


Scenario 2

In the below fetch xml we are getting complete image.

If you will closely look into the query distinct parameter for the first was true where as in second case it was false.


Hope this helps you to retrieve complete image and not the truncated one

Written by

Team Member


Leave a Reply

Your email address will not be published. Required fields are marked *

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Introduction to Microsoft Dynamics Commerce Tools

    19 October’ 2019

    As we know, Dynamics 365 Commerce is released in the preview version, So in this blog, we will have a quick explanation ...

    Read more
  • Error Handling Approaches for Integration

    16 October’ 2019

    Introduction: Handling Errors is a best practice in Integration when integrating to keep a track of the Errors that occu...

    Read more
  • Change in URLs for Business Central Tenants

    16 October’ 2019

    Change in base URLs for Business Central SaaS Tenants. I have noticed the Business Central links for Tenants have chan...

    Read more
  • Record Deletion Tool in Business Central

    16 October’ 2019

    Introduction: After a successful Go-Live in Business Central, we somehow need to delete a record from Backend. There is...

    Read more
  • Error “A reference to ‘xyz ‘ is required to compile this module” solution

    10 October’ 2019

    Many of the time while building project/solution we came across the “reference is required to compile this module ...

    Read more
  • We respect your privacy.
  • This field is for validation purposes and should be left unchanged.