none
Reading key value pairs from Powershell RRS feed

  • Question

  • Hi All.

    I am trying to read key valued pairs from a vault system and was wondering what is the most efficient way of doing this and also converting into a standard function. Once given a URL, I would like the function/routine to be able to read all the keys and values and then this can be converted into a string to be used within variables.

    This is what I have so far.

    $pass = @{
          password='xxxxxxxxxxxx'
    }
    $body = (ConvertTo-Json $pass)
    $secret_url_login = "http://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/loginname"
    
    $result1 = Invoke-RestMethod -secret_url $secret_url_login -Method Post -Body $body
    $authct = $result1.auth.client_token
    
    $secret_url_metadata = "http://xxxxxxxxxxxxxxxxxxx/status/project1"
    $header = @{'X-Vault-Token'=$authct}
    $raw_result = Invoke-RestMethod -secret_url $secret_url_metadata -Method Get -Headers $header
    $result_data = $raw_result.data
    

    From the vault this is what the Json looks like

    {
    
      "host": "server123",
      "department": "department",
      "rack": "false",
      "owner": "business",
      "environment": "Development",
      "location": "USA West"
    }
    
    
    

    From Powershell 

    $result_data looks like the below.

    @{host=server123; department=department; rack=false; owner=business; environment=Development; location=USA West}
    

    Friday, October 18, 2019 11:01 AM

