I hope someone can help
I need to store the return from my GET statement into a database table
This is the format of the return, what method would you recommend. I am currently using 2019 but can easily move to 2021 if the new features help.
regards and thanks in advance
Andrew
{
"delivery":[
{
"site_id":"BB000001",
"order_number":"220224-1",
"datetime":"2022-02-24T11:32:12",
"action_request":"WASH"
}
],
"tags":[
{
"order_number":"220224-1",
"epc":"300ED89F33500080000EFF48",
"product_desc":"T-36",
"product_type":"Jacket"
},
{
"order_number":"220224-1",
"epc":"300ED89F33500080000EFF5E",
"product_desc":"CDUSK5-M",
"product_type":"Skirt"
},
{
"order_number":"220224-1",
"epc":"300ED89F33500080000F0E02",
"product_desc":"CDMT7-34",
"product_type":"Trouser"
}
],
"wearer":[
{
"epc":"300ED89F33500080000EFF48",
"wearer_department":"Reservations",
"wearer_name":"22 Jose Adea"
},
{
"epc":"300ED89F33500080000EFF5E",
"wearer_department":"Reservations",
"wearer_name":"22 Jose Adea"
},
{
"epc":"300ED89F33500080000F0E02",
"wearer_department":"Reservations",
"wearer_name":"22 Jose Adea"
}
],
"result":[
{
"status":"Success"
}
]