Skip to main content
Thar11027
Thar11027
Silver ⭐️⭐️
June 4, 2024
Solved

JOLT TRANSFORMATION returns unexpected result

Input Json,

==============
[
{
"CustomFields": [
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD2",
"FieldName": "Business Registration No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BusinessRegistrationNo",
"Type": "inputfield",
"Id": 99
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD3",
"FieldName": "Type of Business ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "TypeOfBusiness",
"Type": "dropdown",
"Id": 100
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD4",
"FieldName": "Birth Certicate No / Other",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BirthCerticateNoOther",
"Type": "inputfield",
"Id": 101
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD5",
"FieldName": "Passport No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PassportNo",
"Type": "inputfield",
"Id": 102
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD6",
"FieldName": "NIC",
"DataType": "nvarchar",
"Value": "196851000452",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NIC",
"Type": "inputfield",
"Id": 104
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD7",
"FieldName": "Bank",
"DataType": "nvarchar",
"Value": "7214001",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Bank",
"Type": "sqldropdown",
"Id": 107
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD8",
"FieldName": "Initials ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Initials",
"Type": "inputfield",
"Id": 108
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD9",
"FieldName": "Account No",
"DataType": "nvarchar",
"Value": "115510501014",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AccountNo",
"Type": "inputfield",
"Id": 109
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD10",
"FieldName": "Account Name",
"DataType": "nvarchar",
"Value": "B A V PADMINI",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AccountName",
"Type": "inputfield",
"Id": 110
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD11",
"FieldName": "Occupation",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Occupation",
"Type": "inputfield",
"Id": 111
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD12",
"FieldName": "Employer Name",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "EmployerName",
"Type": "inputfield",
"Id": 112
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD13",
"FieldName": "Employers Address",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "EmployersAddress",
"Type": "inputfield",
"Id": 113
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD14",
"FieldName": "Maritial Status",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "MaritialStatus",
"Type": "inputfield",
"Id": 114
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD15",
"FieldName": "Name of Spouse ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NameofSpouse",
"Type": "inputfield",
"Id": 115
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD16",
"FieldName": "Spouses Occupation",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "SpousesOccupation",
"Type": "inputfield",
"Id": 116
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD17",
"FieldName": "Spouse's Employer",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Spouse'sEmployer",
"Type": "inputfield",
"Id": 117
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD18",
"FieldName": "Date of Commencement of Business",
"DataType": "datetime",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DateofCommencementofBusiness",
"Type": "inputfield",
"Id": 140
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD21",
"FieldName": "Date of Registration",
"DataType": "datetime",
"Value": "Sep 1 2023 12:00AM",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DateofRegistration",
"Type": "inputfield",
"Id": 143
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD22",
"FieldName": "Permanant Address 1",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantAddress1",
"Type": "inputfield",
"Id": 144
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD23",
"FieldName": "Permanant Address 2",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantAddress2",
"Type": "inputfield",
"Id": 145
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD24",
"FieldName": "Permanant Town/City",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantTown/City",
"Type": "inputfield",
"Id": 146
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD25",
"FieldName": "Permanant District",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantDistrict",
"Type": "sqldropdown",
"Id": 147
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD26",
"FieldName": "Permanant Country",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantCountry",
"Type": "inputfield",
"Id": 148
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD27",
"FieldName": "Permanant ZIP Code",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantZIPCode",
"Type": "inputfield",
"Id": 149
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD28",
"FieldName": "Nationality/Country of Incorporation",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Nationality/CountryofIncorporation",
"Type": "inputfield",
"Id": 150
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD29",
"FieldName": "Resident/Non-resident",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Resident/Non-resident",
"Type": "dropdown",
"Id": 151
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD30",
"FieldName": "Source of Income",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "SourceOfIncome",
"Type": "dropdown",
"Id": 155
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD31",
"FieldName": "Annual Income Currency",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AnnualIncomeCurrency",
"Type": "dropdown",
"Id": 156
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD32",
"FieldName": "Annual Income",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AnnualIncome",
"Type": "dropdown",
"Id": 157
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD33",
"FieldName": "How did you get to know about us?",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Howdidyougettoknowaboutus?",
"Type": "dropdown",
"Id": 158
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD34",
"FieldName": "Subsidiary/Associate of another organization",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Subsidiary/Associateofanotherorganization",
"Type": "dropdown",
"Id": 159
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD35",
"FieldName": "Subsidiary of (i.e. Owned more than 50%)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Subsidiaryof(i.e.Ownedmorethan50%)",
"Type": "inputfield",
"Id": 160
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD36",
"FieldName": "Associate of (i.e. Owned 20-50%)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Associateof(i.e.Owned20-50%)",
"Type": "inputfield",
"Id": 161
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD37",
"FieldName": "Client Type",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ClientType",
"Type": "dropdown",
"Id": 173
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD38",
"FieldName": "Prefix",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Prefix",
"Type": "dropdown",
"Id": 180
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD39",
"FieldName": "Nature of Business",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NatureofBusiness",
"Type": "inputfield",
"Id": 181
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD40",
"FieldName": "Unit Holder Registration No (MSL)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "UnitHolderRegistrationNo(MSL)",
"Type": "inputfield",
"Id": 182
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD41",
"FieldName": "Application Number ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ApplicationNumber",
"Type": "inputfield",
"Id": 183
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD43",
"FieldName": "Driver's License No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DriversLicenseNo",
"Type": "inputfield",
"Id": 203
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD44",
"FieldName": "Are you a US resident?",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AreYouAUsResident",
"Type": "dropdown",
"Id": 204
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD45",
"FieldName": "FATCA form",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "FatcaForm",
"Type": "dropdown",
"Id": 205
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD46",
"FieldName": "Nature_of_Business ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NatureOf_Business",
"Type": "inputfield",
"Id": 206
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD47",
"FieldName": "SWIFT Code",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "SwiftCode",
"Type": "inputfield",
"Id": 207
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD48",
"FieldName": "Country Which the Bank Branch is Situated",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "CountryWhichTheBankBranchIsSituated",
"Type": "inputfield",
"Id": 208
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD49",
"FieldName": "National Identity Card",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NationalIdentityCard",
"Type": "dropdown",
"Id": 210
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD50",
"FieldName": "Valid Passport",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ValidPassport",
"Type": "dropdown",
"Id": 211
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD51",
"FieldName": "Valid Driver's License ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ValidDriversLicense",
"Type": "dropdown",
"Id": 212
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD52",
"FieldName": "Birth Certificate ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BirthCertificate",
"Type": "dropdown",
"Id": 213
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD53",
"FieldName": "Marriage Certificate",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "MarriageCertificate",
"Type": "dropdown",
"Id": 214
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD54",
"FieldName": "Any Other Indentifcation Document (sepcify)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AnyOtherIndentifcationDocumentSepcify",
"Type": "inputfield",
"Id": 215
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD55",
"FieldName": "Proof of Address Verification",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ProofOfAddressVerification",
"Type": "dropdown",
"Id": 216
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD56",
"FieldName": "Certificate of Incorporation/Business Registration",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "CertificateOfIncorporationBusinessRegistration",
"Type": "dropdown",
"Id": 217
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD57",
"FieldName": "Articles of Association/Partnership Agreement ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ArticlesOfAssociationPartnershipAgreement",
"Type": "dropdown",
"Id": 218
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD58",
"FieldName": "Board Resolution",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BoardResolution",
"Type": "dropdown",
"Id": 219
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD59",
"FieldName": "Directors/Office Bearers/Trustee Details",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DirectorsOfficeBearersTrusteeDetails",
"Type": "dropdown",
"Id": 220
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD60",
"FieldName": "Trust Deed",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "TrustDeed",
"Type": "dropdown",
"Id": 221
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD61",
"FieldName": "Original Application Received",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "OriginalApplicationReceived",
"Type": "dropdown",
"Id": 222
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD62",
"FieldName": "Original Application Submitted ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "OriginalApplicationSubmitted",
"Type": "dropdown",
"Id": 224
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD63",
"FieldName": "Bank Details Received ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BankDetailsReceived",
"Type": "dropdown",
"Id": 225
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD64",
"FieldName": "Bank Details Given",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BankDetailsGiven",
"Type": "dropdown",
"Id": 227
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD68",
"FieldName": "NDB Bank CID No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NdbBankCifNo",
"Type": "inputfield",
"Id": 234
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD69",
"FieldName": "PEP'S",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PEPS",
"Type": "dropdown",
"Id": 242
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD70",
"FieldName": "Notice of Nomination",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NoticeOfNomination",
"Type": "dropdown",
"Id": 243
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD71",
"FieldName": "Nomination Details",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NominationDetails",
"Type": "inputfield",
"Id": 244
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD72",
"FieldName": "Director KYC",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DirectorKyc",
"Type": "dropdown",
"Id": 245
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD73",
"FieldName": "Internal RM",
"DataType": "nvarchar",
"Value": "22742",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "InternalRm",
"Type": "sqldropdown",
"Id": 249
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD75",
"FieldName": "Risk Rating",
"DataType": "nvarchar",
"Value": "Medium Risk",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "RiskRating",
"Type": "dropdown",
"Id": 256
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD76",
"FieldName": "WHT Code",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "WhtCode",
"Type": "inputfield",
"Id": 257
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD77",
"FieldName": "R_FreshSales CID",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "FreshsalesCid",
"Type": "inputfield",
"Id": 258
},
{
"PrimaryId": 2191300,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD78",
"FieldName": "Taxpayer Identification Number",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "TaxpayerIdentificationN",
"Type": "inputfield",
"Id": 259
}
],
"Id": 2191300,
"Created": "2023-09-01T10:47:00",
"Active": 1,
"Guid": "e4d88513-9aa6-4c33-a728-53b50226b926",
"Name": "BAMUNUSINGHE ARACHCHIGE VISHAKA PADMINI",
"DepartmentId": 40058,
"DepartmentName": "NDBWM - PWM",
"DepartmentExternalId": "NO",
"CurrencyId": 222,
"CurrencyName": "Rupee",
"CurrencyIso": "LKR",
"ResponsibleUserId": 22742,
"ResponsibleUserName": "Koralage Thanuri Sarindee Tissera",
"CrmId": null,
"DistributorId": 141,
"DistributorName": "NDB Wealth Mangement",
"ExchangeFeeId": null,
"Address1": "NO 375/14/18A RATHNARAMA ROAD ",
"Address2": "HOKANDARA NORTH ",
"Postal": null,
"City": "HOKANDARA",
"Place": null,
"Country": "lk",
"PersonalId": "1037256",
"Email": "pvishaka68@gmail.com",
"LastUpdated": "2023-09-01T10:47:00",
"WorkPhone": null,
"CellPhone": "94777731719",
"HomePhone": null,
"FirstName": "BAMUNUSINGHE ARACHCHIGE VISHAKA",
"LastName": "PADMINI",
"StatusId": 30,
"StatusProgId": "REG",
"StatusName": "Registered",
"SubSystem": null,
"GroupId": 1,
"GroupProgId": "STANDARD",
"GroupName": "INDIVIDUAL",
"SegmentId": 6,
"SegmentProgId": "RSL",
"SegmentName": "RESIDENT - SRI LANKAN",
"DayOfBirth": "1968-01-10T00:00:00",
"ParentId": null,
"Gender": "F",
"MotherId": null,
"FatherId": null,
"ExternalID": "74380",
"UpdatedById": 14220,
"UpdatedByUserName": "ndbaviva\\samadhi",
"PartnerId": null,
"Fax": null,
"Comment": null,
"SkipPersonalIdVal": 0,
"Parent2Id": null,
"ConnectorCode": null,
"DefaultAddressLabel": null,
"WifeId": null,
"TaxDomicileCountryId": 124,
"ForceSync": 0,
"ExternalGuid": "8cafa5a7-082a-4dcc-a2bc-3650c02cafcf",
"CountryId": 124,
"CountryProgId": "lk",
"CountryName": "Sri Lanka",
"TaxDomicileCountryProgId": "lk",
"Source": null
},
{
"CustomFields": [
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD2",
"FieldName": "Business Registration No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BusinessRegistrationNo",
"Type": "inputfield",
"Id": 99
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD3",
"FieldName": "Type of Business ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "TypeOfBusiness",
"Type": "dropdown",
"Id": 100
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD4",
"FieldName": "Birth Certicate No / Other",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BirthCerticateNoOther",
"Type": "inputfield",
"Id": 101
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD5",
"FieldName": "Passport No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PassportNo",
"Type": "inputfield",
"Id": 102
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD6",
"FieldName": "NIC",
"DataType": "nvarchar",
"Value": "197680801115",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NIC",
"Type": "inputfield",
"Id": 104
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD7",
"FieldName": "Bank",
"DataType": "nvarchar",
"Value": "7056002",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Bank",
"Type": "sqldropdown",
"Id": 107
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD8",
"FieldName": "Initials ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Initials",
"Type": "inputfield",
"Id": 108
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD9",
"FieldName": "Account No",
"DataType": "nvarchar",
"Value": "8480008832",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AccountNo",
"Type": "inputfield",
"Id": 109
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD10",
"FieldName": "Account Name",
"DataType": "nvarchar",
"Value": "KOTTAWA GAMAGE RANGIKA SHIRANTHI KUMARI",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AccountName",
"Type": "inputfield",
"Id": 110
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD11",
"FieldName": "Occupation",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Occupation",
"Type": "inputfield",
"Id": 111
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD12",
"FieldName": "Employer Name",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "EmployerName",
"Type": "inputfield",
"Id": 112
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD13",
"FieldName": "Employers Address",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "EmployersAddress",
"Type": "inputfield",
"Id": 113
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD14",
"FieldName": "Maritial Status",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "MaritialStatus",
"Type": "inputfield",
"Id": 114
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD15",
"FieldName": "Name of Spouse ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NameofSpouse",
"Type": "inputfield",
"Id": 115
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD16",
"FieldName": "Spouses Occupation",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "SpousesOccupation",
"Type": "inputfield",
"Id": 116
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD17",
"FieldName": "Spouse's Employer",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Spouse'sEmployer",
"Type": "inputfield",
"Id": 117
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD18",
"FieldName": "Date of Commencement of Business",
"DataType": "datetime",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DateofCommencementofBusiness",
"Type": "inputfield",
"Id": 140
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD21",
"FieldName": "Date of Registration",
"DataType": "datetime",
"Value": "Sep 1 2023 12:00AM",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DateofRegistration",
"Type": "inputfield",
"Id": 143
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD22",
"FieldName": "Permanant Address 1",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantAddress1",
"Type": "inputfield",
"Id": 144
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD23",
"FieldName": "Permanant Address 2",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantAddress2",
"Type": "inputfield",
"Id": 145
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD24",
"FieldName": "Permanant Town/City",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantTown/City",
"Type": "inputfield",
"Id": 146
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD25",
"FieldName": "Permanant District",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantDistrict",
"Type": "sqldropdown",
"Id": 147
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD26",
"FieldName": "Permanant Country",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantCountry",
"Type": "inputfield",
"Id": 148
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD27",
"FieldName": "Permanant ZIP Code",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PermanantZIPCode",
"Type": "inputfield",
"Id": 149
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD28",
"FieldName": "Nationality/Country of Incorporation",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Nationality/CountryofIncorporation",
"Type": "inputfield",
"Id": 150
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD29",
"FieldName": "Resident/Non-resident",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Resident/Non-resident",
"Type": "dropdown",
"Id": 151
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD30",
"FieldName": "Source of Income",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "SourceOfIncome",
"Type": "dropdown",
"Id": 155
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD31",
"FieldName": "Annual Income Currency",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AnnualIncomeCurrency",
"Type": "dropdown",
"Id": 156
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD32",
"FieldName": "Annual Income",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AnnualIncome",
"Type": "dropdown",
"Id": 157
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD33",
"FieldName": "How did you get to know about us?",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Howdidyougettoknowaboutus?",
"Type": "dropdown",
"Id": 158
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD34",
"FieldName": "Subsidiary/Associate of another organization",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Subsidiary/Associateofanotherorganization",
"Type": "dropdown",
"Id": 159
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD35",
"FieldName": "Subsidiary of (i.e. Owned more than 50%)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Subsidiaryof(i.e.Ownedmorethan50%)",
"Type": "inputfield",
"Id": 160
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD36",
"FieldName": "Associate of (i.e. Owned 20-50%)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Associateof(i.e.Owned20-50%)",
"Type": "inputfield",
"Id": 161
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD37",
"FieldName": "Client Type",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ClientType",
"Type": "dropdown",
"Id": 173
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD38",
"FieldName": "Prefix",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "Prefix",
"Type": "dropdown",
"Id": 180
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD39",
"FieldName": "Nature of Business",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NatureofBusiness",
"Type": "inputfield",
"Id": 181
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD40",
"FieldName": "Unit Holder Registration No (MSL)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "UnitHolderRegistrationNo(MSL)",
"Type": "inputfield",
"Id": 182
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD41",
"FieldName": "Application Number ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ApplicationNumber",
"Type": "inputfield",
"Id": 183
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD43",
"FieldName": "Driver's License No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DriversLicenseNo",
"Type": "inputfield",
"Id": 203
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD44",
"FieldName": "Are you a US resident?",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AreYouAUsResident",
"Type": "dropdown",
"Id": 204
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD45",
"FieldName": "FATCA form",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "FatcaForm",
"Type": "dropdown",
"Id": 205
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD46",
"FieldName": "Nature_of_Business ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NatureOf_Business",
"Type": "inputfield",
"Id": 206
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD47",
"FieldName": "SWIFT Code",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "SwiftCode",
"Type": "inputfield",
"Id": 207
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD48",
"FieldName": "Country Which the Bank Branch is Situated",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "CountryWhichTheBankBranchIsSituated",
"Type": "inputfield",
"Id": 208
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD49",
"FieldName": "National Identity Card",
"DataType": "nvarchar",
"Value": "Yes",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NationalIdentityCard",
"Type": "dropdown",
"Id": 210
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD50",
"FieldName": "Valid Passport",
"DataType": "nvarchar",
"Value": "N/A",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ValidPassport",
"Type": "dropdown",
"Id": 211
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD51",
"FieldName": "Valid Driver's License ",
"DataType": "nvarchar",
"Value": "N/A",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ValidDriversLicense",
"Type": "dropdown",
"Id": 212
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD52",
"FieldName": "Birth Certificate ",
"DataType": "nvarchar",
"Value": "N/A",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BirthCertificate",
"Type": "dropdown",
"Id": 213
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD53",
"FieldName": "Marriage Certificate",
"DataType": "nvarchar",
"Value": "N/A",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "MarriageCertificate",
"Type": "dropdown",
"Id": 214
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD54",
"FieldName": "Any Other Indentifcation Document (sepcify)",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "AnyOtherIndentifcationDocumentSepcify",
"Type": "inputfield",
"Id": 215
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD55",
"FieldName": "Proof of Address Verification",
"DataType": "nvarchar",
"Value": "N/A",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ProofOfAddressVerification",
"Type": "dropdown",
"Id": 216
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD56",
"FieldName": "Certificate of Incorporation/Business Registration",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "CertificateOfIncorporationBusinessRegistration",
"Type": "dropdown",
"Id": 217
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD57",
"FieldName": "Articles of Association/Partnership Agreement ",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "ArticlesOfAssociationPartnershipAgreement",
"Type": "dropdown",
"Id": 218
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD58",
"FieldName": "Board Resolution",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BoardResolution",
"Type": "dropdown",
"Id": 219
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD59",
"FieldName": "Directors/Office Bearers/Trustee Details",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DirectorsOfficeBearersTrusteeDetails",
"Type": "dropdown",
"Id": 220
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD60",
"FieldName": "Trust Deed",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "TrustDeed",
"Type": "dropdown",
"Id": 221
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD61",
"FieldName": "Original Application Received",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "OriginalApplicationReceived",
"Type": "dropdown",
"Id": 222
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD62",
"FieldName": "Original Application Submitted ",
"DataType": "nvarchar",
"Value": "Yes",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "OriginalApplicationSubmitted",
"Type": "dropdown",
"Id": 224
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD63",
"FieldName": "Bank Details Received ",
"DataType": "nvarchar",
"Value": "Yes",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BankDetailsReceived",
"Type": "dropdown",
"Id": 225
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD64",
"FieldName": "Bank Details Given",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "BankDetailsGiven",
"Type": "dropdown",
"Id": 227
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD68",
"FieldName": "NDB Bank CID No",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NdbBankCifNo",
"Type": "inputfield",
"Id": 234
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD69",
"FieldName": "PEP'S",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "PEPS",
"Type": "dropdown",
"Id": 242
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD70",
"FieldName": "Notice of Nomination",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NoticeOfNomination",
"Type": "dropdown",
"Id": 243
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD71",
"FieldName": "Nomination Details",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "NominationDetails",
"Type": "inputfield",
"Id": 244
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD72",
"FieldName": "Director KYC",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "DirectorKyc",
"Type": "dropdown",
"Id": 245
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD73",
"FieldName": "Internal RM",
"DataType": "nvarchar",
"Value": "15424",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "InternalRm",
"Type": "sqldropdown",
"Id": 249
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD75",
"FieldName": "Risk Rating",
"DataType": "nvarchar",
"Value": "Medium Risk",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "RiskRating",
"Type": "dropdown",
"Id": 256
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD76",
"FieldName": "WHT Code",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "WhtCode",
"Type": "inputfield",
"Id": 257
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD77",
"FieldName": "R_FreshSales CID",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "FreshsalesCid",
"Type": "inputfield",
"Id": 258
},
{
"PrimaryId": 2191301,
"ColumnName": "TRX_CUSTOMER_CUSTOMFIELD78",
"FieldName": "Taxpayer Identification Number",
"DataType": "nvarchar",
"Value": "",
"HideFromExternalDistributor": 0,
"IsRequired": 0,
"ViewName": "TaxpayerIdentificationN",
"Type": "inputfield",
"Id": 259
}
],
"Id": 2191301,
"Created": "2023-09-01T11:03:00",
"Active": 1,
"Guid": "9d0153cb-045b-4a30-86e4-c88c874c1861",
"Name": "KOTTAWA GAMAGE RANGIKA SHIRANTHI KUMARI",
"DepartmentId": 40069,
"DepartmentName": "NDBWM - Retails Sales ",
"DepartmentExternalId": "INT",
"CurrencyId": 222,
"CurrencyName": "Rupee",
"CurrencyIso": "LKR",
"ResponsibleUserId": 15424,
"ResponsibleUserName": "Ruweena Ruchirangi",
"CrmId": null,
"DistributorId": 141,
"DistributorName": "NDB Wealth Mangement",
"ExchangeFeeId": null,
"Address1": "NO 1116/06/1 9TH LANE,",
"Address2": "WICKRAMASINGHEPURA",
"Postal": null,
"City": "BATTARAMULLA",
"Place": null,
"Country": "lk",
"PersonalId": "1037257",
"Email": "rangikagamage3@gmail.com",
"LastUpdated": "2023-10-02T18:01:00",
"WorkPhone": null,
"CellPhone": "94773585771",
"HomePhone": null,
"FirstName": "KOTTAWA GAMAGE RANGIKA SHIRANTHI",
"LastName": "KUMARI",
"StatusId": 30,
"StatusProgId": "REG",
"StatusName": "Registered",
"SubSystem": null,
"GroupId": 1,
"GroupProgId": "STANDARD",
"GroupName": "INDIVIDUAL",
"SegmentId": 6,
"SegmentProgId": "RSL",
"SegmentName": "RESIDENT - SRI LANKAN",
"DayOfBirth": "1976-11-03T00:00:00",
"ParentId": null,
"Gender": "F",
"MotherId": null,
"FatherId": null,
"ExternalID": "74381",
"UpdatedById": 19638,
"UpdatedByUserName": "ndbaviva\\nithya",
"PartnerId": null,
"Fax": null,
"Comment": null,
"SkipPersonalIdVal": 0,
"Parent2Id": null,
"ConnectorCode": null,
"DefaultAddressLabel": null,
"WifeId": null,
"TaxDomicileCountryId": 124,
"ForceSync": 0,
"ExternalGuid": "657a6154-5eca-4173-96e3-f09fb5234966",
"CountryId": 124,
"CountryProgId": "lk",
"CountryName": "Sri Lanka",
"TaxDomicileCountryProgId": "lk",
"Source": null
}
]
==============================


