About Thar11027

Thar11027 · ‎05-26-2025

I need to upsert 5MB data bulk to the mongo db collection where in Cloud environment. But it takes almost 5 hours for the upsert action. here is the properties in PutMongoRecord processor. Can you suggest me the proper solution for that matter. Thanks in advance.

Thar11027 · ‎08-08-2024

I have a mongo aggregation query which runs in "RunMongoAggregation" Processor. from using that BULK RESULT, inserted to the mongo collection. For the insertion I'm using "PutMongoRecord" in NIFI 1.25.0 at once. But the issue is this, I need to run this mongo aggregation query in time to time. When it runs in time to time, data will duplicated. It has a Unique Id call "PortfolioTransactionID". here is the sample json, { "PortfolioBaseID": "371", "PortfolioBaseIDOrder": 37539, "PortfolioTransactionID": 1416807, "RecallableDistributedGainLocal": null, "SecTypeCode1": "mf", "SecTypeCode2": "ca", "SplitFactor": 1, "SpotRate": null, "ThruDate": "2016-12-28", "TradeAmount": "5000000.0", "TradeAmountLocal": 5000000.0 } How do I avoid that data duplication using "PortfolioTransactionID" unique key while insert data as bulk.. I'm using NiFi 1.25.0 Thanks.

Thar11027 · ‎06-17-2024

Here is my Input Json, [ { "PortfolioSharing": [], "CustomFields": [ { "PrimaryId": 2069165, "ColumnName": "TRX_PORTFOLIO_CUSTOMFIELD2", "FieldName": "Use Bank Account From Customer?", "DataType": "nvarchar", "Value": "Yes", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "UseBankAccountFromCustomer?", "Type": "dropdown", "Id": 103 } ], "Id": 2069165, "Guid": "0f2aa667-5d6d-4e8a-9ed1-7ef89db03d6d", "Name": "N.M. SANGANI" }, { "PortfolioSharing": [ { "PortfolioId": 2074065, "CustomerId": 2159935, "PersonalId": "1006631", "ReasonId": 810, "ReasonProgId": "OWNER", "ReasonName": "Company owner", "Comment": null, "TypeId": 808, "TypeProgId": "FULL", "TypeName": "Full" } ], "CustomFields": [ { "PrimaryId": 2074065, "ColumnName": "TRX_PORTFOLIO_CUSTOMFIELD2", "FieldName": "Use Bank Account From Customer?", "DataType": "nvarchar", "Value": "Yes", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "UseBankAccountFromCustomer?", "Type": "dropdown", "Id": 103 } ], "Id": 2074065, "Guid": "b276ec7e-b770-4dae-a9b7-2390652ec0d2", "Name": "M. K. BANDARA & G. R. M. K.BANDARA(Jt)" }, { "PortfolioSharing": [ { "PortfolioId": 2074396, "CustomerId": 2160183, "PersonalId": "1006833", "ReasonId": 810, "ReasonProgId": "OWNER", "ReasonName": "Company owner", "Comment": null, "TypeId": 808, "TypeProgId": "FULL", "TypeName": "Full" }, { "PortfolioId": 2074396, "CustomerId": 2160182, "PersonalId": "1006832", "ReasonId": 810, "ReasonProgId": "OWNER", "ReasonName": "Company owner", "Comment": null, "TypeId": 808, "TypeProgId": "FULL", "TypeName": "Full" } ], "CustomFields": [ { "PrimaryId": 2074396, "ColumnName": "TRX_PORTFOLIO_CUSTOMFIELD2", "FieldName": "Use Bank Account From Customer?", "DataType": "nvarchar", "Value": "Yes", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "UseBankAccountFromCustomer?", "Type": "dropdown", "Id": 103 } ], "Id": 2074396, "Guid": "96a07682-8d94-4739-bae0-a950b58fffad", "Name": "L.S.P. VIDANAGAMAGE" } ] ============================== And here is JOLT spec that I'm used, [ { "operation": "shift", "spec": { "*": { "PortfolioSharing": { "*": { "*": "[&1].&" } } } } } ] =================================== And here is the OUPUT json, [ { "PortfolioId" : [ 2074065, 2074396 ], "CustomerId" : [ 2159935, 2160183 ], "PersonalId" : [ "1006631", "1006833" ], "ReasonId" : [ 810, 810 ], "ReasonProgId" : [ "OWNER", "OWNER" ], "ReasonName" : [ "Company owner", "Company owner" ], "Comment" : null, "TypeId" : [ 808, 808 ], "TypeProgId" : [ "FULL", "FULL" ], "TypeName" : [ "Full", "Full" ] }, { "PortfolioId" : 2074396, "CustomerId" : 2160182, "PersonalId" : "1006832", "ReasonId" : 810, "ReasonProgId" : "OWNER", "ReasonName" : "Company owner", "Comment" : null, "TypeId" : 808, "TypeProgId" : "FULL", "TypeName" : "Full" } ] But I need to get it like that, [ { "PortfolioId" : 2074065, "CustomerId" : 2159935, "PersonalId" : "1006631", "ReasonId" : [ 810, 810 , "ReasonProgId" : "OWNER", "ReasonName" : "Company owner",, "Comment" : null, "TypeId" : 808, "TypeProgId" : "FULL", "TypeName" : "FULL" },{ "PortfolioId" : 2074396, "CustomerId" : 2160183, "PersonalId" : "1006833", "ReasonId" : 810, "ReasonProgId" : "OWNER", "ReasonName" : "Company owner", "Comment" : null, "TypeId" : 808, "TypeProgId" : "FULL", "TypeName" : "Full" }, { "PortfolioId" : 2074396, "CustomerId" : 2160182, "PersonalId" : "1006832", "ReasonId" : 810, "ReasonProgId" : "OWNER", "ReasonName" : "Company owner", "Comment" : null, "TypeId" : 808, "TypeProgId" : "FULL", "TypeName" : "Full" } ] I need to get each an objects in separately in same json array. How should I change my spec? Thanks

