import { Destination } from '@sap-cloud-sdk/connectivity';
import { GetAllRequestBuilder } from '@sap-cloud-sdk/odata-v2';
import { BusinessPartner, businessPartnerService } from '@sap/cloud-sdk-vdm-business-partner-service';

const { businessPartnerApi, businessPartnerAddressApi } = businessPartnerService();

// Create destination
let dest: Destination = {
    url: 'https://my000000.s4hana.ondemand.com',
    username: 'ADDRESS_MANAGER_###',
    password: 'WelcomeToTheClouds1!'
};

// Create request
let req: GetAllRequestBuilder<BusinessPartner> =
businessPartnerApi.requestBuilder()
    .getAll()
    .select(
        businessPartnerApi.schema.BUSINESS_PARTNER,
        businessPartnerApi.schema.FIRST_NAME,
        businessPartnerApi.schema.LAST_NAME,
        businessPartnerApi.schema.TO_BUSINESS_PARTNER_ADDRESS
            .select(
                businessPartnerAddressApi.schema.ADDRESS_ID,
                businessPartnerAddressApi.schema.COUNTRY,
                businessPartnerAddressApi.schema.CITY_NAME
            )
    )
    .filter(
        businessPartnerApi.schema.LAST_NAME.equals("Smith")
    );

    // execute request
    req.execute(dest)
        .then(
            // success
            (result: BusinessPartner[]) => {
                console.log(JSON.stringify(result, null, '\t'));
            },
            // error
            (error: any) => {
                console.log("Error: " + error.message);
            }
        );