My JOLT spec,
=============
[
{
"operation": "shift",
"spec": {
"*": {
"CustomFields": {
"*": {
"Value": {
"*": {
"@(2,Value)": "@(3,ViewName)"
}
}
}
},
"*": "&"
}
}
}
]

============================

Output Json looks,
================
{
"BusinessRegistrationNo" : [ "", "" ],
"TypeOfBusiness" : [ "", "" ],
"BirthCerticateNoOther" : [ "", "" ],
"PassportNo" : [ "", "" ],
"NIC" : [ "196851000452", "197680801115" ],
"Bank" : [ "7214001", "7056002" ],
"Initials" : [ "", "" ],
"AccountNo" : [ "115510501014", "8480008832" ],
"AccountName" : [ "B A V PADMINI", "KOTTAWA GAMAGE RANGIKA SHIRANTHI KUMARI" ],
"Occupation" : [ "", "" ],
"EmployerName" : [ "", "" ],
"EmployersAddress" : [ "", "" ],
"MaritialStatus" : [ "", "" ],
"NameofSpouse" : [ "", "" ],
"SpousesOccupation" : [ "", "" ],
"Spouse'sEmployer" : [ "", "" ],
"DateofCommencementofBusiness" : [ "", "" ],
"DateofRegistration" : [ "Sep 1 2023 12:00AM", "Sep 1 2023 12:00AM" ],
"PermanantAddress1" : [ "", "" ],
"PermanantAddress2" : [ "", "" ],
"PermanantTown/City" : [ "", "" ],
"PermanantDistrict" : [ "", "" ],
"PermanantCountry" : [ "", "" ],
"PermanantZIPCode" : [ "", "" ],
"Nationality/CountryofIncorporation" : [ "", "" ],
"Resident/Non-resident" : [ "", "" ],
"SourceOfIncome" : [ "", "" ],
"AnnualIncomeCurrency" : [ "", "" ],
"AnnualIncome" : [ "", "" ],
"Howdidyougettoknowaboutus?" : [ "", "" ],
"Subsidiary/Associateofanotherorganization" : [ "", "" ],
"Subsidiaryof(i.e.Ownedmorethan50%)" : [ "", "" ],
"Associateof(i.e.Owned20-50%)" : [ "", "" ],
"ClientType" : [ "", "" ],
"Prefix" : [ "", "" ],
"NatureofBusiness" : [ "", "" ],
"UnitHolderRegistrationNo(MSL)" : [ "", "" ],
"ApplicationNumber" : [ "", "" ],
"DriversLicenseNo" : [ "", "" ],
"AreYouAUsResident" : [ "", "" ],
"FatcaForm" : [ "", "" ],
"NatureOf_Business" : [ "", "" ],
"SwiftCode" : [ "", "" ],
"CountryWhichTheBankBranchIsSituated" : [ "", "" ],
"NationalIdentityCard" : [ "", "Yes" ],
"ValidPassport" : [ "", "N/A" ],
"ValidDriversLicense" : [ "", "N/A" ],
"BirthCertificate" : [ "", "N/A" ],
"MarriageCertificate" : [ "", "N/A" ],
"AnyOtherIndentifcationDocumentSepcify" : [ "", "" ],
"ProofOfAddressVerification" : [ "", "N/A" ],
"CertificateOfIncorporationBusinessRegistration" : [ "", "" ],
"ArticlesOfAssociationPartnershipAgreement" : [ "", "" ],
"BoardResolution" : [ "", "" ],
"DirectorsOfficeBearersTrusteeDetails" : [ "", "" ],
"TrustDeed" : [ "", "" ],
"OriginalApplicationReceived" : [ "", "" ],
"OriginalApplicationSubmitted" : [ "", "Yes" ],
"BankDetailsReceived" : [ "", "Yes" ],
"BankDetailsGiven" : [ "", "" ],
"NdbBankCifNo" : [ "", "" ],
"PEPS" : [ "", "" ],
"NoticeOfNomination" : [ "", "" ],
"NominationDetails" : [ "", "" ],
"DirectorKyc" : [ "", "" ],
"InternalRm" : [ "22742", "15424" ],
"RiskRating" : [ "Medium Risk", "Medium Risk" ],
"WhtCode" : [ "", "" ],
"FreshsalesCid" : [ "", "" ],
"TaxpayerIdentificationN" : [ "", "" ],
"Id" : [ 2191300, 2191301 ],
"Created" : [ "2023-09-01T10:47:00", "2023-09-01T11:03:00" ],
"Active" : [ 1, 1 ],
"Guid" : [ "e4d88513-9aa6-4c33-a728-53b50226b926", "9d0153cb-045b-4a30-86e4-c88c874c1861" ],
"Name" : [ "BAMUNUSINGHE ARACHCHIGE VISHAKA PADMINI", "KOTTAWA GAMAGE RANGIKA SHIRANTHI KUMARI" ],
"DepartmentId" : [ 40058, 40069 ],
"DepartmentName" : [ "NDBWM - PWM", "NDBWM - Retails Sales " ],
"DepartmentExternalId" : [ "NO", "INT" ],
"CurrencyId" : [ 222, 222 ],
"CurrencyName" : [ "Rupee", "Rupee" ],
"CurrencyIso" : [ "LKR", "LKR" ],
"ResponsibleUserId" : [ 22742, 15424 ],
"ResponsibleUserName" : [ "Koralage Thanuri Sarindee Tissera", "Ruweena Ruchirangi" ],
"CrmId" : null,
"DistributorId" : [ 141, 141 ],
"DistributorName" : [ "NDB Wealth Mangement", "NDB Wealth Mangement" ],
"ExchangeFeeId" : null,
"Address1" : [ "NO 375/14/18A RATHNARAMA ROAD ", "NO 1116/06/1 9TH LANE," ],
"Address2" : [ "HOKANDARA NORTH ", "WICKRAMASINGHEPURA" ],
"Postal" : null,
"City" : [ "HOKANDARA", "BATTARAMULLA" ],
"Place" : null,
"Country" : [ "lk", "lk" ],
"PersonalId" : [ "1037256", "1037257" ],
"Email" : [ "pvishaka68@gmail.com", "rangikagamage3@gmail.com" ],
"LastUpdated" : [ "2023-09-01T10:47:00", "2023-10-02T18:01:00" ],
"WorkPhone" : null,
"CellPhone" : [ "94777731719", "94773585771" ],
"HomePhone" : null,
"FirstName" : [ "BAMUNUSINGHE ARACHCHIGE VISHAKA", "KOTTAWA GAMAGE RANGIKA SHIRANTHI" ],
"LastName" : [ "PADMINI", "KUMARI" ],
"StatusId" : [ 30, 30 ],
"StatusProgId" : [ "REG", "REG" ],
"StatusName" : [ "Registered", "Registered" ],
"SubSystem" : null,
"GroupId" : [ 1, 1 ],
"GroupProgId" : [ "STANDARD", "STANDARD" ],
"GroupName" : [ "INDIVIDUAL", "INDIVIDUAL" ],
"SegmentId" : [ 6, 6 ],
"SegmentProgId" : [ "RSL", "RSL" ],
"SegmentName" : [ "RESIDENT - SRI LANKAN", "RESIDENT - SRI LANKAN" ],
"DayOfBirth" : [ "1968-01-10T00:00:00", "1976-11-03T00:00:00" ],
"ParentId" : null,
"Gender" : [ "F", "F" ],
"MotherId" : null,
"FatherId" : null,
"ExternalID" : [ "74380", "74381" ],
"UpdatedById" : [ 14220, 19638 ],
"UpdatedByUserName" : [ "ndbaviva\\samadhi", "ndbaviva\\nithya" ],
"PartnerId" : null,
"Fax" : null,
"Comment" : null,
"SkipPersonalIdVal" : [ 0, 0 ],
"Parent2Id" : null,
"ConnectorCode" : null,
"DefaultAddressLabel" : null,
"WifeId" : null,
"TaxDomicileCountryId" : [ 124, 124 ],
"ForceSync" : [ 0, 0 ],
"ExternalGuid" : [ "8cafa5a7-082a-4dcc-a2bc-3650c02cafcf", "657a6154-5eca-4173-96e3-f09fb5234966" ],
"CountryId" : [ 124, 124 ],
"CountryProgId" : [ "lk", "lk" ],
"CountryName" : [ "Sri Lanka", "Sri Lanka" ],
"TaxDomicileCountryProgId" : [ "lk", "lk" ],
"Source" : null
}
==============================


