Expand my Community achievements bar.

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