POST public-api/locations/advancedinfosearch

This method returns a page full of active locations given a precise set of search, sort or filter criteria. It is a paging API so this is meant to be called with a smaller number (ca 100) or records to fetch, repeatedly, until you get them all. It requires the Allow Location permission and enforces Role Site permission. Note: This is a Post API to avoid limitations inherent to passing parameters on the URL.



Request Information

URI Parameters

None.

Body Parameters

AdvancedSearchParameters
NameDescriptionTypeAdditional information
TotalCountFromPriorFetch

This field helps to skip the page count recalculation that goes into calculating the TotalRecordsLongCount. For example - When paging through data using functions like the assetadvancedinfosearch, calculating TotalRecordsLongCount for every page full of data is a time-consuming operation. To avoid that extra calculation, and help prevent throttling, TotalRecordsLongCount is assigned to TotalCountFromPriorFetch in the AdvancedSearchParameters to skip recalculating this total page count and to page through the records faster. By default, this value is a null value, meaning the api should peform a record count of the data prior to fetching the records.

integer

None.

AdditionalSkipCount

This is the additional number of records to skip, in addition to page size and page #. This is useful for quick filter (more) mode of operation. This field is not implemented.

integer

None.

PageSize

Due to the large number of records this API may return, this is a paging API. Set this value to specify the number of records you wish to process per API call. (Recommended 100-500). Note: some grid query api will ignore or cap this value if the requested page size is too large. A large page size (several thousands) could overflow or degrade the serialization of return data.

integer

None.

PageNumber

Due to the large number of records this API may return, this is a paging API. Set this value to specify the page number or record set you wish to process. Generally you would want to keep the PageSize constant (Recommended 100-500) and loop thru the results incrementing this PageNumber until the number of records returned is less than the value you specified for PageSize.

integer

None.

Sort

This is an expression tree. Set this to specify all the columns you wish to sort the data by. Default None.

Collection of Object

None.

Filter

This is an expression tree. Set this to specify all the columns, values and operators you wish to filter the data by. Default None.

TopLevelFilterType

None.

ClientUtcOffset

If you provide a valid expression tree for the Filter parameter and the filter expression you provide performs one or more comparisons of DateTime values with constants then set this to specify which time zone your DateTime constants represent. Common ClientUtcOffset string values include: Dateline Standard Time, UTC-11, Hawaiian Standard Time, Marquesas Standard Time, Alaskan Standard Time, Pacific Standard Time, Mountain Standard Time, Central Standard Time, Eastern Standard Time, Venezuela Standard Time, Atlantic Standard Time, Newfoundland Standard Time, Greenland Standard Time, UTC-02, Cape Verde Standard Time, GMT Standard Time, W. Europe Standard Time, GTB Standard Time, Russian Standard Time, Arabian Standard Time, Afghanistan Standard Time, Pakistan Standard Time, India Standard Time, China Standard Time, Tokyo Standard Time, AUS Central Standard Time, West Pacific Standard Time, Central Pacific Standard Time, Fiji Standard Time, Samoa Standard Time.

TimeZoneInfoId

None.

FilterBehavior

Internal - specific filter behaviors

FilterBehaviorFlags

None.

WorkingSiteIdCsvList

Use this comma separated list for values to efficiently filter results to one or more sites.

string

None.

Request Formats

application/json

Sample:
{
  "AdditionalSkipCount": 0,
  "PageSize": 20,
  "PageNumber": 1,
  "Sort": [
    {
      "field": "AssetTag",
      "dir": "ascending"
    }
  ],
  "Filter": {
    "filters": []
  },
  "FilterBehavior": 0
}



Response Information

Resource Description

WaspResultOfListOfLocationModelInfo
NameDescriptionTypeAdditional information
Data

Type specific result that always depends on the function called.

Collection of LocationModelInfo

None.

Messages

List of Messages. All APIs should return messages. If an API function returns an error you can find more information about the error or errors in this collection of messages.

Collection of WtResult

None.

BatchNumber

This is a global batch number generated by a mass group of transaction records to be returned to the consumer on each call to rolling transaction rules. This requests that each group of Move/Add/Remove transaction batches is tied together. In prior products (such as Mobile Asset Cloud), all are set to null and the only time when the batch number is generated is for multiple check-out transactions but the old is to generate for each responsible party.

integer

None.

HasError

True if an API function result has an error message in the results. If this is false, the function succeeded but other informative messages may be available.

boolean

None.

HasHttpError

True if an API function call could not be fully posted to the server or the results could not be fully returned.

boolean

None.

HasMessage

True if any message is available.

boolean

None.

HasSuccessWithMoreDataRemaining

True if the server sent part of the data and there is more data available. Use with paging APIs to fetch data one page at a time.

boolean

None.

TotalRecordsLongCount

This is the total number of records available in the database based on the query and filer conditions provided. It is possible that the value can change from call to call as users add and delete records so this should not be used to page through multiple recordsets of data. This is used, for example, to set relative scroll bar sizes. When paging through data using functions like the assetadvancedinfosearch, calculating TotalRecordsLongCount for every page full of data is an time-consuming operation. To avoid that extra calculation, and help prevent throttling, assign TotalRecordsLongCount to TotalCountFromPriorFetch in the AdvancedSearchParameters to skip recalculating this total page count and to page thru the records faster.

integer

None.

Response Formats

application/json

Sample:
{
  "Data": [
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "Pack",
      "UsageTypeName": "Pick only",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "Put Away",
      "UsageTypeName": "Receive only",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "Stage",
      "UsageTypeName": "Repair/Inactive",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R1",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R10",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R2",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R3",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R4",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R5",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R6",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R7",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R8",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S1.R9",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S2.R1",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S2.R10",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S2.R2",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S2.R3",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S2.R4",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S2.R5",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    },
    {
      "RowNumber": 0,
      "SiteName": "Warehouse 1",
      "LocationCode": "R1.S2.R6",
      "UsageTypeName": "Normal",
      "LocationRecordStatus": 0,
      "AllLocationNotes": [],
      "CustomFields": [],
      "LocationSequence": 0.0,
      "ParentLocation": "",
      "ChildrenLocations": 0
    }
  ],
  "Messages": [
    {
      "ResultCode": 0,
      "Message": "20",
      "HttpStatusCode": 0
    }
  ],
  "TotalRecordsLongCount": 106,
  "HasSuccessWithMoreDataRemaining": false,
  "HasError": false,
  "HasMessage": true,
  "HasHttpError": false
}