Fetch XML - Querying DocumentBody and Displaying Full Image

Question

Hello All Overflowers!

Hoping you can help me out here. I am writing a report on D365 ONLINE 9.0, and I am almost just about done. The basic layout of the report is:

7 Total Data Sets

WorkOrder

WorkOrderProduct

WorkOrderService

ServiceAccount

BillingAccount

CustomerSignature

TechnicianSignature

All of these data sets relate back to Work Order.

For CustomerSignature, I need to grab a specific note, grab its attachment, and then pull it into my report; this is my Fetch query to accomplish that (which, the fetch works swimmingly, as tested in both VS and FetchXML Tester (XRM Toolbox)):

    <fetch mapping="logical" version="1.0" distinct="true" output-format="xml-platform">
  <entity name="msdyn_workorder" enableprefiltering="true" prefilterattributename="@msdyn_woid">
    <attribute name="msdyn_name" />
    <attribute name="createdon" />
    <attribute name="msdyn_workorderid" />
    <order descending="false" attribute="msdyn_name" />
    <link-entity name="annotation" to="msdyn_workorderid" from="objectid" alias="af" link-type="inner">
    <attribute name="documentbody" />
      <filter type="and">
        <condition value="customerSignature" attribute="subject" operator="eq" />
        <condition value="@msdyn_woid" attribute="objectid" operator="eq" />
      </filter>
    </link-entity>
  </entity>
</fetch>

When I validate my Fetch, I am returning a result. The document body of the target record is as follows:

