ABAP RAP Custom Entity with Parameter not allowed

[Sandra_Rossi]

Hi Gurus,

I have created custom entity and Implemented if_rap_query_provider~select method. Service I created in V4 API.

This custom entity is with NO parameter is working as expected and returning all results.

When I added parameter to this Custom Entity It started giving me below Error ->

Entity 'ZCE_TU_DETAILS': Parameter entity set '$PARAMETER$ZCE_TU_DETAILS' cannot be used for read

I do not know how to test or use this Custom Entity with parameter... please help pointing to any documentation or example...

I have followed below documentation:

https://help.sap.com/docs/abap-cloud/abap-rap/using-parameters-in-unmanaged-query?version=sap_btp 

Please help...

@Ramjeekorada @Ramjee_korada 

Thanks-

[Sandra_Rossi]

Did you find the solution?

[AbhishekSharma]

Nope...

@Andre_Fischer Please help...

[Thiyagu-02]

Actually I got above error in the UI, when i try to use Parametrized CDS in the backend extensibility.

Solution:
1. Actually I expose the service as OData V2 - UI. Refer below img 

2. Check the manifest.json file in the BTP. (SAP Business application studio --> Open
your project file --> webApp --> search for manifest.json file).

Search for 'Pages-->ListReport' in the manifest.json. Refer the below image and the marked fields should match your exposed CDS name.
Example: In service binding: ZR_PP_DIFF_PERCENT_CATEGORYSet
                   In BTP's manifest.json file: ZR_PP_DIFF_PERCENT_CATEGORYSet
Both should be same. Don't get confuse! how you get the suffix 'set' next to 'CDS name'. It is default behaviour of OData V2

3. Redeploy the application in BTP.

[Jan-Trcka]

Hi,

I'm unsure if this is your situation, but when I created CDS with a parameter and linked it to the Service Binding, it made a new EntitySet.

Example:

I have a CDS named "ZPO_Item" with a parameter for the posting date. In the service binding component, it created a new EntitySet named "ZPO_ItemResults." All my communication needs to go to this EntitySet.

In the metadata there still exists the ZPO_Item EntitySet, but the linked EntityType is with the sap:semantics="parameters" and thus cannot be used for direct requests.

[DmitriiBalykov]

Hi there 

I'm sure you have already found the right answer

But in case anyone else gets here after googling the message Entity '&1': Parameter entity set '&2' cannot be used for read

After parametrizing your entity you need to add /Set at the end of the URI

Like, ../SomeName(Par1='value1',Par2='value2') wouldn't work but ../SomeName(Par1='value1',Par2='value2')/Set would