Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

Experience using SOQL query to pull a file from a SF Opportunity to Workfront?

Avatar

Adobe Champion

I am attempting to use a SOQL search query from Salesforce to find a file attached to a Salesforce Opportunity "file". We are unable to pull the "ContentDocumentURL" without this query since the file is not technically associated with the Opportunity. 

 

select{{31.Id}}
from ContentDocumentLink
where LinkedEntityId={{14.Id}}

 

Screenshot 2024-01-22 at 11.59.06 AM.png

Screenshot 2024-01-22 at 11.59.58 AM.png

3 Replies

Avatar

Adobe Champion

Update here, I was able to figure out the SOQL, however, I am not sure what related record ID to use: 

Screenshot 2024-01-22 at 4.27.38 PM.png

Screenshot 2024-01-22 at 4.28.09 PM.png

 

But when I run the scenario it is not picking up the ID for Related Records ID in the upload action, it gives me the following error:

Screenshot 2024-01-22 at 4.31.14 PM.png

Screenshot 2024-01-22 at 4.31.29 PM.png

Avatar

Adobe Champion

SOLVED!

 

What was needed was the Project ID in the Related Record field and then leave the Folder ID BLANK

Screenshot 2024-01-23 at 3.01.18 PM.png