Washington United ============================================================================= :Provider Information: +-----------------+-------------------+ | **Id** | washington_united | +-----------------+-------------------+ | **Type** | terminal | +-----------------+-------------------+ | **Trace Type** | Scrape | +-----------------+-------------------+ | **Credentials** | customer | +-----------------+-------------------+ | **Limits** | 20 | +-----------------+-------------------+ | **Status** | completed | +-----------------+-------------------+ | **Doc Status** | draft | +-----------------+-------------------+ | **Doc Version** | 1 | +-----------------+-------------------+ :URLs: +------+-----------------------+-------------+ | Type | URL | Environment | +======+=======================+=============+ | Page | http://tns.uswut.com/ | DEV/STG/PRD | +------+-----------------------+-------------+ :Sites: +------+---------+-----------------+ | Name | Site Id | Description | +======+=========+=================+ | name | ern | the description | +------+---------+-----------------+ Pages ----------------------------------------------------------------------------- Open home page and enter the username and password. .. image:: /_static/providers/rt/washington-united/01_Login.png Once the page is opened, enter container numbers separated by a comma on the url. .. code-block:: shell GET https://tns.uswut.com/uiArp02Action/searchContainerInformationListByCntrNo.do?cntrNo={ContainerNumbers} .. note:: ContainerNumbers in the request should be separated with commas. Once the page is opened for the url then there will be a table with containers information. .. image:: /_static/providers/rt/washington-united/02_Container_Results.png :Data Mapping: +------------------------+---------------------+------------------------------------------------+ | Property | Source Property | Description | +========================+=====================+================================================+ | container_number | ContainerNo | Container number | +------------------------+---------------------+------------------------------------------------+ | carrier.type | Default | Carrier type is defaulted to vessel | +------------------------+---------------------+------------------------------------------------+ | carrier.steamship_line | SCAC | The SCAC for the carrier. | +------------------------+---------------------+------------------------------------------------+ | destination.name | Default | Destination is defaulted to Washington United. | +------------------------+---------------------+------------------------------------------------+ | destination.type | Default | Destination is defaulted to Terminal | +------------------------+---------------------+------------------------------------------------+ || Arrived event || AvailableForPickup || Event will be created if there is | || || YardLocation || 'SHIP/YARD' in available_for_pickup column | || || || Or 'SHIP/YARD' in yard_location column | +------------------------+---------------------+------------------------------------------------+ || Grounded event || AvailableForPickup || Event will be created if there is | || || YardLocation || 'In Yard' in available_for_pickup column | || || || Or 'In Yard' in yard_location column | +------------------------+---------------------+------------------------------------------------+ || Released event || LastFreeDay || Event will be created if there is | || || || lastFreeDay column has data value | +------------------------+---------------------+------------------------------------------------+ || Outgate event || AvailableForPickup || Event will be created if there is | || || YardLocation || 'Out-Gated' in available_for_pickup column | || || || Or 'Out-Gated' in yard_location column | +------------------------+---------------------+------------------------------------------------+ || Customs hold event || CustomsStatus || Event will be created if there is | || || || hold or exam in customsstatus column | +------------------------+---------------------+------------------------------------------------+ || Freight hold event || FreightStatus || Event will be created if there is | || || || hold in freight_status column | +------------------------+---------------------+------------------------------------------------+ || USDA hold event || USDAStatus || Event will be created if there is | || || || hold in usda_status column | +------------------------+---------------------+------------------------------------------------+ || Line hold event || CarrierStatus || Event will be created if there is | || || || hold in carrier_status column | +------------------------+---------------------+------------------------------------------------+ || TMF hold event || TerminalStatus || Event will be created if there is | || || || hold in terminal_status. | +------------------------+---------------------+------------------------------------------------+ || Demurrage hold event || AvailableForPickup || Event will be created if | || || || 'Demurrage' in available_for_pickup column | +------------------------+---------------------+------------------------------------------------+ :Arrived Event: +------------------------+-----------------+-----------------------------------------------------------------+ | Property | Source Property | Description | +========================+=================+=================================================================+ | event[n].code | Arrived | If 'SHIP/YARD' in available_for_pickup or yard_Location columns | +------------------------+-----------------+-----------------------------------------------------------------+ | event[n].date | Default | Today date is the default date value | +------------------------+-----------------+-----------------------------------------------------------------+ | event[n].location.name | Default | Name is defaulted to 'Washington United' | +------------------------+-----------------+-----------------------------------------------------------------+ | event[n].location.type | Default | Type is defaulted to terminal | +------------------------+-----------------+-----------------------------------------------------------------+ | event[n].data.arrived | Default | ISO date of the arrival date which is defaulted to Today | +------------------------+-----------------+-----------------------------------------------------------------+ .. note:: Grounded event is created if If **In Yard** in available_for_pickup or yard_Location columns. :Grounded Event: +------------------------+--------------------+----------------------------------------------------------+ | Property | Source Property | Description | +========================+====================+==========================================================+ | event[n].code | Default | Defaulted to grounded | +------------------------+--------------------+----------------------------------------------------------+ | event[n].date | Default | Today date is the default date value | +------------------------+--------------------+----------------------------------------------------------+ | event[n].location.name | Default | Name is defaulted to 'Washington United' | +------------------------+--------------------+----------------------------------------------------------+ | event[n].location.type | Default | Type is defaulted to terminal | +------------------------+--------------------+----------------------------------------------------------+ | event[n].data.grounded | Default | ISO date of the arrival date which is defaulted to Today | +------------------------+--------------------+----------------------------------------------------------+ | event[n].data.lot | AvailableForPickup | Lot value shows between brackets if it is In Yard. | +------------------------+--------------------+----------------------------------------------------------+ :Lfd Event: +------------------------+-----------------+------------------------------------------+ | Property | Source Property | Description | +========================+=================+==========================================+ || event[n].code || lastfree_day || Lfd event will be created | || || || If date in lastfree_day column | +------------------------+-----------------+------------------------------------------+ | event[n].date | Default | Today date is the default date value | +------------------------+-----------------+------------------------------------------+ | event[n].location.name | Default | Name is defaulted to 'Washington United' | +------------------------+-----------------+------------------------------------------+ | event[n].location.type | Default | Type is defaulted to terminal | +------------------------+-----------------+------------------------------------------+ || event[n].data.lfd || lastfree_day || ISO date representing the last | || || column || Date for the container | +------------------------+-----------------+------------------------------------------+ :Released Event: +------------------------+--------------------+------------------------------------------+ | Property | Source Property | Description | +========================+====================+==========================================+ || event[n].code || Released || Released event will be created | || || || If date in lastfree_day column | +------------------------+--------------------+------------------------------------------+ | event[n].date | Default | Today date is the default date value | +------------------------+--------------------+------------------------------------------+ | event[n].location.name | Default | Name is defaulted to 'Washington United' | +------------------------+--------------------+------------------------------------------+ | event[n].location.type | Default | Type is defaulted to terminal | +------------------------+--------------------+------------------------------------------+ | event[n].data.released | Default | ISO date of release date | +------------------------+--------------------+------------------------------------------+ :Outgated Event: +----------------------------------+---------------------+---------------------------------------------------------------+ | Property | Source Property | Description | +==================================+=====================+===============================================================+ || event[n].code || Outgated || Outgated event will be created if | || || || 'Out-Gated' in available_for_pickup or yard_Location columns | || || || | +----------------------------------+---------------------+---------------------------------------------------------------+ | event[n].date | Default | Today date is the default date value | +----------------------------------+---------------------+---------------------------------------------------------------+ | event[n].location.name | Default | Name is defaulted to 'Washington United' | +----------------------------------+---------------------+---------------------------------------------------------------+ | event[n].location.type | Default | Type is defaulted to terminal | +----------------------------------+---------------------+---------------------------------------------------------------+ | event[n].data.outgate_scac | SCAC | SCAC of the trucking company | +----------------------------------+---------------------+---------------------------------------------------------------+ || event[n].data.outgate_confirmed || Default || Represents whether event is confirmed or not | || || || In this case it is set to True | +----------------------------------+---------------------+---------------------------------------------------------------+ || event[n].data.outgated || AvailableForPickup || ISO date that shows up if 'OutGate' in available_for_pickup | || || yardLocation || Or in yard_location columns | +----------------------------------+---------------------+---------------------------------------------------------------+ :Hold Events: +-------------------------+-----------------+------------------------------------------------------------+ | Property | Source Property | Description | +=========================+=================+============================================================+ | event[n].code | Hold | Hold is the default value for the event | +-------------------------+-----------------+------------------------------------------------------------+ | event[n].date | Default | Today date is the default date value | +-------------------------+-----------------+------------------------------------------------------------+ | event[n].location.name | Default | Name is defaulted to 'Washington United' | +-------------------------+-----------------+------------------------------------------------------------+ | event[n].location.type | Default | Type is defaulted to terminal | +-------------------------+-----------------+------------------------------------------------------------+ || event[n].data.holdType || Customs || CustomsStatus column has carrier_status | || || Freight || FreightStatus column has Hold | || || USDA || USDAStatus column has Hold | || || Line || CarrierStatus column has Hold | || || TMF || TerminalStatus column has Hold | || || Demurrage || 'Demurrage' exists in available_for_pickup column | +-------------------------+-----------------+------------------------------------------------------------+ | event[n].data.code | Hold | All holds columns shows Hold as value so it is set to hold | +-------------------------+-----------------+------------------------------------------------------------+