pfx-odata2:create

Creates a single entity in the external system.

Properties

Option

Type

Default

Description

Option

Type

Default

Description

connection

String

 

Defines a connection to the target system. Another way to define the connection is to specify the serviceUrl, username and password options (see below).

serviceUrl

String

 

Defines the URL of the target system. Use if the connection is not specified.

username

String

 

Defines the username for authentication. Use if the connection is not specified.

password

String

 

Defines the password for authentication. Use if the connection is not specified.

entity

String

 

Defines the entity type.

id

String

 

Defines the entity identifier. Mandatory for the update/delete methods. Optional for the read method.

$select

String

*

Specifies a subset of the entity properties that should be returned back. If not specified, all properties are selected. It is a comma-separated list. E.g. $select=Id,ProductName,NetPrice

$filter

String

 

A predicate expression that selects only entities which match the expression. E.g. $filter=NetPrice le 200 and NetPrice gt 3.5

  • Logical operators: eq, ne, gt, ge, lt, le, and, or, not

  • Arithmetic operators: add, sub, mul, div, mod

  • Grouping operators: ()

$orderby

String

 

Determines what values are used to order a collection of selected entities. E.g. $orderby=NetPrice asc,ProductName desc

$skip

Integer

 

Defines the number of records to skip (from the beginning). If defined, the selected collection skips the first N entities and returns just the remaining subset.

$top

Integer

 

Defines the number of records to include (from the beginning). If defined, just the first N entities from the selected collection are selected.

$inlinecount

String

none

Supported values are:

  • allpages – The response must contain the count of all selected entities after applying the $filter option. The count is returned as a header with the key PfxOpenData2.$inlinecount.

  • none – The response must not contain the count in the response. 

Examples

Create an entity with multiple IDs: A_CreditMemoRequestItems(CreditMemoRequest='60000001',CreditMemoRequestItem='10')

<route id="sap4hana-create-credit-memo-item" autoStartup="false"> <from uri="timer:in?repeatCount=1&delay=5000"/> <setBody> <groovy> [ "CreditMemoRequest":"60000001", "CreditMemoRequestItem":"10", "CreditMemoRequestItemCategory":"G2N", "CreditMemoRequestItemText":"Computer", "TotalNetAmount":new BigDecimal("500.00"), "TransactionCurrency":"USD", "RequestedQuantity":"10" ] </groovy> </setBody> <to uri="pfx-odata2://create?entity=A_CreditMemoRequestItem&connection=cognitus"/> <log message="Created ${body}"/> </route>

IntegrationManager version 5.8.0