A row contains stocking information about items in a warehouse. Warehouses can have any combination of aisles, rows and/or bins.


List Rows

readByQuery

<readByQuery>
    <object>ICROW</object>
    <fields>*</fields>
    <query></query>
    <pagesize>100</pagesize>
</readByQuery>

Parameters

Name Required Type Description
object Required string Use ICROW
fields Required string Comma separated list of fields on the object to list. Use * to return all fields.
query Required string SQL-like query based on fields on the object. Illegal XML characters must be properly encoded. The following SQL operators are supported: <, >, >=, <=, =, like, not like, in, not in. When doing NULL comparisons: IS NOT NULL, IS NULL. Multiple fields may be matched using the AND and OR operators. Joins are not supported. Single quotes in any operands must be escaped with a backslash - For example, the value Erik's Deli would become 'Erik\'s Deli'.
pagesize Optional integer Set a custom page size between 1 and 1000 items (Default: 100)

Get Row

read

<read>
    <object>ICROW</object>
    <keys>1</keys>
    <fields>*</fields>
</read>

Parameters

Name Required Type Description
object Required string Use ICROW
keys Required string The object RECORDNO to get
fields Required string Comma separated list of fields on the object to get. Use * to return all fields.

Get Row by Name

readByName

<readByName>
    <object>ICROW</object>
    <keys>Full Time</keys>
    <fields>*</fields>
</readByName>

Parameters

Name Required Type Description
object Required string Use ICROW
keys Required string The object ROWKEY to get
fields Required string Comma separated list of fields on the object to get. Use * to return all fields.

Provide feedback