Get a specific attribute value from Assets

ScriptRunner
,
1

I have a Custom Field of type Assets objects in which I need to use the Expiration Date attribute (Data Vencimento Bombeiros) to create an alert.

How do I get this date, given that all attributes appear in the JSON with the same workspaceId?

Here is an example:

[
  [
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12821",
      "objectTypeAttributeId": "1207",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1207",
        "name": "NAME",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "0",
          "name": "Text"
        }
      },
      "objectAttributeValues": [
        {
          "value": "111.111.111.11",
          "displayValue": "111.111.111.11",
          "searchValue": "111.111.111.11"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12837",
      "objectTypeAttributeId": "1271",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1271",
        "name": "Tag",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "10",
          "name": "Select"
        },
        "suffix": ""
      },
      "objectAttributeValues": [
        {
          "value": "COM VENCIMENTO",
          "displayValue": "COM VENCIMENTO",
          "searchValue": "COM VENCIMENTO"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12835",
      "objectTypeAttributeId": "1270",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1270",
        "name": "Tag",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "10",
          "name": "Select"
        },
        "suffix": ""
      },
      "objectAttributeValues": [
        {
          "value": "COM VENCIMENTO",
          "displayValue": "COM VENCIMENTO",
          "searchValue": "COM VENCIMENTO"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12834",
      "objectTypeAttributeId": "1261",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1261",
        "name": "Data Vencimento",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "4",
          "name": "Date"
        }
      },
      "objectAttributeValues": [
        {
          "value": "2023-04-30",
          "displayValue": "30/Apr/23",
          "searchValue": "2023-04-30"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12833",
      "objectTypeAttributeId": "1260",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1260",
        "name": "Licença",
        "label": false,
        "type": 7
      },
      "objectAttributeValues": [
        {
          "status": {
            "id": "41",
            "name": "PRIMEIRA LICENÇA",
            "description": "",
            "category": 1,
            "objectSchemaId": "11"
          },
          "displayValue": "PRIMEIRA LICENÇA",
          "searchValue": "PRIMEIRA LICENÇA"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12832",
      "objectTypeAttributeId": "1204",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1204",
        "name": "Cidade",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "0",
          "name": "Text"
        }
      },
      "objectAttributeValues": [
        {
          "value": "Rio de Janeiro",
          "displayValue": "Rio de Janeiro",
          "searchValue": "Rio de Janeiro"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12823",
      "objectTypeAttributeId": "1226",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1226",
        "name": "ABC",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "0",
          "name": "Text"
        }
      },
      "objectAttributeValues": [
        {
          "value": "CDE",
          "displayValue": "CDE",
          "searchValue": "CDE"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12820",
      "objectTypeAttributeId": "1203",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1203",
        "name": "Estado",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "0",
          "name": "Text"
        }
      },
      "objectAttributeValues": [
        {
          "value": "RJ",
          "displayValue": "RJ",
          "searchValue": "RJ"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12819",
      "objectTypeAttributeId": "1200",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1200",
        "name": "Name",
        "label": true,
        "type": 0,
        "description": "The name of the object",
        "defaultType": {
          "id": "0",
          "name": "Text"
        }
      },
      "objectAttributeValues": [
        {
          "value": "111.111.111.11",
          "displayValue": "111.111.111.11",
          "searchValue": "111.111.111.11"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12836",
      "objectTypeAttributeId": "1262",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1262",
        "name": "Licença Bombeiros",
        "label": false,
        "type": 7
      },
      "objectAttributeValues": [
        {
          "status": {
            "id": "43",
            "name": "VENCIDA",
            "description": "",
            "category": 0,
            "objectSchemaId": "11"
          },
          "displayValue": "VENCIDA",
          "searchValue": "VENCIDA"
        }
      ]
    },
    {
      "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
      "id": "12838",
      "objectTypeAttributeId": "1263",
      "objectTypeAttribute": {
        "workspaceId": "d5fdab5d-6a76-4b7d-8b8d-6cff5fa688a0",
        "id": "1263",
        "name": "Data Vencimento Bombeiros",
        "label": false,
        "type": 0,
        "defaultType": {
          "id": "4",
          "name": "Date"
        }
      },
      "objectAttributeValues": [
        {
          "value": "2022-08-08",
          "displayValue": "08/Aug/22",
          "searchValue": "2022-08-08"
        }
      ]
    }
  ]
]
2

Hi,
Maybe you should user any of these values to filter,
“id”: “12838” or “objectTypeAttributeId”: “1263”

PRobably you can combine them with the workspace id to be sure that you access to the correct object.
Let me know if this is helpful to you?

3

Hello @roliveira what was your Jira Rest API Call that you used to aquire these infos.