Ad Widget

Collapse

JSONPath experts - Please Help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • high-t
    Member
    • Dec 2014
    • 68

    #1

    JSONPath experts - Please Help

    I have the following JSON:

    Code:
    [
      {},
      {
        "1": "DB1",
        "2": "     13.94 MB",
        "3": "NT AUTHORITY\\SYSTEM",
        "4": "8",
        "5": "Feb 19 2020",
        "6": "Status=ONLINE",
        "7": " Updateability=READ_WRITE",
        "8": " UserAccess=MULTI_USER",
        "9": " Recovery=FULL",
        "10": " Version=869",
        "11": " Collation=SQL_Latin1_General_CP1_CI_AS",
        "12": " SQLSortOrder=52",
        "13": " IsAutoCreateStatistics",
        "14": " IsAutoUpdateStatistics",
        "15": " IsFullTextEnabled",
        "16": "140"
      },
      {
        "1": "B2",
        "2": "      6.00 MB",
        "3": "NT AUTHORITY\\SYSTEM",
        "4": "7",
        "5": "Feb 19 2020",
        "6": "Status=ONLINE",
        "7": " Updateability=READ_WRITE",
        "8": " UserAccess=MULTI_USER",
        "9": " Recovery=FULL",
        "10": " Version=869",
        "11": " Collation=SQL_Latin1_General_CP1_CI_AS",
        "12": " SQLSortOrder=52",
        "13": " IsAutoCreateStatistics",
        "14": " IsAutoUpdateStatistics",
        "15": " IsFullTextEnabled",
        "16": "140"
      },
      {
        "1": "DB3",
        "2": "   3836.19 MB",
        "3": "NT AUTHORITY\\SYSTEM",
        "4": "12",
        "5": "Feb 19 2020",
        "6": "Status=ONLINE",
        "7": " Updateability=READ_WRITE",
        "8": " UserAccess=MULTI_USER",
        "9": " Recovery=FULL",
        "10": " Version=869",
        "11": " Collation=SQL_Latin1_General_CP1_CI_AS",
        "12": " SQLSortOrder=52",
        "13": " IsAutoCreateStatistics",
        "14": " IsAutoUpdateStatistics",
        "15": " IsFullTextEnabled",
        "16": "140"
      }
    ]
    I need to extract the size (key "2") of each db (key "1").

    I can't seem to understand how to do that in JSONPath.
    Please advise...

    Thank you in advance!
    Amit.
Working...