M
Manny
Guest
I have the following JSON structure stored in a file, and I would like to read it dynamically and assign the values to a temp-table:
json
{ "Reprint": { "RequestID": "00000001", "DeviceCode": "001", "Copies": "2" } }
Problem: The direct use of READ-JSON is not working as expected, possibly because this JSON structure is nested, not a flat array.
Goal: I need to retrieve specific values, such as DeviceCode, from the nested structure. How can I read this JSON dynamically and assign its values to my temp-table?
Continue reading...
json
{ "Reprint": { "RequestID": "00000001", "DeviceCode": "001", "Copies": "2" } }
Problem: The direct use of READ-JSON is not working as expected, possibly because this JSON structure is nested, not a flat array.
Goal: I need to retrieve specific values, such as DeviceCode, from the nested structure. How can I read this JSON dynamically and assign its values to my temp-table?
Continue reading...