1. Run one of the following query

• if the HEAD revision needed
  

  select ref.to_id as file_id from object_reference ref
         inner join object association on ref.assoc_id=association.id and association.deleted=0
  where ref.from_id=:artifact_id

• if a specific revision needed
  

  select ref.to_id as file_id from object_reference ref
         inner join object artifact on ref.from_id=artifact.id inner join object_revision artifact_rev on artifact.id = artifact_rev.object_id
         inner join object association on ref.assoc_id=association.id inner join object_revision association_rev on association.id = association_rev.object_id and artifact_rev.created_at=association_rev.created_at and association_rev.revision=1
  where ref.from_id=:artifact_id
  and artifact_rev.revision=:artifact_revision

2. Note the result file_id and compose the relative path to the file from the docs repository folder by divide the result by 1000. The integer part will be the main folder and the fraction part will be the sub folder. From the docs repository entering the main folder and the sub folder. The artifact content can be found there in a file named 1. Example: if the result file_id is 45678 then the path to the artifact content is: <docs_repository>/45/678/1