Creating a url to a file located on S3 and fileID
We currently have External file storage enabled to have our files stored in s3. However, I know that these resources are still served over the acumatica instance url and go through the Acumatica security. However, we have a need to link to some of these resources directly from remote/3rd party systems. My plan is to have a direct s3 url/link to the resource, however, Acumatica stores the file as some sort of random object id. My question is if anyone knows where this fileID (Example below) comes from. We have looked in several tables that seem to have some relationship to uploaded files, but can't find anything that resembles this. If we were able to figure that out, we would be able to proceed with this strategy.
UPDATE: in case anyone else has the same question...I figured out that the UploadFileRevision table has a field called BlobHandler that stores the name that is used as the object id in s3. But need to keep in mind that even though the db stores the value in all uppercase, it's actually stored in s3 as all lowercase.