I am new to processing json with sql.
I have a very small json document and only need to retrieve 3 fields from every 'record' in the file.
I cannot manage to get the 'numbers' 1,2,4,5 etc into the result set.
I need the number (1) for the first record and (4) for the third record and from the 'records; I also need the name fields.
This should be pretty simple, but unfortunately not simple for me.
Any help would be very much appreciated!