Hi everyone!
I have 3 tables
SaleOrder
LoadInfo
Products
I have an webhook Task for table SaleOrder and I need to achieve this in the JSON template :
"Rows": [
<<Start: [Load#].[Products >>
{
"OrderID": "<<>>", ---- ****Need get OrderID from current row of SaleOrder ****
"ProductID ": "<<[ProductID ]>>",
"ProductName": "<<[ProductName]>>"
},
<<End>>
I can’t find a solution to put the [OrderID] value to the JSON file.
Does anyone know how to achieve this?
Thanks.
Try:
[_THISROW].[OrderID]
See also:
It didn’t work.
_THISROW inside START expression refer to the row in Products table.
I needt to access the row in SaleOrder table.
User | Count |
---|---|
56 | |
25 | |
13 | |
11 | |
6 |