fork download
copy 
  1. import xml.etree.ElementTree as ET
  2. from xml.dom import minidom
  3. import csv
  4. import io
  5.  
  6. def prettify_xml(elem):
  7.     """Return a pretty-printed XML string for the Element."""
  8.     rough_string = ET.tostring(elem, 'utf-8')
  9.     parsed = minidom.parseString(rough_string)
  10.     return parsed.toprettyxml(indent="    ")
  11.  
  12. def create_insert_element(record):
  13.     insert_elem = ET.Element("insert", tableName="EXTERNAL_API_DEFINITION", schemaName="${current_schema}")
  14.  
  15.     # Define each column with values from the record
  16.     columns = [
  17.         ("BILLER_CODE", record['biller_code']),
  18.         ("BILLER_SECRETS", record['biller_secrets']),
  19.         ("INFO_CHECK_REQUEST_DEFINITION", record['info_check_request_definition']),
  20.         ("PAYMENT_REQUEST_DEFINITION", record['payment_request_definition']),
  21.         ("IS_ACTIVE", "${default_boolean_true}"),
  22.         ("INFO_CHECK_ENDPOINT", record['info_check_api']),
  23.         ("PROCESS_PAYMENT_ENDPOINT", record['process_payment_endpoint']),
  24.         ("PAYMENT_STATUS_ENDPOINT", record['payment_status_definition']),
  25.         ("REQUEST_HEADERS_DEFINITION", record['request_headers_definition'])
  26.     ]
  27.  
  28.     # Add each column to the insert element
  29.     for name, value in columns:
  30.         ET.SubElement(insert_elem, "column", name=name, value=value)
  31.  
  32.     return insert_elem
  33.  
  34. def create_xml_migration_script(records):
  35.     root = ET.Element("changeSet", id="insert_external_api_definitions", author="user")
  36.  
  37.     # Add each record's insert element
  38.     for record in records:
  39.         insert_elem = create_insert_element(record)
  40.         root.append(insert_elem)
  41.  
  42.     # Pretty print the XML
  43.     return prettify_xml(root)
  44.  
  45. def parse_input(input_text):
  46.     # Parse the CSV input
  47.     reader = csv.reader(io.StringIO(input_text))
  48.     records = []
  49.     for row in reader:
  50.         if len(row) < 8:
  51.             continue  # Skip rows that don't have all required fields
  52.  
  53.         # Map the row to dictionary keys
  54.         record = {
  55.             "biller_code": row[0].strip(),
  56.             "biller_secrets": row[1].strip(),
  57.             "info_check_request_definition": row[2].strip(),
  58.             "payment_request_definition": row[3].strip(),
  59.             "info_check_api": row[4].strip(),
  60.             "process_payment_endpoint": row[5].strip(),
  61.             "request_headers_definition": row[6].strip(),
  62.             "payment_status_definition": row[7].strip()
  63.         }
  64.         records.append(record)
  65.  
  66.     return records
  67.  
  68. # Sample input
  69. input_text = '''
  70. SSL_DPDC_POSTPAID,"{
  71.   ""common"": {
  72.     ""STK-CODE"": ""ABDIRECT"",
  73.     ""AUTH-KEY"": ""EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi"",
  74.     ""utility_auth_key"": ""16922468323555"",
  75.     ""utility_secret_key"": ""c5iMNoUatdYlSqEW"",
  76.     ""mode"": ""1"",
  77.     ""pay_channel"": ""4""
  78.   }
  79. }","{
  80.         ""transaction_id"": ""transaction_id"",
  81.         ""account_no"": ""account_no"",
  82.         ""bill_month"": ""bill_months"",
  83.         ""bill_year"": ""bill_years"",
  84.         ""utility_auth_key"": ""utility_auth_key"",
  85.         ""utility_secret_key"": ""utility_secret_key""
  86.     }","{
  87.         ""bnk_trx_id"": ""bnk_trx_id"",
  88.         ""pay_channel"": ""pay_channel"",
  89.         ""transaction_id"": ""transaction_id"",
  90.         ""utility_auth_key"": ""utility_auth_key"",
  91.         ""utility_secret_key"": ""utility_secret_key""
  92.     }",true,/api/v1/bill-info,/api/v1/bill-payment,/api/v1/bill-status,"{
  93.     ""AUTH-KEY"": ""AUTH-KEY"",
  94.     ""STK-CODE"": ""STK-CODE""
  95. }","{
  96.     ""bnk_trx_id"": ""bnk_trx_id"",
  97.     ""transaction_id"": ""transaction_id"",
  98.     ""utility_auth_key"": ""utility_auth_key"",
  99.     ""utility_secret_key"": ""utility_secret_key""
  100. }"
  101. SSL_WILLS_LITTLE_FLOWER,"{
  102.   ""STK-CODE"": ""ABDIRECT"",
  103.   ""AUTH-KEY"": ""EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi"",
  104.   ""utility_auth_key"": ""16888826005300"",
  105.   ""utility_secret_key"": ""YlnQ98fCIgEkg2vU""
  106. }","{
  107.     ""transaction_id"": ""transaction_id"",
  108.     ""utility_auth_key"": ""utility_auth_key"",
  109.     ""utility_secret_key"": ""utility_secret_key"",
  110.     ""reference_no"": ""reference_no""
  111. }","{
  112.     ""transaction_id"": ""transaction_id"",
  113.     ""utility_auth_key"": ""utility_auth_key"",
  114.     ""utility_secret_key"": ""utility_secret_key""
  115. }",true,/api/v1/bill-info,/api/v1/bill-payment,/api/v1/bill-status,"{
  116.     ""AUTH-KEY"": ""AUTH-KEY"",
  117.     ""STK-CODE"": ""STK-CODE""
  118. }","{
  119.     ""transaction_id"": ""transaction_id"",
  120.     ""utility_auth_key"": ""utility_auth_key"",
  121.     ""utility_secret_key"": ""utility_secret_key""
  122. }"
  123. SSL_NESCO_POSTPAID,"{
  124.     ""STK-CODE"": ""ABDIRECT"",
  125.     ""AUTH-KEY"": ""EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi"",
  126.     ""utility_auth_key"": ""16976995921527"",
  127.     ""utility_secret_key"": ""Lt/GrXALyd1pj8AY"",
  128.     ""mode"": ""1""
  129. }","{
  130.     ""transaction_id"": ""transaction_id"",
  131.     ""account_no"": ""account_no"",
  132.     ""bill_month"": ""bill_months"",
  133.     ""bill_year"": ""bill_years"",
  134.     ""utility_auth_key"": ""utility_auth_key"",
  135.     ""utility_secret_key"": ""utility_secret_key""
  136. }","{
  137.     ""is_stamp_collected"": ""is_stamp_collected"",
  138.     ""core_transaction_id"": ""core_transaction_id"",
  139.     ""transaction_id"": ""transaction_id"",
  140.     ""utility_auth_key"": ""utility_auth_key"",
  141.     ""utility_secret_key"": ""utility_secret_key""
  142. }",true,/api/v1/bill-info,/api/v1/bill-payment,/api/v1/bill-status,"{
  143.     ""AUTH-KEY"": ""AUTH-KEY"",
  144.     ""STK-CODE"": ""STK-CODE""
  145. }","{
  146.     ""transaction_id"": ""transaction_id"",
  147.     ""utility_auth_key"": ""utility_auth_key"",
  148.     ""utility_secret_key"": ""utility_secret_key""
  149. }"
  150. SSL_WASA_GENERAL_BILL,"{
  151.     ""common"": {
  152.         ""STK-CODE"": ""DEMO"",
  153.         ""utility_auth_key"": ""WA15174603642090"",
  154.         ""utility_secret_key"": ""GWFYAiy8g5T92UIg"",
  155.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  156.         ""bill_type"": ""GENERAL-BILL""
  157.     },
  158.     ""infoCheck"": {},
  159.     ""payBill"": {
  160.         ""payment_type"": ""3"",
  161.         ""channel_id"": ""4""
  162.     }
  163. }","{
  164.     ""transaction_id"": ""transaction_id"",
  165.     ""billno"": ""billno"",
  166.     ""bill_type"": ""bill_type"",
  167.     ""account_no"": ""account_no"",
  168.     ""utility_auth_key"": ""utility_auth_key"",
  169.     ""utility_secret_key"": ""utility_secret_key""
  170. }","{
  171.     ""mobile_no"": ""mobile_no"",
  172.     ""branch_code"": ""branch_code"",
  173.     ""payment_type"": ""payment_type"",
  174.     ""channel_id"": ""channel_id"",
  175.     ""remarks"": ""remarks"",
  176.     ""transaction_id"": ""transaction_id"",
  177.     ""utility_auth_key"": ""utility_auth_key"",
  178.     ""utility_secret_key"": ""utility_secret_key""
  179. }",true,/api/v1/bill-info,/api/v1/bill-payment,/api/v1/bill-status,"{
  180.     ""AUTH-KEY"": ""AUTH-KEY"",
  181.     ""STK-CODE"": ""STK-CODE""
  182. }","{
  183.     ""transaction_id"": ""transaction_id"",
  184.     ""utility_auth_key"": ""utility_auth_key"",
  185.     ""utility_secret_key"": ""utility_secret_key""
  186. }"
  187. SSL_NESCO_PREPAID,"{
  188.     ""common"": {
  189.         ""STK-CODE"": ""DEMO"",
  190.         ""utility_auth_key"": ""NE16151186585379"",
  191.         ""utility_secret_key"": ""PsilgetRO/wYIkPg"",
  192.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  193.         ""bill_type"": ""PREPAID""
  194.     },
  195.     ""infoCheck"": {},
  196.     ""payBill"": {}
  197. }","{
  198.     ""transaction_id"": ""transaction_id"",
  199.     ""utility_auth_key"": ""utility_auth_key"",
  200.     ""utility_secret_key"": ""utility_secret_key"",
  201.     ""bill_type"": ""bill_type""
  202. }","{
  203.     ""utility_bill_type"": ""utility_bill_type"",
  204.     ""transaction_id"": ""transaction_id"",
  205.     ""utility_auth_key"": ""utility_auth_key"",
  206.     ""utility_secret_key"": ""utility_secret_key""
  207. }",true,/api/v1/bill-info,/api/v1/bill-payment,/api/v1/bill-status,"{
  208.     ""AUTH-KEY"": ""AUTH-KEY"",
  209.     ""STK-CODE"": ""STK-CODE""
  210. }","{
  211.     ""transaction_id"": ""transaction_id"",
  212.     ""utility_auth_key"": ""utility_auth_key"",
  213.     ""utility_secret_key"": ""utility_secret_key""
  214. }"
  215. SSL_DPDC_NEW_POSTPAID,"{
  216.     ""common"": {
  217.         ""STK-CODE"": ""DEMO"",
  218.         ""utility_auth_key"": ""DP16030264222969"",
  219.         ""utility_secret_key"": ""wQXJaE6c5ydoxG3H"",
  220.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla""
  221.     },
  222.     ""infoCheck"": {
  223.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  224.         ""utility_auth_key"": ""DP16030264222969"",
  225.         ""utility_secret_key"": ""wQXJaE6c5ydoxG3H""
  226.     },
  227.     ""payBill"": {
  228.         ""mode"": ""1""
  229.     }
  230. }","{
  231.     ""transaction_id"": ""transaction_id"",
  232.     ""account_no"": ""account_no"",
  233.     ""pay_channel"": ""pay_channel"",
  234.     ""bill_months"": ""bill_months"",
  235.     ""bill_years"": ""bill_years"",
  236.     ""utility_auth_key"": ""utility_auth_key"",
  237.     ""utility_secret_key"": ""utility_secret_key""
  238. }","{
  239.     ""pay_channel"": ""pay_channel"",
  240.     ""bnk_trx_id"": ""bnk_trx_id"",
  241.     ""transaction_id"": ""transaction_id"",
  242.     ""utility_auth_key"": ""utility_auth_key"",
  243.     ""utility_secret_key"": ""utility_secret_key""
  244. }",true,"","","","{
  245.     ""AUTH-KEY"": ""AUTH-KEY"",
  246.     ""STK-CODE"": ""STK-CODE""
  247. }",
  248. SSL_DESCO_POSTPAID,"{
  249.   ""STK-CODE"": ""ABDIRECT"",
  250.   ""utility_auth_key"": ""16643633415347"",
  251.   ""utility_secret_key"": ""FrFHsRG3jws7kmMV"",
  252.   ""AUTH-KEY"": ""EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi""
  253. }","{
  254.     ""transaction_id"": ""transaction_id"",
  255.     ""billno"": ""bllNo"",
  256.     ""utility_auth_key"": ""utility_auth_key"",
  257.     ""utility_secret_key"": ""utility_secret_key""
  258. }","{
  259.     ""transaction_id"": ""transaction_id"",
  260.     ""utility_auth_key"": ""utility_auth_key"",
  261.     ""utility_secret_key"": ""utility_secret_key""
  262. }",true,/api/v1/bill-info,/api/v1/bill-payment,/api/v1/bill-status,"{
  263.     ""AUTH-KEY"": ""AUTH-KEY"",
  264.     ""STK-CODE"": ""STK-CODE""
  265. }","{
  266.     ""bnk_trx_id"": ""bnk_trx_id"",
  267.     ""transaction_id"": ""transaction_id"",
  268.     ""utility_auth_key"": ""utility_auth_key"",
  269.     ""utility_secret_key"": ""utility_secret_key""
  270. }"
  271. SSL_BGDCL_DEMAND_NOTE,"{
  272.     ""common"": {
  273.         ""STK-CODE"": ""DEMO"",
  274.         ""utility_auth_key"": ""BG15650660381148"",
  275.         ""utility_secret_key"": ""mfOxzaTBWl0pM8wC"",
  276.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  277.         ""bill_type"": ""DEMAND-NOTE""
  278.     },
  279.     ""infoCheck"": {},
  280.     ""payBill"": {}
  281. }","{
  282.     ""transaction_id"": ""transaction_id"",
  283.     ""custCode"": ""custCode"",
  284.     ""mobileNo"": ""mobileNo"",
  285.     ""demandNoteCode"": ""demandNoteCode"",
  286.     ""bill_type"": ""bill_type"",
  287.     ""utility_auth_key"": ""utility_auth_key"",
  288.     ""utility_secret_key"": ""utility_secret_key""
  289. }","{
  290.     ""transaction_id"": ""transaction_id"",
  291.     ""custCode"": ""custCode"",
  292.     ""mobileNo"": ""mobileNo"",
  293.     ""bankName"": ""bankName"",
  294.     ""branchName"": ""branchName"",
  295.     ""totalAmount"": ""totalAmount"",
  296.     ""bill_type"": ""bill_type"",
  297.     ""utility_auth_key"": ""utility_auth_key"",
  298.     ""utility_secret_key"": ""utility_secret_key""
  299. }",true,"","","","{
  300.     ""AUTH-KEY"": ""AUTH-KEY"",
  301.     ""STK-CODE"": ""STK-CODE""
  302. }",
  303. BGDCL_METERED,"{
  304.     ""common"": {
  305.         ""STK-CODE"": ""DEMO"",
  306.         ""utility_auth_key"": ""BG15650909253030"",
  307.         ""utility_secret_key"": ""xdtDeg65HgUjA6SZ"",
  308.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla""
  309.     },
  310.     ""infoCheck"": {
  311.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  312.         ""utility_auth_key"": ""BG15650909253030"",
  313.         ""utility_secret_key"": ""xdtDeg65HgUjA6SZ""
  314.     },
  315.     ""payBill"": {
  316.         ""mode"": ""1""
  317.     }
  318. }","{
  319.     ""code"": ""custCode"",
  320.     ""mobileNo"": ""mobileNo"",
  321.     ""transaction_id"": ""transaction_id"",
  322.     ""bill_type"": ""bill_type"",
  323.     ""utility_auth_key"": ""utility_auth_key"",
  324.     ""utility_secret_key"": ""utility_secret_key""
  325. }","{
  326.     ""mobileNo"": ""mobileNo"",
  327.     ""bankName"": ""bankName"",
  328.     ""branchName"": ""branchName"",
  329.     ""custCode"": ""custCode"",
  330.     ""billAmount"": ""billAmount"",
  331.     ""transaction_id"": ""transaction_id"",
  332.     ""bill_type"": ""bill_type"",
  333.     ""utility_auth_key"": ""utility_auth_key"",
  334.     ""utility_secret_key"": ""utility_secret_key""
  335. }",true,"","","","{
  336.     ""AUTH-KEY"": ""AUTH-KEY"",
  337.     ""STK-CODE"": ""STK-CODE""
  338. }",
  339. BGDCL_NON_METERED,"{
  340.     ""common"": {
  341.         ""STK-CODE"": ""DEMO"",
  342.         ""utility_auth_key"": ""BG15650661022290"",
  343.         ""utility_secret_key"": ""DVBODGYa3fJuKZm5"",
  344.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla""
  345.     },
  346.     ""infoCheck"": {
  347.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  348.         ""utility_auth_key"": ""BG15650661022290"",
  349.         ""utility_secret_key"": ""DVBODGYa3fJuKZm5""
  350.     },
  351.     ""payBill"": {
  352.         ""mode"": ""1""
  353.     }
  354. }","{
  355.     ""code"": ""code"",
  356.     ""mobileNo"": ""mobileNo"",
  357.     ""transaction_id"": ""transaction_id"",
  358.     ""bill_type"": ""bill_type"",
  359.     ""utility_auth_key"": ""utility_auth_key"",
  360.     ""utility_secret_key"": ""utility_secret_key""
  361. }","{
  362.     ""mobileNo"": ""mobileNo"",
  363.     ""bankName"": ""bankName"",
  364.     ""branchName"": ""branchName"",
  365.     ""custCode"": ""custCode"",
  366.     ""billAmount"": ""billAmount"",
  367.     ""transaction_id"": ""transaction_id"",
  368.     ""bill_type"": ""bill_type"",
  369.     ""utility_auth_key"": ""utility_auth_key"",
  370.     ""utility_secret_key"": ""utility_secret_key""
  371. }
  372. ",true,"","","","{
  373.     ""AUTH-KEY"": ""AUTH-KEY"",
  374.     ""STK-CODE"": ""STK-CODE""
  375. }",
  376. SSL_TITAS_DEMAND_NOTE,"{
  377.     ""common"": {
  378.         ""STK-CODE"": ""DEMO"",
  379.         ""utility_auth_key"": ""TI15174603537876"",
  380.         ""utility_secret_key"": ""IV5RwHzGJDBpkhk1"",
  381.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla""
  382.     },
  383.     ""infoCheck"": {
  384.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  385.         ""utility_auth_key"": ""TI15174603537876"",
  386.         ""utility_secret_key"": ""IV5RwHzGJDBpkhk1""
  387.     },
  388.     ""payBill"": {
  389.         ""mode"": ""1""
  390.     }
  391. }","{
  392.     ""invoiceNo"": ""invoiceNo"",
  393.     ""transaction_id"": ""transaction_id"",
  394.     ""bill_type"": ""bill_type"",
  395.     ""utility_auth_key"": ""utility_auth_key"",
  396.     ""utility_secret_key"": ""utility_secret_key""
  397. }","{
  398.     ""paymentId"": ""paymentId"",
  399.     ""bill_type"": ""bill_type"",
  400.     ""transaction_id"": ""transaction_id"",
  401.     ""utility_auth_key"": ""utility_auth_key"",
  402.     ""utility_secret_key"": ""utility_secret_key""
  403. }",true,"","","","{
  404.     ""AUTH-KEY"": ""AUTH-KEY"",
  405.     ""STK-CODE"": ""STK-CODE""
  406. }",
  407. SSL_TITAS_METERED,"{
  408.     ""common"": {
  409.         ""STK-CODE"": ""DEMO"",
  410.         ""utility_auth_key"": ""TI15174603077847"",
  411.         ""utility_secret_key"": ""Nn2nCVRuTpY6xso5"",
  412.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla""
  413.     },
  414.     ""infoCheck"": {
  415.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  416.         ""utility_auth_key"": ""TI15174603077847"",
  417.         ""utility_secret_key"": ""Nn2nCVRuTpY6xso5""
  418.     },
  419.     ""payBill"": {
  420.         ""mode"": ""1""
  421.     }
  422. }","{
  423.     ""invoiceNo"": ""invoiceNo"",
  424.     ""customerCode"": ""customerCode"",
  425.     ""sourceTaxAmount"": ""sourceTaxAmount"",
  426.     ""branchRoutingNo"": ""branchRoutingNo"",
  427.     ""operator"": ""operator"",
  428.     ""transaction_id"": ""transaction_id"",
  429.     ""chalanNo"": ""chalanNo"",
  430.     ""chalanDate"": ""chalanDate"",
  431.     ""chalanBank"": ""chalanBank"",
  432.     ""chalanBranch"": ""chalanBranch"",
  433.     ""bill_type"": ""bill_type"",
  434.     ""utility_auth_key"": ""utility_auth_key"",
  435.     ""utility_secret_key"": ""utility_secret_key""
  436. }","{
  437.     ""paymentId"": ""paymentId"",
  438.     ""bill_type"": ""bill_type"",
  439.     ""transaction_id"": ""transaction_id"",
  440.     ""utility_auth_key"": ""utility_auth_key"",
  441.     ""utility_secret_key"": ""utility_secret_key""
  442. }",true,"","","","{
  443.     ""AUTH-KEY"": ""AUTH-KEY"",
  444.     ""STK-CODE"": ""STK-CODE""
  445. }",
  446. SSL_TITAS_NON_METERED,"{
  447.     ""common"": {
  448.         ""STK-CODE"": ""DEMO"",
  449.         ""utility_auth_key"": ""TI15174603401736"",
  450.         ""utility_secret_key"": ""PCQue5wZiBhflvYk"",
  451.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla""
  452.     },
  453.     ""infoCheck"": {
  454.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  455.         ""utility_auth_key"": ""TI15174603401736"",
  456.         ""utility_secret_key"": ""PCQue5wZiBhflvYk""
  457.     },
  458.     ""payBill"": {
  459.         ""mode"": ""1""
  460.     }
  461. }","{
  462.     ""customer"": ""customer"",
  463.     ""amount"": ""amount"",
  464.     ""surcharge"": ""surcharge"",
  465.     ""particulars"": ""particulars"",
  466.     ""transaction_id"": ""transaction_id"",
  467.     ""bill_type"": ""bill_type"",
  468.     ""utility_auth_key"": ""utility_auth_key"",
  469.     ""utility_secret_key"": ""utility_secret_key""
  470. }","{
  471.     ""transaction_id"": ""transaction_id"",
  472.     ""paymentId"": ""paymentId"",
  473.     ""bill_type"": ""bill_type"",
  474.     ""utility_auth_key"": ""utility_auth_key"",
  475.     ""utility_secret_key"": ""utility_secret_key""
  476. }",true,"","","","{
  477.     ""AUTH-KEY"": ""AUTH-KEY"",
  478.     ""STK-CODE"": ""STK-CODE""
  479. }",
  480. SSL_BREB_POSTPAID,"{
  481.     ""common"": {
  482.         ""STK-CODE"": ""DEMO"",
  483.         ""utility_auth_key"": ""BR16713629651374"",
  484.         ""utility_secret_key"": ""BR16713629651374"",
  485.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  486.         ""pay_channel"": ""4""
  487.     },
  488.     ""infoCheck"": {
  489.     },
  490.     ""payBill"": {
  491.         ""mode"": ""1""
  492.     }
  493. }","{
  494.     ""transaction_id"": ""transaction_id"",
  495.     ""account_no"": ""account_no"",
  496.     ""type_of_bill"": ""type_of_bill"",
  497.     ""bill_type"": ""bill_type"",
  498.     ""utility_auth_key"": ""utility_auth_key"",
  499.     ""utility_secret_key"": ""utility_secret_key"",
  500.     ""branchRoutingNo"": ""branchRoutingNo""
  501. }
  502. ","{
  503.     ""utility_bill_type"": ""utility_bill_type"",
  504.     ""transaction_id"": ""transaction_id"",
  505.     ""utility_auth_key"": ""utility_auth_key"",
  506.     ""utility_secret_key"": ""utility_secret_key""
  507. }",true,"","","","{
  508.     ""AUTH-KEY"": ""AUTH-KEY"",
  509.     ""STK-CODE"": ""STK-CODE""
  510. }",
  511. SSL_BTCL_NEW_REGULAR_BILL,"{
  512.     ""common"": {
  513.         ""STK-CODE"": ""DEMO"",
  514.         ""utility_auth_key"": ""BT16001654136458"",
  515.         ""utility_secret_key"": ""11eoYOi3nemSPglu"",
  516.         ""AUTH-KEY"": ""BD6pFSIfSOLEIgKyru67MeBhICkRiFla"",
  517.         ""pay_channel"": ""4""
  518.     },
  519.     ""infoCheck"": {
  520.     },
  521.     ""payBill"": {
  522.         ""mode"": ""1""
  523.     }
  524. }","{
  525.     ""bill_no"": ""bill_no"",
  526.     ""phone_number"": ""phone_number"",
  527.     ""exchange_code"": ""exchange_code"",
  528.     ""branch_code"": ""branch_code"",
  529.     ""bill_type"": ""bill_type"",
  530.     ""transaction_id"": ""transaction_id"",
  531.     ""utility_auth_key"": ""utility_auth_key"",
  532.     ""utility_secret_key"": ""utility_secret_key""
  533. }","{
  534.     ""transaction_id"": ""transaction_id"",
  535.     ""utility_bill_type"": ""utility_bill_type"",
  536.     ""utility_auth_key"": ""utility_auth_key"",
  537.     ""utility_secret_key"": ""utility_secret_key""
  538. }",true,"","","","{
  539.     ""AUTH-KEY"": ""AUTH-KEY"",
  540.     ""STK-CODE"": ""STK-CODE""
  541. }",
  542.  
  543. '''
  544.  
  545. # Parse the input and create records
  546. records = parse_input(input_text)
  547.  
  548. # Generate XML migration script
  549. xml_script = create_xml_migration_script(records)
  550.  
  551. # Output the generated XML script
  552. print(xml_script)
  553.  
Success #stdin #stdout 0.04s 11580KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
<?xml version="1.0" ?>
<changeSet id="insert_external_api_definitions" author="user">
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_DPDC_POSTPAID"/>
        <column name="BILLER_SECRETS" value="{
  &quot;common&quot;: {
    &quot;STK-CODE&quot;: &quot;ABDIRECT&quot;,
    &quot;AUTH-KEY&quot;: &quot;EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi&quot;,
    &quot;utility_auth_key&quot;: &quot;16922468323555&quot;,
    &quot;utility_secret_key&quot;: &quot;c5iMNoUatdYlSqEW&quot;,
    &quot;mode&quot;: &quot;1&quot;,
    &quot;pay_channel&quot;: &quot;4&quot;
  }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
        &quot;transaction_id&quot;: &quot;transaction_id&quot;,
        &quot;account_no&quot;: &quot;account_no&quot;,
        &quot;bill_month&quot;: &quot;bill_months&quot;,
        &quot;bill_year&quot;: &quot;bill_years&quot;,
        &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
        &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
    }"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
        &quot;bnk_trx_id&quot;: &quot;bnk_trx_id&quot;,
        &quot;pay_channel&quot;: &quot;pay_channel&quot;,
        &quot;transaction_id&quot;: &quot;transaction_id&quot;,
        &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
        &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
    }"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value="/api/v1/bill-info"/>
        <column name="PAYMENT_STATUS_ENDPOINT" value="/api/v1/bill-status"/>
        <column name="REQUEST_HEADERS_DEFINITION" value="/api/v1/bill-payment"/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_WILLS_LITTLE_FLOWER"/>
        <column name="BILLER_SECRETS" value="{
  &quot;STK-CODE&quot;: &quot;ABDIRECT&quot;,
  &quot;AUTH-KEY&quot;: &quot;EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi&quot;,
  &quot;utility_auth_key&quot;: &quot;16888826005300&quot;,
  &quot;utility_secret_key&quot;: &quot;YlnQ98fCIgEkg2vU&quot;
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;,
    &quot;reference_no&quot;: &quot;reference_no&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value="/api/v1/bill-info"/>
        <column name="PAYMENT_STATUS_ENDPOINT" value="/api/v1/bill-status"/>
        <column name="REQUEST_HEADERS_DEFINITION" value="/api/v1/bill-payment"/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_NESCO_POSTPAID"/>
        <column name="BILLER_SECRETS" value="{
    &quot;STK-CODE&quot;: &quot;ABDIRECT&quot;,
    &quot;AUTH-KEY&quot;: &quot;EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi&quot;,
    &quot;utility_auth_key&quot;: &quot;16976995921527&quot;,
    &quot;utility_secret_key&quot;: &quot;Lt/GrXALyd1pj8AY&quot;,
    &quot;mode&quot;: &quot;1&quot;
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;account_no&quot;: &quot;account_no&quot;,
    &quot;bill_month&quot;: &quot;bill_months&quot;,
    &quot;bill_year&quot;: &quot;bill_years&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;is_stamp_collected&quot;: &quot;is_stamp_collected&quot;,
    &quot;core_transaction_id&quot;: &quot;core_transaction_id&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value="/api/v1/bill-info"/>
        <column name="PAYMENT_STATUS_ENDPOINT" value="/api/v1/bill-status"/>
        <column name="REQUEST_HEADERS_DEFINITION" value="/api/v1/bill-payment"/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_WASA_GENERAL_BILL"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;WA15174603642090&quot;,
        &quot;utility_secret_key&quot;: &quot;GWFYAiy8g5T92UIg&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;bill_type&quot;: &quot;GENERAL-BILL&quot;
    },
    &quot;infoCheck&quot;: {},
    &quot;payBill&quot;: {
        &quot;payment_type&quot;: &quot;3&quot;,
        &quot;channel_id&quot;: &quot;4&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;billno&quot;: &quot;billno&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;account_no&quot;: &quot;account_no&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;mobile_no&quot;: &quot;mobile_no&quot;,
    &quot;branch_code&quot;: &quot;branch_code&quot;,
    &quot;payment_type&quot;: &quot;payment_type&quot;,
    &quot;channel_id&quot;: &quot;channel_id&quot;,
    &quot;remarks&quot;: &quot;remarks&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value="/api/v1/bill-info"/>
        <column name="PAYMENT_STATUS_ENDPOINT" value="/api/v1/bill-status"/>
        <column name="REQUEST_HEADERS_DEFINITION" value="/api/v1/bill-payment"/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_NESCO_PREPAID"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;NE16151186585379&quot;,
        &quot;utility_secret_key&quot;: &quot;PsilgetRO/wYIkPg&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;bill_type&quot;: &quot;PREPAID&quot;
    },
    &quot;infoCheck&quot;: {},
    &quot;payBill&quot;: {}
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;utility_bill_type&quot;: &quot;utility_bill_type&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value="/api/v1/bill-info"/>
        <column name="PAYMENT_STATUS_ENDPOINT" value="/api/v1/bill-status"/>
        <column name="REQUEST_HEADERS_DEFINITION" value="/api/v1/bill-payment"/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_DPDC_NEW_POSTPAID"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;DP16030264222969&quot;,
        &quot;utility_secret_key&quot;: &quot;wQXJaE6c5ydoxG3H&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;
    },
    &quot;infoCheck&quot;: {
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;utility_auth_key&quot;: &quot;DP16030264222969&quot;,
        &quot;utility_secret_key&quot;: &quot;wQXJaE6c5ydoxG3H&quot;
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;account_no&quot;: &quot;account_no&quot;,
    &quot;pay_channel&quot;: &quot;pay_channel&quot;,
    &quot;bill_months&quot;: &quot;bill_months&quot;,
    &quot;bill_years&quot;: &quot;bill_years&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;pay_channel&quot;: &quot;pay_channel&quot;,
    &quot;bnk_trx_id&quot;: &quot;bnk_trx_id&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_DESCO_POSTPAID"/>
        <column name="BILLER_SECRETS" value="{
  &quot;STK-CODE&quot;: &quot;ABDIRECT&quot;,
  &quot;utility_auth_key&quot;: &quot;16643633415347&quot;,
  &quot;utility_secret_key&quot;: &quot;FrFHsRG3jws7kmMV&quot;,
  &quot;AUTH-KEY&quot;: &quot;EWEECFBy4WywpHCXWuYEK.WlGBtbUuyi&quot;
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;billno&quot;: &quot;bllNo&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value="/api/v1/bill-info"/>
        <column name="PAYMENT_STATUS_ENDPOINT" value="/api/v1/bill-status"/>
        <column name="REQUEST_HEADERS_DEFINITION" value="/api/v1/bill-payment"/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_BGDCL_DEMAND_NOTE"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;BG15650660381148&quot;,
        &quot;utility_secret_key&quot;: &quot;mfOxzaTBWl0pM8wC&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;bill_type&quot;: &quot;DEMAND-NOTE&quot;
    },
    &quot;infoCheck&quot;: {},
    &quot;payBill&quot;: {}
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;custCode&quot;: &quot;custCode&quot;,
    &quot;mobileNo&quot;: &quot;mobileNo&quot;,
    &quot;demandNoteCode&quot;: &quot;demandNoteCode&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;custCode&quot;: &quot;custCode&quot;,
    &quot;mobileNo&quot;: &quot;mobileNo&quot;,
    &quot;bankName&quot;: &quot;bankName&quot;,
    &quot;branchName&quot;: &quot;branchName&quot;,
    &quot;totalAmount&quot;: &quot;totalAmount&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="BGDCL_METERED"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;BG15650909253030&quot;,
        &quot;utility_secret_key&quot;: &quot;xdtDeg65HgUjA6SZ&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;
    },
    &quot;infoCheck&quot;: {
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;utility_auth_key&quot;: &quot;BG15650909253030&quot;,
        &quot;utility_secret_key&quot;: &quot;xdtDeg65HgUjA6SZ&quot;
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;code&quot;: &quot;custCode&quot;,
    &quot;mobileNo&quot;: &quot;mobileNo&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;mobileNo&quot;: &quot;mobileNo&quot;,
    &quot;bankName&quot;: &quot;bankName&quot;,
    &quot;branchName&quot;: &quot;branchName&quot;,
    &quot;custCode&quot;: &quot;custCode&quot;,
    &quot;billAmount&quot;: &quot;billAmount&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="BGDCL_NON_METERED"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;BG15650661022290&quot;,
        &quot;utility_secret_key&quot;: &quot;DVBODGYa3fJuKZm5&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;
    },
    &quot;infoCheck&quot;: {
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;utility_auth_key&quot;: &quot;BG15650661022290&quot;,
        &quot;utility_secret_key&quot;: &quot;DVBODGYa3fJuKZm5&quot;
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;code&quot;: &quot;code&quot;,
    &quot;mobileNo&quot;: &quot;mobileNo&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;mobileNo&quot;: &quot;mobileNo&quot;,
    &quot;bankName&quot;: &quot;bankName&quot;,
    &quot;branchName&quot;: &quot;branchName&quot;,
    &quot;custCode&quot;: &quot;custCode&quot;,
    &quot;billAmount&quot;: &quot;billAmount&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_TITAS_DEMAND_NOTE"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;TI15174603537876&quot;,
        &quot;utility_secret_key&quot;: &quot;IV5RwHzGJDBpkhk1&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;
    },
    &quot;infoCheck&quot;: {
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;utility_auth_key&quot;: &quot;TI15174603537876&quot;,
        &quot;utility_secret_key&quot;: &quot;IV5RwHzGJDBpkhk1&quot;
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;invoiceNo&quot;: &quot;invoiceNo&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;paymentId&quot;: &quot;paymentId&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_TITAS_METERED"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;TI15174603077847&quot;,
        &quot;utility_secret_key&quot;: &quot;Nn2nCVRuTpY6xso5&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;
    },
    &quot;infoCheck&quot;: {
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;utility_auth_key&quot;: &quot;TI15174603077847&quot;,
        &quot;utility_secret_key&quot;: &quot;Nn2nCVRuTpY6xso5&quot;
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;invoiceNo&quot;: &quot;invoiceNo&quot;,
    &quot;customerCode&quot;: &quot;customerCode&quot;,
    &quot;sourceTaxAmount&quot;: &quot;sourceTaxAmount&quot;,
    &quot;branchRoutingNo&quot;: &quot;branchRoutingNo&quot;,
    &quot;operator&quot;: &quot;operator&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;chalanNo&quot;: &quot;chalanNo&quot;,
    &quot;chalanDate&quot;: &quot;chalanDate&quot;,
    &quot;chalanBank&quot;: &quot;chalanBank&quot;,
    &quot;chalanBranch&quot;: &quot;chalanBranch&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;paymentId&quot;: &quot;paymentId&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_TITAS_NON_METERED"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;TI15174603401736&quot;,
        &quot;utility_secret_key&quot;: &quot;PCQue5wZiBhflvYk&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;
    },
    &quot;infoCheck&quot;: {
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;utility_auth_key&quot;: &quot;TI15174603401736&quot;,
        &quot;utility_secret_key&quot;: &quot;PCQue5wZiBhflvYk&quot;
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;customer&quot;: &quot;customer&quot;,
    &quot;amount&quot;: &quot;amount&quot;,
    &quot;surcharge&quot;: &quot;surcharge&quot;,
    &quot;particulars&quot;: &quot;particulars&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;paymentId&quot;: &quot;paymentId&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_BREB_POSTPAID"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;BR16713629651374&quot;,
        &quot;utility_secret_key&quot;: &quot;BR16713629651374&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;pay_channel&quot;: &quot;4&quot;
    },
    &quot;infoCheck&quot;: {
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;account_no&quot;: &quot;account_no&quot;,
    &quot;type_of_bill&quot;: &quot;type_of_bill&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;,
    &quot;branchRoutingNo&quot;: &quot;branchRoutingNo&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;utility_bill_type&quot;: &quot;utility_bill_type&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
    <insert tableName="EXTERNAL_API_DEFINITION" schemaName="${current_schema}">
        <column name="BILLER_CODE" value="SSL_BTCL_NEW_REGULAR_BILL"/>
        <column name="BILLER_SECRETS" value="{
    &quot;common&quot;: {
        &quot;STK-CODE&quot;: &quot;DEMO&quot;,
        &quot;utility_auth_key&quot;: &quot;BT16001654136458&quot;,
        &quot;utility_secret_key&quot;: &quot;11eoYOi3nemSPglu&quot;,
        &quot;AUTH-KEY&quot;: &quot;BD6pFSIfSOLEIgKyru67MeBhICkRiFla&quot;,
        &quot;pay_channel&quot;: &quot;4&quot;
    },
    &quot;infoCheck&quot;: {
    },
    &quot;payBill&quot;: {
        &quot;mode&quot;: &quot;1&quot;
    }
}"/>
        <column name="INFO_CHECK_REQUEST_DEFINITION" value="{
    &quot;bill_no&quot;: &quot;bill_no&quot;,
    &quot;phone_number&quot;: &quot;phone_number&quot;,
    &quot;exchange_code&quot;: &quot;exchange_code&quot;,
    &quot;branch_code&quot;: &quot;branch_code&quot;,
    &quot;bill_type&quot;: &quot;bill_type&quot;,
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="PAYMENT_REQUEST_DEFINITION" value="{
    &quot;transaction_id&quot;: &quot;transaction_id&quot;,
    &quot;utility_bill_type&quot;: &quot;utility_bill_type&quot;,
    &quot;utility_auth_key&quot;: &quot;utility_auth_key&quot;,
    &quot;utility_secret_key&quot;: &quot;utility_secret_key&quot;
}"/>
        <column name="IS_ACTIVE" value="${default_boolean_true}"/>
        <column name="INFO_CHECK_ENDPOINT" value="true"/>
        <column name="PROCESS_PAYMENT_ENDPOINT" value=""/>
        <column name="PAYMENT_STATUS_ENDPOINT" value=""/>
        <column name="REQUEST_HEADERS_DEFINITION" value=""/>
    </insert>
</changeSet>
https://ideone.com/PG7YZs
language:
Python 3 (python  3.9.5)
created:
1 day ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!