{
    "Id": "ConnectToDatabaseToSearch",
    "LineOfBusinessProcessData": [
        {
            "Key": "object",
            "Type": "Xenhey.BPM.Core.Net8.Processes.ProcessData"
        }
    ],
    "Type": "",
    "DataFlowProcess": [
                {
            "Key": "MessageBuilderProcess",
            "Type": "Xenhey.BPM.Core.Net8.Processes.MessageBuilderProcess",
            "Async": "false",
            "IsEnable": "true",
            "DataFlowProcessParameters": [
                {
                    "Key": "QueryBuilder",
                    "Value": "yes"
                },
                {
                    "Key": "statement",
                    "Value": "EXEC dbo.usp_GetTopCreditApplications @Term = '@{Term}', @MinCreditScore = @{MinCreditScore}, @MaxCreditScore = @{MaxCreditScore}, @HomeOwnership = '@{HomeOwnership}', @Top = @{Top}"
                },
                {
                    "Key": "filters",
                    "Value": "[{\"Key\": \"@{Term}\",\"Value\": \"Term\"},{\"Key\": \"@{MinCreditScore}\",\"Value\": \"MinCreditScore\"},{\"Key\": \"@{MaxCreditScore}\",\"Value\": \"MaxCreditScore\"},{\"Key\": \"@{HomeOwnership}\",\"Value\": \"HomeOwnership\"},{\"Key\": \"@{Top}\",\"Value\": \"Top\"}]"
                }
            ]
        },
        {
            "Key": "SearchDatabaseForResults",
            "Type": "Xenhey.BPM.Core.Net8.Processes.ConnectToDBProcess",
            "Async": "false",
            "IsEnable": "true",
            "DataFlowProcessParameters": [
                {
                    "Key": "ConnectToDatabaseJSONResultSet",
                    "Value": "Yes"
                },
                {
                    "Key": "SearchTerm",
                    "Value": "query"
                },
                {
                    "Key": "connectionstring",
                    "Value": "DatabaseConnection"
                },
                {
                    "Key": "messageformat",
                    "Value": "application/json"
                }
            ]
        }
    ]
}