Handling missing variables from a Webhook call

orn

I am integrating Xano with Salesforce. I've gotten it to work fairly well but when data isn't populated in Salesforce the API callout doesn't include a null value for the variable but rather just strips it from the call.

An example is Middle Name. When it is populated in Salesforce the JSON looks like this:

{
"new":
[
{
"Id": "00QAd000007uz1ZLAQ",
"LastName": "Johnson",
"FirstName": "Joe",
"LeadSource": "Trade Show",
"MiddleName": "Bob",
"Salutation": "Mr.",
},
],
"old":
[
{
}
],
"userId": "0054K000001cmRSQAY"
}

When it isn't populated it looks like this:

{
"new":
[
{
"Id": "00QAd000007uz1ZMAQ",
"LastName": "Johnson",
"FirstName": "Joe",
"LeadSource": "Trade Show",
"Salutation": "Mr.",
},
],
"old":
[
{
}
],
"userId": "0054K000001cmROQAY"
}

When Xano gets the second JSON there is a 500 error with the message: Unable to locate var: fromSalesforce.new.0.MiddleName

Is there a way to handle missing input variables like this somehow? I've tried checking for null but that seems to only check for a null value and not a missing variable.

Michael Udinski

Hi @orn - you can use the GET filter (https://docs.xano.com/working-with-data/dot-notation#get-filter) instead of dot notation. This filter will let you define a default value such as null or an empty string when the middle name is not present in the payload.