Drawloop - How to get Images from Content Files

[#1]

Topic

How to get Images from Content Files on a records related list.

Instructions

*** Merging Images from content files is currently not a built-in managed feature. Below is a custom workaround using a custom formula field and SOQL.

1. Build a custom formula field on the Salesforce Files Object to form a URL to the Content document Image:

(Salesforce Lightning) Navigate to: Setup → Object Manager →Content Version →Fields & Relationships→ Add New Field → Type = Formula.
(Salesforce Classic) Navigate to: Setup → Build → Customize → Salesforce Files → Field → Type = Formula.



2. Create a formula field.
Formula for the URL field:

LEFT( $Api.Enterprise_Server_URL_100, FIND( ".com", $Api.Enterprise_Server_URL_100 ) + 4)& "sfc/servlet.shepherd/version/renditionDownload?rendition=THUMB720BY480&versionId=" & Id & "&operationContext=CHATTER"


3. Create the SOQL relationship in the DocGen Package:

Parent Object Files -SOQL: Copy Type = Table or Row
SELECT ContentDocument.LatestPublishedVersion.URL_Formula__c FROM ContentDocumentLink WHERE LinkedEntityId = '<<Parent_Object_Id>>' AND ContentDocument.FileType IN ('PNG','JPG','JPEG')


Table > Row Replicate Child Object - SOQL: Copy Type = Table
Select id, name, (SELECT ContentDocument.LatestPublishedVersion.URL_Formula__c FROM ContentDocumentLinks WHERE ContentDocument.FileType IN ('PNG','JPG','JPEG')) FROM Child_Object__c WHERE Parent_Object__c = '<<Parent_Object_Id>>'

** Please find the correct corresponding Child_Object__c & Parent_Object__c API names for your environment and the correct <<Parent_Object_Id>> tag.


4. Now the <<Tag>> The DocGen Template with the desired tags and behavior. Append ‘__image’ to the URL Formula Tag.
Image Documentation: https://help.nintex.com/en-US/docgen/docservices/#docgen-sfdc/Services/templates/AddImagesRichTextFi...

 Example below:

5. The expected result is the Images will replicate and populate in the output document based on the Image URL from the formula field.