I've encountered a recurring question with no satisfactory answers. Can someone please clarify things for me?
Let's take a look at a JSON file:
{ 'soapenv:Envelope':
{ '$':
{ 'xmlns:soapenv': 'http://schemas.xmlsoap.org/soap/envelope/',
'xmlns:xsd': 'http://www.w3.org/2001/XMLSchema',
'xmlns:xsi': 'http://www.w3.org/2001/XMLSchema-instance' },
'soapenv:Body':
[ { 'ns1:getTBTransactionsWithFiltersResponse':
[ { '$':
{ 'soapenv:encodingStyle': 'http://schemas.xmlsoap.org/soap/encoding/',
'xmlns:ns1': 'http://TransactionSOAPService/' },
getTBTransactionsWithFiltersReturn:
[ { '$':
{ 'soapenc:arrayType': 'ns2:BeanTBTransaction[1]',
'xsi:type': 'soapenc:Array',
'xmlns:ns2': 'http://TransactionSOAPService.SOAP.genSrv.tt.slb.com',
'xmlns:soapenc': 'http://schemas.xmlsoap.org/soap/encoding/' },
getTBTransactionsWithFiltersReturn: [ { '$': { href: '#id0' } } ] } ] } ],
multiRef:
[ { '$':
{ id: 'id0',
'soapenc:root': '0',
'soapenv:encodingStyle': 'http://schemas.xmlsoap.org/soap/encoding/',
'xsi:type': 'ns3:BeanTBTransaction',
'xmlns:soapenc': 'http://schemas.xmlsoap.org/soap/encoding/',
'xmlns:ns3': 'http://TransactionSOAPService.SOAP.genSrv.tt.slb.com' },
batchId: [ { _: '36', '$': { 'xsi:type': 'xsd:int' } } ],
... (truncated for brevity) ... ] } ] } }
I'm interested in extracting the alphanumId label values and saving them into a variable.
Is there a method to retrieve these label values effectively, considering there could be multiple instances?
Ultimately, I aim to export these values into a CSV file.