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 |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |