CData BizTalk Adapter for FedEx 2019 - Online Help
Questions / Feedback?

PickupAvailability

CData BizTalk Adapter for FedEx 2019 - Build 19.0.7354

Checks availability for courier dispatch service for an address. This should be used prior to executing SchedulePickup in order to ensure the service will be available. The output values are not stored internally.

Procedure Specific Information

The stored procedure will examine the following tables for input:

  • Senders
  • Packages

Execute

In order to execute this procedure, one must specify SenderId, and PackageId. See the example below:

EXECUTE PickupAvailability SenderId = 3, PackageId = '9,13,17'

Input

Name Type Description
IsExpress Boolean Whether the Express service or Ground service is used.
PackageId String Comma-separated list of PackageIds to be picked up.
ShipDate Date Initial date for picking up the package. This value should be in the format (yyyy-MM-dd).
ShipTime Time Initial time for picking up the package. This value should be in the format (hh:mm:ss).
CompanyClosingTime Time Time in which Sender's company closes. This value should be in the format (hh:mm:ss).
SenderId Integer Identifier for the Sender requesting pickup.
IsFreight Boolean Whether the shipment is freight or standard.

Result Set Columns

Name Type Description
ShipDate Date Date in which pickup service is available.
ShipDate Time Time in which pickup service is available.
AccessTime Time Time window for FedEx to pickup the package. It will be equal to or greater than the difference between the CompanyCloseTime and the ShipTime.
CutoffTime Time Latest possible pickup time.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7354.0