Extract JSON using SQL
I'm trying to extract the following JSON message using SQL: { "document": { "Invoice": { "_NavRecordId": "Purch. Inv. Header: 06IF+230033", "InvoiceNumber": "06IF+230033", "PurchaseOrderNumber": "P0032259", "InvoiceLine": [ { "_NavRecordId": "Purch. Inv. Line: 06IF+230033,1", "item": "A05284", "Quantity": "2", "PurchaseOrderLineNumber": "1" }, {…