Splunk Search

Extract fields from array of data and find best performing currency.

sandeepmakkena
Contributor

SSP Request: {
"disableAMLFlag" = "false";
"orderAttributes" = {
"OrderAttributes" = {
"requestPostalIndicator" = "X";
"soldToParty" = "76";
"shipCompleteIndicator" = "false";
"disableLineLevelShipOptionsFlag" = "false";
"deliveryGroupingFlag" = "true";
"language" = "E";
"salesOrg" = "30";
"delayedPaymentFlag" = "false";
"locale" = "en-ca";
};
};
"addressArray" = (
{
"Address" = (
{
"cityName" = "Toronto";
"countryCode" = "CA";
"addressType" = "HomeHome";
"postalCode" = "00078";
"state" = "ON";
"addressID" = "b2e6d5-e488-431c-b20e-e5d1babb56cb";
}
);
}
);
"lineItemArray" = (
{
"LineItem" = (
{
"flag" = "false";
"itemNumber" = "c9b73e-ef52-44b0-b22e-83675318d2dc";
"quantity" = "1";
"bopisItem" = "STH";
"materialNumber" = "PTFP";
"selectedShipMethodCode" = "02";
"perUnitNetPrice" = "1699.00";
"currency" = "CAD";
"giftWrap" = {};
"commitCode" = "24";
"addressID" = "b2e6d5-e488-431c-b20e-e5d1babb56cb";
}
);
},
{
"LineItem" = (
{
"flag" = "false";
"itemNumber" = "4243ab-cc41-4ee8-abf9-fea5129dc624";
"quantity" = "1";
"bopisItem" = "STH";
"materialNumber" = "MWLE";
"selectedShipMethodCode" = "02";
"perUnitNetPrice" = "1049.00";
"currency" = "CAD";
"giftWrap" = {};
"commitCode" = "24";
"addressID" = "b2e6d5-e488-431c-b20e-e5d1babb56cb";
}
);
}
);
}

I have something like this I am trying to extract currency field, quantity and perUnitNetPrice to see best performning currency.

Thanks for your time in advance.

0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...