{
    "config": {
        "application": {
            "GoogleDataEnricherPlugin": {
                "description": "Uses the keys in rabbitMQ messages and expands them using queries defines by dataQueries",
                "version": "1.0",
                "configuration": {
                    "dataQueries": {
                        "retrieveCallConversion": {
                            "type": "fetchSingleRow",
                            "description": "Retrieves 1 full conversion row based on a particular conversion_id key supplied.",
                            "configuration": {
                                "dataSources": "callTracker",
                                "query": "SELECT * FROM conversion WHERE conversion_id = @conversionIdr vagrafhfhf",
                                "parameters": {
                                    "conversionId": "aa"
                                }
                            }
                        },
                        "someOtherQuery": {
                            "type": "fetchScalar",
                            "description": "EXAMPLE ONLY - retrieves a scalar result being a single row and single column - in this case returning the call_type value from call tracker calls table",
                            "configuration": {
                                "dataSources": "callTracker",
                                "query": "SELECT call_type FROM calls WHERE call_ref_no = @callRefNo",
                                "parameters": {
                                    "callRefNo": "OED.data.callRefNo"
                                }
                            }
                        },
                        "updateConversionWorkflow": {
                            "type": "updateSingleRow",
                            "description": "Updates conversion workflow with status based on successful or failed execution result.",
                            "configuration": {
                                "dataSources": "webTracker",
                                "query": "UPDATE conversion_workflow SET status = @status WHERE conversion_id = @conversionId AND process = 'GAU'",
                                "parameters": {
                                    "conversionId": "OED.data.conversionId",
                                    "status": "OED.data.google_universal_post_status"
                                }
                            }
                        }
                    },
                    "dataSources": {
                        "webTracker": {
                            "alias": "wt",
                            "type": "database",
                            "id": "online",
                            "configuration": {
                                "connectionString": "postgresql:host=webtracker.int.db.phone-analytics.net;port=5432;dbname=dynamic_numbers_tracking_system;user=dynamic_numbers_tracking_system;password=d4pj1ifjgi;driver=org.postgresql.Driver"
                            }
                        },
                        "callTracker": {
                            "alias": "ct",
                            "type": "database",
                            "id": "datawarehouse",
                            "configuration": {
                                "connectionString": "mysql:host=calltracker.int.db.phone-analytics.net;port=3306;dbname=jct;user=geo_ss;password=hagia;driver=com.mysql.jdbc.Driver"
                            }
                        },
                        "crmWS": {
                            "alias": "wtrest",
                            "type": "REST",
                            "id": "online",
                            "configuration": {
                                "serviceUrl": "crm.phone-analytics.com"
                            }
                        },
                        "webTrackerWS": {
                            "alias": "wtrest",
                            "type": "REST",
                            "id": "online",
                            "configuration": {
                                "serviceUrl": "webtracker.phone-analytics.com"
                            }
                        },
                        "callTrackerWS": {
                            "alias": "ctrest",
                            "type": "REST",
                            "id": "datawarehouse",
                            "configuration": {
                                "serviceUrl": "calltracker.phone-analytics.com"
                            }
                        }
                    }
                }
            }
        },
        "sites": {
            "JI0001": {
                "syncEnabled": false,
                "behaviorAttributes": {
                    "cookieRetryInterval": "40",
                    "numberReplacementStyle": "Immediate",
                    "errorCapture": false,
                    "logLevel": "None",
                    "traceEnabled": true
                },
                "features": {
                    "MultiSiteSession": {
                        "status": "enabled"
                    }
                },
                "timezone": "Australia/Perth",
                "webAnalytics": {
                    "GoogleAnalytics": {
                        "trackingCode": "UA-16875404-1"
                    },
                    "GlobalCRMAnalytics": {
                        "jobs": [
                            {
                                "jobHandler": "crmWriters",
                                "lastConversionId": 0,
                                "jobNextRun": "20150115T100000.00Z 10:00",
                                "emailAlertTo": "",
                                "jobData": {
                                    "template": "GlobalCRMRevenue",
                                    "filename": "jet-feed-int-test-wt96-crm_{trackingCode}_{YYYYMMDDTZ}.txt",
                                    "ftpSLL": false,
                                    "credentials": {
                                        "password": "eric",
                                        "login": "eric"
                                    },
                                    "numbersExcluded": [
                                        "1300864958"
                                    ],
                                    "uploadFolder": "/files/crmAnalytics",
                                    "ftpServer": "localhost",
                                    "currency": "AUD",
                                    "ftpPort": 21,
                                    "numbersIncluded": []
                                },
                                "lastRun": "20150114T110116.44Z 11:00",
                                "timezone": "Australia/Sydney",
                                "emailReportTo": "matthew.bush@jetinteractive.com.au",
                                "executionStyle": "scheduled",
                                "frequency": {
                                    "days": 1
                                },
                                "jobExtractor": "callDataCRMExtractor",
                                "system": "gendai",
                                "delimiter": ",",
                                "jobStart": "20131020T100000.00Z 10:00",
                                "jobExecutionStartTime": "",
                                "name": "CRM Call Conversion Revenue FTP export",
                                "columnHeadings": true
                            }
                        ],
                        "enabled": true
                    },
                    "GoogleUniversalAnalytics": {
                        "jobs": [
                            {
                                "system": "godi",
                                "emailAlertTo": "agus.zulfani@jetinteractive.com.au",
                                "workflow": "TestWorkFlow",
                                "emailReportTo": "agus.zulfani@jetinteractive.com.au",
                                "executionStyle": "continuous"
                            }
                        ],
                        "trackingCode": "UA-16875404-1",
                        "enabled": true
                    }
                },
                "accountNumber": "WT1384"
            }
        }
    }
}