Hi … I received a configuration file in JSON that I need to use to check for changes. I have tried to get the JSON into a table but instead of getting a (x) rows, the whole file is a block in a single row.
This is a sample…
[{"id":"10864a80-b662-11ed-a0b3-19a034ecda5d","company":16,"name":"(19) Monitor for merchant turnover that projects to exceed contract volume *","description":"Group \u003d\u003d Setttlement\n\nDetect for a surge in signed volume in 12 month period where processing will exceed the signed volume","savedtime":1678347223398,"severity":3,"queries":[],"enabled":false,"ratelimits":false,"group":"group-incubator","msglife":-1,"headertemplate":"","features":[],"extradetails":{},"availableFlags":[],"emails":[],"distributionLists":[],"phones":[],"actions":"","additionalqueries":[],"testmsg":"","outputchannels":[],"conditional_rules":[]}
{"id":"59a32df0-b662-11ed-a0b3-19a034ecda5d","company":16,"name":"I020 | Daily PAN use at MID limit exceeded","description":"Monitor for the same card being used at the same MID in 1 day","feed":"company16.curated.cluster.settlements","savedtime":1688384257168,"severity":0,"queries":["\"{{fraudChecksEnabled}}\" \u003d\u003d true","\"{{LS_DailyPANatMIDCount}}\" \u003e 5"],"enabled":true,"ratelimits":false,"group":"group-cluster-settlement","msglife":-1,"headertemplate":"rc:3f2fb380-b35b-11ed-a030-19a034ecda5d:{{transactionId}}","features":[],"extradetails":{},"availableFlags":[],"emails":[],"distributionLists":[],"phones":[],"actions":"","additionalqueries":[],"testmsg":"{\n \"postilionTranNumber\": 1234567890,\n \"LS_DailyPANatMIDCount\": 6,\n \"fraudChecksEnabled\": true,\n \"mid\": \"999418999111222\",\n \"LS_Curated_001_timestamp\": 1686742350044,\n \"LS_RecentTAPandGoCount\": 6,\n \"transactionTime\": \"092450\",\n \"mcc\": 0,\n \"deviceId\": -1,\n \"tid\": \"23423423\",\n \"responseCode\": \"92\",\n \"LS_Curated_003_timestamp\": 1686742350107,\n \"LS_Curated_005_timestamp\": 1686742350140,\n \"LS_Curated_004_result\": \"success\",\n \"amount\": 65,\n \"LS_Curated_005_result\": \"success\",\n \"clientId\": 0,\n \"maskedPan\": \"123456******1234\",\n \"LS_Curated_002_result\": \"counted\",\n \"LS_Curated_003_result\": \"counted\",\n \"cardAcceptor\": \"Demo TOP CPT ZA\",\n \"LS_Curated_002_timestamp\": 1686742350076,\n \"transactionDate\": \"20230529\",\n \"LS_IsPANWatchlisted\": false,\n \"transactionId\": \"e61b07a5-c85a-4f23-b9be-18730f2517eb\",\n \"rrn\": \"274456298679\",\n \"transactionType\": 71,\n \"LS_IsTAPAndGo\": true,\n \"accountId\": 0,\n \"LS_Curated_004_timestamp\": 1686742350125,\n \"LS_IsRefund\": false,\n \"stan\": 27,\n \"LS_Curated_001_result\": \"counted\",\n \"posEntryMode\": 71\n}","outputchannels":[],"conditional_rules":[]}]
How do I read or split this into individual rows?
Thanks,
tC/.
