Version: 2.11

Select Sap B1

Retrieves entities from SAP B1 system

Description

Selects zero or more records from SAP B1.

The maximum number of rows retrieved per one request call is 20. Increment the page input to select the next 20 records.

The JSON response has the following structure:

&#123;
  value: &#123;&#125;, - retrieved records,
  totalSize: 0 - number of all records of the querying resource
&#125;

Control Flow (Control Flow)
SAP B1 Config (SAP B1 Config): A object with connection configuration
Where (String): Optional. ObjectKey or SAP B1 filtering option. Could be provided in format: Property operator value. The whole list of operators could be found in filter query options in <a href="https://help.sap.com/doc/0d2533ad95ba4ad7a702e83570a21c32/9.3/en-US/Working_with_SAP_Business_One_Service_Layer.pdf" target="_blank">SAP B1 documentation</a>. Example: CardType eq cSupplier.
Resource (String): A collection of entities, identifies the resource to be interacted with
Page (Number): Optional. Each page contains a maximum of 20 records
Order By (String): Optional. Should be in the next format: Property asc/desc. Example, UpdateDate desc, UpdateTime desc
Limit (Number): Optional. The number of records to select. Maximum is defined by the SAP instance (typically 100). To select the next rows increment the page.