But I need separate json object in same json array, like this,
=======
[
{
"BusinessRegistrationNo": "",
"TypeOfBusiness": "",
"BirthCerticateNoOther": "",
"PassportNo": "",
"NIC": "196851000452",
"Bank": "7214001",
"Initials": "",
"AccountNo": "115510501014",
"AccountName": "B A V PADMINI",
"Occupation": "",
"EmployerName": "",
"EmployersAddress": "",
"MaritialStatus": "",
"NameofSpouse": "",
"SpousesOccupation": "",
"Spouse'sEmployer": "",
"DateofCommencementofBusiness": "",
"DateofRegistration": "Sep 1 2023 12:00AM",
"PermanantAddress1": "",
"PermanantAddress2": "",
"PermanantTown/City": "",
"PermanantDistrict": "",
"PermanantCountry": "",
"PermanantZIPCode": "",
"Nationality/CountryofIncorporation": "",
"Resident/Non-resident": "",
"SourceOfIncome": "",
"AnnualIncomeCurrency": "",
"AnnualIncome": "",
"Howdidyougettoknowaboutus?": "",
"Subsidiary/Associateofanotherorganization": "",
"Subsidiaryof(i.e.Ownedmorethan50%)": "",
"Associateof(i.e.Owned20-50%)": "",
"ClientType": "",
"Prefix": "",
"NatureofBusiness": "",
"UnitHolderRegistrationNo(MSL)": "",
"ApplicationNumber": "",
"DriversLicenseNo": "",
"AreYouAUsResident": "",
"FatcaForm": "",
"NatureOf_Business": "",
"SwiftCode": "",
"CountryWhichTheBankBranchIsSituated": "",
"NationalIdentityCard": "",
"ValidPassport": "",
"ValidDriversLicense": "",
"BirthCertificate": "",
"MarriageCertificate": "",
"AnyOtherIndentifcationDocumentSepcify": "",
"ProofOfAddressVerification": "",
"CertificateOfIncorporationBusinessRegistration": "",
"ArticlesOfAssociationPartnershipAgreement": "",
"BoardResolution": "",
"DirectorsOfficeBearersTrusteeDetails": "",
"TrustDeed": "",
"OriginalApplicationReceived": "",
"OriginalApplicationSubmitted": "",
"BankDetailsReceived": "",
"BankDetailsGiven": "",
"NdbBankCifNo": "",
"PEPS": "",
"NoticeOfNomination": "",
"NominationDetails": "",
"DirectorKyc": "",
"InternalRm": "22742",
"RiskRating": "Medium Risk",
"WhtCode": "",
"FreshsalesCid": "",
"TaxpayerIdentificationN": "",
"Id": 2191300,
"Created": "2023-09-01T10:47:00",
"Active": 1,
"Guid": "e4d88513-9aa6-4c33-a728-53b50226b926",
"Name": "BAMUNUSINGHE ARACHCHIGE VISHAKA PADMINI",
"DepartmentId": 40058,
"DepartmentName": "NDBWM - PWM",
"DepartmentExternalId": "NO",
"CurrencyId": 222,
"CurrencyName": "Rupee",
"CurrencyIso": "LKR",
"ResponsibleUserId": 22742,
"ResponsibleUserName": "Koralage Thanuri Sarindee Tissera",
"CrmId": null,
"DistributorId": 141,
"DistributorName": "NDB Wealth Mangement",
"ExchangeFeeId": null,
"Address1": "NO 375/14/18A RATHNARAMA ROAD ",
"Address2": "HOKANDARA NORTH ",
"Postal": null,
"City": "HOKANDARA",
"Place": null,
"Country": "lk",
"PersonalId": "1037256",
"Email": "pvishaka68@gmail.com",
"LastUpdated": "2023-09-01T10:47:00",
"WorkPhone": null,
"CellPhone": "94777731719",
"HomePhone": null,
"FirstName": "BAMUNUSINGHE ARACHCHIGE VISHAKA",
"LastName": "PADMINI",
"StatusId": 30,
"StatusProgId": "REG",
"StatusName": "Registered",
"SubSystem": null,
"GroupId": 1,
"GroupProgId": "STANDARD",
"GroupName": "INDIVIDUAL",
"SegmentId": 6,
"SegmentProgId": "RSL",
"SegmentName": "RESIDENT - SRI LANKAN",
"DayOfBirth": "1968-01-10T00:00:00",
"ParentId": null,
"Gender": "F",
"MotherId": null,
"FatherId": null,
"ExternalID": "74380",
"UpdatedById": 14220,
"UpdatedByUserName": "ndbaviva\\samadhi",
"PartnerId": null,
"Fax": null,
"Comment": null,
"SkipPersonalIdVal": 0,
"Parent2Id": null,
"ConnectorCode": null,
"DefaultAddressLabel": null,
"WifeId": null,
"TaxDomicileCountryId": 124,
"ForceSync": 0,
"ExternalGuid": "8cafa5a7-082a-4dcc-a2bc-3650c02cafcf",
"CountryId": 124,
"CountryProgId": "lk",
"CountryName": "Sri Lanka",
"TaxDomicileCountryProgId": "lk",
"Source": null
},
{
"BusinessRegistrationNo": "",
"TypeOfBusiness": "",
"BirthCerticateNoOther": "",
"PassportNo": "",
"NIC": "197680801115",
"Bank": "7056002",
"Initials": "",
"AccountNo": "8480008832",
"AccountName": "KOTTAWA GAMAGE RANGIKA SHIRANTHI KUMARI",
"Occupation": "",
"EmployerName": "",
"EmployersAddress": "",
"MaritialStatus": "",
"NameofSpouse": "",
"SpousesOccupation": "",
"Spouse'sEmployer": "",
"DateofCommencementofBusiness": "",
"DateofRegistration": "Sep 1 2023 12:00AM",
"PermanantAddress1": "",
"PermanantAddress2": "",
"PermanantTown/City": "",
"PermanantDistrict": "",
"PermanantCountry": "",
"PermanantZIPCode": "",
"Nationality/CountryofIncorporation": "",
"Resident/Non-resident": "",
"SourceOfIncome": "",
"AnnualIncomeCurrency": "",
"AnnualIncome": "",
"Howdidyougettoknowaboutus?": "",
"Subsidiary/Associateofanotherorganization": "",
"Subsidiaryof(i.e.Ownedmorethan50%)": "",
"Associateof(i.e.Owned20-50%)": "",
"ClientType": "",
"Prefix": "",
"NatureofBusiness": "",
"UnitHolderRegistrationNo(MSL)": "",
"ApplicationNumber": "",
"DriversLicenseNo": "",
"AreYouAUsResident": "",
"FatcaForm": "",
"NatureOf_Business": "",
"SwiftCode": "",
"CountryWhichTheBankBranchIsSituated": "",
"NationalIdentityCard": "Yes",
"ValidPassport": "N/A",
"ValidDriversLicense": "N/A",
"BirthCertificate": "N/A",
"MarriageCertificate": "N/A",
"AnyOtherIndentifcationDocumentSepcify": "",
"ProofOfAddressVerification": "N/A",
"CertificateOfIncorporationBusinessRegistration": "",
"ArticlesOfAssociationPartnershipAgreement": "",
"BoardResolution": "",
"DirectorsOfficeBearersTrusteeDetails": "",
"TrustDeed": "",
"OriginalApplicationReceived": "",
"OriginalApplicationSubmitted": "Yes",
"BankDetailsReceived": "Yes",
"BankDetailsGiven": "",
"NdbBankCifNo": "",
"PEPS": "",
"NoticeOfNomination": "",
"NominationDetails": "",
"DirectorKyc": "",
"InternalRm": "15424",
"RiskRating": "Medium Risk",
"WhtCode": "",
"FreshsalesCid": "",
"TaxpayerIdentificationN": "",
"Id": 2191301,
"Created": "2023-09-01T11:03:00",
"Active": 1,
"Guid": "9d0153cb-045b-4a30-86e4-c88c874c1861",
"Name": "KOTTAWA GAMAGE RANGIKA SHIRANTHI KUMARI",
"DepartmentId": 40069,
"DepartmentName": "NDBWM - Retails Sales ",
"DepartmentExternalId": "INT",
"CurrencyId": 222,
"CurrencyName": "Rupee",
"CurrencyIso": "LKR",
"ResponsibleUserId": 15424,
"ResponsibleUserName": "Ruweena Ruchirangi",
"CrmId": null,
"DistributorId": 141,
"DistributorName": "NDB Wealth Mangement",
"ExchangeFeeId": null,
"Address1": "NO 1116/06/1 9TH LANE,",
"Address2": "WICKRAMASINGHEPURA",
"Postal": null,
"City": "BATTARAMULLA",
"Place": null,
"Country": "lk",
"PersonalId": "1037257",
"Email": "rangikagamage3@gmail.com",
"LastUpdated": "2023-10-02T18:01:00",
"WorkPhone": null,
"CellPhone": "94773585771",
"HomePhone": null,
"FirstName": "KOTTAWA GAMAGE RANGIKA SHIRANTHI",
"LastName": "KUMARI",
"StatusId": 30,
"StatusProgId": "REG",
"StatusName": "Registered",
"SubSystem": null,
"GroupId": 1,
"GroupProgId": "STANDARD",
"GroupName": "INDIVIDUAL",
"SegmentId": 6,
"SegmentProgId": "RSL",
"SegmentName": "RESIDENT - SRI LANKAN",
"DayOfBirth": "1976-11-03T00:00:00",
"ParentId": null,
"Gender": "F",
"MotherId": null,
"FatherId": null,
"ExternalID": "74381",
"UpdatedById": 19638,
"UpdatedByUserName": "ndbaviva\\nithya",
"PartnerId": null,
"Fax": null,
"Comment": null,
"SkipPersonalIdVal": 0,
"Parent2Id": null,
"ConnectorCode": null,
"DefaultAddressLabel": null,
"WifeId": null,
"TaxDomicileCountryId": 124,
"ForceSync": 0,
"ExternalGuid": "657a6154-5eca-4173-96e3-f09fb5234966",
"CountryId": 124,
"CountryProgId": "lk",
"CountryName": "Sri Lanka",
"TaxDomicileCountryProgId": "lk",
"Source": null
}
]
====================

