How to parse multiline json containing multiple arrays


(Jason Gregory) #1

Very new to ELK. Need assistance figuring out out to import the following json input which contains several arrays within it.

{
"Status": "0",
"Message": "OK",
"Count": "507",
"BookingRecords": [
{
"BookDate": "1/3/2017 12:00:00 AM",
"BookLocation": "017",
"BookNumber": "17001056",
"BookingRecordHeaderDetails": [
{
"InvNum": "17001056",
"Location": "017",
"InvDate": "1/3/2017 12:00:00 AM",
"FiscalMonth": "0",
"GROWID": null,
"FIELDID": null,
"DueDate": "8/31/2017 12:00:00 AM",
"ApplicatorID": "",
"VehicleID": "",
"SalesmanID": "0103",
"COMMENTS": "",
"FooterComments": "",
"SourceTickets": "",
"CROPID": "",
"ACRES": "0"
}
],
"BookingRecordSplitDetails": [
{
"UniqueID": "18427",
"InvNum": "17001056",
"Location": "017",
"InvoiceDate": "1/3/2017 12:00:00 AM",
"Splitnum": "1",
"CUSTID": "010444",
"PERCENTS1": "100",
"PERCENTS2": "0",
"PERCENTS3": "0",
"PESTEXP": "1/1/1900 12:00:00 AM",
"quotelistflag": "",
"AmountPaid": "0",
"PaidTF": "False"
}
],
"BookingRecordLineItemDetails": [
{
"UniqueID": "48304",
"InvNum": "17001056",
"Location": "017",
"InvoiceDate": "1/3/2017 12:00:00 AM",
"LINEITEM": "1",
"CUSTID": "010444",
"DEPTID": "103303",
"PRODID": "070075",
"ProdDesc": "89 UNLEADED W/ ETHANOL",
"RATEACRE": "0",
"RATEUNIT": "",
"QUANT": "0"
}
],
"BookingRecordAnalysisDetails": []
}
]
}


(system) #2

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