Here is the JSON data and looking for Props settings for splitting the event based on "Level:4" as the correlation ID mentioned is a unique transaction. Esisting Props: [mscs:azure:eventhub:vad01_apim_qa] SHOULD_LINEMERGE = false INDEXED_EXTRACTIONS = JSON KV_MODE = none TRUNCATE = 0 JSON Data: { "body":{ "records":[ { "Level":4, "isRequestSuccess":true, "time":"2021-03-18T12:20:48.7984746Z", "operationName":"Microsoft.ApiManagement/GatewayLogs", "category":"GatewayLogs", "durationMs":35, "callerIpAddress":"10.244.53.200", "correlationId":"8c5bb044-db88-47fd-9fc6-997959ac1aae", "location":"East US 2", "properties":{ "method":"GET", "url":"https://easyapiqa-corp-azure.staples.com/nephos/gp-api-tierc-store-locator/v1/storelocator/storeSearch?limit=10&radius=50&storeNumber=0193&locale=en_US", "backendResponseCode":200, "responseCode":200, "responseSize":2680, "cache":"none", "backendTime":30, "requestSize":1878, "apiId":"nephos", "operationId":"get-call", "productId":"nephos-pni", "apimSubscriptionId":"PNI", "clientTime":4, "clientProtocol":"HTTP/1.1", "backendProtocol":"HTTP/1.1", "apiRevision":"3", "clientTlsVersion":"1.2", "responseHeaders":{ "X-B3-TraceId":"f884152944db8c96" }, "backendMethod":"GET", "backendUrl":"https://nephos-qa-open.staples.com/gp-api-tierc-store-locator/v1/storelocator/storeSearch?limit=10&radius=50&storeNumber=0193&locale=en_US", "requestHeaders":{ "X-Forwarded-For":"199.10.28.20,204.2.136.181,23.215.131.118:42751", "X-Azure-Client-Id":"567e713e-e278-4cdd-a90a-653e1de87e0d", "Ocp-Apim-Subscription-Key":"431e8630d74b45eca5921fec2f21f08f" }, "backendResponseHeaders":{ "X-B3-TraceId":"f884152944db8c96" }, "backendRequestHeaders":{ "X-Forwarded-For":"199.10.28.20,204.2.136.181,23.215.131.118:42751", "X-Azure-Client-Id":"567e713e-e278-4cdd-a90a-653e1de87e0d", "Ocp-Apim-Subscription-Key":"431e8630d74b45eca5921fec2f21f08f" }, "responseBody":"{\"staplesURL\":\"//www.staples.com\",\"results\":{\"status\":\"SUCCESS\",\"stores\":[{\"storeNumber\":\"0193\",\"storeTitle\":\"Staples 0193 - Store 0193 - 217 Broadway (Ves\",\"latitude\":40.7116,\"longitude\":-74.0087,\"storeDivision\":\"V1\",\"storeRegion\":\"R03\",\"emailCopyCenter\":\"print.marketing0193@Staples.com\",\"address\":{\"addressLine1\":\"217 Broadway (Vesey Street)\",\"city\":\"New York\",\"state\":\"NY\",\"zipcode\":\"10007\",\"country\":\"USA\",\"phoneNumber\":\"2123469624\",\"faxNumber\":\"2123469633\"},\"featureVOs\":[{\"featureName\":\"ISP\",\"featureLabel\":\"Buy online. Pickup in store\",\"featureTooltip\":\"We will have your online order ready at your local store within one hour. See an associate for details.\"},{\"featureName\":\"TS\",\"featureLabel\":\"Technology Services\",\"featureTooltip\":\"Complete technology solutions for your home or office from our certified techs.\"},{\"featureName\":\"F1\",\"featureLabel\":\"Computer Workstation\",\"featureTooltip\":\"Private rental areas with Microsoft<sup>®</sup> Office, Internet access, and printing capabilities.\"},{\"featureName\":\"STS\",\"featureLabel\":\"Ship to Store\",\"featureTooltip\":\"Free shipping to your local Staples<sup>®</sup> store when you order online.\"},{\"featureName\":\"CPC\",\"featureLabel\":\"Print & Marketing Services\",\"featureTooltip\":\"Print services ranging from presentations & business cards to signs & banners with expert advice from our Certified Print Pros.\"},{\"featureName\":\"UPS\",\"featureLabel\":\"UPS<sup>®</sup> Prepaid Drop-off\",\"featureTooltip\":\"Drop off any UPS<sup>®</sup> prepaid package for shipment.\"},{\"featureName\":\"MPR\",\"featureLabel\":\"Mobile Printing\",\"featureTooltip\":\"Ability to accept documents submitted through a web enabled mobile device.\"},{\"featureName\":\"FSU\",\"featureLabel\":\"Full-service UPS<sup>®</sup> Shipping\",\"featureTooltip\":\"Easy shipping with UPS and up to 5% back in Staples Rewards. All Staples stores accept UPS prepaid drop-off packages\"}],\"workingHourVOs\":[{\"day\":\"THU\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"TUS\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"WED\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SAT\",\"openTime\":\"0900\",\"closeTime\":\"1800\"},{\"day\":\"FRI\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SUN\",\"openTime\":\"1100\",\"closeTime\":\"1800\"},{\"day\":\"MON\",\"openTime\":\"0800\",\"closeTime\":\"1900\"}]}],\"count\":1}}", "backendResponseBody":"{\"staplesURL\":\"//www.staples.com\",\"results\":{\"status\":\"SUCCESS\",\"stores\":[{\"storeNumber\":\"0193\",\"storeTitle\":\"Staples 0193 - Store 0193 - 217 Broadway (Ves\",\"latitude\":40.7116,\"longitude\":-74.0087,\"storeDivision\":\"V1\",\"storeRegion\":\"R03\",\"emailCopyCenter\":\"print.marketing0193@Staples.com\",\"address\":{\"addressLine1\":\"217 Broadway (Vesey Street)\",\"city\":\"New York\",\"state\":\"NY\",\"zipcode\":\"10007\",\"country\":\"USA\",\"phoneNumber\":\"2123469624\",\"faxNumber\":\"2123469633\"},\"featureVOs\":[{\"featureName\":\"ISP\",\"featureLabel\":\"Buy online. Pickup in store\",\"featureTooltip\":\"We will have your online order ready at your local store within one hour. See an associate for details.\"},{\"featureName\":\"TS\",\"featureLabel\":\"Technology Services\",\"featureTooltip\":\"Complete technology solutions for your home or office from our certified techs.\"},{\"featureName\":\"F1\",\"featureLabel\":\"Computer Workstation\",\"featureTooltip\":\"Private rental areas with Microsoft<sup>®</sup> Office, Internet access, and printing capabilities.\"},{\"featureName\":\"STS\",\"featureLabel\":\"Ship to Store\",\"featureTooltip\":\"Free shipping to your local Staples<sup>®</sup> store when you order online.\"},{\"featureName\":\"CPC\",\"featureLabel\":\"Print & Marketing Services\",\"featureTooltip\":\"Print services ranging from presentations & business cards to signs & banners with expert advice from our Certified Print Pros.\"},{\"featureName\":\"UPS\",\"featureLabel\":\"UPS<sup>®</sup> Prepaid Drop-off\",\"featureTooltip\":\"Drop off any UPS<sup>®</sup> prepaid package for shipment.\"},{\"featureName\":\"MPR\",\"featureLabel\":\"Mobile Printing\",\"featureTooltip\":\"Ability to accept documents submitted through a web enabled mobile device.\"},{\"featureName\":\"FSU\",\"featureLabel\":\"Full-service UPS<sup>®</sup> Shipping\",\"featureTooltip\":\"Easy shipping with UPS and up to 5% back in Staples Rewards. All Staples stores accept UPS prepaid drop-off packages\"}],\"workingHourVOs\":[{\"day\":\"THU\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"TUS\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"WED\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SAT\",\"openTime\":\"0900\",\"closeTime\":\"1800\"},{\"day\":\"FRI\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SUN\",\"openTime\":\"1100\",\"closeTime\":\"1800\"},{\"day\":\"MON\",\"openTime\":\"0800\",\"closeTime\":\"1900\"}]}],\"count\":1}}" }, "resourceId":"/SUBSCRIPTIONS/B00FC482-62DC-49BF-BBD6-9B4CE971B3DB/RESOURCEGROUPS/VAD01_APIM_QE_0/PROVIDERS/MICROSOFT.APIMANAGEMENT/SERVICE/VAD01QEAPIM01" }, { "Level":4, "isRequestSuccess":true, "time":"2021-03-18T12:20:50.8832104Z", "operationName":"Microsoft.ApiManagement/GatewayLogs", "category":"GatewayLogs", "durationMs":29, "callerIpAddress":"10.244.53.200", "correlationId":"a4f739b5-6502-4725-8fe1-31bddb1bade1", "location":"East US 2", "properties":{ "method":"GET", "url":"https://easyapiqa-corp-azure.staples.com/nephos/gp-api-tierc-store-locator/v1/storelocator/storeSearch?limit=10&radius=50&storeNumber=0193&locale=en_US", "backendResponseCode":200, "responseCode":200, "responseSize":2680, "cache":"none", "backendTime":27, "requestSize":1878, "apiId":"nephos", "operationId":"get-call", "productId":"nephos-pni", "apimSubscriptionId":"PNI", "clientTime":1, "clientProtocol":"HTTP/1.1", "backendProtocol":"HTTP/1.1", "apiRevision":"3", "clientTlsVersion":"1.2", "responseHeaders":{ "X-B3-TraceId":"43bde31fa5060147" }, "backendMethod":"GET", "backendUrl":"https://nephos-qa-open.staples.com/gp-api-tierc-store-locator/v1/storelocator/storeSearch?limit=10&radius=50&storeNumber=0193&locale=en_US", "requestHeaders":{ "X-Forwarded-For":"199.10.28.20,63.217.232.36,23.215.131.118:42751", "X-Azure-Client-Id":"567e713e-e278-4cdd-a90a-653e1de87e0d", "Ocp-Apim-Subscription-Key":"431e8630d74b45eca5921fec2f21f08f" }, "backendResponseHeaders":{ "X-B3-TraceId":"43bde31fa5060147" }, "backendRequestHeaders":{ "X-Forwarded-For":"199.10.28.20,63.217.232.36,23.215.131.118:42751", "X-Azure-Client-Id":"567e713e-e278-4cdd-a90a-653e1de87e0d", "Ocp-Apim-Subscription-Key":"431e8630d74b45eca5921fec2f21f08f" }, "responseBody":"{\"staplesURL\":\"//www.staples.com\",\"results\":{\"status\":\"SUCCESS\",\"stores\":[{\"storeNumber\":\"0193\",\"storeTitle\":\"Staples 0193 - Store 0193 - 217 Broadway (Ves\",\"latitude\":40.7116,\"longitude\":-74.0087,\"storeDivision\":\"V1\",\"storeRegion\":\"R03\",\"emailCopyCenter\":\"print.marketing0193@Staples.com\",\"address\":{\"addressLine1\":\"217 Broadway (Vesey Street)\",\"city\":\"New York\",\"state\":\"NY\",\"zipcode\":\"10007\",\"country\":\"USA\",\"phoneNumber\":\"2123469624\",\"faxNumber\":\"2123469633\"},\"featureVOs\":[{\"featureName\":\"ISP\",\"featureLabel\":\"Buy online. Pickup in store\",\"featureTooltip\":\"We will have your online order ready at your local store within one hour. See an associate for details.\"},{\"featureName\":\"TS\",\"featureLabel\":\"Technology Services\",\"featureTooltip\":\"Complete technology solutions for your home or office from our certified techs.\"},{\"featureName\":\"F1\",\"featureLabel\":\"Computer Workstation\",\"featureTooltip\":\"Private rental areas with Microsoft<sup>®</sup> Office, Internet access, and printing capabilities.\"},{\"featureName\":\"STS\",\"featureLabel\":\"Ship to Store\",\"featureTooltip\":\"Free shipping to your local Staples<sup>®</sup> store when you order online.\"},{\"featureName\":\"CPC\",\"featureLabel\":\"Print & Marketing Services\",\"featureTooltip\":\"Print services ranging from presentations & business cards to signs & banners with expert advice from our Certified Print Pros.\"},{\"featureName\":\"UPS\",\"featureLabel\":\"UPS<sup>®</sup> Prepaid Drop-off\",\"featureTooltip\":\"Drop off any UPS<sup>®</sup> prepaid package for shipment.\"},{\"featureName\":\"MPR\",\"featureLabel\":\"Mobile Printing\",\"featureTooltip\":\"Ability to accept documents submitted through a web enabled mobile device.\"},{\"featureName\":\"FSU\",\"featureLabel\":\"Full-service UPS<sup>®</sup> Shipping\",\"featureTooltip\":\"Easy shipping with UPS and up to 5% back in Staples Rewards. All Staples stores accept UPS prepaid drop-off packages\"}],\"workingHourVOs\":[{\"day\":\"THU\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"TUS\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"WED\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SAT\",\"openTime\":\"0900\",\"closeTime\":\"1800\"},{\"day\":\"FRI\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SUN\",\"openTime\":\"1100\",\"closeTime\":\"1800\"},{\"day\":\"MON\",\"openTime\":\"0800\",\"closeTime\":\"1900\"}]}],\"count\":1}}", "backendResponseBody":"{\"staplesURL\":\"//www.staples.com\",\"results\":{\"status\":\"SUCCESS\",\"stores\":[{\"storeNumber\":\"0193\",\"storeTitle\":\"Staples 0193 - Store 0193 - 217 Broadway (Ves\",\"latitude\":40.7116,\"longitude\":-74.0087,\"storeDivision\":\"V1\",\"storeRegion\":\"R03\",\"emailCopyCenter\":\"print.marketing0193@Staples.com\",\"address\":{\"addressLine1\":\"217 Broadway (Vesey Street)\",\"city\":\"New York\",\"state\":\"NY\",\"zipcode\":\"10007\",\"country\":\"USA\",\"phoneNumber\":\"2123469624\",\"faxNumber\":\"2123469633\"},\"featureVOs\":[{\"featureName\":\"ISP\",\"featureLabel\":\"Buy online. Pickup in store\",\"featureTooltip\":\"We will have your online order ready at your local store within one hour. See an associate for details.\"},{\"featureName\":\"TS\",\"featureLabel\":\"Technology Services\",\"featureTooltip\":\"Complete technology solutions for your home or office from our certified techs.\"},{\"featureName\":\"F1\",\"featureLabel\":\"Computer Workstation\",\"featureTooltip\":\"Private rental areas with Microsoft<sup>®</sup> Office, Internet access, and printing capabilities.\"},{\"featureName\":\"STS\",\"featureLabel\":\"Ship to Store\",\"featureTooltip\":\"Free shipping to your local Staples<sup>®</sup> store when you order online.\"},{\"featureName\":\"CPC\",\"featureLabel\":\"Print & Marketing Services\",\"featureTooltip\":\"Print services ranging from presentations & business cards to signs & banners with expert advice from our Certified Print Pros.\"},{\"featureName\":\"UPS\",\"featureLabel\":\"UPS<sup>®</sup> Prepaid Drop-off\",\"featureTooltip\":\"Drop off any UPS<sup>®</sup> prepaid package for shipment.\"},{\"featureName\":\"MPR\",\"featureLabel\":\"Mobile Printing\",\"featureTooltip\":\"Ability to accept documents submitted through a web enabled mobile device.\"},{\"featureName\":\"FSU\",\"featureLabel\":\"Full-service UPS<sup>®</sup> Shipping\",\"featureTooltip\":\"Easy shipping with UPS and up to 5% back in Staples Rewards. All Staples stores accept UPS prepaid drop-off packages\"}],\"workingHourVOs\":[{\"day\":\"THU\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"TUS\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"WED\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SAT\",\"openTime\":\"0900\",\"closeTime\":\"1800\"},{\"day\":\"FRI\",\"openTime\":\"0800\",\"closeTime\":\"1900\"},{\"day\":\"SUN\",\"openTime\":\"1100\",\"closeTime\":\"1800\"},{\"day\":\"MON\",\"openTime\":\"0800\",\"closeTime\":\"1900\"}]}],\"count\":1}}" }, "resourceId":"/SUBSCRIPTIONS/B00FC482-62DC-49BF-BBD6-9B4CE971B3DB/RESOURCEGROUPS/VAD01_APIM_QE_0/PROVIDERS/MICROSOFT.APIMANAGEMENT/SERVICE/VAD01QEAPIM01" } ] }, "x-opt-sequence-number":16240, "x-opt-offset":"236247275192", "x-opt-enqueued-time":1616070109930 }
... View more