Data Action - Issues with filter operators

Data Actions
1

I'm trying to figure out how to handle JSON where null values get removed from the JSON

{
  "expand": "schema,names",
  "startAt": 0,
  "maxResults": 50,
  "total": 4,
  "issues": [
    {
      "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
      "id": "482154",
      "self": "https://example.atlassian.net/rest/api/2/issue/482154",
      "key": "SD-91151",
      "fields": {
        "summary": "Issue related to system configurations and alerts",
        "status": {
          "self": "https://example.atlassian.net/rest/api/2/status/10496",
          "description": "This was auto-generated by Jira Service Management during workflow import",
          "iconUrl": "https://example.atlassian.net/images/icons/status_generic.gif",
          "name": "Waiting for support",
          "id": "10496",
          "statusCategory": {
            "self": "https://example.atlassian.net/rest/api/2/statuscategory/4",
            "id": 4,
            "key": "indeterminate",
            "colorName": "yellow",
            "name": "In Progress"
          }
        }
      }
    },
    {
      "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
      "id": "470330",
      "self": "https://example.atlassian.net/rest/api/2/issue/470330",
      "key": "SD-86422",
      "fields": {
        "summary": "Communication system issues affecting operations",
        "status": {
          "self": "https://example.atlassian.net/rest/api/2/status/10496",
          "description": "This was auto-generated by Jira Service Management during workflow import",
          "iconUrl": "https://example.atlassian.net/images/icons/status_generic.gif",
          "name": "Waiting for support",
          "id": "10496",
          "statusCategory": {
            "self": "https://example.atlassian.net/rest/api/2/statuscategory/4",
            "id": 4,
            "key": "indeterminate",
            "colorName": "yellow",
            "name": "In Progress"
          }
        }
      }
    },
    {
      "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
      "id": "462387",
      "self": "https://example.atlassian.net/rest/api/2/issue/462387",
      "key": "SD-83244",
      "fields": {
        "summary": "Setup of network configurations for internal platform",
        "assignee": {
          "self": "https://example.atlassian.net/rest/api/2/user?accountId=6426ff032cee496759ed9848",
          "accountId": "6426ff032cee496759ed9848",
          "emailAddress": "example.user1@domain.com",
          "avatarUrls": {
            "48x48": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/6426ff032cee496759ed9848/25d7dd8d-13c7-4825-a1a0-afd9125a1ae5/48",
            "24x24": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/6426ff032cee496759ed9848/25d7dd8d-13c7-4825-a1a0-afd9125a1ae5/24",
            "16x16": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/6426ff032cee496759ed9848/25d7dd8d-13c7-4825-a1a0-afd9125a1ae5/16",
            "32x32": "https://avatar-management--avatars.us-west-2.prod.public.atl-paas.net/6426ff032cee496759ed9848/25d7dd8d-13c7-4825-a1a0-afd9125a1ae5/32"
          },
          "displayName": "User One",
          "active": true,
          "timeZone": "Europe/Dublin",
          "accountType": "atlassian"
        },
        "status": {
          "self": "https://example.atlassian.net/rest/api/2/status/10498",
          "description": "This was auto-generated by Jira Service Management during workflow import",
          "iconUrl": "https://example.atlassian.net/images/icons/status_generic.gif",
          "name": "Pending",
          "id": "10498",
          "statusCategory": {
            "self": "https://example.atlassian.net/rest/api/2/statuscategory/4",
            "id": 4,
            "key": "indeterminate",
            "colorName": "yellow",
            "name": "In Progress"
          }
        }
      }
    },
    {
      "expand": "operations,versionedRepresentations,editmeta,changelog,renderedFields",
      "id": "379279",
      "self": "https://example.atlassian.net/rest/api/2/issue/379279",
      "key": "SD-55762",
      "fields": {
        "summary": "Issue with administrative configuration in system",
        "assignee": {
          "self": "https://example.atlassian.net/rest/api/2/user?accountId=712020%3A03543b68-e7d3-4b6b-973c-b5e7bd91b907",
          "accountId": "712020:03543b68-e7d3-4b6b-973c-b5e7bd91b907",
          "emailAddress": "example.user2@domain.com",
          "avatarUrls": {
          },
          "displayName": "User Two",
          "active": true,
          "timeZone": "Europe/London",
          "accountType": "atlassian"
        },
        "status": {
          "self": "https://example.atlassian.net/rest/api/2/status/10496",
          "description": "This was auto-generated by Jira Service Management during workflow import",
          "iconUrl": "https://example.atlassian.net/images/icons/status_generic.gif",
          "name": "Waiting for support",
          "id": "10496",
          "statusCategory": {
            "self": "https://example.atlassian.net/rest/api/2/statuscategory/4",
            "id": 4,
            "key": "indeterminate",
            "colorName": "yellow",
            "name": "In Progress"
          }
        }
      }
    }
  ]
}

