[SalesForce] associate File With Custom Object but getting Error

I am trying to create new File through ContentVersion and Associating it with Custom Object ParentId is ID of Custom Object .

Error given is
Document: You cannot create a link for a document in a private library.

EXCEPTION_THROWN [356]|System.DmlException: Insert failed. First exception on row 0; first error: FIELD_INTEGRITY_EXCEPTION, You cannot create a link for a document in a private library: [ContentDocumentId]

Following is my Code ,

        public ID createFileFromUploadedFile(Id parentId) {
        ID docID = null;
        ContentVersion cv = new ContentVersion();
        cv.versionData =  file.Body;
        cv.title = file.FileName;
        cv.pathOnClient = file.FileName;
    insert cv;

    docID = cv.id;
        ContentVersion currentDoc = [SELECT ContentDocumentId from 
                                     ContentVersion  where id =:docID];
        docID = currentDoc.ContentDocumentId;
        ContentDocumentLink cdl = new ContentDocumentLink();
        cdl.ContentDocumentId = currentDoc.ContentDocumentId;
        cdl.LinkedEntityId = parentId;
        cdl.ShareType = 'S';
        insert cdl;

    return docID;
}

Best Answer

You should add location for the file (the library), I use ContentLocation for creating my ContentVersion:

    ContentVersion cv = new ContentVersion();
    cv.ContentLocation = 'S'; // S = within Salesforce, E = External
    cv.VersionData = body;
    cv.Title = fileName;
    cv.PathOnClient = filename;

    insert cv;

Related Solutions

[SalesForce] Not able to create ContentDocumentLink from sforce ajax

Please find my below code: -

   <apex:page >
 <script type="text/javascript">
        var __sfdcSessionId = '{!GETSESSIONID()}';
    </script>
    <script src="/soap/ajax/33.0/connection.js" type="text/javascript"></script>
    <script src="/soap/ajax/33.0/apex.js" type="text/javascript"></script>
<script type="text/javascript">
    function CreatecontentDocumentLink()
    {          
            var contentDocumentLink = new sforce.SObject('ContentDocumentLink');//Initialize the contentDocumentLink
            contentDocumentLink.ContentDocumentId = '06990000001zDCnAAM'; //Document Id
            contentDocumentLink.LinkedEntityId ='00690000002FBX2';//Linked Object Id , in My case it is opportunity record Id
            contentDocumentLink.ShareType = 'V'; //Required. The permission granted to the user of the shared file in a library. This is determined by the 
                                                    permission the user already has in the library. This field is available in API version 25.0 and later.
                                                    V
                                                    Viewer premission. The user can explicitly view but not edit the shared file.
                                                    C
                                                    Collaborator permission. The user can explicitly view and edit the shared file.
                                                    I
                                                    Inferred permission. The user’s permission is determined by the related record. For shares with a library, this is defined by the permissions the user has in that library.
            results = sforce.connection.create([contentDocumentLink]);
            alert('results---------'+results);
    }              
</script>
<apex:form >
<apex:pageBlock >
<apex:pageBlockButtons location="bottom">
<apex:commandLink styleClass="btn" style="text-decoration:none;padding:4px;" value="New Case" id="clink" onclick="CreatecontentDocumentLink(); return false;"/>
</apex:pageBlockButtons>
</apex:pageBlock>
</apex:form>
</apex:page>

The code is running perfectly. Just check below things : - 1. version of API 2. then check share Type. 3. After that the permission on object record.

[SalesForce] Content Document Link: FIELD_INTEGRITY_EXCEPTION, Document with ID: * is already linked with the entity with ID: *: Linked Entity ID:

You need to put a check to verify if ContentDocumentLink records exist before putting it into final list ContentDocumentList. Logic will be like this.

trigger ContentVersionTrigger on ContentVersion (after insert) {
    if(!TriggerRunOnce.hasAlreadyfired())
    {
        List<user> users = [select user.id, user.Email, user.FirstName, user.LastName, user.profile.name, user.Username, user.IsActive 
        FROM user, user.profile 
        where user.LastName IN ('***','***') and user.IsActive=true];
        Set<Id> contentDocumentIdSet = new Set<Id>();

        for(ContentVersion cv:trigger.new)
        {
            if(cv.ContentDocumentId != null)
            {
                contentDocumentIdSet.add(cv.ContentDocumentId);
            }
        }

        List<ContentDocumentLink> lstContentDocumentlink = [SELECT ContentDocumentId, LINKEDENTITYID 
                                                            FROM ContentDocumentLink WHERE ContentDocumentId IN:contentDocumentIdSet];


        List<ContentDocumentLink> ContentDocumentList = new List<ContentDocumentLink>();


        for(ContentVersion cv:trigger.new)
        {
            system.debug('at 5 '+cv);
            if(cv.ContentDocumentId != null && !lstContentDocumentlink.contains(cv.ContentDocumentId))
            {
                for(user u:users){
                    if(u.Id != cv.OwnerId){
                        ContentDocumentLink cdl = new ContentDocumentLink(ContentDocumentId=cv.ContentDocumentId,LINKEDENTITYID = u.Id,SHARETYPE='C');
                        ContentDocumentList.add(cdl);  
                    }
                }
            }
        }

        insert ContentDocumentList;
        TriggerRunOnce.setAlreadyfired();
    }
}

Best Answer

Related Solutions

[SalesForce] Not able to create ContentDocumentLink from sforce ajax

[SalesForce] Content Document Link: FIELD_INTEGRITY_EXCEPTION, Document with ID: *** is already linked with the entity with ID: ***: Linked Entity ID:

Related Topic

[SalesForce] Content Document Link: FIELD_INTEGRITY_EXCEPTION, Document with ID: * is already linked with the entity with ID: *: Linked Entity ID: