Useremail in Json Webhook

AppSheet AppSheet Q&A
1

Hello, I’ve built an app that is used to report faulty mobile phones.

When this is done I have a webhook running connection the information to other databases through the information I get from a Webhook from Appsheet

It looks like this:

[
    {
        "UpdateMode": "Update",
        "Application": "EBBDeployment",
        "TableName": "Replacement",
        "UserName": "",
        "At": "2022-06-23 10:21:56",
        "Data": {
            "Timestamp": "2022-06-03 17:51:02",
            "UUID": "35924b84",
            "Filial": "017 - Essingen",
            "IMEI": "351921580305912",
            "Serialnumber": "R58RB492P1H",
            "Phonenumber": "46700008050",
            "Profile": "Bud",
            "GroupID": "160",
            "Issue": "Other",
            "Description": "test",
            "Replacement": "Y",
            "File": "",
            "Replacement-IMEI": "351921589867417",
            "Replacement-SerialNumber": "R58RB3TG45E",
            "Replacement-PhoneNumber": "46700817873"
        }
    }
]

Now I wish to replace UserName to UserEmail

Email instead because I’m going to implement an internal booking of a package and send the label to UserEmail.

I’ve found some documentation and questions in this forum but not exactly what I’m searching for.

How do I replace userName without losing all other information?

{
  "MyTable": [
  <<Start: Select(MyTable[MyKey], TRUE)>>
      {
         "UpdateMode": "<<_UPDATEMODE>>",
         "Application": "<<_APPNAME>>,
         "TableName": "<<_TABLENAME>>,
         "UserEmail": "<<_USEREMAIL>>
      },
   <<End>>
   ]
}

Is the above example the correct format or is it just plain json similar to the original output?

Thanks in advance

2

Not quite sure exactly what you’re asking, like why would you “lose all other information”? But maybe try <<USEREMAIL()>> instead of the template variable?

1 Like
3

Sorry, maybe I explained it badly.

I meant I still want all other information that is being sent now plus userEmail, so just adding userEmail I figured would only send just that information.

So I was mostly wondering if the example I gave if I was following the correct template.

But I will try adding all variables with <<>> around them.