Overview

This node interacts with the BEAS Service Layer API to retrieve multiple records of the 'Item' resource. It supports filtering, sorting, pagination, field selection, and expansion of related entities using OData query parameters. This is useful for scenarios where you need to fetch a list of items with specific criteria, such as filtering items by status or creation date, sorting them by a field, or limiting the number of records returned.

Use Case Examples

1. Fetch all items created after a certain date, sorted by creation date descending.
2. Retrieve the top 10 items with a specific status, selecting only certain fields like ItemID and Description.
3. Get all items and expand related entities such as item categories or suppliers.

Properties

Output

JSON

• json - The JSON response containing the list of items retrieved from the BEAS Service Layer API, including any selected fields and expanded related entities.

Dependencies

• BEAS Service Layer API with valid credentials including service URL and service password for authentication.

Troubleshooting

• Ensure the service URL and service password credentials are correct and valid to obtain a session cookie; failure to get the session cookie will cause the node to throw an error.
• Invalid OData filter, sort, select, or expand strings may cause the API request to fail; verify the syntax and field names used in these parameters.
• If the JSON response is empty or incomplete, check the 'Top' and 'Skip' parameters to ensure correct pagination.
• If the node throws an error about unsupported operations or resources, verify that the resource is set to 'Item' and operation to 'Get All'.