double check if file exists in S3 bucket directory

Question

Post reply

double check if file exists in S3 bucket directory

Siten0308

SSCarpal Tunnel

Points: 4404

February 16, 2021 at 11:22 pm

Go to Answer

#3845883

Hello,

I did google this, and not sure if I am doing it right or maybe just missing one minor thing, I am just trying to verify if the file exists in S3, if so, great, if not, then... I will figure something out 😉

for now I have the following code:

$DBList = Invoke-SQLQuery -Query $GetDBList.ToString() -QueryParameters $QueryParams


#Just a heads up, the $DBList just pulls 4 columns array:
#Databasename, Database backup file that i trim to get from Database Path, What environment, and ServerName

$s3Bucket = "S3"

ForEach ($DB in $DBList)
{
    #Check which region will determin the bucket:
    if($DB.Environment -eq 'Prod'){
        $s3Bucket = 'S3-Prod'
    }
    elseif($DB.Environment -eq 'Test')
    {
        $s3Bucket = 'S3-Test'
    }
    else
    {
        $s3Bucket = "S3-BlackHole"
    }

    $s3Path = $DB.Environment + '/'  + $DB.Servername + '/' + $DB.databasename + '/FULL'# + $DB.DBFileName

    if(Get-S3Object -BucketName $s3Bucket -Key $s3Path | where{$_.Key -eq $DB.DBFileName}){
            "File found " + $DB.DBFileName
        }
    else{
            "File NOT found " + $DB.DBFileName
     }
    
}

for some reason, I double check and I know for sure the files are there in the S3 bucket, in the specific directory, however when i run this PowerShell script above, it doesn't work, not sure what i am doing wrong? if anyone can assist in this, it would be awesome.

thanks in advance

Siten0308

SSCarpal Tunnel

Points: 4404
More actions
February 23, 2021 at 8:48 pm
Answer
#3849206

got it working now,:
this helped below.
https://blog.revathskumar.com/2018/02/nodejs-list-s3-directories-with-aws-sdk.html

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Site Owners SSC Guru Points: 80320 More actions · Answer 1

Thanks for posting your issue and hopefully someone will answer soon.

This is an automated bump to increase visibility of your question.