Created
May 14, 2018 13:29
-
-
Save vikramIde/24dfc9fb2adb448fb6c4cd13a1e61ccb to your computer and use it in GitHub Desktop.
ygp-mapper
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [{ | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "EA" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "10", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "EM" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "11", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "WN" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "13", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "WS" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "21", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "NE" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "23", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "NO" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "15", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "NT" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "12", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "NW" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "16", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "LSC" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "17", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "SE" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "19", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "SO" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "20", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "SW" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "22", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| }, | |
| { | |
| "template": { | |
| "skipRows": 1, | |
| "where": [{ | |
| "column": "LDZ", | |
| "operator": "=", | |
| "query": "WM" | |
| }, { | |
| "column": "Type", | |
| "operator": "=", | |
| "query": "LSC" | |
| }], | |
| "repeatNode": ["band", "rates"] | |
| }, | |
| "criteria": { | |
| "supplierId": 1, | |
| "productType": "gas", | |
| "distributor": "14", | |
| "validStart": "20170404", | |
| "validEnd": "20180404", | |
| "acceptStart": "20170405", | |
| "acceptEnd": "20180504" | |
| }, | |
| "price": { | |
| "saleType": "A", | |
| "cot": "y", | |
| "smartMeter": "y", | |
| "standingCharge": "y", | |
| "minAq": { | |
| "column": "Min Consumption" | |
| }, | |
| "maxAq": { | |
| "column": "Max Consumption" | |
| }, | |
| "duration": { | |
| "column": "Term", | |
| "calculation": true, | |
| "operator": "*", | |
| "value": "12" | |
| }, | |
| "paymentMethod": "Direct Debit", | |
| "band": { | |
| "rates": [{ | |
| "rate": { | |
| "column": "SC £/day" | |
| }, | |
| "description": "Standing Charge", | |
| "units": "£/day" | |
| }, | |
| { | |
| "rate": { | |
| "column": "Unit Rate" | |
| }, | |
| "description": "Unit Rate", | |
| "units": "p/kWh" | |
| } | |
| ] | |
| } | |
| } | |
| } | |
| ] |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment