Export specific data from vault

@"Justin.Yoon_1P" -

Quick question for you: Why am I getting random errors like those pictured (there are others where it says something to the effect of errors with tcp to xxx.xxx.xxx.xxx [assuming 1password server], and others about secure key error or the software terminated [i will try to capture some of them but haven't yet])? I cannot make sense of it because I have gotten them even at the beginning of the script where its getting the $vaultdetails or $vaultitems.

Plus, is there a difference with --format=json and > --format json?

I will give yours a go here in a bit, I DID manage to get things SOMEWHAT working. I have removed the sleep statement in the foreach loop as I was testing it without it this time. I have approximately 4200 entries in this vault in particular I am needing to export from. Supports suggestion was to setup a 1password connect server, but I am not sure that it would work the way I want it to, and the cost for setting it up seems a bit much for the use it would get.

```
function Get-1passworditems {
[CmdletBinding()]
param (
[Parameter(Mandatory=$true)][string]$vault
)

#Create initial set of empty variables/arrays

    #Array for exporting the data to excel
    $results = @()

    #Vault details for worksheet name/id info
    $vaultdetails = @()
    $vaultdetailsconverted = @()

    #Summary items in vault - keys such as ID, type, name, etc
    $vaultitems = @()

    #Array for the $vaultitem records converted from JSON format
    $vaultitemsconverted = @()

#Start process of getting data
    #Get Vault Details
    Write-Host "Getting Vault info and item list" -ForegroundColor Green
    $vaultdetails = op vault get $vault --format=json
    $vaultdetailsconverted = $vaultdetails | ConvertFrom-Json
    $vaultdetailsconverted
    $vaultitems = op item list --vault $vault --categories Login --format=json
    $vaultitemsconverted = $vaultitems | ConvertFrom-Json
    Write-Host -ForegroundColor Yellow "Items in the data set to parse: $($vaultitemsconverted.count)"
#Start looping through the item details to extract username and password
    Write-Host -ForegroundColor Green "Starting to get item details"
    foreach($id in $vaultitemsconverted){
        $c++
        $obj = @()
        $item =@()
        $obj1 =@()
        $username = @()
        $password = @()
        $item = op item get $id.id --vault $vaultdetailsconverted.id --format=json
        $obj = $item | ConvertFrom-Json
        foreach($field in $obj.fields){
            if($field.id -eq "username"){
                $username = $field.value
            }elseif ($field.id -eq "password") {
                $password = $field.value
            }else {

            }
        }
        $obj1 = New-Object psobject -Property @{
            Vault_ID = $obj.vault.id
            Vault_Name = $obj.vault.name
            User_Name = $username
            Password = $password
            Tags = $id.Tags
            Item_ID = $id.ID
            Title = $id.Title
        }
        $results += $obj1
        Write-host -ForegroundColor Green "$c of $(($vaultitemsconverted.id).count)"
    }
    $results | Export-Excel -Path C:\Scripts\Results\1password_vault_info.xlsx -AutoSize -AutoFilter -FreezeTopRow

}
```

You could remove the export-excel part to see if you are getting what I am - I know I tested this on my personal 1password account and was able to retrieve all 150 results in there.

Hey there @jwilson5607

I've gotten your script to work locally with some modifications, but Instead of exporting to Excel, I just printed the fields of interest, as I don't have that specific Export-Excel module on my Windows test device.


function Get-1passworditems {
[CmdletBinding()]
param ([Parameter(Mandatory=$true)][string]$vaultuuid)
#Ensure variables are empty and ready to go
$results = @()
$data = @()
$item = @()
$vault = @()
#Get Initial list of item uuids
$results = op item list --vault $vaultuuid --format=json
Write-Host ($results)
$vault = op vault get $vaultuuid --format json
Write-Host ($vault)
$vaultObj = $vault | ConvertFrom-Json
Write-Host ("vaultName: " + $vaultObj.name)
#Convert from JSON to powershell objects
$data = $results | ConvertFrom-Json
foreach($item in $data){
Start-Sleep -Seconds 1
$name = op item get $item.id --vault $vaultuuid --field username
Write-Host ("name: " + $name + " uuid: " + $data.id + " title: " + $data.title)
}
}


Some things I modified are:
- the $vault = op vault get $vaultuuid should specify the --format json flag

- the $vault output should be converted from JSON to access its name in subsequent commands

With these changes I am able to output the vault name, item username, item id, and item title.

As for the error you encountered, I have a feeling that could be caused by continuous execution of op commands after one of them has returned an error, please do let me know if you keep seeing it.

I started to get somewhere with these commands but its still being a bit of a pain and randomly giving me these errors in the screenshot. There are about 4200 entries in this Vault and I KNOW API limits are likely an issue, so I added the start-sleep after each one, to avoid it. It might be too much of a timer, but I am trying to get all the results back.

```
function Get-1passworditems {
[CmdletBinding()]
param ([Parameter(Mandatory=$true)][string]$vaultuuid)

#Set Console Encoding

#Ensure variables are empty and ready to go
$results = @()
$data =@()
$item = @()
$export = @()
$vaultname = @()

#Get Initial list of item uuids
$results = op item list --vault $vaultuuid --format=json
$vaultname = op vault get $vaultuuid
#Convert from JSON to powershell objects

$data = $results | ConvertFrom-Json

foreach($item in $data){
    $obj = @()
    $name = op item get $item.id --vault $vaultuuid --field username
    $obj = New-Object psobject -Property @{
        Username = $name
        UUID = $data.id
        Title = $data.title
    }
    $export += $obj
    Start-Sleep -Seconds 10
}

Export-Excel -Path C:\Scripts\Results\1password_logins.xlsx -WorksheetName $vaultname.Name -Append -AutoSize -AutoFilter -FreezeTopRow

}
```