All replies

  • Hi MrFlinstone,

    I didn't get what exactly you want to do but if you want to use $result_Data variable as JSON body for your Invoke-RestMethod command then you can use ConvertTo-Json command to convert $result_Data into JSON.

    Friday, October 18, 2019 1:42 PM
  • I want to read the values of the following keys

    host

    department

    rack

    owners

    environment

    location

    Friday, October 18, 2019 1:43 PM
  • To list only values :

    $result_Data.Keys|foreach{$result_Data[$_]}

    To list keys and values

    $resultData.Keys|foreach{ Write-Output "$($_ +":"+ $resultData[$_])"}

    Friday, October 18, 2019 1:53 PM
  • Another way to loop through a hashtable:

    foreach ($i in $result_data.GetEnumerator()) { write-host $i.name $i.value }

    Friday, October 18, 2019 2:05 PM
  • Try this:

    $x = @{host='server123'; department='department'; rack='false'; owner='business'; environment='Development'; location='USA West'}
    
    $x.GetEnumerator()|
        foreach {
            "{0,-14} `t {1}" -f $_.Key, $_.Value
            
        }


    --- Rich Matheisen MCSE&I, Exchange Ex-MVP (16 years)

    Friday, October 18, 2019 3:52 PM
  • Another way to loop through a hashtable:

    foreach ($i in $result_data.GetEnumerator()) { write-host $i.name $i.value }

    Thanks for the reply.

    I had the error below.

    Method invocation failed because [System.Management.Automation.PSCustomObject] does not contain a method named 'GetEnumerator'.
    At line:1 char:16
    + foreach ($i in $result_data.GetEnumerator()) { write-host $i.name $i.valu ...
    +                ~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : InvalidOperation: (GetEnumerator:String) [], RuntimeException
        + FullyQualifiedErrorId : MethodNotFound
    
    


    Monday, October 21, 2019 11:53 PM
  • Try this:

    $x = @{host='server123'; department='department'; rack='false'; owner='business'; environment='Development'; location='USA West'}
    
    $x.GetEnumerator()|
        foreach {
            "{0,-14} `t {1}" -f $_.Key, $_.Value
            
        }


    --- Rich Matheisen MCSE&I, Exchange Ex-MVP (16 years)

    Hi,

    When I tried this, nothing came out of it.

    Monday, October 21, 2019 11:55 PM
  • To list only values :

    $result_Data.Keys|foreach{$result_Data[$_]}

    To list keys and values

    $resultData.Keys|foreach{ Write-Output "$($_ +":"+ $resultData[$_])"}

    Hi,

    I tried the above.

    I got the error below.

     $result_data.Keys|foreach{$result_data[$_]}
    Index operation failed; the array index evaluated to null.
    At line:1 char:23
    + $result_data.Keys|foreach{$result_data[$_]}
    +                       ~~~~~~~~~~~~
        + CategoryInfo          : InvalidOperation: (:) [], RuntimeException
        + FullyQualifiedErrorId : NullArrayIndex
    The data type is of type custom object.

    Monday, October 21, 2019 11:58 PM
  • Json is NOT a hash - it is text.

    $object = $raw_result.data  | ConvertFrom-Json

    If resultdat ais a hash then this would work:

    $raw_result.data.Keys

    which would list the keys.


    \_(ツ)_/

    Tuesday, October 22, 2019 12:31 AM
    Moderator
  • Really? Here's what I see:

    PS C:\Users\richm> $x = @{host='server123'; department='department'; rack='false'; owner='business'; environment='Development'; location='USA West'}
    PS C:\Users\richm>
    PS C:\Users\richm> $x.GetEnumerator()|
    >>     foreach {
    >>         "{0,-14} `t {1}" -f $_.Key, $_.Value
    >>
    >>     }
    department       department
    host             server123
    rack             false
    environment      Development
    owner            business
    location         USA West
    PS C:\Users\richm>


    --- Rich Matheisen MCSE&I, Exchange Ex-MVP (16 years)

    Tuesday, October 22, 2019 1:44 AM
  • Json is NOT a hash - it is text.

    $object = $raw_result.data  | ConvertFrom-Json

    If resultdat ais a hash then this would work:

    $raw_result.data.Keys

    which would list the keys.


    \_(ツ)_/

    Its not a hash, the data type is string. When I tried to convert from jSon. I get the error below.

    ConvertFrom-Json : Invalid JSON primitive: .
    At line:1 char:29
    + $object =  $result_data.data  | ConvertFrom-Json
    +                             ~~~~~~~~~~~~~~~~
        + CategoryInfo          : NotSpecified: (:) [ConvertFrom-Json], ArgumentException
        + FullyQualifiedErrorId : System.ArgumentException,Microsoft.PowerShell.Commands.ConvertFromJsonCommand
    


    Tuesday, October 22, 2019 11:36 AM
  • Json is NOT a hash - it is text.

    $object = $raw_result.data  | ConvertFrom-Json

    If resultdat ais a hash then this would work:

    $raw_result.data.Keys

    which would list the keys.


    \_(ツ)_/

    Its not a hash, the data type is string. When I tried to convert from jSon. I get the error below.

    ConvertFrom-Json : Invalid JSON primitive: .
    At line:1 char:29
    + $object =  $result_data.data  | ConvertFrom-Json
    +                             ~~~~~~~~~~~~~~~~
        + CategoryInfo          : NotSpecified: (:) [ConvertFrom-Json], ArgumentException
        + FullyQualifiedErrorId : System.ArgumentException,Microsoft.PowerShell.Commands.ConvertFromJsonCommand


    The data type returned is a string.

    I run the get-Member command and got the below.

       TypeName: System.String
    
    Name             MemberType            Definition
    ----             ----------            ----------
    Clone            Method                System.Object Clone(), System.Object ICloneable.Clone()
    CompareTo        Method                int CompareTo(System.Object value), int CompareTo(string strB), int IComparable.CompareTo(System.Object obj), int IComparable[string].CompareTo(string other)
    Contains         Method                bool Contains(string value)
    CopyTo           Method                void CopyTo(int sourceIndex, char[] destination, int destinationIndex, int count)
    EndsWith         Method                bool EndsWith(string value), bool EndsWith(string value, System.StringComparison comparisonType), bool EndsWith(string value, bool ignoreCase, cultureinfo culture)
    Equals           Method                bool Equals(System.Object obj), bool Equals(string value), bool Equals(string value, System.StringComparison comparisonType), bool IEquatable[string].Equals(string other)
    GetEnumerator    Method                System.CharEnumerator GetEnumerator(), System.Collections.IEnumerator IEnumerable.GetEnumerator(), System.Collections.Generic.IEnumerator[char] IEnumerable[char].GetEnumerator()
    GetHashCode      Method                int GetHashCode()
    GetType          Method                type GetType()
    GetTypeCode      Method                System.TypeCode GetTypeCode(), System.TypeCode IConvertible.GetTypeCode()
    IndexOf          Method                int IndexOf(char value), int IndexOf(char value, int startIndex), int IndexOf(char value, int startIndex, int count), int IndexOf(string value), int IndexOf(string value, int startIndex), int IndexOf(string value, int startIndex...
    IndexOfAny       Method                int IndexOfAny(char[] anyOf), int IndexOfAny(char[] anyOf, int startIndex), int IndexOfAny(char[] anyOf, int startIndex, int count)
    Insert           Method                string Insert(int startIndex, string value)
    IsNormalized     Method                bool IsNormalized(), bool IsNormalized(System.Text.NormalizationForm normalizationForm)
    LastIndexOf      Method                int LastIndexOf(char value), int LastIndexOf(char value, int startIndex), int LastIndexOf(char value, int startIndex, int count), int LastIndexOf(string value), int LastIndexOf(string value, int startIndex), int LastIndexOf(stri...
    LastIndexOfAny   Method                int LastIndexOfAny(char[] anyOf), int LastIndexOfAny(char[] anyOf, int startIndex), int LastIndexOfAny(char[] anyOf, int startIndex, int count)
    Normalize        Method                string Normalize(), string Normalize(System.Text.NormalizationForm normalizationForm)
    PadLeft          Method                string PadLeft(int totalWidth), string PadLeft(int totalWidth, char paddingChar)
    PadRight         Method                string PadRight(int totalWidth), string PadRight(int totalWidth, char paddingChar)
    Remove           Method                string Remove(int startIndex, int count), string Remove(int startIndex)
    Replace          Method                string Replace(char oldChar, char newChar), string Replace(string oldValue, string newValue)
    Split            Method                string[] Split(Params char[] separator), string[] Split(char[] separator, int count), string[] Split(char[] separator, System.StringSplitOptions options), string[] Split(char[] separator, int count, System.StringSplitOptions opt...
    StartsWith       Method                bool StartsWith(string value), bool StartsWith(string value, System.StringComparison comparisonType), bool StartsWith(string value, bool ignoreCase, cultureinfo culture)
    Substring        Method                string Substring(int startIndex), string Substring(int startIndex, int length)
    ToBoolean        Method                bool IConvertible.ToBoolean(System.IFormatProvider provider)
    ToByte           Method                byte IConvertible.ToByte(System.IFormatProvider provider)
    ToChar           Method                char IConvertible.ToChar(System.IFormatProvider provider)
    ToCharArray      Method                char[] ToCharArray(), char[] ToCharArray(int startIndex, int length)
    ToDateTime       Method                datetime IConvertible.ToDateTime(System.IFormatProvider provider)
    ToDecimal        Method                decimal IConvertible.ToDecimal(System.IFormatProvider provider)
    ToDouble         Method                double IConvertible.ToDouble(System.IFormatProvider provider)
    ToInt16          Method                int16 IConvertible.ToInt16(System.IFormatProvider provider)
    ToInt32          Method                int IConvertible.ToInt32(System.IFormatProvider provider)
    ToInt64          Method                long IConvertible.ToInt64(System.IFormatProvider provider)
    ToLower          Method                string ToLower(), string ToLower(cultureinfo culture)
    ToLowerInvariant Method                string ToLowerInvariant()
    ToSByte          Method                sbyte IConvertible.ToSByte(System.IFormatProvider provider)
    ToSingle         Method                float IConvertible.ToSingle(System.IFormatProvider provider)
    ToString         Method                string ToString(), string ToString(System.IFormatProvider provider), string IConvertible.ToString(System.IFormatProvider provider)
    ToType           Method                System.Object IConvertible.ToType(type conversionType, System.IFormatProvider provider)
    ToUInt16         Method                uint16 IConvertible.ToUInt16(System.IFormatProvider provider)
    ToUInt32         Method                uint32 IConvertible.ToUInt32(System.IFormatProvider provider)
    ToUInt64         Method                uint64 IConvertible.ToUInt64(System.IFormatProvider provider)
    ToUpper          Method                string ToUpper(), string ToUpper(cultureinfo culture)
    ToUpperInvariant Method                string ToUpperInvariant()
    Trim             Method                string Trim(Params char[] trimChars), string Trim()
    TrimEnd          Method                string TrimEnd(Params char[] trimChars)
    TrimStart        Method                string TrimStart(Params char[] trimChars)
    Chars            ParameterizedProperty char Chars(int index) {get;}

    Tuesday, October 22, 2019 11:40 AM
  • Copy and post the string.


    \_(ツ)_/

    Tuesday, October 22, 2019 12:13 PM
    Moderator
  • Copy and post the string.


    \_(ツ)_/

    This is what it looks like, I am interested in what is in the data section, but the others could also be needed later.

    data                                                                                                                                                                                                                                                                                                                                              
    ----                                                                                                                                                                                                                                                                                                                                              
    @{buildstatus=built; department=department; rack=false; owner=business; environment=Development; location=USA West; os=Windows Server 2012} 
    
     metadata
    --------  
    @{created_time=2019-10-15T14:27:09.609277032Z; deletion_time=; decomission=False; version=2}
    


    Tuesday, October 22, 2019 2:32 PM
  • What you have posted is not Json and it is not a hash it is just a set of strings.  Someone screwed up the web side.  Contact the site owner for help.


    \_(ツ)_/

    Tuesday, October 22, 2019 2:44 PM
    Moderator
  • The following will convert the string into a hash.

    $hash = $data -replace '@|\{|\}' | ConvertFrom-StringData
    $hash.Keys


    \_(ツ)_/

    Tuesday, October 22, 2019 2:46 PM
    Moderator
  • The following will convert the string into a hash.

    $hash = $data -replace '@|\{|\}' | ConvertFrom-StringData
    $hash.Keys


    \_(ツ)_/

    This just outputs data.

    Tuesday, October 22, 2019 3:26 PM
  • You have to replace $data with your variable.


    \_(ツ)_/

    Tuesday, October 22, 2019 3:27 PM
    Moderator
  • You have to replace $data with your variable.


    \_(ツ)_/

    Please confirm if you mean the below, see the modification below.

    $pass = @{ password='xxxxxxxxxxxx' } $body = (ConvertTo-Json $pass) $secret_url_login = "http://xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx/loginname" $result1 = Invoke-RestMethod -secret_url $secret_url_login -Method Post -Body $body $authct = $result1.auth.client_token $secret_url_metadata = "http://xxxxxxxxxxxxxxxxxxx/status/project1" $header = @{'X-Vault-Token'=$authct} $raw_result = Invoke-RestMethod -secret_url $secret_url_metadata -Method Get -Headers $header $result_data = $raw_result.data

    $hash = $result_data.data -replace '@|\{|\}' | ConvertFrom-StringData

    $hash.Keys


    • Edited by MrFlinstone Tuesday, October 22, 2019 10:17 PM
    Tuesday, October 22, 2019 9:37 PM
  • You have to replace $data with your variable.


    \_(ツ)_/

    So I am finding that trying to convert the value into hash gives the following results.

    Name                                                      Value

    build_status                                                  built; department=department; rack=false; owner=business; environment=Development; location=USA West; os=Windows Server 2012}

    The powershell output of $raw_result.data is similar to what I expect, but I just cannot extract the values individually. On the Ps console, $raw_result.data gives.

    buildstatus: built 
    department: department
    rack: false 
    owner: business 
    environment: Development 
    location: USA West 
    os: Windows Server 2012
    
    

    Tuesday, October 22, 2019 10:29 PM
  • Without your learning enough basic PowerShell this could go on for days. The answers above sow you how to deal with a hash.

    Without some basic understanding of these things it is not possible to understand what your issues are or what you have.  If we can access the web site this would be simple.  Your answers and questions seem to only confuse you and us more.

    Sorry.


    \_(ツ)_/

    Wednesday, October 23, 2019 12:07 AM
    Moderator
  • Thanks for the help, I have read up about it but its just not coming out the way I expect it to. On the website, this is the raw Json data.

    {
      "host": "server123",
      "department": "department",
      "rack": "false",
      "owner": "business",
      "environment": "Development",
      "location": "USA West"
    }

    Wednesday, October 23, 2019 12:42 PM
  • $raw = @'
    {
      "host": "server123",
      "department": "department",
      "rack": "false",
      "owner": "business",
      "environment": "Development",
      "location": "USA West"
    }
    '@
    $raw | ConvertFrom-Json
    


    \_(ツ)_/

    Wednesday, October 23, 2019 3:03 PM
    Moderator
  • Hi,

    Was your issue resolved?

    If you resolved it using our solution, please "mark it as answer" to help other community members find the helpful reply quickly.

    If you resolve it using your own solution, please share your experience and solution here. It will be very beneficial for other community members who have similar questions.

    If no, please reply and tell us the current situation in order to provide further help.

    Best Regards,

    Lee

    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, November 8, 2019 1:41 PM
    Moderator