Project Number Date
Lakeside Mutual - Customer Self-Service - API and Database(test) 676b8b35-c7c3-4fad-8760-e153edbc1169 06 Mar 2022, 20:40

Feature Report

Steps Scenarios Features
Feature Passed Failed Skipped Pending Undefined Total Passed Failed Total Duration Status
CSS-Reject-DB - Workflow 49 0 0 0 0 49 8 0 8 1.088 Passed
Feature CSS-Reject-DB - Workflow
0.000
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given provided all the feature level parameters from file 0.000
ContextId:18 
{
    "firstname": "Max",
    "city": "Rapperswil",
    "postalCode": "8640",
    "STATUS_CODE": "200",
    "quoteId": "466",
    "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjEwMjAsImV4cCI6MTY0NzIyNTYyMX0.20mHq_jgaV9r2BXmHzPzwHmfmabpmi-4XC0-rKowG2EThYWOTA9fwWA_ZUwVucaTDO-j8V9mrL93krNxN3tioA",
    "lastname": "Mustermann",
    "expiryDate": "2023-03-06T20:40:22",
    "password": "xxxxxxxxxxxx",
    "streetAddress": "Oberseestrasse 10",
    "policy_limit_amount": "50000.00",
    "customerId": "rgpp0wkpec",
    "email": "admin@example.com",
    "startDate": "2022-03-06"
}
Tags: @token @okta @store-response @variable @password @secret @workflow @cssapi
0.261
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given as a insurance user perform login api action 0.000
And add content type with given header params 0.000
contentType application/json
And create login information with given input 0.000
password [password]
email [email]
RequestData: 
{
    "password": "1password",
    "email": "admin@example.com"
}
When logging in using post application/json in /auth resource on cssapi 0.231
RequestData: 
{
    "AcceptContentType": "application/json",
    "resource": "http://microservices.virtualandemo.com:8080/auth",
    "context": {
        "firstname": "Max",
        "city": "Rapperswil",
        "postalCode": "8640",
        "STATUS_CODE": "200",
        "quoteId": "466",
        "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjEwMjAsImV4cCI6MTY0NzIyNTYyMX0.20mHq_jgaV9r2BXmHzPzwHmfmabpmi-4XC0-rKowG2EThYWOTA9fwWA_ZUwVucaTDO-j8V9mrL93krNxN3tioA",
        "lastname": "Mustermann",
        "expiryDate": "2023-03-06T20:40:22",
        "password": "xxxxxxxxxxxx",
        "streetAddress": "Oberseestrasse 10",
        "policy_limit_amount": "50000.00",
        "customerId": "rgpp0wkpec",
        "email": "admin@example.com",
        "startDate": "2022-03-06"
    },
    "url": "http://microservices.virtualandemo.com:8080"
}
Then the status code is 200 0.001
Contextual-Dataset: 
{
    "firstname": "Max",
    "city": "Rapperswil",
    "postalCode": "8640",
    "STATUS_CODE": "200",
    "quoteId": "466",
    "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjEwMjAsImV4cCI6MTY0NzIyNTYyMX0.20mHq_jgaV9r2BXmHzPzwHmfmabpmi-4XC0-rKowG2EThYWOTA9fwWA_ZUwVucaTDO-j8V9mrL93krNxN3tioA",
    "lastname": "Mustermann",
    "expiryDate": "2023-03-06T20:40:22",
    "password": "xxxxxxxxxxxx",
    "streetAddress": "Oberseestrasse 10",
    "policy_limit_amount": "50000.00",
    "customerId": "rgpp0wkpec",
    "email": "admin@example.com",
    "startDate": "2022-03-06"
}
And verify user email information includes following in the response 0.014
email [email]
Actual-Response 
{
  "email" : "admin@example.com",
  "token" : "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA"
}
And store token as key and api's token as value 0.011
Tags: @dynamic-date @dynamic-value @cssapi
0.120
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given a user perform a api action 0.000
And add request with given header params 0.000
contentType application/json
X-Auth-Token [token]
When a user get application/json in /user resource on cssapi 0.083
RequestData: 
{
    "AcceptContentType": "application/json",
    "resource": "http://microservices.virtualandemo.com:8080/user",
    "context": {
        "firstname": "Max",
        "city": "Rapperswil",
        "postalCode": "8640",
        "STATUS_CODE": "200",
        "quoteId": "466",
        "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
        "lastname": "Mustermann",
        "expiryDate": "2023-03-06T20:40:22",
        "password": "xxxxxxxxxxxx",
        "streetAddress": "Oberseestrasse 10",
        "policy_limit_amount": "50000.00",
        "customerId": "rgpp0wkpec",
        "email": "admin@example.com",
        "startDate": "2022-03-06"
    },
    "url": "http://microservices.virtualandemo.com:8080"
}
Then the status code is 200 0.000
Contextual-Dataset: 
{
    "firstname": "Max",
    "city": "Rapperswil",
    "postalCode": "8640",
    "STATUS_CODE": "200",
    "quoteId": "466",
    "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
    "lastname": "Mustermann",
    "expiryDate": "2023-03-06T20:40:22",
    "password": "xxxxxxxxxxxx",
    "streetAddress": "Oberseestrasse 10",
    "policy_limit_amount": "50000.00",
    "customerId": "rgpp0wkpec",
    "email": "admin@example.com",
    "startDate": "2022-03-06"
}
And verify across response includes following in the response 0.017
email [email]
Actual-Response 
{
  "email" : "admin@example.com",
  "customerId" : "rgpp0wkpec"
}
And store customerId as key and api's customerId as value 0.012
And evaluate key as expiryDate and SUBSTITUTE(TEXT(NOW()+365, "yyyy-mm-dd HH:mm:ss"), " ", "T") as function value 0.001
And evaluate key as startDate and TEXT(TODAY(),"yyyy-mm-dd") as function value 0.001
Tags: @store_response @workflow @create_response_variable @cssapi
0.196
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given a user perform a api action 0.000
And add request with given header params 0.000
contentType application/json
X-Auth-Token [token]
When a user get application/json in /customers/[customerId] resource on cssapi 0.091
RequestData: 
{
    "AcceptContentType": "application/json",
    "resource": "http://microservices.virtualandemo.com:8080/customers/rgpp0wkpec",
    "context": {
        "firstname": "Max",
        "city": "Rapperswil",
        "postalCode": "8640",
        "STATUS_CODE": "200",
        "quoteId": "466",
        "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
        "lastname": "Mustermann",
        "expiryDate": "2023-03-06T20:40:24",
        "password": "xxxxxxxxxxxx",
        "streetAddress": "Oberseestrasse 10",
        "policy_limit_amount": "50000.00",
        "customerId": "rgpp0wkpec",
        "email": "admin@example.com",
        "startDate": "2022-03-06"
    },
    "url": "http://microservices.virtualandemo.com:8080"
}
Then the status code is 200 0.000
Contextual-Dataset: 
{
    "firstname": "Max",
    "city": "Rapperswil",
    "postalCode": "8640",
    "STATUS_CODE": "200",
    "quoteId": "466",
    "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
    "lastname": "Mustermann",
    "expiryDate": "2023-03-06T20:40:24",
    "password": "xxxxxxxxxxxx",
    "streetAddress": "Oberseestrasse 10",
    "policy_limit_amount": "50000.00",
    "customerId": "rgpp0wkpec",
    "email": "admin@example.com",
    "startDate": "2022-03-06"
}
And verify across response includes following in the response 0.017
firstname Max
Actual-Response 
{
  "customerId" : "rgpp0wkpec",
  "firstname" : "Max",
  "lastname" : "Mustermann",
  "birthday" : "1990-01-01T00:00:00.000+00:00",
  "streetAddress" : "Oberseestrasse 10",
  "postalCode" : "8640",
  "city" : "Rapperswil",
  "email" : "admin@example.com",
  "phoneNumber" : "055 222 4111",
  "moveHistory" : [ ],
  "_links" : {
    "self" : {
      "href" : "http://microservices.virtualandemo.com:8080/customers/rgpp0wkpec"
    },
    "address.change" : {
      "href" : "http://microservices.virtualandemo.com:8080/customers/rgpp0wkpec/address"
    }
  }
}
And store customerId as key and api's customerId as value 0.014
And store firstname as key and api's firstname as value 0.012
And store lastname as key and api's lastname as value 0.013
And store streetAddress as key and api's streetAddress as value 0.011
And store postalCode as key and api's postalCode as value 0.016
And store city as key and api's city as value 0.013
Tags: @pass_dynamic_variables @workflow @cssapi
0.157
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given a user perform a api action 0.000
And add request with given header params 0.000
contentType application/json
X-Auth-Token [token]
And create api with given input 0.000
customerInfo.firstname [firstname]
customerInfo.customerId [customerId]
customerInfo.contactAddress.streetAddress [streetAddress]
customerInfo.contactAddress.city [city]
customerInfo.contactAddress.postalCode [postalCode]
customerInfo.billingAddress.streetAddress [streetAddress]
customerInfo.billingAddress.city [city]
customerInfo.billingAddress.postalCode [postalCode]
customerInfo.lastname [lastname]
insuranceOptions.deductible.amount i~500
insuranceOptions.deductible.currency CHF
insuranceOptions.insuranceType Life Insurance
insuranceOptions.startDate 2021-09-20
RequestData: 
{
    "customerInfo": {
        "firstname": "Max",
        "customerId": "rgpp0wkpec",
        "contactAddress": {
            "streetAddress": "Oberseestrasse 10",
            "city": "Rapperswil",
            "postalCode": "8640"
        },
        "billingAddress": {
            "streetAddress": "Oberseestrasse 10",
            "city": "Rapperswil",
            "postalCode": "8640"
        },
        "lastname": "Mustermann"
    },
    "insuranceOptions": {
        "deductible": {
            "amount": 500,
            "currency": "CHF"
        },
        "insuranceType": "Life Insurance",
        "startDate": "2021-09-20"
    }
}
When a user post application/json in /insurance-quote-requests resource on cssapi 0.135
RequestData: 
{
    "AcceptContentType": "application/json",
    "resource": "http://microservices.virtualandemo.com:8080/insurance-quote-requests",
    "context": {
        "firstname": "Max",
        "city": "Rapperswil",
        "postalCode": "8640",
        "STATUS_CODE": "200",
        "quoteId": "466",
        "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
        "lastname": "Mustermann",
        "expiryDate": "2023-03-06T20:40:24",
        "password": "xxxxxxxxxxxx",
        "streetAddress": "Oberseestrasse 10",
        "policy_limit_amount": "50000.00",
        "customerId": "rgpp0wkpec",
        "email": "admin@example.com",
        "startDate": "2022-03-06"
    },
    "url": "http://microservices.virtualandemo.com:8080"
}
Then the status code is 200 0.001
Contextual-Dataset: 
{
    "firstname": "Max",
    "city": "Rapperswil",
    "postalCode": "8640",
    "STATUS_CODE": "200",
    "quoteId": "466",
    "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
    "lastname": "Mustermann",
    "expiryDate": "2023-03-06T20:40:24",
    "password": "xxxxxxxxxxxx",
    "streetAddress": "Oberseestrasse 10",
    "policy_limit_amount": "50000.00",
    "customerId": "rgpp0wkpec",
    "email": "admin@example.com",
    "startDate": "2022-03-06"
}
And store rejectQuoteId as key and api's id as value 0.018
Tags: @workflow @dynamic_date @quoteapi
0.128
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given a user perform a api action 0.000
And add request with given header params 0.000
contentType application/json
X-Auth-Token [token]
And update api with given input 0.000
insurancePremium.amount i~500
insurancePremium.currency CHF
policyLimit.amount i~50000
policyLimit.currency CHF
status QUOTE_RECEIVED
expirationDate [expiryDate].000Z
RequestData: 
{
  "insurancePremium": {
    "amount": 500,
    "currency": "CHF"
  },
  "policyLimit": {
    "amount": 50000,
    "currency": "CHF"
  },
  "status": "QUOTE_RECEIVED",
  "expirationDate": "2023-03-06T20:40:24.000Z"
}
When a user patch application/json in /insurance-quote-requests/[rejectQuoteId] resource on quoteapi 0.111
RequestData: 
{
    "AcceptContentType": "application/json",
    "resource": "http://microservices.virtualandemo.com:8090/insurance-quote-requests/475",
    "context": {
        "firstname": "Max",
        "city": "Rapperswil",
        "postalCode": "8640",
        "STATUS_CODE": "200",
        "quoteId": "466",
        "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
        "lastname": "Mustermann",
        "expiryDate": "2023-03-06T20:40:24",
        "password": "xxxxxxxxxxxx",
        "rejectQuoteId": "475",
        "streetAddress": "Oberseestrasse 10",
        "policy_limit_amount": "50000.00",
        "customerId": "rgpp0wkpec",
        "email": "admin@example.com",
        "startDate": "2022-03-06"
    },
    "url": "http://microservices.virtualandemo.com:8090"
}
Then the status code is 200 0.001
Contextual-Dataset: 
{
    "firstname": "Max",
    "city": "Rapperswil",
    "postalCode": "8640",
    "STATUS_CODE": "200",
    "quoteId": "466",
    "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
    "lastname": "Mustermann",
    "expiryDate": "2023-03-06T20:40:24",
    "password": "xxxxxxxxxxxx",
    "rejectQuoteId": "475",
    "streetAddress": "Oberseestrasse 10",
    "policy_limit_amount": "50000.00",
    "customerId": "rgpp0wkpec",
    "email": "admin@example.com",
    "startDate": "2022-03-06"
}
And verify across response includes following in the response 0.012
id [rejectQuoteId]
Actual-Response 
{
  "id" : 475,
  "date" : "2022-03-07T02:40:24.606+00:00",
  "statusHistory" : [ {
    "date" : "2022-03-07T02:40:24.606+00:00",
    "status" : "REQUEST_SUBMITTED"
  }, {
    "date" : "2022-03-07T02:40:24.767+00:00",
    "status" : "QUOTE_RECEIVED"
  } ],
  "customerInfo" : {
    "customerId" : "rgpp0wkpec",
    "firstname" : "Max",
    "lastname" : "Mustermann",
    "contactAddress" : {
      "streetAddress" : "Oberseestrasse 10",
      "postalCode" : "8640",
      "city" : "Rapperswil"
    },
    "billingAddress" : {
      "streetAddress" : "Oberseestrasse 10",
      "postalCode" : "8640",
      "city" : "Rapperswil"
    }
  },
  "insuranceOptions" : {
    "startDate" : "2021-09-20T00:00:00.000+00:00",
    "insuranceType" : "Life Insurance",
    "deductible" : {
      "amount" : 500.00,
      "currency" : "CHF"
    }
  },
  "insuranceQuote" : {
    "expirationDate" : "2023-03-06T20:40:24.000+00:00",
    "insurancePremium" : {
      "amount" : 500,
      "currency" : "CHF"
    },
    "policyLimit" : {
      "amount" : 50000,
      "currency" : "CHF"
    }
  }
}
Tags: @json_Array @json_path @cssapi
0.171
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given a user perform a api action 0.000
And add request with given header params 0.000
contentType application/json
X-Auth-Token [token]
And update api with given input 0.000
status QUOTE_REJECTED
RequestData: 
{"status": "QUOTE_REJECTED"}
When a user patch application/json in /insurance-quote-requests/[rejectQuoteId] resource on cssapi 0.124
RequestData: 
{
    "AcceptContentType": "application/json",
    "resource": "http://microservices.virtualandemo.com:8080/insurance-quote-requests/475",
    "context": {
        "firstname": "Max",
        "city": "Rapperswil",
        "postalCode": "8640",
        "STATUS_CODE": "200",
        "quoteId": "466",
        "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
        "lastname": "Mustermann",
        "expiryDate": "2023-03-06T20:40:24",
        "password": "xxxxxxxxxxxx",
        "rejectQuoteId": "475",
        "streetAddress": "Oberseestrasse 10",
        "policy_limit_amount": "50000.00",
        "customerId": "rgpp0wkpec",
        "email": "admin@example.com",
        "startDate": "2022-03-06"
    },
    "url": "http://microservices.virtualandemo.com:8080"
}
Then the status code is 200 0.000
Contextual-Dataset: 
{
    "firstname": "Max",
    "city": "Rapperswil",
    "postalCode": "8640",
    "STATUS_CODE": "200",
    "quoteId": "466",
    "token": "eyJhbGciOiJIUzUxMiJ9.eyJzdWIiOiJhZG1pbkBleGFtcGxlLmNvbSIsImNyZWF0ZWQiOjE2NDY2MjA4MjQxNjIsImV4cCI6MTY0NzIyNTYyNH0.Z-_c7spJ7roXf_YA46KPnnTZZELicU58uFJHgj7IadWZT-xWRle0S5nHvRfDZahxOvWxgqPJwypOwP6_1quNJA",
    "lastname": "Mustermann",
    "expiryDate": "2023-03-06T20:40:24",
    "password": "xxxxxxxxxxxx",
    "rejectQuoteId": "475",
    "streetAddress": "Oberseestrasse 10",
    "policy_limit_amount": "50000.00",
    "customerId": "rgpp0wkpec",
    "email": "admin@example.com",
    "startDate": "2022-03-06"
}
And verify statusHistory response csvson includes in the response 0.031
status
REQUEST_SUBMITTED
QUOTE_RECEIVED
QUOTE_REJECTED
Expected json 
[{"status":"REQUEST_SUBMITTED"},{"status":"QUOTE_RECEIVED"},{"status":"QUOTE_REJECTED"}]
Actual json 
{"date":"2022-03-07T02:40:24.606+00:00","statusHistory":[{"date":"2022-03-07T02:40:24.606+00:00","status":"REQUEST_SUBMITTED"},{"date":"2022-03-07T02:40:24.767+00:00","status":"QUOTE_RECEIVED"},{"date":"2022-03-07T02:40:24.910+00:00","status":"QUOTE_REJECTED"}],"customerInfo":{"firstname":"Max","customerId":"rgpp0wkpec","contactAddress":{"streetAddress":"Oberseestrasse 10","city":"Rapperswil","postalCode":"8640"},"billingAddress":{"streetAddress":"Oberseestrasse 10","city":"Rapperswil","postalCode":"8640"},"lastname":"Mustermann"},"insuranceOptions":{"deductible":{"amount":500,"currency":"CHF"},"insuranceType":"Life Insurance","startDate":"2021-09-20"},"id":475,"insuranceQuote":{"insurancePremium":{"amount":500,"currency":"CHF"},"policyLimit":{"amount":50000,"currency":"CHF"},"expirationDate":"2023-03-06T20:40:24.000+00:00"}}
And verify across response includes following in the response 0.012
id [rejectQuoteId]
Actual-Response 
{
  "id" : 475,
  "date" : "2022-03-07T02:40:24.606+00:00",
  "statusHistory" : [ {
    "date" : "2022-03-07T02:40:24.606+00:00",
    "status" : "REQUEST_SUBMITTED"
  }, {
    "date" : "2022-03-07T02:40:24.767+00:00",
    "status" : "QUOTE_RECEIVED"
  }, {
    "date" : "2022-03-07T02:40:24.910+00:00",
    "status" : "QUOTE_REJECTED"
  } ],
  "customerInfo" : {
    "customerId" : "rgpp0wkpec",
    "firstname" : "Max",
    "lastname" : "Mustermann",
    "contactAddress" : {
      "streetAddress" : "Oberseestrasse 10",
      "postalCode" : "8640",
      "city" : "Rapperswil"
    },
    "billingAddress" : {
      "streetAddress" : "Oberseestrasse 10",
      "postalCode" : "8640",
      "city" : "Rapperswil"
    }
  },
  "insuranceOptions" : {
    "startDate" : "2021-09-20",
    "insuranceType" : "Life Insurance",
    "deductible" : {
      "amount" : 500.00,
      "currency" : "CHF"
    }
  },
  "insuranceQuote" : {
    "expirationDate" : "2023-03-06T20:40:24.000+00:00",
    "insurancePremium" : {
      "amount" : 500.00,
      "currency" : "CHF"
    },
    "policyLimit" : {
      "amount" : 50000.00,
      "currency" : "CHF"
    }
  }
}
Tags: @sql_select @sql_validate @store_sql_response @cssdb
0.050
Before io.virtualan.cucumblan.core.BaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.DBBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Before io.virtualan.cucumblan.core.MsgBaseStepDefinition.before(io.cucumber.java.Scenario) 0.000
Given as a user perform sql query action 0.000
When read details on the given query on cssdb 0.050
select iqr.id, iq.insurance_premium_amount, iq.insurance_premium_currency, iq.policy_limit_amount from insurancequotes iq INNER JOIN insurancequoterequests iqr on iq.id = iqr.insurance_quote_id and iqr.id = [rejectQuoteId]
SelectSql: 
{
    "resource": "cssdb",
    "sql": "select iqr.id, iq.insurance_premium_amount, iq.insurance_premium_currency, iq.policy_limit_amount from insurancequotes iq INNER JOIN insurancequoterequests iqr on iq.id = iqr.insurance_quote_id and iqr.id  =  475"
}
SqlResponse: 
[{"id":475,"insurance_premium_amount":500.00,"insurance_premium_currency":"CHF","policy_limit_amount":50000.00}]
And store policy_limit_amount as key and query's [0].policy_limit_amount as value 0.000