Test the Extended Incident Management Application with the Business Partner API

Since you already have a SQLite in-memory database that was automatically created in the previous step, let’s now fill it in with some test data.

1. Navigate to the Incident Management application project and create a new folder data in the srv/external folder.

2. In the data folder, create a new file API_BUSINESS_PARTNER-A_BusinessPartner.csv and add the following data to it:

   CSV Copy

   BusinessPartner;FirstName;LastName;BusinessPartnerName;BusinessPartnerIsBlocked;
   1004155;Daniel;Watts;Daniel Watts;false
   1004161;Stormy;Weathers;Stormy Weathers;false
   1004100;Sunny;Sunshine;Sunny Sunshine;true

3. In the data folder, create a new file API_BUSINESS_PARTNER-A_BusinessPartnerAddress.csv and add the following data to it:

   CSV Copy

   BusinessPartner;AddressID;
   1004155;123
   1004161;345
   1004100;456

4. In the data folder, create a new file API_BUSINESS_PARTNER-A_AddressEmailAddress.csv and add the following data to it:

   CSV Copy

   AddressID;EmailAddress;Person;OrdinalNumber
   123;test@demo.com;Williams;123
   345;testjohn@demo.com;Smith;222
   456;testhencry@demo.com;johnson;333

5. In the data folder, create a new file API_BUSINESS_PARTNER-A_AddressPhoneNumber.csv and add the following data to it:

   CSV Copy

   AddressID;PhoneNumber;Person;OrdinalNumber
   123;+44-555-123;Daniel;123
   345;+01-555-688;Stormy;222
   456;+01-555-789;Sunny;333

1. Install dependencies.

   Shell Copy

   npm i

2. Run the mock server locally.

   Shell Copy

   cds mock API_BUSINESS_PARTNER

3. In the terminal, you see the following output:

   CDS Copy

   [cds] - connect using bindings from: { registry: '~/.cds-services.json' }
   [cds] - connect to db > sqlite { url: ':memory:' }
      > init from db/data/sap.capire.incidents-Urgency.csv 
      > init from db/data/sap.capire.incidents-Status.csv 
      > init from db/data/sap.capire.incidents-Incidents.csv 
      > init from db/data/sap.capire.incidents-Customers.csv 
      > init from db/data/sap.capire.incidents-Conversations.csv 
      > init from srv/external/data/API_BUSINESS_PARTNER-A_BusinessPartnerAddress.csv 
      > init from srv/external/data/API_BUSINESS_PARTNER-A_BusinessPartner.csv 
      > init from srv/external/data/API_BUSINESS_PARTNER-A_AddressPhoneNumber.csv 
      > init from srv/external/data/API_BUSINESS_PARTNER-A_AddressEmailAddress.csv