Adding row by using webhook JSON

[Muzekker_Vatan]

Dear friends,
I had an automation before which was adding row from table2 to table1. My friend was created a webhook and i lost it now. I don't have idea how to create it again.
The body of this automation (workflow) is:
{
"Action": "Add",
"Properties": {
"Locale": "en-US",
"Location": "47.623098, -122.330184",
"Timezone": "Pacific Standard Time"
},
"Rows": [
<<Start: SELECT(FSCHEDULE[ID],[Day]=WEEKDAY(TODAY()))>>
{
"ID": "<<UNIQUEID()>>",
"ROUTE": "<<IFS([ROUTE]="S","SINGLE",[ROUTE]="M","MULTIPLE")>>",
"Date": "<<TODAY()>>",
"ETD": "<<[ETD]>>",
"Flt no": "<<[Flt no]>>",
"Station": "<<[Station]>>",
"AC type": ""
},
<<End>>
]
}

Table2 name is FSCHEDULE
Name of the Table1 is FOps

Could help me to create again webhook for this action?

The error message i am getting is
'FOPS DATA TRANSFER' task 'FOPS DATA TRANSFER_Action 1' The web hook 'Url' for FOPS DATA TRANSFER_Action 1' is missing

Thanks in advance.

[WillowMobileSys]

It looks really good!  Only a few things:

1)  The comma just before <<END>> is not needed - not sure it causes a problem.

2)  I found you cannot simply set a value to "", instead you need to use:

"AC type": "<<TEXT("")>>"

3) Informational....You can rely on Initial Value settings.  For example, if ID has the Initial Value expression of UNIQUEID(), you do not need to specify it in the JSON.  Same idea with "Date".  These help to simply the JSON.

[Muzekker_Vatan]

Hi
The idea here is to get data from SCHEDULE table to FOps table. There is scheduled flight in table SCHEDULE. And this code is getting flight details day before from SCHEDULE to FOps table.
Example; if i have SCHEDULED flight details in table SCHEDULE as
day 2
Flight
route

The code provides me date in FOps table day before which is Monday. That is why i need webhook set up.
Thanks for your answer and hope i have explained clearly.

[WillowMobileSys]

I am not sure of the reason for your response.  Maybe my post wasn't clear?  I am proposing the described changes ONLY to the JSON code you supplied.  1) and 2) are changes you should make, while 3) is optional but will help simplify the JSON.