S4HANA Public Cloud - CBO Upsert Error 'Expected type is 'Edm.Boolean''

[RWeidner]

Hi all,

I'm trying an upsert to a custom CBO but the expected types are sort of strange.

It does not accept the values a GET request response.
Also numeric is not accepted as '1.00' but 1.00m

Example for the error:

https://xxxx/sap/opu/odata/sap/YY1_API_TEST_CDS/YY1_API_TESTSap_upsert?NumericID='0000000001'&SAP_De...

CheckBox = true is not considered as boolean, nor is 'true' or 'X' or 1 or whatever.

Has anyone solved this?

[Jerry_Lowery]

Hi

Unfortunately, I am not familiar with upsert, but have you checked this blog: https://community.sap.com/t5/enterprise-resource-planning-blog-posts-by-sap/upsert-a-custom-business...?

Is there a reason you are not doing a PUT or POST?

PS you might want to try "Yes" and "No" - I created a sample CBO and populated it with the generated UI

This is how it looks in the generated UI (you might also be able to check it in the Customer Data Browser for the created CDS View or do a GET to read the CDS View.)

[Chuma]

Hello @RWeidner 

Your call is failing because the CBO sap_upsert must be invoked with POST and a JSON body, not by passing parameters in the URL. When you include parameters in the query string, the gateway treats them as strings, leading to the error Expected type is Edm.Boolean.

What to do (works reliably in Public Cloud):

Call the function import with POST + JSON

POST /sap/opu/odata/sap/YY1_API_TEST_CDS/YY1_API_TESTSap_upsert

Content-Type: application/json

Accept: application/json

{

  "NumericID": "0000000001",

  "CheckBox": true,

  "Amount": 1.00

}

• CheckBox must be a JSON boolean: true or false (no quotes).
• Decimals can be sent as numbers in JSON; the service will type them as Edm. Decimal from metadata. SAP Help Portal

If you only want to quick-test via URL (GET)

• Use OData V2 literal rules:
• Boolean: CheckBox=true (lowercase, no quotes)
• Decimal: add the M suffix, e.g. Amount=1.00M
  Example:

.../YY1_API_TEST_CDS/YY1_API_TESTSap_upsert?

  NumericID='0000000001'&CheckBox=true&Amount=1.00M

• (But the supported pattern for sap_upsert is POST with a body.) odata.org-URI Conventions (OData Version 2.0)

Double-check names and types in $metadata
Open the service $metadata and verify the FunctionImport parameter names and EDM types match what you send. If the parameter name differs from the entity field name, you must use the function import’s parameter name. odata.org-Operations (OData Version 2.0)

With kind regards

Chuma