Thar11027 · ‎06-13-2024

Thanks @SAMSAL for your quick response. But I have another "PutDatabaseRecord" in work flow referring database table called "Transaction". It includes Primary key called "transaction_id" without auto incrementing and "transaction_id" is the value of "Update key" in "PutDatabaseRecord". In here, update and insert process are working properly. What is the reason for difference.

Thar11027 · ‎06-13-2024

I'm using "PutDatabaseRecord (NiFi 1.25.0)" for data insert/update purposes in MySql. Imagine, I have a table called "Customer" which has running primary key called "Id" and the another field call "id_from_core". The only mentioned "Id" field as auto generated primary key in "Customer" table. But when data insert through the NiFi flow, I mentioned "id_from_core" field as "Update Key" property in "PutDatabaseRecord". Here is the "Customer" table, CREATE TABLE `Customer` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `created_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `created_date` datetime(0) NULL DEFAULT NULL, `record_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `surname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `id_from_core` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 175 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; My problem is, update action is not work properly, while inserting same values in "id_from_core" field data, it should be a update, but it's not updated. Insert as a new record. Could you please anyone know the reason for that matter and what is the solution for that. Thanks in advance.

Thar11027 · ‎06-12-2024

This is my input JSON, [ { "CustomFields": [ { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD2", "FieldName": "PaymentMode", "DataType": "nvarchar", "Value": "Cash", "HideFromExternalDistributor": 0, "IsRequired": 1, "ViewName": "PaymentMode", "Type": "dropdown", "Id": 118 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD3", "FieldName": "test", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "test", "Type": "inputfield", "Id": 119 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD4", "FieldName": "Reason for Transfer", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 1, "ViewName": "ReasonforTransfer", "Type": "dropdown", "Id": 120 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD5", "FieldName": "Remption Mode", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 1, "ViewName": "RemptionMode", "Type": "dropdown", "Id": 128 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD6", "FieldName": "Redemption Bank", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "RedemptionBank", "Type": "inputfield", "Id": 129 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD7", "FieldName": "Redemption Account Name", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "RedemptionAccountName", "Type": "inputfield", "Id": 130 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD8", "FieldName": "Redemption Account Code", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "RedemptionAccountCode", "Type": "inputfield", "Id": 131 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD9", "FieldName": "Money Received Date", "DataType": "datetime", "Value": "May 7 2024 12:00AM", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "MoneyReceivedDate", "Type": "inputfield", "Id": 132 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD10", "FieldName": "Currency Type", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "CurrencyType", "Type": "dropdown", "Id": 152 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD11", "FieldName": "Amount ", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "Amount", "Type": "inputfield", "Id": 153 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD12", "FieldName": "FX Rate", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "FXRate", "Type": "inputfield", "Id": 154 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD13", "FieldName": "Calculate Exit Fee", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "CalculateExitFee", "Type": "dropdown", "Id": 177 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD14", "FieldName": "Exit Fee", "DataType": "money", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "ExitFee", "Type": "inputfield", "Id": 178 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD15", "FieldName": "FOF Link", "DataType": "int", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "FOFLink", "Type": "inputfield", "Id": 179 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD16", "FieldName": "Cheque Number ", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "ChequeNumber", "Type": "inputfield", "Id": 188 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD17", "FieldName": "Locking Start Date", "DataType": "datetime", "Value": "", "HideFromExternalDistributor": 1, "IsRequired": 0, "ViewName": "LockingStartDate", "Type": "inputfield", "Id": 236 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD18", "FieldName": "Collection Account(from Investrack)", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "CollectionAccount", "Type": "inputfield", "Id": 240 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD19", "FieldName": "Order From Investrack", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "OrderFromInvestrack", "Type": "dropdown", "Id": 241 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD20", "FieldName": "APX Trade Date", "DataType": "datetime", "Value": "May 8 2024 12:00AM", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "ApxTradeDate", "Type": "inputfield", "Id": 250 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD21", "FieldName": "Skip Document Check(Registered)", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "Skipdocumentcheck", "Type": "dropdown", "Id": 251 }, { "PrimaryId": 598870, "ColumnName": "TRX_ORDER_CUSTOMFIELD22", "FieldName": "IPCounter", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "Ipcounter", "Type": "inputfield", "Id": 261 } ], "CustomerId": 2161271, "Id": 598870, "Guid": "59d9640e-c00c-4ced-a761-8ab1641cbd37", "Created": "2024-05-08T13:37:15.99", "Amount": 1000, "SwitchPercent": null, "Quantity": 0, "ItemPrice": null, "Kid": null, "PaymentDate": "2024-05-08T00:00:00", "CustomerAccountId": null, "CustomerAccountName": null, "CustomerAccountNumber": null, "TradeTypeId": 1, "TradeTypeProgId": "BUY", "TradeTypeName": "Buy", "SwitchId": null, "OrderStatusId": 16, "OrderStatusProgId": "CCL", "OrderStatusName": "Cancelled", "CurrencyId": 222, "CurrencyIso": "LKR", "CurrencyName": "Rupee", "PortfolioId": 2106841, "PortfolioExternalId": null, "PortfolioName": "1ShareAPILakmal1234567891ShareAPILakmal123456789", "ProductId": 28315, "ProductIsin": "LKNWINU00000", "ProductName": "NDB WEALTH INCOME FUND", "AgreementId": null, "AgreementExternalId": null, "AgreementName": null, "FeeId": 2343, "FeeName": "Fee 0.00%", "FeeAmountOrPercent": "P", "FeeValue": 0, "FeeDisplayName": "NAME", "CommissionId": null, "CommissionName": null, "CommissionAmountOrPercent": null, "CommissionValue": null, "PaymentTypeId": 79, "PaymentTypeProgId": "GENERIC_IN", "PaymentTypeName": "GENERIC Incoming for SIP", "Comment": null, "UserId": 6699, "UserName": "ndbaviva\\yatheendra", "MoxyOrderId": null, "OrderModelId": 3, "DistributorId": 141, "ChannelId": 1, "CommissionAmount": null, "FeeAmount": 0, "NetAmount": 1000, "ExchangeFeeAmount": 0, "ExchangeFeePercent": 0, "ToExchangeAmount": 1000, "FxPercent": 1, "OrderFxPercent": 1, "SupplierAmount": 1000, "SupplierItemPrice": null, "TradeDate": "2024-05-07T00:00:00", "SettleDate": null, "SupplierReference": null, "GibAmount": 5, "ExternalId": null, "FeePercent": 0, "GibPercent": 0.5, "ExchangeAccountId": null, "IncentiveDate": null, "PaidDate": "2024-05-08T13:41:00", "CancelledDate": "2024-06-06T09:11:40.027", "StatusChangeDate": "2024-06-06T09:12:00", "SavingsId": null, "ModelOrderId": null, "CashProductId": 28137, "CashProductIsin": null, "CashProductName": "Cash Account", "SupplierFeeAmount": 0, "SupplierFeePercent": 0, "SupplierFeeId": 2343, "SupplierNetFeeAmount": 1000, "CustodyId": 0, "CustodianId": 0, "CashUpFront": 0, "OrderMatchId": null, "LotNumber": 0, "InterestDays": null, "BuySettleDays": null, "SellSettleDays": null, "OwnerId": 6699, "OrderdetailTypeId": 909, "OrderdetailDate": "2024-05-08T13:36:00", "OrderdetailComment": null, "PeriodicRedemptionId": null, "CreatedByUserId": 6699, "IsSettledInAmount": 1, "CostPrice": null, "NavDate": "2024-05-29T00:00:00", "CostDate": null, "CommittedCapital": null, "ContributedCapital": null, "Recallable": 0, "PortfolioTypeId": 140, "PortfolioTypeProgId": "UNIT TRUST", "PortfolioTypeName": "APX TYPE", "SellShort": 0, "OrderHeaderId": null, "PortfolioExternalNumericId": 77623, "AxysPortfolioId": "1007919-09", "RecordDate": null, "RequiresApproval": "NO", "Interest": null, "AlternativeFee1": null, "AlternativeFee2": null, "ChannelProgId": "ORD", "ChannelName": "Sales", "OrderdetialTypeProgId": "FAX", "OrderdetialTypeName": "Fax", "OrderSourceId": null, "OrderSourceValue": null, "OrderSource": null, "CustomerPersonalId": "1007919", "DistributorProgId": "NDBWealth ", "CreatedByUserName": "ndbaviva\\yatheendra", "BulkOrder": 0, "FlowCode": null, "ReturnOfCapital": null, "RecallableReturnOfCapital": null, "PreferredReturn": null, "RecallablePreferredReturn": null, "ProfitAboveHurdle": null, "RecallableProfitAboveHurdle": null, "TaxDistributionAmount": null, "IsTaxDistribution": 0 }, { "CustomFields": [ { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD2", "FieldName": "PaymentMode", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 1, "ViewName": "PaymentMode", "Type": "dropdown", "Id": 118 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD3", "FieldName": "test", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "test", "Type": "inputfield", "Id": 119 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD4", "FieldName": "Reason for Transfer", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 1, "ViewName": "ReasonforTransfer", "Type": "dropdown", "Id": 120 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD5", "FieldName": "Remption Mode", "DataType": "nvarchar", "Value": "CEFT", "HideFromExternalDistributor": 0, "IsRequired": 1, "ViewName": "RemptionMode", "Type": "dropdown", "Id": 128 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD6", "FieldName": "Redemption Bank", "DataType": "nvarchar", "Value": "7311001", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "RedemptionBank", "Type": "inputfield", "Id": 129 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD7", "FieldName": "Redemption Account Name", "DataType": "nvarchar", "Value": " C.Y.L. FONSEKAtest1", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "RedemptionAccountName", "Type": "inputfield", "Id": 130 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD8", "FieldName": "Redemption Account Code", "DataType": "nvarchar", "Value": " 108562522565", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "RedemptionAccountCode", "Type": "inputfield", "Id": 131 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD9", "FieldName": "Money Received Date", "DataType": "datetime", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "MoneyReceivedDate", "Type": "inputfield", "Id": 132 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD10", "FieldName": "Currency Type", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "CurrencyType", "Type": "dropdown", "Id": 152 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD11", "FieldName": "Amount ", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "Amount", "Type": "inputfield", "Id": 153 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD12", "FieldName": "FX Rate", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "FXRate", "Type": "inputfield", "Id": 154 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD13", "FieldName": "Calculate Exit Fee", "DataType": "nvarchar", "Value": "Yes", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "CalculateExitFee", "Type": "dropdown", "Id": 177 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD14", "FieldName": "Exit Fee", "DataType": "money", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "ExitFee", "Type": "inputfield", "Id": 178 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD15", "FieldName": "FOF Link", "DataType": "int", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "FOFLink", "Type": "inputfield", "Id": 179 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD16", "FieldName": "Cheque Number ", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "ChequeNumber", "Type": "inputfield", "Id": 188 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD17", "FieldName": "Locking Start Date", "DataType": "datetime", "Value": "", "HideFromExternalDistributor": 1, "IsRequired": 0, "ViewName": "LockingStartDate", "Type": "inputfield", "Id": 236 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD18", "FieldName": "Collection Account(from Investrack)", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "CollectionAccount", "Type": "inputfield", "Id": 240 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD19", "FieldName": "Order From Investrack", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "OrderFromInvestrack", "Type": "dropdown", "Id": 241 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD20", "FieldName": "APX Trade Date", "DataType": "datetime", "Value": "May 8 2024 12:00AM", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "ApxTradeDate", "Type": "inputfield", "Id": 250 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD21", "FieldName": "Skip Document Check(Registered)", "DataType": "nvarchar", "Value": "Yes", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "Skipdocumentcheck", "Type": "dropdown", "Id": 251 }, { "PrimaryId": 598869, "ColumnName": "TRX_ORDER_CUSTOMFIELD22", "FieldName": "IPCounter", "DataType": "nvarchar", "Value": "", "HideFromExternalDistributor": 0, "IsRequired": 0, "ViewName": "Ipcounter", "Type": "inputfield", "Id": 261 } ], "CustomerId": 2161271, "Id": 598869, "Guid": "6e7c2597-30be-4aa1-9db5-0fa53716c60a", "Created": "2024-05-08T13:04:48.007", "Amount": 11120, "SwitchPercent": null, "Quantity": 0, "ItemPrice": null, "Kid": null, "PaymentDate": "2024-05-08T13:04:00", "CustomerAccountId": null, "CustomerAccountName": null, "CustomerAccountNumber": null, "TradeTypeId": 2, "TradeTypeProgId": "SELL", "TradeTypeName": "Sell", "SwitchId": null, "OrderStatusId": 16, "OrderStatusProgId": "CCL", "OrderStatusName": "Cancelled", "CurrencyId": 222, "CurrencyIso": "LKR", "CurrencyName": "Rupee", "PortfolioId": 2076305, "PortfolioExternalId": null, "PortfolioName": "Y.L. FONSEKA (02)", "ProductId": 28431, "ProductIsin": "LKNWMNU00002", "ProductName": "NDB WEALTH MONEY FUND", "AgreementId": null, "AgreementExternalId": null, "AgreementName": null, "FeeId": 2343, "FeeName": "Fee 0.00%", "FeeAmountOrPercent": "P", "FeeValue": 0, "FeeDisplayName": "NAME", "CommissionId": null, "CommissionName": null, "CommissionAmountOrPercent": null, "CommissionValue": null, "PaymentTypeId": 81, "PaymentTypeProgId": "GENERIC_OT", "PaymentTypeName": "GENERIC Outgoing", "Comment": "MIRunningNO", "UserId": 22752, "UserName": "acupdateU", "MoxyOrderId": null, "OrderModelId": 6, "DistributorId": null, "ChannelId": 18, "CommissionAmount": null, "FeeAmount": 0, "NetAmount": 11120, "ExchangeFeeAmount": 0, "ExchangeFeePercent": 0, "ToExchangeAmount": 11120, "FxPercent": 1, "OrderFxPercent": 1, "SupplierAmount": 11120, "SupplierItemPrice": null, "TradeDate": "2024-05-07T00:00:00", "SettleDate": null, "SupplierReference": null, "GibAmount": 0, "ExternalId": null, "FeePercent": 0, "GibPercent": 0, "ExchangeAccountId": null, "IncentiveDate": null, "PaidDate": null, "CancelledDate": "2024-06-06T09:11:40.153", "StatusChangeDate": "2024-06-06T09:12:00", "SavingsId": null, "ModelOrderId": null, "CashProductId": 28137, "CashProductIsin": null, "CashProductName": "Cash Account", "SupplierFeeAmount": 0, "SupplierFeePercent": 0, "SupplierFeeId": 2343, "SupplierNetFeeAmount": 11120, "CustodyId": 0, "CustodianId": 0, "CashUpFront": 0, "OrderMatchId": null, "LotNumber": -1, "InterestDays": null, "BuySettleDays": null, "SellSettleDays": null, "OwnerId": 22752, "OrderdetailTypeId": null, "OrderdetailDate": null, "OrderdetailComment": null, "PeriodicRedemptionId": null, "CreatedByUserId": 22752, "IsSettledInAmount": 1, "CostPrice": null, "NavDate": null, "CostDate": null, "CommittedCapital": null, "ContributedCapital": null, "Recallable": 0, "PortfolioTypeId": 140, "PortfolioTypeProgId": "UNIT TRUST", "PortfolioTypeName": "APX TYPE", "SellShort": 0, "OrderHeaderId": null, "PortfolioExternalNumericId": 16438, "AxysPortfolioId": "1007919-02", "RecordDate": null, "RequiresApproval": "NO", "Interest": null, "AlternativeFee1": null, "AlternativeFee2": null, "ChannelProgId": "CUSTOM17", "ChannelName": "API use only", "OrderdetialTypeProgId": null, "OrderdetialTypeName": null, "OrderSourceId": null, "OrderSourceValue": null, "OrderSource": null, "CustomerPersonalId": "1007919", "DistributorProgId": null, "CreatedByUserName": "acupdateU", "BulkOrder": 0, "FlowCode": null, "ReturnOfCapital": null, "RecallableReturnOfCapital": null, "PreferredReturn": null, "RecallablePreferredReturn": null, "ProfitAboveHurdle": null, "RecallableProfitAboveHurdle": null, "TaxDistributionAmount": null, "IsTaxDistribution": 0 } ] ============================================== Here is my JOLT spec, [ { "operation": "shift", "spec": { "*": { "CustomFields": { "*": { "@(0,Value)": "[&3].@(0,ViewName)" } }, "PortfolioSharing": { "*": { "@(0,PortfolioId)": "[&3].sharing_PortfolioId", "@(0,CustomerId)": "[&3].sharing_CustomerId", "@(0,PersonalId)": "[&3].sharing_PersonalId", "@(0,ReasonId)": "[&3].sharing_ReasonId", "@(0,ReasonProgId)": "[&3].sharing_ReasonProgId", "@(0,ReasonName)": "[&3].sharing_ReasonName", "@(0,Comment)": "[&3].sharing_Comment", "@(0,TypeId)": "[&3].sharing_TypeId", "@(0,TypeProgId)": "[&3].sharing_TypeProgId", "@(0,TypeName)": "[&3].sharing_TypeName" } }, "*": "[&1].&" } } }, { "operation": "modify-default-beta", "spec": { "*": { // trx_customer "ResidentNonresident": "@(1,Resident/Non-resident)", "NationalityCountryofIncorporation": "@(1,Nationality/CountryofIncorporation)", "PermanantTownCity": "@(1,PermanantTown/City)", "SubsidiaryAssociateofanotherorganization": "@(1,Subsidiary/Associateofanotherorganization)", "Howdidyougettoknowaboutus": "@(1,Howdidyougettoknowaboutus?)", // trx_portfolio "UseBankAccountFromCustomer": "@(1,UseBankAccountFromCustomer?)" } } }, { "operation": "remove", "spec": { "*": { // trx_customer "Resident/Non-resident": "", "Nationality/CountryofIncorporation": "", "PermanantTown/City": "", "Subsidiary/Associateofanotherorganization": "", "NatureOf_Business": "", "Howdidyougettoknowaboutus?": "", //trx_portfolio "UseBankAccountFromCustomer?": "" } } } ] ================================== After the execute JOLT, result like that, [ { "PaymentMode" : "Cash", "test" : "", "ReasonforTransfer" : "", "RemptionMode" : "", "RedemptionBank" : "", "RedemptionAccountName" : "", "RedemptionAccountCode" : "", "MoneyReceivedDate" : "May 7 2024 12:00AM", "CurrencyType" : "", "Amount" : [ "", 1000 ], "FXRate" : "", "CalculateExitFee" : "", "ExitFee" : "", "FOFLink" : "", "ChequeNumber" : "", "LockingStartDate" : "", "CollectionAccount" : "", "OrderFromInvestrack" : "", "ApxTradeDate" : "May 8 2024 12:00AM", "Skipdocumentcheck" : "", "Ipcounter" : "", "CustomerId" : 2161271, "Id" : 598870, "Guid" : "59d9640e-c00c-4ced-a761-8ab1641cbd37", "Created" : "2024-05-08T13:37:15.99", "SwitchPercent" : null, "Quantity" : 0, "ItemPrice" : null, "Kid" : null, "PaymentDate" : "2024-05-08T00:00:00", "CustomerAccountId" : null, "CustomerAccountName" : null, "CustomerAccountNumber" : null, "TradeTypeId" : 1, "TradeTypeProgId" : "BUY", "TradeTypeName" : "Buy", "SwitchId" : null, "OrderStatusId" : 16, "OrderStatusProgId" : "CCL", "OrderStatusName" : "Cancelled", "CurrencyId" : 222, "CurrencyIso" : "LKR", "CurrencyName" : "Rupee", "PortfolioId" : 2106841, "PortfolioExternalId" : null, "PortfolioName" : "1ShareAPILakmal1234567891ShareAPILakmal123456789", "ProductId" : 28315, "ProductIsin" : "LKNWINU00000", "ProductName" : "NDB WEALTH INCOME FUND", "AgreementId" : null, "AgreementExternalId" : null, "AgreementName" : null, "FeeId" : 2343, "FeeName" : "Fee 0.00%", "FeeAmountOrPercent" : "P", "FeeValue" : 0, "FeeDisplayName" : "NAME", "CommissionId" : null, "CommissionName" : null, "CommissionAmountOrPercent" : null, "CommissionValue" : null, "PaymentTypeId" : 79, "PaymentTypeProgId" : "GENERIC_IN", "PaymentTypeName" : "GENERIC Incoming for SIP", "Comment" : null, "UserId" : 6699, "UserName" : "ndbaviva\\yatheendra", "MoxyOrderId" : null, "OrderModelId" : 3, "DistributorId" : 141, "ChannelId" : 1, "CommissionAmount" : null, "FeeAmount" : 0, "NetAmount" : 1000, "ExchangeFeeAmount" : 0, "ExchangeFeePercent" : 0, "ToExchangeAmount" : 1000, "FxPercent" : 1, "OrderFxPercent" : 1, "SupplierAmount" : 1000, "SupplierItemPrice" : null, "TradeDate" : "2024-05-07T00:00:00", "SettleDate" : null, "SupplierReference" : null, "GibAmount" : 5, "ExternalId" : null, "FeePercent" : 0, "GibPercent" : 0.5, "ExchangeAccountId" : null, "IncentiveDate" : null, "PaidDate" : "2024-05-08T13:41:00", "CancelledDate" : "2024-06-06T09:11:40.027", "StatusChangeDate" : "2024-06-06T09:12:00", "SavingsId" : null, "ModelOrderId" : null, "CashProductId" : 28137, "CashProductIsin" : null, "CashProductName" : "Cash Account", "SupplierFeeAmount" : 0, "SupplierFeePercent" : 0, "SupplierFeeId" : 2343, "SupplierNetFeeAmount" : 1000, "CustodyId" : 0, "CustodianId" : 0, "CashUpFront" : 0, "OrderMatchId" : null, "LotNumber" : 0, "InterestDays" : null, "BuySettleDays" : null, "SellSettleDays" : null, "OwnerId" : 6699, "OrderdetailTypeId" : 909, "OrderdetailDate" : "2024-05-08T13:36:00", "OrderdetailComment" : null, "PeriodicRedemptionId" : null, "CreatedByUserId" : 6699, "IsSettledInAmount" : 1, "CostPrice" : null, "NavDate" : "2024-05-29T00:00:00", "CostDate" : null, "CommittedCapital" : null, "ContributedCapital" : null, "Recallable" : 0, "PortfolioTypeId" : 140, "PortfolioTypeProgId" : "UNIT TRUST", "PortfolioTypeName" : "APX TYPE", "SellShort" : 0, "OrderHeaderId" : null, "PortfolioExternalNumericId" : 77623, "AxysPortfolioId" : "1007919-09", "RecordDate" : null, "RequiresApproval" : "NO", "Interest" : null, "AlternativeFee1" : null, "AlternativeFee2" : null, "ChannelProgId" : "ORD", "ChannelName" : "Sales", "OrderdetialTypeProgId" : "FAX", "OrderdetialTypeName" : "Fax", "OrderSourceId" : null, "OrderSourceValue" : null, "OrderSource" : null, "CustomerPersonalId" : "1007919", "DistributorProgId" : "NDBWealth ", "CreatedByUserName" : "ndbaviva\\yatheendra", "BulkOrder" : 0, "FlowCode" : null, "ReturnOfCapital" : null, "RecallableReturnOfCapital" : null, "PreferredReturn" : null, "RecallablePreferredReturn" : null, "ProfitAboveHurdle" : null, "RecallableProfitAboveHurdle" : null, "TaxDistributionAmount" : null, "IsTaxDistribution" : 0 }, { "PaymentMode" : "", "test" : "", "ReasonforTransfer" : "", "RemptionMode" : "CEFT", "RedemptionBank" : "7311001", "RedemptionAccountName" : " C.Y.L. FONSEKAtest1", "RedemptionAccountCode" : " 108562522565", "MoneyReceivedDate" : "", "CurrencyType" : "", "Amount" : [ "", 11120 ], "FXRate" : "", "CalculateExitFee" : "Yes", "ExitFee" : "", "FOFLink" : "", "ChequeNumber" : "", "LockingStartDate" : "", "CollectionAccount" : "", "OrderFromInvestrack" : "", "ApxTradeDate" : "May 8 2024 12:00AM", "Skipdocumentcheck" : "Yes", "Ipcounter" : "", "CustomerId" : 2161271, "Id" : 598869, "Guid" : "6e7c2597-30be-4aa1-9db5-0fa53716c60a", "Created" : "2024-05-08T13:04:48.007", "SwitchPercent" : null, "Quantity" : 0, "ItemPrice" : null, "Kid" : null, "PaymentDate" : "2024-05-08T13:04:00", "CustomerAccountId" : null, "CustomerAccountName" : null, "CustomerAccountNumber" : null, "TradeTypeId" : 2, "TradeTypeProgId" : "SELL", "TradeTypeName" : "Sell", "SwitchId" : null, "OrderStatusId" : 16, "OrderStatusProgId" : "CCL", "OrderStatusName" : "Cancelled", "CurrencyId" : 222, "CurrencyIso" : "LKR", "CurrencyName" : "Rupee", "PortfolioId" : 2076305, "PortfolioExternalId" : null, "PortfolioName" : "Y.L. FONSEKA (02)", "ProductId" : 28431, "ProductIsin" : "LKNWMNU00002", "ProductName" : "NDB WEALTH MONEY FUND", "AgreementId" : null, "AgreementExternalId" : null, "AgreementName" : null, "FeeId" : 2343, "FeeName" : "Fee 0.00%", "FeeAmountOrPercent" : "P", "FeeValue" : 0, "FeeDisplayName" : "NAME", "CommissionId" : null, "CommissionName" : null, "CommissionAmountOrPercent" : null, "CommissionValue" : null, "PaymentTypeId" : 81, "PaymentTypeProgId" : "GENERIC_OT", "PaymentTypeName" : "GENERIC Outgoing", "Comment" : "MIRunningNO", "UserId" : 22752, "UserName" : "acupdateU", "MoxyOrderId" : null, "OrderModelId" : 6, "DistributorId" : null, "ChannelId" : 18, "CommissionAmount" : null, "FeeAmount" : 0, "NetAmount" : 11120, "ExchangeFeeAmount" : 0, "ExchangeFeePercent" : 0, "ToExchangeAmount" : 11120, "FxPercent" : 1, "OrderFxPercent" : 1, "SupplierAmount" : 11120, "SupplierItemPrice" : null, "TradeDate" : "2024-05-07T00:00:00", "SettleDate" : null, "SupplierReference" : null, "GibAmount" : 0, "ExternalId" : null, "FeePercent" : 0, "GibPercent" : 0, "ExchangeAccountId" : null, "IncentiveDate" : null, "PaidDate" : null, "CancelledDate" : "2024-06-06T09:11:40.153", "StatusChangeDate" : "2024-06-06T09:12:00", "SavingsId" : null, "ModelOrderId" : null, "CashProductId" : 28137, "CashProductIsin" : null, "CashProductName" : "Cash Account", "SupplierFeeAmount" : 0, "SupplierFeePercent" : 0, "SupplierFeeId" : 2343, "SupplierNetFeeAmount" : 11120, "CustodyId" : 0, "CustodianId" : 0, "CashUpFront" : 0, "OrderMatchId" : null, "LotNumber" : -1, "InterestDays" : null, "BuySettleDays" : null, "SellSettleDays" : null, "OwnerId" : 22752, "OrderdetailTypeId" : null, "OrderdetailDate" : null, "OrderdetailComment" : null, "PeriodicRedemptionId" : null, "CreatedByUserId" : 22752, "IsSettledInAmount" : 1, "CostPrice" : null, "NavDate" : null, "CostDate" : null, "CommittedCapital" : null, "ContributedCapital" : null, "Recallable" : 0, "PortfolioTypeId" : 140, "PortfolioTypeProgId" : "UNIT TRUST", "PortfolioTypeName" : "APX TYPE", "SellShort" : 0, "OrderHeaderId" : null, "PortfolioExternalNumericId" : 16438, "AxysPortfolioId" : "1007919-02", "RecordDate" : null, "RequiresApproval" : "NO", "Interest" : null, "AlternativeFee1" : null, "AlternativeFee2" : null, "ChannelProgId" : "CUSTOM17", "ChannelName" : "API use only", "OrderdetialTypeProgId" : null, "OrderdetialTypeName" : null, "OrderSourceId" : null, "OrderSourceValue" : null, "OrderSource" : null, "CustomerPersonalId" : "1007919", "DistributorProgId" : null, "CreatedByUserName" : "acupdateU", "BulkOrder" : 0, "FlowCode" : null, "ReturnOfCapital" : null, "RecallableReturnOfCapital" : null, "PreferredReturn" : null, "RecallablePreferredReturn" : null, "ProfitAboveHurdle" : null, "RecallableProfitAboveHurdle" : null, "TaxDistributionAmount" : null, "IsTaxDistribution" : 0 } ] =============================== The problem is here, "Amount" : [ "", 1000 ]" There are two "Amount" fields in my input json, First one is in the "CustomFiled" and the other one is in the main root json, I need to get these two "Amount" fields separately, as an example, "Amount1" and "Amount2", To do this, How do I change my JOLT spec.? Thanks for advance.

Thar11027 · ‎06-06-2024

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

Thar11027 · ‎06-06-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.

Thar11027 · ‎06-04-2024

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.

Online	Offline
Last Visited	‎05-27-2025 12:20 AM

Member Since	‎06-04-2024 04:07 AM
Last Visited	‎05-27-2025 12:20 AM
Posts	9
Kudos received	11

Cloudera Community

Take to many time when upsert action in Mongodb us...

Record duplication in MongoDB

JOLT returns UNexpected array

Re: Get duplicate records in MySql

Get duplicate records in MySql

Jolt Returns unnecessary output

Re: JOLT TRANSFORMATION returns unexpected result

Re: JOLT TRANSFORMATION returns unexpected result

JOLT TRANSFORMATION returns unexpected result