Hello Expert,
I am asking how to make JSON format using SQL query.
This is the format:
{
"InventoryCountingLines": [
{
"LineNumber": 1,
"ItemCode": "1",
"WarehouseCode": "1",
"BinEntry":1,
"InventoryCountingLineUoMs": [
{
"LineNumber": 1,
"ChildNumber": 1,
"CountedQuantity": 90.0
}
]
}, {
"LineNumber": 2,
"ItemCode": "2",
"WarehouseCode": "2",
"BinEntry":2,
"InventoryCountingLineUoMs": [
{
"LineNumber": 2,
"ChildNumber": 1,
"CountedQuantity": 90.0
}
]
}
]
}
This is the data:
| ItemCode | WarehouseCode | BinEntry | LineNumber | ChildNumber | CountedQuantity |
| 1 | 1 | 1 | 1 | 1 | 27650 |
| 2 | 2 | 2 | 2 | 1 | 4000 |
Thank you in Advanced!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.