Experience using SOQL query to pull a file from a SF Opportunity to Workfront? | Community
Skip to main content
aearle
Adobe Champion
Adobe Champion
January 22, 2024
Question

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

  • January 22, 2024
  • 1 reply
  • 1633 views

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}}

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

aearle
Adobe Champion
aearleAdobe ChampionAuthor
Adobe Champion
January 22, 2024

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

 

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:

aearle
Adobe Champion
aearleAdobe ChampionAuthor
Adobe Champion
January 23, 2024

SOLVED!

 

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

aearle
Adobe Champion
aearleAdobe ChampionAuthor
Adobe Champion
January 23, 2024

 Overall FLOW