In this example assignee doesn't exist for all issues and I can't default it to null values so I'm trying to separate them instead using filter options as stated here: GitHub - json-path/JsonPath: Java JsonPath implementation.

My translation map

{
  "translationMap": {
    "assigneesAssigned": "$.issues[?(@.fields.assignee)].fields.assignee.displayName",
    "statusesAssigned": "$.issues[?(@.fields.assignee)].fields.status.name",
    "ticketSummariesAssigned": "$.issues[?(@.fields.assignee)].fields.summary",
    "ticketKeysAssigned": "$.issues[?(@.fields.assignee)].key",
    "assigneesUnassigned": "$.issues[?(!@.fields.assignee)].fields.assignee.displayName",
    "statusesUnassigned": "$.issues[?(!@.fields.assignee)].fields.status.name",
    "ticketSummariesUnassigned": "$.issues[?(!@.fields.assignee)].fields.summary",
    "ticketKeysUnassigned": "$.issues[?(!@.fields.assignee)].key"
  },
  "translationMapDefaults": {
    
  },
  "successTemplate": "{\"KeysAssigned\": ${ticketKeysAssigned}, \"SummariesAssigned\": ${ticketSummariesAssigned}, \"AssigneesAssigned\": ${assigneesAssigned}, \"StatusesAssigned\": ${statusesAssigned}, \"KeysUnassigned\": ${ticketKeysUnassigned}, \"SummariesUnassigned\": ${ticketSummariesUnassigned}, \"StatusesUnassigned\": ${statusesUnassigned}}"
}

I'm getting a response like so:

{
  "KeysAssigned": [
    "SD-91151",
    "SD-86422",
    "SD-83244",
    "SD-55762"
  ],
  "StatusesAssigned": [
    "Waiting for support",
    "Waiting for support",
    "Pending",
    "Waiting for support"
  ],
  "SummariesAssigned": [
    "Redacted ",
    "Redacted",
    "Redacted",
    "Redacted"
  ],
  "AssigneesAssigned": [
    "User One",
    "User Two"
  ],
  "Issues.KeysAssigned": [
    null
  ],
  "Issues.SummariesAssigned": [
    null
  ],
  "Issues.AssigneesAssigned": [
    null
  ],
  "Issues.StatusesAssigned": [
    null
  ],
  "Issues.KeysUnassigned": [
    null
  ],
  "Issues.SummariesUnassigned": [
    null
  ],
  "Issues.StatusesUnassigned": [
    null
  ]
}

Am I missing something with my filter operators? I should only be seeing two values for each

2

Hello,

The processed response you have included at the end of your post (with KeysAssigned, StatusesAssigned , ...) doesn't seem to correspond to the Response Configuration and the sample response/example you are showing at the beginning of your post.

Using the first response example (on a simulated web service) and your response configuration, this is what I get:

{
  "KeysAssigned": [
    "SD-83244",
    "SD-55762"
  ],
  "SummariesAssigned": [
    "Setup of network configurations for internal platform",
    "Issue with administrative configuration in system"
  ],
  "AssigneesAssigned": [
    "User One",
    "User Two"
  ],
  "StatusesAssigned": [
    "Pending",
    "Waiting for support"
  ],
  "KeysUnassigned": [
    "SD-91151",
    "SD-86422"
  ],
  "SummariesUnassigned": [
    "Issue related to system configurations and alerts",
    "Communication system issues affecting operations"
  ],
  "StatusesUnassigned": [
    "Waiting for support",
    "Waiting for support"
  ]
}

My output contract is:

{
  "type": "object",
  "properties": {
    "KeysAssigned": {
      "type": "array",
      "items": {
        "title": "Item 1",
        "type": "string"
      }
    },
    "StatusesAssigned": {
      "type": "array",
      "items": {
        "title": "Item 1",
        "type": "string"
      }
    },
    "SummariesAssigned": {
      "type": "array",
      "items": {
        "title": "Item 1",
        "type": "string"
      }
    },
    "AssigneesAssigned": {
      "type": "array",
      "items": {
        "title": "Item 1",
        "type": "string"
      }
    },
    "KeysUnassigned": {
      "type": "array",
      "items": {
        "title": "Item 1",
        "type": "string"
      }
    },
    "SummariesUnassigned": {
      "type": "array",
      "items": {
        "title": "Item 1",
        "type": "string"
      }
    },
    "StatusesUnassigned": {
      "type": "array",
      "items": {
        "title": "Item 1",
        "type": "string"
      }
    }
  },
  "additionalProperties": true
}

Regards,

3

This topic was automatically closed 31 days after the last reply. New replies are no longer allowed.