How to write if and else condition in webhook?

[Jin_Tan]

Hi,

I am trying to write if condition in my webhook.

the formula does not work when i use > <> <>

It works fine when i am using <> <> tag only.

Below are my formulas.
<<IF:[Invoice No.]=ANY(SELECT(Sheet2.1[Invoice No.],AND([Sewing Order ID]=[_ThisRow].[SGM D.O. to Sub Con],[Invoice No.]=[_ThisRow].[Invoice No.])))>>

“ID”:"<<ANY(
SELECT(Sheet2.1[ID],
AND([Sewing Order ID]=[_ThisRow].[SGM D.O. to Sub Con],
[Invoice No.]=[_ThisRow].[Invoice No.])))>>",

“SubCon”:"<<[Invoice No.].[Supplier/SubCon]>>",

“Sewing Order ID”:"<<[SGM D.O. to Sub Con]>>",

“Receive Item Description”:"<<[Invoice No.].[Material]>>",

“Receive Item HS Code”:"<<[Invoice No.].[HS Code]>>",

“Invoice No.”:"<<[Invoice No.]>>",

“Total Receive Quantity”:"<<SUM(
SELECT(Invoice Details[Quantity],
AND([SGM D.O. to Sub Con]=[_ThisRow].[SGM D.O. to Sub Con],
[Invoice No.]=[_ThisRow].[Invoice No.])))>>",

“Total Value of Service”:"<<SUM(
SELECT(Invoice Details[Value],
AND([SGM D.O. to Sub Con]=[_ThisRow].[SGM D.O. to Sub Con],
[Invoice No.]=[_ThisRow].[Invoice No.])))>>"

<ELSE:>
“ID”:"<<UNIQUEID()>>",
“SubCon”:"<<[Invoice No.].[Supplier/SubCon]>>",
“Sewing Order ID”:"<<[SGM D.O. to Sub Con]>>",
“Receive Item Description”:"<<[Invoice No.].[Material]>>",
“Receive Item HS Code”:"<<[Invoice No.].[HS Code]>>",
“Invoice No.”:"<<[Invoice No.]>>",
“Total Receive Quantity”:“1”,
“Total Value of Service”:"<<[Value]>>"
<>

[Aleksi]

Instead of using < ELSE > use << EndIf >>