Use the OData v2 Type-safe Client API
This guide explains how to use features of the OData v2 protocol supported by the SAP Cloud SDK. To demonstrate the features we will use the Business Partner Service from the SAP S/4HANA ERP suit.
For more details on how to execute requests using a OData type-safe client by the SAP Cloud SDK, refer to this guide.
Entities
In OData, entity collections are the resource against which you execute requests and CRUD operations. The SAP Cloud SDK operates on entity classes, that represent those resources.
An OData JSON representation of a single business partner could be something like this:
{
"FirstName": "Peter",
"LastName": "Pan",
"to_BusinessPartnerAddress": [
{
"Country": "Neverland"
}
]
}
When using the SAP Cloud SDK this entity would be represented as an instance of the BusinessPartner
entity class from the according business partner service.
The properties of entity class instances are held in camel case as is common in JavaScript:
BusinessPartner {
firstName: 'Peter',
lastName: 'Pan',
toBusinessPartnerAddress: [ BusinessPartnerAddress { country: 'Neverland' } ]
}
OData responses, that contain entities are automatically deserialized to the respective entity class when using the SAP Cloud SDK. To execute create or update requests you have to build an instance of an entity class, that represents the data to be created or updated. There are three ways to build entities on your own as described below.
Custom Fields
In the real world, OData service implementations can differ from their original service specifications. This can happen due to incorrect specifications or customizations of the service. The SAP Cloud SDK supports custom fields on your entities, that are not covered by the specification the according service is based on.
You can set custom fields on an entity through the .setCustomFields
and .setCustomField
methods.
Setting custom fields with existing keys overrides the existing fields.
Non-existent fields are added without removing other fields.
// add custom fields to the existing fields
businessPartner.setCustomFields({
myCustomField: 'this is custom'
});
// add specific custom field
businessPartner.setCustomField('myCustomField', 'this is custom');
You can also access existing fields using the .getCustomField
and .getCustomFields
methods.
// get all custom fields
const customFields = businessPartner.getCustomFields(); // { myCustomField: 'this is custom' }
// get specific custom field
const customFields: = businessPartner.getCustomField(); // 'this is custom'
As custom fields are not defined through the service specification, the type of their values is unknown. Therefore, custom fields are never automatically serialized or deserialized. If you are using custom fields, you might have to take care of serialization on your own.
Build an Entity From Scratch
To build an entity by assigning its properties, you can use the entity builders provided by every entity class.
Use the static .builder
method to access the builder, set the properties and finally use the .build
method to yield the entity.
To set navigation properties, that link to other entities, you have to create the linked entities using their respective builder.
Navigation properties, that are linked through a one-to-many relation have to be assigned in an array - one-to-one relations are assigned as single objects.
The example below shows how you can create the data from above using the entity builder.
The relation to the business partner address is a one-to-many relation here.
import {
BusinessPartner,
BusinessPartnerAddress
} from '@sap/cloud-sdk-vdm-business-partner-service';
const businessPartner = BusinessPartner.builder()
.firstName('Peter')
.lastName('Pan')
.toBusinessPartnerAddress([
BusinessPartnerAddress.builder().country('Neverland').build()
])
.build();
You can also add fields, that are unknown according to the specification, if you add them as custom fields.
To achieve this, pass an object the .withCustomFields
method, where the keys denote the names of the custom fields, and the values their respective values.
import { BusinessPartner } from '@sap/cloud-sdk-vdm-business-partner-service';
const businessPartner = BusinessPartner.builder()
.firstName('Peter')
.withCustomFields({
myCustomField: 'this is custom'
})
.build();
Build an Entity From a JSON Representation
Sometimes, it makes sense for you to store your data as a JSON object, that is based on the entity type. For example, when using the property names of the entity class as properties of your object. If you are looking for a way to create an entity from a JSON response, that you got from an OData service, you are probably looking for entity deserialization.
This would be the JSON representation of a business partner in the SAP Cloud SDK:
{
"firstName": "Peter",
"lastName": "Pan",
"toBusinessPartnerAddress": [
{
"country": "Neverland"
}
]
}
You can use this data to build an entity using the .fromJson
method.
The example below shows how you would create an instance of the business partner class using the .fromJson
method.
import { BusinessPartner } from '@sap/cloud-sdk-vdm-business-partner-service';
const businessPartner = BusinessPartner.builder().fromJson({
firstName: 'Peter',
lastName: 'Pan',
toBusinessPartnerAddress: [
{
country: 'Neverland'
}
]
});
If there are unknown fields present in the JSON object, they will be treated as custom fields.
Deserialize an OData JSON Response to an Entity
In some cases you might retrieve raw data from an OData response.
If you need to transform it to an SAP Cloud SDK representation of an entity, you can deserialize it using the deserializeEntity
function.
Fields unknown according to the specification are added as custom fields, without deserializing the according value.
Note that this function is not part of a specific service and has to be imported from the SAP Cloud SDK core package.
import { deserializeEntity } from '@sap-cloud-sdk/core';
const businessPartner = deserializeEntity(
{
FirstName: 'Peter',
LastName: 'Pan',
to_BusinessPartnerAddress: [
{
Country: 'Neverland'
}
]
},
BusinessPartner
);
GetAll
Request Builder
The GetAll
request builder allows you to create a request to retrieve all entities that match the request configuration.
BusinessPartner.requestBuilder().getAll();
The example above creates a request to get all BusinessPartner
entities.
Select
When reading entities, the API offers select( ... )
on the builders.
Through it, the query parameters $select
and $expand
are set.
It restricts the response to the given selection of properties in the request.
The properties that can be selected or expanded are represented via static fields on the entity class.
So there will be a field for each property.
E.g. the business partner entity has BusinessPartner.FIRST_NAME
as a representation of a property and BusinessPartner.TO_BUSINESS_PARTNER_ADDRESS
as a representation of a navigation property.
A navigation property means that there is a relation between a business partner and their addresses.
In this case, one business partner can have multiple addresses.
In SAP S/4HANA, navigation properties typically start with TO_
.
BusinessPartner.requestBuilder()
.getAll()
.select(
BusinessPartner.FIRST_NAME,
BusinessPartner.LAST_NAME,
BusinessPartner.TO_BUSINESS_PARTNER_ADDRESS
)
.execute(destination);
The above translates to the following query parameters:
$select=FirstName,LastName,to_BusinessPartnerAddress/*&$expand=to_BusinessPartnerAddress
One can also select properties of the expanded navigation property:
BusinessPartner.requestBuilder()
.getAll()
.select(
BusinessPartner.FIRST_NAME,
BusinessPartner.TO_BUSINESS_PARTNER_ADDRESS.select(
BusinessPartnerAddress.ADDRESS_ID,
BusinessPartnerAddress.CITY_CODE
)
)
.execute(destination);
The above translates to the following query parameters:
$select=FirstName,to_BusinessPartnerAddress/AddressID,to_BusinessPartnerAddress/CityCode&$expand=to_BusinessPartnerAddress
Filter
When operating on a collection of entities, the API offers filter( ... )
on the builders.
It directly corresponds to the $filter
parameter of the request.
/*
Get all business partners that either:
- Have first name 'Alice' but not last name 'Bob'
- Or have first name 'Mallory'
*/
BusinessPartner.requestBuilder()
.getAll()
.filter(
or(
and(
BusinessPartner.FIRST_NAME.equals('Alice'),
BusinessPartner.LAST_NAME.notEquals('Bob')
),
BusinessPartner.FIRST_NAME.equals('Mallory')
)
)
.execute(destination);
The example above will translate to this filter parameter:
$filter=(((FirstName eq 'Alice') and (LastName ne 'Bob')) or (FirstName eq 'Mallory'))
Take note of the order of and
and or
.
As or
is invoked on the result of and
it will form the outer expression while and
is an inner expression in the first branch of or
.
In addition, the negation operator not
can also be used for wrapping any filter expressions.
/*
Get all business partners that do not match any of the cases:
- Have first name 'Alice'
- Have last name 'Bob'
*/
.filter(
not(
or(
BusinessPartner.FIRST_NAME.equals('Alice'),
BusinessPartner.LAST_NAME.equals('Bob')
)
)
)
The $filter
parameter will then be generated like below:
$filter=not (FirstName eq 'Alice') or (LastName eq 'Bob'))
It is also possible to pass multiple filters to the same filter function without concatenating them with and
or or
.
They will be concatenated with and
by default.
The two following examples are equal:
.filter(
and(
BusinessPartner.FIRST_NAME.equals('Alice'),
BusinessPartner.LAST_NAME.notEquals('Bob')
)
)
The example above can be shortened to:
.filter(
BusinessPartner.FIRST_NAME.equals('Alice'),
BusinessPartner.LAST_NAME.notEquals('Bob')
)
Filter on One-to-One Navigation Properties
In addition to basic properties, filters can also be applied to one-to-one navigation properties.
The example below shows how to filter on the TO_CUSTOMER
, which is a one-to-one navigation property of the BusinessPartner entity.
Please note, that the CUSTOMER_NAME
and CUSTOMER_ACCOUNT_GROUP
are properties of the entity Customer
, which is the type of the one-to-one navigation property TO_CUSTOMER
.
/*
Get all business partners that match all the following conditions:
- Have customer with the customer name 'John'
- Have customer with the customer account group '0001'
*/
.filter(
BusinessPartner.TO_CUSTOMER.filter(
Customer.CUSTOMER_NAME.equals('John'),
Customer.CUSTOMER_ACCOUNT_GROUP.equals('0001')
)
)
The generated $filter
will be:
$filter=((to_Customer/CustomerName eq 'John' and to_Customer/CustomerAccountGroup eq '0001'))
More Filter Expressions
More advanced filter expressions can be found here.
Skip
skip
allows you to skip a number of results in the requested set.
It can be useful for paging:
BusinessPartner.requestBuilder().
.getAll()
.skip(10)
Top
top
limits the number of returned results.
This can also be useful for paging:
BusinessPartner.requestBuilder().getAll().top(10);
The example above retrieves the first ten BusinessPartner
entities.
Count
The method count()
allows you to get the number of elements in a collection.
It is only available for getAll()
requests and is added before the request execution:
BusinessPartner.requestBuilder().getAll().count();
The return type of count requests is a Promise<number>
.
You can combine the count()
with filter conditions.
To get the number of business partners with first name John
execute the following request:
BusinessPartner.requestBuilder()
.filter(BusinessPartner.FIRST_NAME.equals('John'))
.count()
.getAll();
As defined in the OData spec count
is not affected by top
, skip
, and orderBy
.
top()
and skip()
are ignored for countIf you include these methods in a count request they will be ignored by the SAP Cloud SDK. These three requests will all return the same value.
BusinessPartner.requestBuilder().getAll().top(5).count();
BusinessPartner.requestBuilder().getAll().skip(5).count();
BusinessPartner.requestBuilder().getAll().count();
GetByKey
Request Builder
The GetByKey
request builder allows you to create a request to retrieve one entity based on its key:
BusinessPartner.requestBuilder().getByKey('id');
The example above retrieves the BusinessPartner
with the ID 'id'
.
The result can be restricted by applying the select function, same as in the GetAll request.
Create Request Builder
The Create request builder allows you to send a POST
request to create a new entity:
const businessPartner = BusinessPartner.builder().build();
BusinessPartner.requestBuilder().create(businessPartner);
In the example above we created an instance of BusinessPartner
and sent it to the BusinessPartner
service in a POST
request.
Deep Create
It is also possible to create an entity together with related entities in a single request:
// build a business partner instance with one linked address
const businessPartner = BusinessPartner.builder()
.firstName('John')
.lastName('Doe')
.businessPartnerCategory('1')
.toBusinessPartnerAddress([
BusinessPartnerAddress.builder()
.country('DE')
.postalCode('14469')
.cityName('Potsdam')
.streetName('Konrad-Zuse-Ring')
.houseNumber('10')
.build()
])
.build();
// execute the create request
BusinessPartner.requestBuilder().create(businessPartner).execute(myDestination);
When you try the example code above for testing the deep create
feature, you might see some errors like "operation module BUA_CHECK_ADDRESS_VALIDITY_ALL; a check table is missing"
.
Typically, it can happen if you are using a new system with a default configuration.
You need to configure an address usage
field as shown in the example below to fix it.
const businessPartner = BusinessPartner.builder()
.firstName('John')
.lastName('Doe')
.businessPartnerCategory('1')
.toBusinessPartnerAddress([
BusinessPartnerAddress.builder()
.country('DE')
.postalCode('14469')
.cityName('Potsdam')
.streetName('Konrad-Zuse-Ring')
.houseNumber('10')
// additional code starts
.toAddressUsage([
BuPaAddressUsage.builder().addressUsage('XXDEFAULT').build()
])
.build()
])
.build();
You can also create an entity asChildOf
another entity.
Create as Child Of
Assume you have already created a business partner and would like to add a new address to it:
const existingBusinessPartner = await BusinessPartner.requestBuilder()
.getByKey(myID)
.execute(myDestination);
const newAddress = new BusinessPartnerAddress()
.builder()
.country('DE')
.postalCode('14469')
.cityName('Potsdam')
.streetName('Konrad-Zuse-Ring')
.houseNumber('10')
.build();
This can be done by using the asChildOf
method which allows for creating an entity as a child of an existing entity.
You need to give the parent object and the field connecting the two entities:
BusinessPartnerAddress.requestBuilder()
.create(newAddress)
.asChildOf(
existingBusinessPartner,
BusinessPartner.TO_BUSINESS_PARTNER_ADDRESS
)
.execute(myDestination);
Update Request Builder
The update request builder allows you to change existing entities.
By default, PATCH
is used to only update changed fields.
In the following example, we first get a business partner, change one of its values, and then send an update request.
// Get a business partner
const businessPartner = await BusinessPartner.requestBuilder()
.getByKey('1')
.execute({ destinationName: 'myDestination' });
// Change first name
businessPartner.firstName = 'Steve';
// Send a PATCH request with `{ "FirstName" : "Steve" }`
BusinessPartner.requestBuilder().update(businessPartner);
In the example above we changed the first name of the given business partner. The payload sent to the service with PATCH includes only the first name.
Be aware that update requests will fail if their ETags don't match. Check out our ETag section for more information.
Replace the Entity With PUT
To replace an entity instead of just updating specific fields, use replaceWholeEntityWithPut
:
BusinessPartner.requestBuilder()
.update(businessPartner)
.replaceWholeEntityWithPut();
This will send a PUT
request and include all existing properties on your entity, whether they were changed or not.
Set Required Fields
If you want to send properties in the payload of the update request, that you did not change, use the setRequiredFields
method to add them.
In the following example, the PATCH
request will contain the FIRST_NAME
property of the business partner, even if it didn't change.
// Get a business partner
const businessPartner = await BusinessPartner.requestBuilder()
.getByKey('1')
.execute({ destinationName: 'myDestination' });
// Change last name
businessPartner.lastName = 'Smith';
// Send a PATCH request with `{ "LastName" : "Smith", "FirstName": "Steve" }` and include the first name although it was not changed
BusinessPartner.requestBuilder()
.update(businessPartner)
.setRequiredFields(BusinessPartner.FIRST_NAME);
Set Ignored Fields
If you changed properties on an entity, that you do not want to send in the payload of the update request, use the setIgnoredFields
method to ignore them.
In the following example, the PATCH
request won't contain changes that were made to the FIRST_NAME
property of the business partner.
// Get a business partner
const businessPartner = await BusinessPartner.requestBuilder()
.getByKey('1')
.execute({ destinationName: 'myDestination' });
// Change first name and last name
businessPartner.firstName = 'Steve';
businessPartner.lastName = 'Smith';
// Send a PATCH request with `{ "LastName" : "Smith" }` and do not include the changed first name
BusinessPartner.requestBuilder()
.update(businessPartner)
.setIgnoredFields(BusinessPartner.FIRST_NAME);
Delete Request Builder
The Delete request builder allows you to create DELETE
requests, that delete an entity.
/*
The following won't work on the real SAP S/4HANA BusinessPartner service because BusinessPartners cannot be deleted.
We added this only for the sake of the example.
*/
BusinessPartner.requestBuilder().delete(businessPartner);
Be aware that delete requests will fail if their ETag doesn't match. Check out our ETag section for more information.
Handling of ETags
An ETag is a version identifier that is often used to implement an optimistic locking mechanism. The SAP Cloud SDK will try to read version identifiers from responses and set them when sending OData requests.
Consider the following example:
async function modifyBusinessPartner(id) {
const destination = { url: 'https://my.s4-system.com' };
const businessPartner = await BusinessPartner.requestBuilder()
.getByKey(id)
.execute(myDestination);
// do some modification
applyModification(businessPartner);
return BusinessPartner.requestBuilder()
.update(businessPartner)
.execute(destination);
}
When executing getAll
and getByKey
requests, the SAP Cloud SDK will automatically attempt to extract the version identifier from the response and store it within the returned entity (partner
in the example above).
When executing update
requests, the version identifier will be sent in the If-match
request header.
If a service requires this header to be sent: Fetching the entity from the service first is essential to ensure that the ETag is present and up to date.
By default, an ETag is sent if it's present on the entity being modified.
ignoreVersionIdentifier()
will instead always send a *
which acts as a wildcard to match all ETags.
Ignore or Overwrite the Version Identifier
Entities can only be updated or deleted if ETags match.
If you want to force either an update or the deletion of the entity regardless of the ETag, configure the request to ignore version identifiers with ignoreVersionIdentifier
.
Below is an example with an update:
BusinessPartner.requestBuilder()
.update(businessPartner)
.ignoreVersionIdentifier();
You can also overwrite ETags using setVersionIdentifier
:
BusinessPartner.requestBuilder()
.update(businessPartner)
.setVersionIdentifier('etag');
In the example above, the ETag etag
is used instead of the original one.
Handling of Cross-Site Request Forgery Tokens
To create, update, and delete requests the SAP Cloud SDK will try to send a CSRF token. Upon execution, the request will try to fetch a token first before issuing the create request. Many services require this behavior for security reasons. However, the create request will be made without a CSRF token if none could be obtained.
Skip CSRF
Token Handling
For some services, the CSRF
token is not required even for non-get requests.
Therefore, skipping fetching the CSRF
token makes sense as a performance improvement.
You can disable the CSRF
token request by using skipCsrfTokenFetching()
like below:
BusinessPartner.requestBuilder()
.update(businessPartner)
.skipCsrfTokenFetching();
Available Filter Expressions
Filter Functions
There are predefined filter functions e.g. length
, substring
, substringOf
in the core library, that allow for a wide range of filter expressions:
/*
Fetch all business partners who have a first name shorter than 5 letters
*/
BusinessPartner.requestBuilder()
.getAll()
.filter(length(BusinessPartner.FIRST_NAME).lessThan(5))
.execute(destination);
For filter functions with boolean
as the return type, the filter function can be used directly as a filter without .equal(true)
.
Logically, the two following examples are equivalent to each other:
/*
$filter=startswith(FirstName, 'Bob') eq true
*/
.filter(
startsWith(BusinessPartner.FIRST_NAME, 'Bob').equal(true)
)
The filter expression can be shortened:
/*
$filter=startswith(FirstName, 'Bob')
*/
.filter(
startsWith(BusinessPartner.FIRST_NAME, 'Bob')
)
However, as some services might not support both versions shown above, you might have to choose one of them to fit the target system.
Function Imports
Request Builder
The function import request builder helps build a request for service operations including their parameters.
Not all services expose function imports.
We will use the Warehouse Outbound Delivery Order service as an example.
The according SAP Cloud SDK for JavaScript package is named @sap/cloud-sdk-vdm-warehouse-outbound-delivery-order-service
.
The example below creates a function import request builder for the service operation PostGoodsIssue
and then executes it against your destination.
postGoodsIssue({ outboundDeliveryOrder: 'order' }).execute(destination);
The service operation is defined in the service metadata.
If the response structure does not match the transformation type, the promise from execute(destination)
will be resolved into undefined
.
The default transformer expects the following response format:
{
"d": {
"Count": 0
}
}
Assume the actual response has an additional layer Foo
:
{
"d": {
"Foo": {
"Count": 0
}
}
}
In this case, dataAccessor
can be used in the following way to modify the response into the desired form for further deserialization.
functionImportRequestBuilder.execute(destination, data => data.d.Foo);
For some OData functions or action imports, the execute()
method might be missing as intended.
Typically, this might happen when an entity type is shared by multiple entity sets and is used as the return type of OData function or action imports.
In such a case you can use executeRaw
method for getting the raw response returned after invoking the OData function or action via type-safe API and deserialize it on your own.
Setting ETag
Function and action imports do not support ETag
handling automatically.
If your service requires the version identifier of an entity to be present, you can pass it to the request on your own using the addCustomHeaders
method (see example below).
With this approach, you have to retrieve the required entity with a GET request, before executing the function import.
Note, that if the function import execution succeeds, the version identifier of your entity will be outdated.
myFunction()
.addCustomHeaders({ 'if-match': entity.versionIdentifier })
.execute(destination);
Batch Requests
OData batch requests combine multiple operations into one POST operation, allowing you to execute multiple requests with just one network call. This can significantly reduce the network overhead you have to deal with when you want to execute many requests.
Every SAP Cloud SDK client provides a batch
function that takes retrieve requests and changesets.
You can combine those arbitrarily.
To execute batch requests, use the execute
method - it works the same way as for single requests.
The response of a batch
request is a list of BatchResponse
s.
Each of the items in the response is either a ReadResponse
, WriteResponses
or an ErrorResponse
, see Responses.
Retrieve Request
A retrieve request represents an HTTP GET
request.
In terms of the SAP Cloud SDK this includes all requests built by GetAllRequestBuilder
and GetByKeyRequestBuilder
.
You can pass retrieve requests directly to the batch
function.
Once you execute a batch
request you get a list of BatchResponse
.
A BatchResponse
that corresponds with a retrieve request can either be a ReadResponse
or an ErrorResponse
.
In the example below, we map each given address ID to a GetByKeyRequestBuilder
.
These retrieve requests are combined into one batch
request and executed against a destination.
async function getAddressesByIds(
businessPartnerId: string,
addressIds: string[]
): Promise<BusinessPartnerAddress[]> {
const retrieveRequests = addressIds.map(addressId =>
// Create get by key request
BusinessPartnerAddress.requestBuilder().getByKey(
businessPartnerId,
addressId
)
);
// Execute batch request combining multiple retrieve requests
const batchResponses = await batch(...retrieveRequests).execute(destination);
// ...
}
Changeset
A changeset is a collection of HTTP POST
, PUT
, PATCH
and DELETE
operations - requests built by CreateRequestBuilder
s, UpdateRequestBuilder
s, and DeleteRequestBuilder
s in terms of the SAP Cloud SDK.
The order of execution within a changeset is not defined.
This differs from the whole batch request itself, where the order is defined.
Therefore, the requests within one changeset should not depend on each other.
If the execution of any request within a changeset fails, the whole changeset will be reflected as an error in the response.
The changeset will not be applied, much like a database transaction.
Unlike retrieve requests, you can not pass change requests to the batch
function directly.
You have to combine them in a changeset
, which in turn can be passed to the batch
function.
Once a batch request is executed, it returns a list of BatchResponse
s.
If a changeset was executed successfully, its corresponding response is of type WriteResponses
and contains a collection of all raw responses to the requests in the changeset.
If the execution fails, the response is an ErrorResponse
.
In the example below, we create a list of UpdateRequestBuilder
s from a list of addresses.
We combine these change requests into one changeset
and pass it to the batch
request, which we execute against a destination.
Once we execute the batch
request, we get a list of BatchResponse
s, which in this example contains one response only, i.e. the one for the changeset.
async function updateAddresses(
businessPartnerAddresses: BusinessPartnerAddress[]
): Promise<BusinessPartnerAddress[]> {
// Create update requests
const updateRequests = businessPartnerAddresses.map(address =>
BusinessPartnerAddress.requestBuilder().update(address)
);
// Execute batch request with one changeset
const batchResponses = await batch(
// Combine update requests into one changeset
changeset(...updateRequests)
).execute(destination);
// Get response for the changeset request
const changesetResponse = batchResponses[0];
// ...
}
Responses
Once a batch
request is executed, it returns a list of BatchResponse
s.
The responses correspond to the retrieve requests and changesets in the same order that they were passed to the batch
function.
Requests that were not successful are reflected as ErrorResponse
s.
Responses to successful requests are represented as ReadResponse
s for retrieve requests, and WriteResponses
for changesets.
To determine if a request was successful use .isSuccess()
.
Then, depending on the corresponding request, you can parse the response or handle the error.
ReadResponse
Successful retrieve requests can be cast to ReadResponse
, which contains the HTTP code, the raw body, and the constructor of the entity that was parsed from the response.
To work with an instance of the retrieved entity, you can use the .as
method, which allows you to transform the raw data into an instance of the given constructor.
Note, that the .as
method transforms the raw data to an array of entities, even if the original request was a GetByKeyRequestBuilder
.
Also note, that retrieve responses can be ErrorResponse
s.
Therefore, it is crucial to check responses for success, before casting them to ReadResponse
.
In the example below, we combine a list of GetByKeyRequestBuilder
s into one batch
request and execute it against a destination.
If one of the requests was unsuccessful, an error will be thrown.
Otherwise, the responses are transformed into instances of BusinessPartnerAddress
.
async function getAddressesByIds(
...retrieveRequests: GetByKeyRequestBuilder<BusinessPartnerAddress>[]
): Promise<BusinessPartnerAddress[]> {
// Execute batch request combining multiple retrieve requests
const batchResponses = await batch(...retrieveRequests).execute(destination);
// Error handling
if (batchResponses.some(response => !response.isSuccess())) {
throw new Error('Some of the batch subrequests were not successful.');
}
return batchResponses.reduce(
(addresses: BusinessPartnerAddress[], response: BatchResponse) => [
...addresses,
// Transform response to an instance of BusinessPartnerAddress
...(response as ReadResponse).as(BusinessPartnerAddress)
],
[]
);
}
WriteResponses
Successful changeset requests can be cast to WriteResponses
which contains all subresponses for the changeset request.
Those responses can be accessed by .responses
and have the type WriteResponse
.
Each WriteResponse
contains the HTTP code and can contain the raw body and the constructor of the entity that was parsed from the response, depending on whether there was a body in the response.
Create and delete requests typically do not have a response body.
To work with an instance of an entity given in a WriteResponse
, you can use the .as
method, which allows you to transform the raw string body into an instance of the given constructor.
Note that the response may not exist, so you should only call this method if you know that there is data.
Typically the HTTP code is a good indicator for this - 201 No Content
probably won't have content.
If you are working with TypeScript you will have to tell the compiler, that the .as!
method can be used here by adding a !
.
Also note, that the response to a changeset can be an ErrorResponse
.
Therefore, it is crucial to check responses for success, before casting them to WriteResponses
.
In the example below, we combine a list of UpdateRequestBuilder
s into one changeset
and pass it to the batch
request, which we execute against a destination.
Once we execute the batch
request, we get a list of BatchResponse
s, which contains one response only.
If the request was unsuccessful, an error will be thrown.
Otherwise, the subresponses are transformed into instances of BusinessPartnerAddress
.
async function updateAddresses(
...updateRequests: UpdateRequestBuilder<BusinessPartnerAddress>
): Promise<BusinessPartnerAddress[]> {
// Execute batch request with one changeset
const batchResponses = await batch(
// Combine update requests into one changeset
changeset(...updateRequests)
).execute(destination);
// Get response for the changeset request
const changesetResponse = batchResponses[0];
// Error handling
if (!changesetResponse.isSuccess()) {
throw new Error('The changeset request was not successful.');
}
return changesetResponse.responses.map(response =>
// Transform response to an instance of BusinessPartnerAddress
response.as!(BusinessPartnerAddress)
);
}
ErrorResponse
Unsuccessful retrieve requests and changesets are reflected as ErrorResponse
s in the response.
Those responses have an httpCode
(a number) and a body
(a JSON object).
Combining Requests
You can combine requests within a batch
request as you like.
In the example below, we combine create requests, update requests, and get requests into one batch
request.
Remember, that change requests have to be wrapped in a changeset
.
We put the create requests into one changeset and combine the update and delete requests into another.
The GET
requests are added to the batch
request directly without wrapping.
Once the batch request is executed the response will be an array of sub-responses to the specific changeset and retrieve requests in the order that was given in the request. Note, that the sub-responses of a changeset don't have to be in order.
async function executeComplexBatch(
createAddressRequests: CreateRequestBuilder<BusinessPartnerAddress>[],
updateAddressRequests: UpdateRequestBuilder<BusinessPartnerAddress>[],
deleteAddressRequests: DeleteRequestBuilder<BusinessPartnerAddress>[],
getAddressByIdRequests: GetByKeyRequestBuilder<BusinessPartnerAddress>[]
) {
// Execute batch request
const [
createAddressesResponse,
updateAndDeleteAddressesResponse,
...getAddressesByIdResponses
] = await batch(
changeset(...createAddressRequests),
changeset(...updateAddressRequests, ...deleteAddressRequests),
...getAddressByIdRequests
).execute(destination);
// Do something with responses
}
Serialization
By default, when you execute a batch request, the subrequests are serialized to a multipart representation of the request, which is essentially a string. This is what a create request for a business partner addresses would serialize to:
Content-Type: application/http
Content-Transfer-Encoding: binary
POST /sap/opu/odata/sap/API_BUSINESS_PARTNER/A_BusinessPartnerAddress HTTP/1.1
Content-Type: application/json
Accept: application/json
{"BusinessPartner":"1","PostalCode":"10001","City":"New York","Country":"USA"}
The first lines are request headers for the multipart request, followed by a blank line.
The next line contains the request method and URL, followed by the request headers, a blank line, and the request payload.
Every "atomic" request is serialized to a string of this kind, while GET
and DELETE
requests do not provide a payload.
Configure Subrequest Serialization
By default, URLs in the multipart representation of a request are serialized to a path relative to the service, e.g.:
GET /sap/opu/odata/sap/API_BUSINESS_PARTNER/A_BusinessPartnerAddress HTTP/1.1
However, some services might only understand URLs relative to the entity or even absolute URLs.
To configure the serialization of the URLs within a batch request, you can set the subrequest path type with withSubRequestPathType
.
You can either set it to 'relativeToService'
, as is the default, 'relativeToEntity'
, which will yield URLs relative to the entity, or 'absolute'
, which will produce absolute URLs.
See below for examples:
Serialize subrequest path relative to entity:
// GET /A_BusinessPartnerAddress HTTP/1.1
batch(...requests).withSubRequestPathType('relativeToEntity');
Serialize subrequest path as absolute URL:
// GET https://my-s4.system.com/sap/opu/odata/sap/API_BUSINESS_PARTNER/A_BusinessPartnerAddress HTTP/1.1
batch(...requests).withSubRequestPathType('absolute');