question Re: JOLT TRANSFORMATION returns unexpected result in Support Questions

JOLT TRANSFORMATION returns unexpected result

Thar11027 — Tue, 04 Jun 2024 11:36:22 GMT

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.

Re: JOLT TRANSFORMATION returns unexpected result

DianaTorres — Tue, 04 Jun 2024 16:58:41 GMT

@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.

Re: JOLT TRANSFORMATION returns unexpected result

JOLTEnjoyer — Wed, 05 Jun 2024 08:22:52 GMT

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

Re: JOLT TRANSFORMATION returns unexpected result

Thar11027 — Thu, 06 Jun 2024 07:08:19 GMT

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.

Re: JOLT TRANSFORMATION returns unexpected result

JOLTEnjoyer — Thu, 06 Jun 2024 08:43:03 GMT

@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.

Re: JOLT TRANSFORMATION returns unexpected result

Thar11027 — Thu, 06 Jun 2024 09:16:19 GMT

Thanks @JOLTEnjoyer .
Is there any possibility to identify key fields which has "-" , "?" and "/" characters in generally?
without mentioning one by one in Jolt spec.

Thanks

Re: JOLT TRANSFORMATION returns unexpected result

JOLTEnjoyer — Thu, 06 Jun 2024 09:44:27 GMT

@Thar11027 yes, but it will be more complex: you can put a shift operation and using the "*" wildcard.

So if for example you do this:

[ { "operation": "shift", "spec": { "*": { "*/*": "[&1].&", //with a '/' in the middle somewhere "/*":"[&1].&", //with a '/' at the start followed by something "*/":"[&1].&" //with a '/' at the end following something } } } ]

You will obtain all the desired fields, so it will be more easy to do the manual substitution(try it on the jolt demo site).

Know that if you want to make it full automated, it will be a little more difficult, because then you would have to manipulate the string of the field.

If you are interested in that I really suggest you to look at the last example on the guide I already sent you (My Guide).

(I don't know if maybe it will be more appropriate to open another question about this other problem, because the topic changed and maybe if someone with the same problem is searching for it, it can be found)