GetMovementsByQuery

This function lets you retrieve information about stock movements. By "movement" we mean when an item physically moves from one warehouse location to another location.

Tags: GetMovementsByQuery, GetGoodsOwnerMovementsQuery, GetMovementsByQueryResponse, GetGoodsOwnerMovementsResult, GoodsOwnerMovement, GetGoodsOwnerMovementsErrorResult, ArticleInfo_GetGoodsOwnerMovements, InOrderInfo_GetGoodsOwnerMovements, LocationInfo_GetGoodsOwnerMovements, WarehouseInfo_GetGoodsOwnerMovements, ArticleItemPalletItemInfo

Request XML

POST /xxx/Service.asmx HTTP/1.1
Host: api.ongoingsystems.se
Content-Type: text/xml; charset=utf-8
Content-Length: length
SOAPAction: "http://ongoingsystems.se/WSI/GetMovementsByQuery"

<?xml version="1.0" encoding="utf-8" ?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetMovementsByQuery xmlns="http://ongoingsystems.se/WSI">
      <GoodsOwnerCode>string</GoodsOwnerCode>
      <UserName>string</UserName>
      <Password>string</Password>
      <Query>
        <FromLocation>string</FromLocation>
        <ToLocation>string</ToLocation>
        <MoveTimeFrom>dateTime</MoveTimeFrom>
        <MoveTimeTo>dateTime</MoveTimeTo>
        <ArticleDefIdsToGet>
          <int>int</int>
          <int>int</int>
        </ArticleDefIdsToGet>
        <ArticleNumbersToGet>
          <string>string</string>
          <string>string</string>
        </ArticleNumbersToGet>
        <FromWarehouseCode>string</FromWarehouseCode>
        <ToWarehouseCode>string</ToWarehouseCode>
        <FromWarehouseId>int</FromWarehouseId>
        <ToWarehouseId>int</ToWarehouseId>
        <OnlyMovementsBetweenDifferentWarehouses>boolean</OnlyMovementsBetweenDifferentWarehouses>
        <OnlyMovementsBetweenDifferentArticleItemPalletItems>boolean</OnlyMovementsBetweenDifferentArticleItemPalletItems>
      </Query>
    </GetMovementsByQuery>
  </soap:Body>
</soap:Envelope>

Request specification

GetMovementsByQuery
GoodsOwnerCode string(400) Req. The name/code of your client
UserName string(50) Req. Your username
Password string(50) Req. Your password
Query GetGoodsOwnerMovementsQuery Req. The query object
GetGoodsOwnerMovementsQuery
FromLocation string(50) Only return stock movements from this location.
ToLocation string(50) Only return stock movements to this location.
MoveTimeFrom dateTime Req. Only return stock movements which happened after this time.
MoveTimeTo dateTime Only return stock movements which happened before this time.
ArticleDefIdsToGet int[] Only return stock movements for these particular articles.
ArticleNumbersToGet string[] Only return stock movements for these particular articles.
FromWarehouseCode string Only return stock movements from this warehouse.
ToWarehouseCode string Only return stock movements to this warehouse.
FromWarehouseId int Only return stock movements from this warehouse.
ToWarehouseId int Only return stock movements to this warehouse.
OnlyMovementsBetweenDifferentWarehouses boolean Only return stock movements between warehouses.
OnlyMovementsBetweenDifferentArticleItemPalletItems boolean Only return stock movements where items where moved into, out from, or between pallet items.

Response XML

