Bugs - some system fields don't work and concatenate seems broken

[paustint]

This formula reports a syntax error (works in Salesforce)

"$Api.Session_ID" & $Api.Session_ID & "\n" &
"$Api.Partner_Server_URL_90" & $Api.Partner_Server_URL_90 & "\n" &
"$CustomMetadata.Billing_Scenario__mdt.Scenario_1.Name__c" & $CustomMetadata.Billing_Scenario__mdt.Scenario_1.Name__c & "\n" &
"$Label.X1LABEL" & $Label.X1LABEL & "\n" &
"$Organization.Id" & $Organization.Id & "\n" &
"$Permission.SBQQ__CPQStandardPerm" & IF($Permission.SBQQ__CPQStandardPerm, "TRUE", "FALSE") & "\n" &
"$Profile.Name" & $Profile.Name & "\n" &
"$Setup.blng__BillingPrefix__c.blng__BarPrefix__c" & $Setup.blng__BillingPrefix__c.blng__BarPrefix__c & "\n" &
"$System.OriginDateTime" & TEXT($System.OriginDateTime) & "\n" &
"$User.City" & $User.City & "\n" &
"$UserRole.Name" & $UserRole.Name

This formula works to extract fields but when using & to concatenate, this breaks if a value is null
Incorrect parameter type for function 'ADD()'. Expected Number, received Null

$Api.Partner_Server_URL_90 &
$Label.X1LABEL &
$Organization.Id &
$Profile.Name &
TEXT($System.OriginDateTime) &
$User.City &
$UserRole.Name

Here was the data I passed in

{
    "$Api.Partner_Server_URL_90": {
        "type": "literal",
        "dataType": "text",
        "value": "https://austin-steelbrick-dev-ed.my.salesforce.com/services/Soap/u/9.0/00D50000000O712",
        "options": {
            "length": 86
        }
    },
    "$Label.X1LABEL": {
        "type": "literal",
        "dataType": "text",
        "value": "Test Label",
        "options": {
            "length": 10
        }
    },
    "$Organization.Id": {
        "type": "literal",
        "dataType": "text",
        "value": "00D50000000O712EAC",
        "options": {
            "length": 18
        }
    },
    "$User.City": {
        "type": "literal",
        "dataType": "null",
        "value": null
    },
    "$Profile.Name": {
        "type": "literal",
        "dataType": "text",
        "value": "System Administrator",
        "options": {
            "length": 20
        }
    },
    "$UserRole.Name": {
        "type": "literal",
        "dataType": "null",
        "value": null
    },
    "$System.OriginDateTime": {
        "type": "literal",
        "dataType": "datetime",
        "value": "1900-02-01T07:00:00.000Z"
    }
}

[paustint]

Did some more troubleshooting - Looks like concatenation does not work on null values - I guess I can set to empty string and it should fix it?

{
    "$User.City": {
        "type": "literal",
        "dataType": "null",
        "value": null
    },
    "$Profile.Name": {
        "type": "literal",
        "dataType": "text",
        "value": "System Administrator",
        "options": {
            "length": 20
        }
    }
}

[leifg]

Thank you for reporting. Was pretty busy the last couple of weeks. Hopefully I can look at this

[github-actions]

🎉 This issue has been resolved in version 6.24.3 🎉

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot 📦🚀

[leifg]

Can you try again with version 6.24.3 (or later)?

[paustint]

@leifg - Still getting the error, but I had previously worked around it by ensuring the value was an empty string.

Initially I was setting the data to this shape below, which produces the error:

{
    type: 'literal',
    dataType: 'null',
    value: null,
}

I have been using this and it has been working correctly:

{
  type: 'literal',
  dataType,
  value: value || '',
  options: {
    length: value?.length || 0,
  },
};

[leifg]

Mmh interesting. I currently don’t have a salesforce account to verify what the expected behavior is.

Can you try switching the order: Concatenate a string with null?

also can you try what happens if you concatenate two null values.

Also does it make a difference wether you use the & operator or the + operator?

[paustint]

@leifg - Just tested again and it looks like it is working. I did upgrade the version again (not sure if that matters), but maybe I tested incorrectly the first time.

Looks like both text and null data types work with concatenation when the value is null and do not throw an error.

I think we are good here - thanks for the fix!