Webhook for all rows in table

[jonbowles84]

Hi Guys,

I need a webhook to list all hours of each member of staff from a table, I am currently doing it like this but I'm sure theres a better more dynamic method that doesnt require listing every staff member, anyone got any tips?

{"Staff": [
{
"Xero ID": "<<SELECT(Staff[Xero ID],[Full Name] = "Filip-Leon Biondic")>>",
"Full Name": "<<SELECT(Staff[Full Name],[Full Name] = "Filip-Leon Biondic")>>",
"Pay Hours": "<<SELECT(Staff[Pay Hours],[Full Name] = "Filip-Leon Biondic")>>",
"Pay Hours Over 40": "<<SELECT(Staff[Pay Hours Over 40],[Full Name] = "Filip-Leon Biondic")>>",
"Pay Advice": "<<SELECT(Staff[Pay Advice],[Full Name] = "Filip-Leon Biondic")>>"
},
{
"Xero ID": "<<SELECT(Staff[Xero ID],[Full Name] = "Jon Bowles")>>",
"Full Name": "<<SELECT(Staff[Full Name],[Full Name] = "Jon Bowles")>>",
"Pay Hours": "<<SELECT(Staff[Pay Hours],[Full Name] = "Jon Bowles")>>",
"Pay Hours Over 40": "<<SELECT(Staff[Pay Hours Over 40],[Full Name] = "Jon Bowles")>>",
"Pay Advice": "<<SELECT(Staff[Pay Advice],[Full Name] = "Jon Bowles")>>"
},
{
"Xero ID": "<<SELECT(Staff[Xero ID],[Full Name] = "Paul Edwards")>>",
"Full Name": "<<SELECT(Staff[Full Name],[Full Name] = "Paul Edwards")>>",
"Pay Hours": "<<SELECT(Staff[Pay Hours],[Full Name] = "Paul Edwards")>>",
"Pay Hours Over 40": "<<SELECT(Staff[Pay Hours Over 40],[Full Name] = "Paul Edwards")>>",
"Pay Advice": "<<SELECT(Staff[Pay Advice],[Full Name] = "Paul Edwards")>>"
}
]
}

[Marc_Dillon · Accepted solution]

https://help.appsheet.com/en/articles/961746-template-start-expressions

[jonbowles84]

Thanks!