Add multiple rows to another table

Hi all, 

I am having some difficulty with adding multiple rows to another table: 

So far I have this formula in my call a webhook body:

{
"Action": "Add",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"

},
"Rows": [

<<START: SELECT(Selected Checklist Questions[Key], ([Equipment Type] = [_THISROW].[Equipment Type]))>>
{
"Work Order": "<<[Work Order]>>",
"Equipment Category": "<<[Equipment Category]>>",
"Equipment": "<<[Equipment]>>",
"Equipment Type": "<<[Equipment Type]>>",
"Selected Checklist question": "<<[Key]>>",
"Maintenance": "<<[Key]>>"
}
<<End>>
]
}

These are the settings: 

add questions.PNG

What I am trying to do is add whatever questions are selected for the equipment type to the maintenance. There could be one question or 10 or none. 

I have a work order table, a maintenance table and a selected questions table. There is an api that automatically adds maintenance records to the work order for each equipment that is assigned to the location the maintenance is to be done at. Now I just need the questions to be added to the maintenance. 

Thank you, 

Josh 

0 1 86
1 REPLY 1

Just a wild guess.

Could it be just you are missing a comma here? 

....
"Maintenance": "<<[Key]>>"
}, // a comma required??
<<End>>
....

 

Top Labels in this Space