This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Filter object from array

Go to solution
Max
New Contributor II

‎06-18-2024 01:38 PM

Hello, I need to filter out an object from the distributionCenterSpecificData array where countryCodes array is empty.

input payload:

[{
            "rpn": "ABCD",
            "gpn": "G12345",
            "productName": "CATHETER",
            "productDescription": "EXTRA FIRM",
            "division": "MedSurg",
            "sbu": "CC",
            "productFamily": "AIRWAY MANAGEMENT",
            "productSubFamily1": "C-CAE",
            "productSubFamily2": "NOT APPLICABLE",
            "productStatus": "CURRENT",
            "program": "CC",
            "madeby": "CEW",
            "lastUpdatedDate": "2024-02-08T00:00:50.000",
            "distributionCenterSpecificData": [
                {
                    "dcName": "NADC",
                    "gtin": "004011",
                    "uom": "EA",
                    "quantity": 1,
                    "availability": "AVAILABLE",
                    "stockStatus": "STOCK",
                    "currencyCode": "USD",
                    "isActive": "true",
                    "countryCodes": []
                },
                {
                    "dcName": "CADC",
                    "gtin": "004011",
                    "uom": "EA",
                    "quantity": 1,
                    "availability": "AVAILABLE",
                    "stockStatus": "STOCK",
                    "currencyCode": "CAD",
                    "isActive": "true",
                    "countryCodes": [
                        "CA"
                    ]
                }
            ]
        },
    {
            "rpn": "XYZ",
            "gpn": "G45678",
            "productName": "GRAFT",
            "productDescription": "SOFT",
            "division": "Other",
            "sbu": "TTX",
            "productFamily": "COLORECTAL",
            "productSubFamily1": "RECTOPEXY",
            "productSubFamily2": "RECTOPEXY PLUG",
            "productStatus": "CURRENT",
            "program": "Other",
            "madeby": "CEW",
            "lastUpdatedDate": "2023-10-09T10:04:29.480",
            "distributionCenterSpecificData": [
                {
                    "dcName": "NADC",
                    "gtin": "104731",
                    "uom": "BX",
                    "quantity": 1,
                    "availability": "AVAILABLE",
                    "stockStatus": "STOCK",
                    "currencyCode": "USD",
                    "isActive": "true",
                    "countryCodes": [
                        "US"
                    ]
                }
            ]
        }
]
 
Expected output:
[{
            "rpn": "ABCD",
            "gpn": "G12345",
            "productName": "CATHETER",
            "productDescription": "EXTRA FIRM",
            "division": "MedSurg",
            "sbu": "CC",
            "productFamily": "AIRWAY MANAGEMENT",
            "productSubFamily1": "C-CAE",
            "productSubFamily2": "NOT APPLICABLE",
            "productStatus": "CURRENT",
            "program": "CC",
            "madeby": "CEW",
            "lastUpdatedDate": "2024-02-08T00:00:50.000",
            "distributionCenterSpecificData": [
                {
                    "dcName": "CADC",
                    "gtin": "004011",
                    "uom": "EA",
                    "quantity": 1,
                    "availability": "AVAILABLE",
                    "stockStatus": "STOCK",
                    "currencyCode": "CAD",
                    "isActive": "true",
                    "countryCodes": [
                        "CA"
                    ]
                }
            ]
        },
    {
            "rpn": "XYZ",
            "gpn": "G45678",
            "productName": "GRAFT",
            "productDescription": "SOFT",
            "division": "Other",
            "sbu": "TTX",
            "productFamily": "COLORECTAL",
            "productSubFamily1": "RECTOPEXY",
            "productSubFamily2": "RECTOPEXY PLUG",
            "productStatus": "CURRENT",
            "program": "Other",
            "madeby": "CEW",
            "lastUpdatedDate": "2023-10-09T10:04:29.480",
            "distributionCenterSpecificData": [
                {
                    "dcName": "NADC",
                    "gtin": "104731",
                    "uom": "BX",
                    "quantity": 1,
                    "availability": "AVAILABLE",
                    "stockStatus": "STOCK",
                    "currencyCode": "USD",
                    "isActive": "true",
                    "countryCodes": [
                        "US"
                    ]
                }
            ]
        }
]
0 Kudos
Reply
1 ACCEPTED SOLUTION

Go to solution
SpiroTaleski
Valued Contributor

‎06-19-2024 01:07 AM

@Max 

You can achieve the transformation using filter function.

Find the attached sample pipeline. 

 

View solution in original post

filterArrayPipe_2024_06_19.zip
Reply
1 REPLY 1

Go to solution
SpiroTaleski
Valued Contributor

‎06-19-2024 01:07 AM

@Max 

You can achieve the transformation using filter function.

Find the attached sample pipeline. 

 

filterArrayPipe_2024_06_19.zip
Reply