Build OData Batch Requests for Writing Data with SAP Cloud SDK's Virtual Data Model

Create a file with the name batch-changeset-route.ts in the root folder and then copy the code below to the file:

import { Request, Response } from 'express';
import {
  batch,
  BusinessPartnerAddress,
  changeset
} from "@sap/cloud-sdk-vdm-business-partner-service";
import { BatchResponse, WriteResponses } from "@sap/cloud-sdk-core";

export function batchChangesetRoute(req: Request, res: Response) {
  const addresses = req.body.addresses as any[];
  batch(
      changeset(
        ...addresses.map(address =>
          BusinessPartnerAddress.requestBuilder().create(
            BusinessPartnerAddress.builder().fromJson(address)
          )
        )
      )
    )
    .execute({
      url: 'https://my.s4hana.ondemand.com/'
    })
    .then(batchResult => {
      const success = 'success';
      res.status(200).send(success);
    })
    .catch(error => {
      res.status(500).send(error.message);
    });
}

Replace the url with your system info.

Open the application.ts, add the router definition and the missing import.

...
import { batchChangeSetRoute } from "./batch-changeset-route";
...
private routes(): void {
  const router = express.Router();
...
  // please add this line starts
  router.post("/batch-changeset/create", batchChangesetRoute);
  // please add this line ends
  this.app.use("/", router);
}

Create a file with the name batch-changeset-route.js in the root folder and then copy the code below to the file:

const { batch, BusinessPartnerAddress, changeset } = require('@sap/cloud-sdk-vdm-business-partner-service');

export function batchChangesetRoute(req, res) {
  const addresses = req.body.addresses;
  batch(
      changeset(
        ...addresses.map(address =>
          BusinessPartnerAddress.requestBuilder().create(BusinessPartnerAddress.builder().fromJson(address))
        )
      )
    )
    .execute({
      url: 'https://my.s4hana.ondemand.com/'
    })
    .then(batchResult => {
      const success = 'success';
      res.status(200).send(success);
    })
    .catch(error => {
      res.status(500).send(error.message);
    });
}

Replace the url with your system info.

Open the application.js, add the router definition and the missing import.

...
const { batchChangeSetRoute } require ('./batch-changeset-route');
...
private routes() {
  const router = express.Router();
...
  // please add this line starts
  router.post("/batch-changeset/create", batchChangesetRoute);
  // please add this line ends
  this.app.use("/", router);
}

Now I’ll show you how to build type-safe BusinessPartnerAddress entities by using the SDK.

Copy the function below to your batch-changeset-route.ts file.

function convertBatchResponse(batchResponse: BatchResponse): BusinessPartnerAddress[]{
  return (batchResponse as WriteResponses).responses.map(r=> r.as!(r.type!) as BusinessPartnerAddress);
}

First of all, based on the changeset in the batch requests you sent, you know the batch responses are WriteResponses instead of ReadResponse. Secondly, by calling as(Constructable<Entity>), the responses are cast to Entity. Then, the Entity is eventually cast to BusinessPartnerAddress by using as keyword. This is essential, because during compile time, the type of the entity is not clear. Only you as the caller can provide the entity type based on the order of the changesets.

Now you can comment out the old code and replace it by using the one below in the batch-changeset-route.ts file:

...
        .then(batchResult =>{
          // const success = 'success';
          // res.status(200).send(success);
          const entities = batchResult.map(convertBatchResponse);
          res.status(200).send(entities);
        })
...

Now I’ll show you how to build BusinessPartnerAddress entities by using the SDK.

Copy the function below to your batch-changeset-route.js file.

function convertBatchResponse(batchResponse) {
  return batchResponse.responses;
}

Now you can comment out the old code and replace it by using the one below in the batch-changeset-route.js file:

...
        .then(batchResult =>{
          // const success = 'success';
          // res.status(200).send(success);
          const entities = batchResult.map(convertBatchResponse);
          res.status(200).send(entities);
        })
...