You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Filtering REST response based on child collection

Received Response
70
Views
1
Comments
edited Nov 16, 2020 8:35AM in Product Master Data Management 1 comment

Content

Hello Experts,

I am using REST service to find Item infomation.

https://XXXXXX.oraclecloud.com/fscmRestApi/resources/11.13.18.05/itemsV2?q=ItemNumber='218';OrganizationCode='XXXX'&expand=ItemDFF

In order to filter elements from parent collection I used q= in conjunction with Item Number and OrganizationCode.

In order to expand DFF node , I used expand=ItemDFF.

Now I want to filter data based on the ItemDFF's classification type. How to do it?

Sample shown below: I want to filter records with strategicItemFlag as Y.

 

"ItemDFF": [
                {
                    "InventoryItemId"100000002793044,
                    "OrganizationId"300000002124609,
                    "itemgroup"null,
                    "itemFamily"null,
                    "__FLEX_Context""ItemClassification",
                    "__FLEX_Context_DisplayValue""Item Classification",
                    "strategicItemFlag""Y"
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!