主页 / user-552918

Lord OfTheRing's questions

Martin Hope
Lord OfTheRing
Asked: 2024-08-01 23:43:00 +0800 CST
  • 9

我在字符串 groupsjasontext 中有以下 Json 值，我想使用 JsonConverter.ParseJson 解析 id、members.value、roles.value。我该怎么做？我尝试通过消息框显示 id 字段，但出现错误“类型不匹配”

    Set JsonData = JsonConverter.ParseJson(groupsjasontext)
    tempName = JsonData("id")(0)
    MsgBox (tempName)

    {
  "schemas": [
    "urn:ietf:params:scim:api:messages:2.0:ListResponse"
  ],
  "totalResults": 3,
  "startIndex": 1,
  "itemsPerPage": 3,
  "Resources": [
    {
      "schemas": [
        "urn:ietf:params:scim:schemas:core:2.0:Group",
        "urn:sap:params:scim:schemas:extension:sac:2.0:group-custom-parameters"
      ],
      "id": "d3094970-ce7e-4794-b9e2-f84817b7c820",
      "meta": {
        "resourceType": "Group",
        "created": "2024-05-21T17:53:06.808Z",
        "lastModified": "2024-05-21T17:53:06.808Z",
        "location": "/api/v1/scim2/Groups/d3094970-ce7e-4794-b9e2-f84817b7c820"
      },
      "displayName": "AHI_VW_ALL_REGION",
      "urn:sap:params:scim:schemas:extension:sac:2.0:group-custom-parameters": {
        "description": "View Mode ALL REGION"
      }
    },
    {
      "schemas": [
        "urn:ietf:params:scim:schemas:core:2.0:Group",
        "urn:sap:params:scim:schemas:extension:sac:2.0:group-roles",
        "urn:sap:params:scim:schemas:extension:sac:2.0:group-custom-parameters"
      ],
      "id": "bef561ee-5a1e-420e-a1e\n4-4f624c96af6e",
      "meta": {
        "resourceType": "Group",
        "created": "2024-07-25T14:17:53.215Z",
        "lastModified": "2024-08-01T14:31:29.632Z",
        "location": "/api/v1/scim2/Groups/bef561ee-5a1e-420e-a1e4-4f624c96af6e"
      },
      "displayName": "TEAM_TEST",
      "members": [
        {
          "value": "f27dcbb9-df9a-46b2-b23a-3b35d5a8bdff",
          "type": "User",
          "display": "Test_FirstName1 TEST_Familyname1",
          "$ref": "/api/v1/scim2/Users/f27dcbb9-df9a-46b2-b23a-3b35d5a8bdff"
        }
      ],
      "urn:sap:params:scim:schemas:extension:sac:2.0:group-roles": {
        "roles": [
          {
            "value": "PROFILE:t.4:VIEW_USER",
            "display": "VIEW_USER"
          }
        ]
      },
      "urn:sap:params:scim:schemas:extension:sac:2.0:group-custom-parameters": {
        "description": "Team Test"
      }
    },
    {
      "schemas": [
        "urn:ietf:params:scim:schemas:core:2.0:Group",
        "urn:sap:params:scim:schemas:extension:sac:2.0:group-custom-parameters"
      ],
      "id": "1edd9227-c8de-486e-93f6-69396524c792",
      "meta": {
        "resourceType": "Group",
        "created": "2024-05-21T17:51:49.808Z",
        "lastModified": "2024-05-21T17:53:06.121Z",
        "location": "/api/v1/scim2/Groups/1edd9227-c8de-486e-93f6-69396524c792"
      },
      "displayName": "AHI_VW_EURAM\n",
      "urn:sap:params:scim:schemas:extension:sac:2.0:group-custom-parameters": {
        "description": "View mode EURAM"
      }
    }
  ]
}
json
Martin Hope
Lord OfTheRing
Asked: 2023-08-31 02:35:04 +0800 CST
  • 6

我有以下文字：

    roledetails="name: CLD:HYB_Y_BASIS_ADMIN
    description: Basis Admin
    readOnly: <null>
    roleReferences:
      - description: desc1
        name: AuthGroup_Administrator
        roleTemplateAppId: it!b2455
        roleTemplateName: AuthGroup_Administrator
      - description: Desc2
        name: AuthGroup_BusinessExpert
        roleTemplateAppId: it!b2455
        roleTemplateName: AuthGroup_BusinessExpert
"

我喜欢转换为以下格式的 .csv 文件。我将如何使用 AWK 来做到这一点？

Collection Role Desc,Role_Name,App_Id, Role_Template
CLD:HYB_Y_BASIS_ADMIN, desc1, AuthGroup_Administrator,it!b2455,AuthGroup_Administrator
CLD:HYB_Y_BASIS_ADMIN, desc2, AuthGroup_BusinessExpert,it!b2455,AuthGroup_BusinessExpert

我尝试了下面的代码但不起作用：

declare fullfilepath=$(pwd)"/test1.csv"    
awk -F':[[:space:]]+' -v fullfilepath="$fullfilepath" 'NR==1{               # When on Line 1
        a=$2;cnt=0            # Set a and cnt vars
    }
    /^-/{                     # When line starts with -
        rta[cnt]=$2; getline; # Add role template app ID to rta array
        rtn[cnt]=$2; getline; # Add role template name to rtn array
        n[cnt]=$2;cnt++       # Add name to n array
    }
    END{                      # When the file processing is over
        for(i=0;i<cnt;i++) {  # Iterate over the found values and... 
            #print a","n[i]","rtn[i]","rta[i]     # print them
            printf a","n[i]","rtn[i]","rta[i] "\n"  >> fullfilepath   # print them
        }
    }' <<< "$roledetails"
shell