how should I change my spec. ? Thanks for advance.

    JOLTEnjoyer
    JOLTEnjoyerAnswer
    Gold ⭐️
    June 6, 2024

    @Thar11027 to do that, you will need to add a modify-default-beta and a remove operations.

    I'll give you an example here:

    [
    {
        "operation": "modify-default-beta",
        "spec": {
          "*": {
            "ResidentNonresident": "@(1,Resident/Non-resident)",
            "NationalityCountryofIncorporation": "@(1,Nationality/CountryofIncorporation)"
          }
        }
    },
    {
        "operation": "remove",
        "spec": {
          "*": {
            "Resident/Non-resident": "",
            "Nationality/CountryofIncorporation": ""
          }
        }
    }
    ]

     Here you can see I've used only a few fields just to show you the logic: you have to manually assign (in the first spec) the value of the "wrong" field to the corrected field, and then at the end, remove all the old fields that now are useless.

    You can test your jolt on this site that allows you to play with the specifications all you want: jolt-demo.appspot.com/ and if you have any doubts, check the guide i already mentioed in my first reply.

    View in thread

    6 replies

    DianaTorres
    Community Manager
    DianaTorres
    Community Manager
    June 4, 2024

    @Thar11027 Welcome to the Cloudera Community!

    To help you get the best possible solution, I have tagged our NiFi expert @steven-matison  who may be able to assist you further.

    Please keep us updated on your post, and we hope you find a satisfactory solution to your query.

    Translate
    Regards, Diana Torres, Senior Community Moderator
    JOLTEnjoyer
    JOLTEnjoyer
    Gold ⭐️
    June 5, 2024

    Hi,

    I've seen your jolt and i made some correction to make it work, here is what i did:

    [
      {
        "operation": "shift",
        "spec": {
          "*": {
            "CustomFields": {
              "*": {
                "@(0,Value)": "[&3].@(0,ViewName)"
              }
            },
            "*": "[&1].&"
          }
        }
    }
    ]

    I basically put everything in an array, and I removed the "value" part, because it wan't necessary.

    If you have any doubts on how to use the Jolt, I have written a simple guide on how to use it here: My guide

    Hope i helped

    Translate
      Thar11027
      Thar11027Author
      Silver ⭐️⭐️
      June 6, 2024

      Thanks @JOLTEnjoyer . and I have an another trouble,
      There are some special characters in key fields of final output json like '-' , '?' and  '/' . can you extend the given spec for removing those characters?

      eg:

      "Nationality/CountryofIncorporation" : "",
      "Resident/Non-resident" : "",
      "SourceOfIncome" : "",
      "AnnualIncomeCurrency" : "",
      "AnnualIncome" : "",
      "Howdidyougettoknowaboutus?" : ""

      Thanks.   

      Translate
        JOLTEnjoyer
        JOLTEnjoyerAnswer
        Gold ⭐️
        June 6, 2024

        @Thar11027 to do that, you will need to add a modify-default-beta and a remove operations.

        I'll give you an example here:

        [
        {
            "operation": "modify-default-beta",
            "spec": {
              "*": {
                "ResidentNonresident": "@(1,Resident/Non-resident)",
                "NationalityCountryofIncorporation": "@(1,Nationality/CountryofIncorporation)"
              }
            }
        },
        {
            "operation": "remove",
            "spec": {
              "*": {
                "Resident/Non-resident": "",
                "Nationality/CountryofIncorporation": ""
              }
            }
        }
        ]

         Here you can see I've used only a few fields just to show you the logic: you have to manually assign (in the first spec) the value of the "wrong" field to the corrected field, and then at the end, remove all the old fields that now are useless.

        You can test your jolt on this site that allows you to play with the specifications all you want: jolt-demo.appspot.com/ and if you have any doubts, check the guide i already mentioed in my first reply.

        Translate
          Terms & ConditionsAccessibility statement