Retool webhook - accept data from external system

App Building
1

Hi,
I want to integrate my workflow with external system, the system will send data to webhook url. The structure is like below and I can't change it:

  [
        {
            "TxnId": "EV201705111541CN", 
            "PaymentStatus": "Completed", 
            "To": {
                "Name": "John", 
                "Company": "xxx", 
                "Street": "xxxxxx", 
                "Street2": "", 
                "State": "CA", 
                "City": "Culver City", 
                "ZipCode": "xxxxxxxxxx", 
                "CountryCode": "US", 
                "PhoneNumber": "xxxxx", 
                "Email": "fake@sey.com"
            }, 
            "OrderTotals": { }, 
            "OrderDetails": { }, 
            "OrderItems": [
                {
                    "Name": "Camera", 
                    "ItemId": "1", 
                    "Quantity": 2
                }
            ]
        }
    ]

But in my workflow's trigger I am getting it wrong :slight_smile:
is there a way to parse this data from startTrigger.data ?

Thanks

2 
'[{"TxnId":"xxx","StoreType":"Manual","StoreKey":"","SellerID":"","OrderSource":"","xx":"","PaymentStatus":"Completed","LastUpdateDate":"2024-01-07 11:31:53","To":{"Name":"test 2","FirstName":"test","LastName":"2","Company":"","Street":"22 xxRd","Street2":"","State":"NJ","City":"Lakewood","ZipCode":"xx","Country":"United xx","CountryCode":"US","PhoneNumber":"","Email":""},"BillTo":{"Name":"","Company":"","Street":"","Street2":"","State":"","City":"","ZipCode":""},"OrderTotals":{"Shipping":"10.00","Handling":"","Discount":"","Tax":"","InsuranceType":"teapplix","Currency":"USD","Fee":"","Total":"16.00","PaymentType":""},"OrderDetails":{"Invoice":"","PaymentDate":"2024-01-07 10:36:38","Memo":"note","PrivateMemo":"Private Note","GiftMessage":"Gift Message","WarehouseId":"5","QueueId":"3","ShipClass":"","Custom":"","Custom2":""},"OrderItems":': {
    '{"Name":"test item 1 ","LineNumber":"1","ItemId":"","Description":"","Quantity":"1","CancelQuantity":"0","Amount":"1.00"},{"Name":"test item 2 ","LineNumber":"2","ItemId":"","Description":"","Quantity":"2","CancelQuantity":"0","Amount":"2.00"},{"Name":"test item 3 ","LineNumber":"3","ItemId":"","Description":"","Quantity":"3","CancelQuantity":"0","Amount":"3.00"}': [ '' ]
  }
}

this is a sample of what webhook is parsing/ receiving , it's interesting how it is splitting on "OrderItems":':

3

this is correctly parsed in other system like pabbly