How do I access a column from current row in a JSON tempate Start Expression

AppSheet AppSheet Q&A
,
1

Hi everyone!

I have 3 tables

SaleOrder

  • OrderID Key
  • Load#

LoadInfo

  • Load# Key
  • Orders Ref_Rows(“SaleOrder”,“Load#”)
  • Products Ref_Rows(“Products”,“Load#”)

Products

  • ProductID Key
  • ProductName
  • Load#

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.

2

Try:

[_THISROW].[OrderID]

See also:

[FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()](https://community.appsheet.com/t/faq-filter-lookup-maxrow-minrow-and-select/24216/43) Tips & Tricks ?

Back-references within nested queries ([_THISROW-n]) Consider a complex App formula with “nested” SELECT() expressions (SELECT() expressions within SELECT() expressions): SELECT( table[column1], … SELECT( table[column2], … SELECT( table[column3], … ) … ) … ) Let’s call the row for which this entire expression is evaluated as its App formula the Origin Row. Within this entire expression, we can refer to column values of the Origin Row by dere…

1 Like
3

FAQ: FILTER(), LOOKUP(), MAXROW(), MINROW(), REF_ROWS(), and SELECT()

_THISROW

It didn’t work.
_THISROW inside START expression refer to the row in Products table.
I needt to access the row in SaleOrder table.