Question Re: HCI Odata API dynamic query in Technology Q&A

HCI Odata API dynamic query

former_member597363 — Thu, 22 Nov 2018 10:50:06 GMT

Hi experts

The requirement is to pass the top paramter of the Odata API query dynamically.

Based on the input paylod value, this top parameter should be modified and passed to the API.

For ex : Below is the query where we need to pick the top 10 Campaign objects.

https://xxxxxx.s4hana.ondemand.com/sap/opu/odata/sap/API_MKT_CAMPAIGN_SRV/Campaigns?$top=10&$filter=CampaignCategory eq 'abc' and CampaignLifecycleStatus eq '2'&$orderby=CampaignPriority desc&$format=json&$expand=CampaignAssignedTargetGroups

This value 10 should change based on the input payload value ( we could also maintain a value mapping for the same)

Kindly provide your suggestions.

Regards

Sudarvizhi P

Re: HCI Odata API dynamic query

Sriprasadsbhat — Tue, 27 Nov 2018 07:42:57 GMT

Hello Sudarvizhi,

Add content modifier just before your request reply and set the header [ For Ex topval ] with whatever value you need and call the same in your channel like below

https://xxxxxx.s4hana.ondemand.com/sap/opu/odata/sap/API_MKT_CAMPAIGN_SRV/Campaigns?$top=${header.topval}&$filter=CampaignCategory eq 'abc' and CampaignLifecycleStatus eq '2'&$orderby=CampaignPriority desc&$format=json&$expand=CampaignAssignedTargetGroups

Regards,

Sriprasad Shivaram Bhat

Re: HCI Odata API dynamic query

former_member597363 — Tue, 11 Dec 2018 09:46:56 GMT

Thanks Sriprasad Shivaram Bhat. Let me try this

Re: HCI Odata API dynamic query

czzzh — Wed, 10 Jan 2024 09:33:48 GMT

Hello Sriprasad

Do you know the reason why postman does not return the $expand content, only the root content?

Thanks