<af.documentbody>iVBORw0KGgoAAAANSUhEUgAAAjkAAAGnCAYAAABVb0bDAAAABHNCSVQICAgIfAhkiAAAIABJREFUeJzt3e112tq2h/GZO853KRUgKgAqQFQAVICoAKgAUYGhAkQFlitArgClAq9UYKWC3A858nFiLUmA3nl+Y+xxz0VsWzux4c9cc8317ffv378FAACgY/6v7hsAAAAoAyEHAAB00n/qvgHgEby+vkoYhqKUkjAMJQxDiaLo7q9r2/aXxyzLEsuycj231+slPhcAuuAbPTlAccIwlB8/fohSSoIgEKWUKKXqvq2rxYHINE0ZDodi2zaBCEDrEHKAGyil5MePHx9VmbhC03Vx6In/sSxLxuNx3bcFAIkIOUCKKIrkx48ff1VlgiCo+7Yax7Ksv8LPYDCg6gOgdoQc4L/K6pt5ZLZtf1R84vBjmmbdtwXgQRBy8JDiQBMEwUewQTUsy5LZbCaLxUKGw2HdtwOgwwg56Ly4fyYONHUsN/V6vS+9LEW8wSf9t+ianXXP/fnz5933cSvLsmS9Xst0OmV5C0DhCDnonDqrNIZhfOxGirdyJ23dbro4EH1urH59fS31e9q2LY7jyHQ6ZUkLQCEIOeiE0+kkvu+L7/uVfc/xePxXVWY4HHb+zflzz1LcjF1GJchxHJnNZjKdTgv/2gAeByEHraWUktPpJJ7nlVqtGQwGH2Hmc4UGf0RR9GUrfVFVH9M0xXEc+ncA3ISQg9YJguAj3BSprL6ZR/V5l1r8zz1VH/p3AFyLkINWiKJIXl5eZL/fFzJ0zzCMj+3Ntm23sm+mjZRS4vu+eJ4nP378uPnr0L8DIA9CDhpNKSWHw0E8z7trZs1gMPgr1FAJqF8YhuJ5nvi+f1eFh/4dADqEHDTSy8vLxxvgtajStE/cNO77vvz69eumr0H/DoB/EXLQGFEUyel0kv1+f1Mj8Xg8FsdxxHGcwu8N1Yii6CPsvLy83Px16N8BIELIQQOEYSiHw0F83796ScowDJnNZuK6Lm9mHUP/DoB7EXJQm3iH1C0TiHu9nqzXa3EchzeuB0D/DoBbEHJQqXtn20ynU1mv1/TZPLCi+nfW67Vst9uC7w5AkxByUIl7ZtsYhiGO48h6vWZJCh+K6N8ZDodyPB5pVAY6ipCD0tw722YwGHwsSQFp7unfMU1TXNeV1WpV0t0BqAshB4WLokgOh4Ps9/ubZtssFgtxHIclKdzk1v4d27bl+fmZHi+gQwg5KNTpdJL1en11uOn1eh9LUrzJoCjX9u+YpinH41Fms1kFdwegbIQcFCIIAtlsNlcvSzHbBlWI+3c8z8t1eKjjOPL09ETgBlqOkIO7KKVks9lcNZmY2Tao036/F9d1Mys7lmXJ8Xhk2RRoMUIObhL33bium/vfYbYNmkIpJbPZLFeTsuu6bDUHWoqQg6td23czHo/FdV0+EaNxXNeV3W6X+TyakoF2IuQgt2v7bgaDgez3e8INGi0MQ5nNZpk7sZipA7TP/9V9A2g+pZTM53OZTCa5Ao5hGHI8HiUMQwIOGm84HEoYhplzcsIwlMlkclX/GYB6UcmB1i19N9vtlm3gaC3f98VxnMym5P1+z/BAoAUIOUh0bd/NdDqV/X7Pbim0XhRFMpvNMreaO44jx+OxorsCcAuWq/CXIAhkNBqJ4zi5As5gMJDz+Sy+7xNw0AmmaUoQBJmVGs/zZDQa3TTVG0A1qORARK6fd2MYhuz3e4b4odM8z5Plcpn6HNM05Xw+05AMNBCVnAcXRZHsdjvp9/u5A852uxWlFAEHnec4jlwuFzEMQ/ucKIpkMpmI53nV3RiAXKjkPLDdbnfVIZr03eBR5R0eyOBAoFkIOQ/odDqJ67qilMr1fObdAH8qNuv1Wk6nU+rzZrOZHI9HdhgCDUDIeSBBEMhyucwdbui7Ab7KMyV5OBzK8/MzVU+gZoScBxAEgex2OwmCIPe/w7wbQM/zPFmv16nzdGhIBupHyOmwW04Ip+8GyCfv</af.documentbody>

But, when I render the report, it appears only the top 1/5th (or so) of the image is actually being displayed. I am wondering if there is some escape character inside the DocumentBody return variable (above), or something else that may be causing my issue? When I download the attachment directly from D365, the image is not corrupted - and is displayed in full.

Here is a snapshot of the image that is rendered within the report. As you can see, it is not fully rendered:

The Image control in my report is configured as:

Image Source: Database

MIME Type: image/png (all signature files are default saved as .png via Resco/FS Mobile app)

Use this Field: =First(Fields!af_documentbody.Value, "CustomerSignature")

For what its worth (likely nothing) - I am pulling the signatures in from the Field Service Mobile app.

Any ideas as to why this is failing? Has anyone faced this issue and overcome it in the past?

Thanks in advance!

I have found a workaround online, and will start doing some analysis on the query results, but if you remove the "distinct=’true'" element from the first line of code, the image is being returned properly. I do not think this is the BEST way to solve it, as I envision distinct = true has some bearing on the results. I will check this over the coming days and reply to see if I found a better method, or verified that the query is unaffected. — Brian Frick, Apr 30 '18 at 21:14
Yes, I would suggest that this is a duplicate of that question. I was unable to locate it while searching yesterday - and I felt my post actually has more detail (if less visibility) into the issue. Feel free to close this as duplicate, if necessary. Thanks. — Brian Frick, May 01 '18 at 13:43

Fetch XML - Querying DocumentBody and Displaying Full Image

0 Answers0