<?xml version="1.0" encoding="utf-8" ?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <GetMovementsByQueryResponse xmlns="http://ongoingsystems.se/WSI">
      <GetMovementsByQueryResult>
        <Success>boolean</Success>
        <Movements>
          <Movement>
            <Article>
              <ArticleDefId>int</ArticleDefId>
              <ArticleNumber>string</ArticleNumber>
              <ArticleName>string</ArticleName>
            </Article>
            <NumberOfItems>decimal</NumberOfItems>
            <OriginalArticleItemId>int</OriginalArticleItemId>
            <Serial>string</Serial>
            <ExpiryDate>dateTime</ExpiryDate>
            <Batch>string</Batch>
            <InOrder>
              <InOrderId>int</InOrderId>
              <InOrderNumber>string</InOrderNumber>
            </InOrder>
            <MoveTime>dateTime</MoveTime>
            <FromLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </FromLocation>
            <ToLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </ToLocation>
            <FromWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </FromWarehouse>
            <ToWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </ToWarehouse>
            <FromArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </FromArticleItemPalletItem>
            <ToArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </ToArticleItemPalletItem>
          </Movement>
          <Movement>
            <Article>
              <ArticleDefId>int</ArticleDefId>
              <ArticleNumber>string</ArticleNumber>
              <ArticleName>string</ArticleName>
            </Article>
            <NumberOfItems>decimal</NumberOfItems>
            <OriginalArticleItemId>int</OriginalArticleItemId>
            <Serial>string</Serial>
            <ExpiryDate>dateTime</ExpiryDate>
            <Batch>string</Batch>
            <InOrder>
              <InOrderId>int</InOrderId>
              <InOrderNumber>string</InOrderNumber>
            </InOrder>
            <MoveTime>dateTime</MoveTime>
            <FromLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </FromLocation>
            <ToLocation>
              <LocationName>string</LocationName>
              <LocationTypeCode>string</LocationTypeCode>
            </ToLocation>
            <FromWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </FromWarehouse>
            <ToWarehouse>
              <WarehouseId>int</WarehouseId>
              <WarehouseCode>string</WarehouseCode>
            </ToWarehouse>
            <FromArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </FromArticleItemPalletItem>
            <ToArticleItemPalletItem>
              <Id>int</Id>
              <TypeCode>string</TypeCode>
              <LabelId>string</LabelId>
            </ToArticleItemPalletItem>
          </Movement>
        </Movements>
        <Error>
          <ErrorType>FromDateOccursAfterToDate or Unknown or LogonError</ErrorType>
          <Message>string</Message>
        </Error>
      </GetMovementsByQueryResult>
    </GetMovementsByQueryResponse>
  </soap:Body>
</soap:Envelope>

Response specification

GetMovementsByQueryResponse
GetMovementsByQueryResult GetGoodsOwnerMovementsResult
GetGoodsOwnerMovementsResult
Success boolean
Movements GoodsOwnerMovement[] List of movements.
Error GetGoodsOwnerMovementsErrorResult An element of type GetGoodsOwnerMovementsErrorResult.
GoodsOwnerMovement
Article ArticleInfo_GetGoodsOwnerMovements Contains information about the moved article (article number, article name, etc).
NumberOfItems decimal Number of items which were moved.
OriginalArticleItemId int Original article item id.
Serial string(128) Serial number of the moved item.
ExpiryDate dateTime Expiry date of the moved item.
Batch string(50) Batch number of the moved item.
InOrder InOrderInfo_GetGoodsOwnerMovements Information about the purchase which the item belongs to (if the item was received on a purchase order).
MoveTime dateTime The time when the move was performed.
FromLocation LocationInfo_GetGoodsOwnerMovements The location the items were moved From.
ToLocation LocationInfo_GetGoodsOwnerMovements The location the items were moved to.
FromWarehouse WarehouseInfo_GetGoodsOwnerMovements The warehouse which the items were moved from.
ToWarehouse WarehouseInfo_GetGoodsOwnerMovements The warehouse which the items were moved to.
FromArticleItemPalletItem ArticleItemPalletItemInfo Information about the pallet item that the item was (possibly) packed in before the move.
ToArticleItemPalletItem ArticleItemPalletItemInfo Information about the pallet item that the item is (possibly) packed in after the move.
GetGoodsOwnerMovementsErrorResult
ErrorType enum An element of type GetGoodsOwnerMovementsErrorType.
Message string
ArticleInfo_GetGoodsOwnerMovements
ArticleDefId int The id of the article.
ArticleNumber string(100) The article number.
ArticleName string(200) The article number.
InOrderInfo_GetGoodsOwnerMovements
InOrderId int The id of the inorder which the item belongs to (if the item was received on an inorder).
InOrderNumber string(50) The inorder number of the inorder which the item belongs to (if the item was received on an inorder).
LocationInfo_GetGoodsOwnerMovements
LocationName string(50) The location name.
LocationTypeCode string(50) The location type code.
WarehouseInfo_GetGoodsOwnerMovements
WarehouseId int
WarehouseCode string
ArticleItemPalletItemInfo
Id int System id of the pallet item
TypeCode string(50) Code of the package type
LabelId string(30) Label number