Click HERE to see how Saviynt Intelligence is transforming the industry. |
10/22/2024 11:40 PM
Hello, I need to include a whole logic to a json based on the if else conditions for country attribute. Unfortunately the number of attributes seems to be too large. The if else statement is working, until there is not too many conditions. Could you please help me here?
This worked:
"httpParams": "{\"externalId\":\"${user.email}\",\"userName\":\"${user.username}\",\"firstName\":\"${user.firstname}\",\"lastName\":\"${user.lastname}\",\"primaryEmail\":\"${user.email}\",\"address\":{\"country\":\"${user.customproperty7 == 'Aruba' ? 'ABW' : user.customproperty7 == 'Afghanistan' ? 'AFG' : user.customproperty7 == 'Angola' ? 'AGO' : user.customproperty7 == 'Argentina' ? 'ARG' : user.customproperty7 == 'Australia' ? 'AUS' : user.customproperty7 == 'Austria' ? 'AUT' : user.customproperty7 == 'Belgium' ? 'BEL' : user.customproperty7 == 'Brazil' ? 'BRA' : user.customproperty7 == 'Canada' ? 'CAN' : user.customproperty7 == 'China' ? 'CHN' : user.customproperty7 == 'France' ? 'FRA' : user.customproperty7 == 'Germany' ? 'DEU' : user.customproperty7 == 'India' ? 'IND' : user.customproperty7 == 'Indonesia' ? 'IDN' : user.customproperty7 == 'Italy' ? 'ITA' : user.customproperty7 == 'Japan' ? 'JPN' : user.customproperty7 == 'Mexico' ? 'MEX' : user.customproperty7 == 'Netherlands' ? 'NLD' : user.customproperty7 == 'New Zealand' ? 'NZL' : user.customproperty7 == 'Poland' ? 'POL' : user.customproperty7 == 'Russia' ? 'RUS' : user.customproperty7 == 'South Africa' ? 'ZAF' : user.customproperty7 == 'Spain' ? 'ESP' : user.customproperty7 == 'Sweden' ? 'SWE' : user.customproperty7 == 'Switzerland' ? 'CHE' : user.customproperty7 == 'United Kingdom' ? 'GBR' : user.customproperty7 == 'United States' ? 'USA' : null}\"},\"line1\":\"${user.customproperty39=='GUESTUSER'?null:user.street}\",\"city\":\"${user.customproperty39=='GUESTUSER'?null:user.city}\",\"state\":\"${user.customproperty39=='GUESTUSER'?null:user.state}\",\"zipCode\":\"${user.customproperty39=='GUESTUSER'?null:user.regioncode}\"},\"workerStatus\":{\"lastHireDate\":\"${user.customproperty39=='GUESTUSER'?null:Date.parse('MM-dd-yyyy', user.customproperty41).format('yyyy-MM-dd')}T00:00:00\",\"active\":${user.statuskey==0?false:true}},\"settings\":{},\"managerId\":${ if (managerAccount == null || managerAccount?.accountID == null || managerAccount?.accountID == '' ){null} else {managerAccount?.accountID} },\"customFields\":[{\"id\":134,\"value\":\"${user.customproperty39=='GUESTUSER'? null : user.costcenter}\"},{\"id\":138,\"value\":\"${if (user.customproperty39 == 'GUESTUSER') {null} else if (user.customproperty52 == null || user.customproperty52 == '') {null} else {user.customproperty52}}\"},{\"id\":139,\"value\": \"${user.customproperty39=='GUESTUSER'? 107 : user.customproperty42=='Indirect'? 106 : 105}\"},{\"id\":140,\"value\":\"${if (user.customproperty39 == 'GUESTUSER') {null} else if (user.customproperty8 == null || user.customproperty4 == null || user.customproperty8 == '' || user.customproperty4 == '') {null} else {user.customproperty8 + ', ' + user.customproperty4}}\"},{\"id\":141,\"value\":true},{\"id\":142,\"value\":\"${if (user.customproperty39 == 'GUESTUSER') {null} else if (user.customproperty51 == null || user.customproperty51 == '') {null} else {user.customproperty51}}\"},{\"id\":143,\"value\":\"${if (user.customproperty39 == 'GUESTUSER') {null} else if (user.customproperty49 == null || user.customproperty43 == null || user.customproperty49 == '' || user.customproperty43 == '') {null} else {user.customproperty49 + ' - ' + user.customproperty43}}\"},{\"id\":144,\"value\":\"${if (user.customproperty39 == 'GUESTUSER') {null} else if (user.customproperty19 == null || user.customproperty19 == '') {null} else {user.customproperty19}}\"},{\"id\":145,\"value\":\"${if (user.customproperty39 == 'GUESTUSER') {null} else if (user.customproperty21 == null || user.customproperty22 == null || user.customproperty21 == '' || user.customproperty22 == '') {null} else {user.customproperty21 + ' - ' + user.customproperty22}}\"},{\"id\":146,\"value\":\"${if (user.customproperty39 == 'GUESTUSER') {null} else if (user.customproperty15 == null || user.customproperty15 == '') {null} else {user.customproperty15}}\"},{\"id\":147,\"value\":\"${user.customproperty39=='GUESTUSER'? null : user.job_function}\"}]}"
But the target list is around 10 times bigger and even following the same logic it simply doesn`t work.
10/22/2024 11:50 PM
@Marek_Kornik there isn't any limit on number of if else statement.
10/23/2024 01:52 AM
But for this set (complete set of data) it doesn`t work at all, just throws error:
{\"country\":\"${user.customproperty7 == 'Aruba' ? 'ABW' : user.customproperty7 == 'AW' ? 'ABW' : user.customproperty7 == 'Afghanistan' ? 'AFG' : user.customproperty7 == 'AF' ? 'AFG' : user.customproperty7 == 'Angola' ? 'AGO' : user.customproperty7 == 'AO' ? 'AGO' : user.customproperty7 == 'Anguilla' ? 'AIA' : user.customproperty7 == 'AI' ? 'AIA' : user.customproperty7 == 'Aland Islands' ? 'ALA' : user.customproperty7 == 'AX' ? 'ALA' : user.customproperty7 == 'Albania' ? 'ALB' : user.customproperty7 == 'AL' ? 'ALB' : user.customproperty7 == 'Andorra' ? 'AND' : user.customproperty7 == 'AD' ? 'AND' : user.customproperty7 == 'United Arab Emirates' ? 'ARE' : user.customproperty7 == 'AE' ? 'ARE' : user.customproperty7 == 'Argentina' ? 'ARG' : user.customproperty7 == 'AR' ? 'ARG' : user.customproperty7 == 'Armenia' ? 'ARM' : user.customproperty7 == 'AM' ? 'ARM' : user.customproperty7 == 'American Samoa' ? 'ASM' : user.customproperty7 == 'AS' ? 'ASM' : user.customproperty7 == 'Antarctica' ? 'ATA' : user.customproperty7 == 'AQ' ? 'ATA' : user.customproperty7 == 'French Southern Territories' ? 'ATF' : user.customproperty7 == 'TF' ? 'ATF' : user.customproperty7 == 'Antigua and Barbuda' ? 'ATG' : user.customproperty7 == 'AG' ? 'ATG' : user.customproperty7 == 'Australia' ? 'AUS' : user.customproperty7 == 'AU' ? 'AUS' : user.customproperty7 == 'Austria' ? 'AUT' : user.customproperty7 == 'AT' ? 'AUT' : user.customproperty7 == 'Azerbaijan' ? 'AZE' : user.customproperty7 == 'AZ' ? 'AZE' : user.customproperty7 == 'Burundi' ? 'BDI' : user.customproperty7 == 'BI' ? 'BDI' : user.customproperty7 == 'Belgium' ? 'BEL' : user.customproperty7 == 'BE' ? 'BEL' : user.customproperty7 == 'Benin' ? 'BEN' : user.customproperty7 == 'BJ' ? 'BEN' : user.customproperty7 == 'Bonaire, Sint Eustatius and Saba' ? 'BES' : user.customproperty7 == 'BQ' ? 'BES' : user.customproperty7 == 'Burkina Faso' ? 'BFA' : user.customproperty7 == 'BF' ? 'BFA' : user.customproperty7 == 'Bangladesh' ? 'BGD' : user.customproperty7 == 'BD' ? 'BGD' : user.customproperty7 == 'Bulgaria' ? 'BGR' : user.customproperty7 == 'BG' ? 'BGR' : user.customproperty7 == 'Bahrain' ? 'BHR' : user.customproperty7 == 'BH' ? 'BHR' : user.customproperty7 == 'Bahamas' ? 'BHS' : user.customproperty7 == 'BS' ? 'BHS' : user.customproperty7 == 'Bosnia and Herzegovina' ? 'BIH' : user.customproperty7 == 'BA' ? 'BIH' : user.customproperty7 == 'Saint Barthélemy' ? 'BLM' : user.customproperty7 == 'BL' ? 'BLM' : user.customproperty7 == 'Belarus' ? 'BLR' : user.customproperty7 == 'BY' ? 'BLR' : user.customproperty7 == 'Belize' ? 'BLZ' : user.customproperty7 == 'BZ' ? 'BLZ' : user.customproperty7 == 'Bermuda' ? 'BMU' : user.customproperty7 == 'BM' ? 'BMU' : user.customproperty7 == 'Bolivia, Plurinational State of' ? 'BOL' : user.customproperty7 == 'BO' ? 'BOL' : user.customproperty7 == 'Brazil' ? 'BRA' : user.customproperty7 == 'BR' ? 'BRA' : user.customproperty7 == 'Barbados' ? 'BRB' : user.customproperty7 == 'BB' ? 'BRB' : user.customproperty7 == 'Brunei Darussalam' ? 'BRN' : user.customproperty7 == 'BN' ? 'BRN' : user.customproperty7 == 'Bhutan' ? 'BTN' : user.customproperty7 == 'BT' ? 'BTN' : user.customproperty7 == 'Bouvet Island' ? 'BVT' : user.customproperty7 == 'BV' ? 'BVT' : user.customproperty7 == 'Botswana' ? 'BWA' : user.customproperty7 == 'BW' ? 'BWA' : user.customproperty7 == 'Central African Republic' ? 'CAF' : user.customproperty7 == 'CF' ? 'CAF' : user.customproperty7 == 'Canada' ? 'CAN' : user.customproperty7 == 'CA' ? 'CAN' : user.customproperty7 == 'Cocos (Keeling) Islands' ? 'CCK' : user.customproperty7 == 'CC' ? 'CCK' : user.customproperty7 == 'Switzerland' ? 'CHE' : user.customproperty7 == 'CH' ? 'CHE' : user.customproperty7 == 'Chile' ? 'CHL' : user.customproperty7 == 'CL' ? 'CHL' : user.customproperty7 == 'China' ? 'CHN' : user.customproperty7 == 'CN' ? 'CHN' : user.customproperty7 == 'Cote d'Ivoire' ? 'CIV' : user.customproperty7 == 'CI' ? 'CIV' : user.customproperty7 == 'Cameroon' ? 'CMR' : user.customproperty7 == 'CM' ? 'CMR' : user.customproperty7 == 'Congo, Democratic Republic of the' ? 'COD' : user.customproperty7 == 'CD' ? 'COD' : user.customproperty7 == 'Congo' ? 'COG' : user.customproperty7 == 'CG' ? 'COG' : user.customproperty7 == 'Cook Islands' ? 'COK' : user.customproperty7 == 'CK' ? 'COK' : user.customproperty7 == 'Croatia' ? 'HRV' : user.customproperty7 == 'HR' ? 'HRV' : user.customproperty7 == 'Haiti' ? 'HTI' : user.customproperty7 == 'HT' ? 'HTI' : user.customproperty7 == 'HU' ? 'HUN' : user.customproperty7 == 'Hungary' ? 'HUN' : user.customproperty7 == 'ID' ? 'IDN' : user.customproperty7 == 'Indonesia' ? 'IDN' : user.customproperty7 == 'IM' ? 'IMN' : user.customproperty7 == 'Isle of Man' ? 'IMN' : user.customproperty7 == 'IN' ? 'IND' : user.customproperty7 == 'India' ? 'IND' : user.customproperty7 == 'British Indian Ocean Territory' ? 'IOT' : user.customproperty7 == 'IO' ? 'IOT' : user.customproperty7 == 'IE' ? 'IRL' : user.customproperty7 == 'Ireland' ? 'IRL' : user.customproperty7 == 'IR' ? 'IRN' : user.customproperty7 == 'Iran, Islamic Republic of' ? 'IRN' : user.customproperty7 == 'IQ' ? 'IRQ' : user.customproperty7 == 'Iraq' ? 'IRQ' : user.customproperty7 == 'Iceland' ? 'ISL' : user.customproperty7 == 'IS' ? 'ISL' : user.customproperty7 == 'IL' ? 'ISR' : user.customproperty7 == 'Israel' ? 'ISR' : user.customproperty7 == 'IT' ? 'ITA' : user.customproperty7 == 'Italy' ? 'ITA' : user.customproperty7 == 'Jamaica' ? 'JAM' : user.customproperty7 == 'JM' ? 'JAM' : user.customproperty7 == 'JE' ? 'JEY' : user.customproperty7 == 'Jersey' ? 'JEY' : user.customproperty7 == 'JO' ? 'JOR' : user.customproperty7 == 'Jordan' ? 'JOR' : user.customproperty7 == 'Japan' ? 'JPN' : user.customproperty7 == 'JP' ? 'JPN' : user.customproperty7 == 'Kazakhstan' ? 'KAZ' : user.customproperty7 == 'KZ' ? 'KAZ' : user.customproperty7 == 'KE' ? 'KEN' : user.customproperty7 == 'Kenya' ? 'KEN' : user.customproperty7 == 'KG' ? 'KGZ' : user.customproperty7 == 'Kyrgyzstan' ? 'KGZ' : user.customproperty7 == 'Cambodia' ? 'KHM' : user.customproperty7 == 'KH' ? 'KHM' : user.customproperty7 == 'KI' ? 'KIR' : user.customproperty7 == 'Kiribati' ? 'KIR' : user.customproperty7 == 'KN' ? 'KNA' : user.customproperty7 == 'Saint Kitts and Nevis' ? 'KNA' : user.customproperty7 == 'Korea, Republic of' ? 'KOR' : user.customproperty7 == 'KR' ? 'KOR' : user.customproperty7 == 'Kuwait' ? 'KWT' : user.customproperty7 == 'KW' ? 'KWT' : user.customproperty7 == 'LA' ? 'LAO' : user.customproperty7 == 'Lao People's Democratic Republic' ? 'LAO' : user.customproperty7 == 'LB' ? 'LBN' : user.customproperty7 == 'Lebanon' ? 'LBN' : user.customproperty7 == 'Liberia' ? 'LBR' : user.customproperty7 == 'LR' ? 'LBR' : user.customproperty7 == 'Libya' ? 'LBY' : user.customproperty7 == 'LY' ? 'LBY' : user.customproperty7 == 'LC' ? 'LCA' : user.customproperty7 == 'Saint Lucia' ? 'LCA' : user.customproperty7 == 'LI' ? 'LIE' : user.customproperty7 == 'Liechtenstein' ? 'LIE' : user.customproperty7 == 'LK' ? 'LKA' : user.customproperty7 == 'Sri Lanka' ? 'LKA' : user.customproperty7 == 'Lesotho' ? 'LSO' : user.customproperty7 == 'LS' ? 'LSO' : user.customproperty7 == 'Lithuania' ? 'LTU' : user.customproperty7 == 'LT' ? 'LTU' : user.customproperty7 == 'LU' ? 'LUX' : user.customproperty7 == 'Luxembourg' ? 'LUX' : user.customproperty7 == 'Latvia' ? 'LVA' : user.customproperty7 == 'LV' ? 'LVA' : user.customproperty7 == 'Macao' ? 'MAC' : user.customproperty7 == 'MO' ? 'MAC' : user.customproperty7 == 'MF' ? 'MAF' : user.customproperty7 == 'Saint Martin (French Part)' ? 'MAF' : user.customproperty7 == 'MA' ? 'MAR' : user.customproperty7 == 'Morocco' ? 'MAR' : user.customproperty7 == 'MC' ? 'MCO' : user.customproperty7 == 'Monaco' ? 'MCO' : user.customproperty7 == 'MD' ? 'MDA' : user.customproperty7 == 'Moldova' ? 'MDA' : user.customproperty7 == 'Madagascar' ? 'MDG' : user.customproperty7 == 'MG' ? 'MDG' : user.customproperty7 == 'Maldives' ? 'MDV' : user.customproperty7 == 'MV' ? 'MDV' : user.customproperty7 == 'Mexico' ? 'MEX' : user.customproperty7 == 'MX' ? 'MEX' : user.customproperty7 == 'Marshall Islands' ? 'MHL' : user.customproperty7 == 'MH' ? 'MHL' : user.customproperty7 == 'MK' ? 'MKD' : user.customproperty7 == 'North Macedonia' ? 'MKD' : user.customproperty7 == 'Mali' ? 'MLI' : user.customproperty7 == 'ML' ? 'MLI' : user.customproperty7 == 'Malta' ? 'MLT' : user.customproperty7 == 'MT' ? 'MLT' : user.customproperty7 == 'MM' ? 'MMR' : user.customproperty7 == 'Myanmar' ? 'MMR' : user.customproperty7 == 'ME' ? 'MNE' : user.customproperty7 == 'Montenegro' ? 'MNE' : user.customproperty7 == 'MN' ? 'MNG' : user.customproperty7 == 'Mongolia' ? 'MNG' : user.customproperty7 == 'MP' ? 'MNP' : user.customproperty7 == 'Northern Mariana Islands' ? 'MNP' : user.customproperty7 == 'Mozambique' ? 'MOZ' : user.customproperty7 == 'MZ' ? 'MOZ' : user.customproperty7 == 'Mauritania' ? 'MRT' : user.customproperty7 == 'MR' ? 'MRT' : user.customproperty7 == 'Montserrat' ? 'MSR' : user.customproperty7 == 'MS' ? 'MSR' : user.customproperty7 == 'Martinique' ? 'MTQ' : user.customproperty7 == 'MQ' ? 'MTQ' : user.customproperty7 == 'Mauritius' ? 'MUS' : user.customproperty7 == 'MU' ? 'MUS' : user.customproperty7 == 'Malawi' ? 'MWI' : user.customproperty7 == 'MW' ? 'MWI' : user.customproperty7 == 'Malaysia' ? 'MYS' : user.customproperty7 == 'MY' ? 'MYS' : user.customproperty7 == 'Mayotte' ? 'MYT' : user.customproperty7 == 'YT' ? 'MYT' : user.customproperty7 == 'NA' ? 'NAM' : user.customproperty7 == 'Namibia' ? 'NAM' : user.customproperty7 == 'NC' ? 'NCL' : user.customproperty7 == 'New Caledonia' ? 'NCL' : user.customproperty7 == 'NE' ? 'NER' : user.customproperty7 == 'Niger' ? 'NER' : user.customproperty7 == 'NF' ? 'NFK' : user.customproperty7 == 'Norfolk Island' ? 'NFK' : user.customproperty7 == 'NG' ? 'NGA' : user.customproperty7 == 'Nigeria' ? 'NGA' : user.customproperty7 == 'NI' ? 'NIC' : user.customproperty7 == 'Nicaragua' ? 'NIC' : user.customproperty7 == 'Niue' ? 'NIU' : user.customproperty7 == 'NU' ? 'NIU' : user.customproperty7 == 'Netherlands' ? 'NLD' : user.customproperty7 == 'NL' ? 'NLD' : user.customproperty7 == 'NO' ? 'NOR' : user.customproperty7 == 'Norway' ? 'NOR' : user.customproperty7 == 'Nepal' ? 'NPL' : user.customproperty7 == 'NP' ? 'NPL' : user.customproperty7 == 'Nauru' ? 'NRU' : user.customproperty7 == 'NR' ? 'NRU' : user.customproperty7 == 'New Zealand' ? 'NZL' : user.customproperty7 == 'NZ' ? 'NZL' : user.customproperty7 == 'OM' ? 'OMN' : user.customproperty7 == 'Oman' ? 'OMN' : user.customproperty7 == 'Pakistan' ? 'PAK' : user.customproperty7 == 'PK' ? 'PAK' : user.customproperty7 == 'PA' ? 'PAN' : user.customproperty7 == 'Panama' ? 'PAN' : user.customproperty7 == 'Pitcairn' ? 'PCN' : user.customproperty7 == 'PN' ? 'PCN' : user.customproperty7 == 'PE' ? 'PER' : user.customproperty7 == 'Peru' ? 'PER' : user.customproperty7 == 'PH' ? 'PHL' : user.customproperty7 == 'Philippines' ? 'PHL' : user.customproperty7 == 'Palau' ? 'PLW' : user.customproperty7 == 'PW' ? 'PLW' : user.customproperty7 == 'Papua New Guinea' ? 'PNG' : user.customproperty7 == 'PG' ? 'PNG' : user.customproperty7 == 'PL' ? 'POL' : user.customproperty7 == 'Poland' ? 'POL' : user.customproperty7 == 'PR' ? 'PRI' : user.customproperty7 == 'Puerto Rico' ? 'PRI' : user.customproperty7 == 'Korea, Democratic People's Republic of' ? 'PRK' : user.customproperty7 == 'KP' ? 'PRK' : user.customproperty7 == 'Portugal' ? 'PRT' : user.customproperty7 == 'PT' ? 'PRT' : user.customproperty7 == 'Paraguay' ? 'PRY' : user.customproperty7 == 'PY' ? 'PRY' : user.customproperty7 == 'Palestine, State of' ? 'PSE' : user.customproperty7 == 'PS' ? 'PSE' : user.customproperty7 == 'French Polynesia' ? 'PYF' : user.customproperty7 == 'PF' ? 'PYF' : user.customproperty7 == 'QA' ? 'QAT' : user.customproperty7 == 'Qatar' ? 'QAT' : user.customproperty7 == 'RE' ? 'REU' : user.customproperty7 == 'Réunion' ? 'REU' : user.customproperty7 == 'RO' ? 'ROU' : user.customproperty7 == 'Romania' ? 'ROU' : user.customproperty7 == 'RU' ? 'RUS' : user.customproperty7 == 'Russia' ? 'RUS' : user.customproperty7 == 'RW' ? 'RWA' : user.customproperty7 == 'Rwanda' ? 'RWA' : user.customproperty7 == 'SA' ? 'SAU' : user.customproperty7 == 'Saudi Arabia' ? 'SAU' : user.customproperty7 == 'SD' ? 'SDN' : user.customproperty7 == 'Sudan' ? 'SDN' : user.customproperty7 == 'Senegal' ? 'SEN' : user.customproperty7 == 'SN' ? 'SEN' : user.customproperty7 == 'SG' ? 'SGP' : user.customproperty7 == 'Singapore' ? 'SGP' : user.customproperty7 == 'GS' ? 'SGS' : user.customproperty7 == 'South Georgia and the South Sandwich Islands' ? 'SGS' : user.customproperty7 == 'Saint Helena, Ascension and Tristan da Cunha' ? 'SHN' : user.customproperty7 == 'SH' ? 'SHN' : user.customproperty7 == 'SJ' ? 'SJM' : user.customproperty7 == 'Svalbard and Jan Mayen' ? 'SJM' : user.customproperty7 == 'SB' ? 'SLB' : user.customproperty7 == 'Solomon Islands' ? 'SLB' : user.customproperty7 == 'Sierra Leone' ? 'SLE' : user.customproperty7 == 'SL' ? 'SLE' : user.customproperty7 == 'El Salvador' ? 'SLV' : user.customproperty7 == 'SV' ? 'SLV' : user.customproperty7 == 'San Marino' ? 'SMR' : user.customproperty7 == 'SM' ? 'SMR' : user.customproperty7 == 'SO' ? 'SOM' : user.customproperty7 == 'Somalia' ? 'SOM' : user.customproperty7 == 'PM' ? 'SPM' : user.customproperty7 == 'Saint Pierre and Miquelon' ? 'SPM' : user.customproperty7 == 'RS' ? 'SRB' : user.customproperty7 == 'Serbia' ? 'SRB' : user.customproperty7 == 'South Sudan' ? 'SSD' : user.customproperty7 == 'SS' ? 'SSD' : user.customproperty7 == 'Sao Tome and Principe' ? 'STP' : user.customproperty7 == 'ST' ? 'STP' : user.customproperty7 == 'SR' ? 'SUR' : user.customproperty7 == 'Suriname' ? 'SUR' : user.customproperty7 == 'SK' ? 'SVK' : user.customproperty7 == 'Slovakia' ? 'SVK' : user.customproperty7 == 'SI' ? 'SVN' : user.customproperty7 == 'Slovenia' ? 'SVN' : user.customproperty7 == 'SE' ? 'SWE' : user.customproperty7 == 'Sweden' ? 'SWE' : user.customproperty7 == 'Swaziland' ? 'SWZ' : user.customproperty7 == 'SZ' ? 'SWZ' : user.customproperty7 == 'Sint Maarten (Dutch part)' ? 'SXM' : user.customproperty7 == 'SX' ? 'SXM' : user.customproperty7 == 'SC' ? 'SYC' : user.customproperty7 == 'Seychelles' ? 'SYC' : user.customproperty7 == 'SY' ? 'SYR' : user.customproperty7 == 'Syrian Arab Republic' ? 'SYR' : user.customproperty7 == 'TC' ? 'TCA' : user.customproperty7 == 'Turks and Caicos Islands' ? 'TCA' : user.customproperty7 == 'Chad' ? 'TCD' : user.customproperty7 == 'TD' ? 'TCD' : user.customproperty7 == 'TG' ? 'TGO' : user.customproperty7 == 'Togo' ? 'TGO' : user.customproperty7 == 'TH' ? 'THA' : user.customproperty7 == 'Thailand' ? 'THA' : user.customproperty7 == 'Tajikistan' ? 'TJK' : user.customproperty7 == 'TJ' ? 'TJK' : user.customproperty7 == 'TK' ? 'TKL' : user.customproperty7 == 'Tokelau' ? 'TKL' : user.customproperty7 == 'TM' ? 'TKM' : user.customproperty7 == 'Turkmenistan' ? 'TKM' : user.customproperty7 == 'Timor-Leste' ? 'TLS' : user.customproperty7 == 'TL' ? 'TLS' : user.customproperty7 == 'TO' ? 'TON' : user.customproperty7 == 'Tonga' ? 'TON' : user.customproperty7 == 'Trinidad and Tobago' ? 'TTO' : user.customproperty7 == 'TT' ? 'TTO' : user.customproperty7 == 'TN' ? 'TUN' : user.customproperty7 == 'Tunisia' ? 'TUN' : user.customproperty7 == 'TR' ? 'TUR' : user.customproperty7 == 'Turkiye' ? 'TUR' : user.customproperty7 == 'Tuvalu' ? 'TUV' : user.customproperty7 == 'TV' ? 'TUV' : user.customproperty7 == 'Taiwan, China' ? 'TWN' : user.customproperty7 == 'TW' ? 'TWN' : user.customproperty7 == 'Tanzania, United Republic of' ? 'TZA' : user.customproperty7 == 'TZ' ? 'TZA' : user.customproperty7 == 'UG' ? 'UGA' : user.customproperty7 == 'Uganda' ? 'UGA' : user.customproperty7 == 'UA' ? 'UKR' : user.customproperty7 == 'Ukraine' ? 'UKR' : user.customproperty7 == 'UM' ? 'UMI' : user.customproperty7 == 'United States Minor Outlying Islands' ? 'UMI' : user.customproperty7 == 'Uruguay' ? 'URY' : user.customproperty7 == 'UY' ? 'URY' : user.customproperty7 == 'United States' ? 'USA' : user.customproperty7 == 'US' ? 'USA' : user.customproperty7 == 'UZ' ? 'UZB' : user.customproperty7 == 'Uzbekistan' ? 'UZB' : user.customproperty7 == 'Holy See (Vatican City)' ? 'VAT' : user.customproperty7 == 'VA' ? 'VAT' : user.customproperty7 == 'Saint Vincent and the Grenadines' ? 'VCT' : user.customproperty7 == 'VC' ? 'VCT' : user.customproperty7 == 'VE' ? 'VEN' : user.customproperty7 == 'Venezuela, Bolivarian Republic of' ? 'VEN' : user.customproperty7 == 'VG' ? 'VGB' : user.customproperty7 == 'Virgin Islands, British' ? 'VGB' : user.customproperty7 == 'VI' ? 'VIR' : user.customproperty7 == 'Virgin Islands (U.S.)' ? 'VIR' : user.customproperty7 == 'Vietnam' ? 'VNM' : user.customproperty7 == 'VN' ? 'VNM' : user.customproperty7 == 'Vanuatu' ? 'VUT' : user.customproperty7 == 'VU' ? 'VUT' : user.customproperty7 == 'Wallis and Futuna' ? 'WLF' : user.customproperty7 == 'WF' ? 'WLF' : user.customproperty7 == 'Samoa' ? 'WSM' : user.customproperty7 == 'WS' ? 'WSM' : user.customproperty7 == 'YE' ? 'YEM' : user.customproperty7 == 'Yemen' ? 'YEM' : user.customproperty7 == 'South Africa' ? 'ZAF' : user.customproperty7 == 'ZA' ? 'ZAF' : user.customproperty7 == 'Zambia' ? 'ZMB' : user.customproperty7 == 'ZM' ? 'ZMB' : user.customproperty7 == 'Zimbabwe' ? 'ZWE' : user.customproperty7 == 'ZW' ? 'ZWE' : 'ZWE'}\"}
10/23/2024 02:18 AM
@Marek_Kornik add brackets before the condition
Sample
(User.custompropety7='xyz') ?:
10/23/2024 02:41 AM
Thanks, I`ll try that
10/23/2024 03:43 AM
I`m getting this error now:
"call1":{"message":"Unrecognized token '$': was expecting (JSON String, Number, Array, Object or token 'null', 'true' or 'false')\n at [Source: REDACTED (`StreamReadFeature.INCLUDE_SOURCE_IN_LOCATION` disabled); line: 1, column: 18529]","status":"Failed"}}