Camelot 3PL - Enable API Access

The API (Application Programming Interface) provides automated communication between connected systems. In order to automate fulfillment, access to the Camelot API must be enabled.

If you have not yet gathered your API credentials, follow these steps first:

Gather API credentials from Camelot 3PL.

Enter API credentials in DropStream

  1. In your DropStream Dashboard, click Merchants.

In DropStream Dashboard, click Merchants.

  1. Click the name of your Camelot 3PL merchant.
  2. In Connection details, enter your API credentials:
  • Webservice URL
  • Username
  • Password
  • Client Code
  • Auth Mode — one of:
    • Basic
    • Digest
    • NTLM

Camelot connection details - required

  1. Optional: Specify the Carrier Billing Code, one of:
  • 3rd party
  • 3rd party Collect
  • Auto Select
  • Collect
  • N/A
  • Prepaid 3rd party
  • Prepaid & Add
  • Prepaid (the default)

Camelot connection details - billing code

  1. Optional: Set the Local Time Zone to be used in OrderDate values sent to Excalibur.

Local time zone

  1. Click Advanced Options, and specify the following:
  • Trading Partner — usually DROPSTREAM
  • Shipment Import Profile ID — default: DS_SHP_IMP
  • Order Status Profile ID — default: DS_SHP_EXP
  • Inventory Export Profile ID — default: DS_INV_EXP
  1. Optional: Import Shipments Containing Only The Given Order Status — import only Shipments with this status. If no status is specified, all shipments will be imported.

Camelot connection details - Advanced

  1. Optional: If your Excalibur installation has Paged Inventory enabled, check this box to enable the feature in DropStream.

Paged inventory

Notes about Paged Inventory:

  • Paged Inventory must be enabled for the Excalibur webservice by a Camelot 3PL support representative.
  • Paged Inventory needs to be either enabled or disabled in both Excalibur and DropStream, or inventory sync will not function properly.
  • For more information, contact your Camelot 3PL support representative.
  1. When you're done, click Save changes.

Save changes

Merchant Setup, Implementation Tips and Troubleshooting

When setting up your DropStream merchant connection to your fulfillment provider who uses Camelot 3PL as their WMS, here are a few things to keep in mind:

  1. Camelot has three database objects specifically for DropStream (Order In, Order Out, and Inventory Out).
  2. When setting up a merchant in DropStream, under Advanced Options, you must enter the following credentials:
  • Trading Partner
  • Shipment Import Profile ID
  • Order Status Profile ID
  • Inventory Export Profile ID

Verify Camelot advanced settings

  1. Verify that the values for Trading Partner, Shipment Import Profile ID, Order Status Profile ID, and Inventory Export Profile ID in DropStream are identical to your settings in Camelot for Trading Partner, and the corresponding Profile names:

Verify credentials

  1. Once you have set up your merchant in DropStream and have tested sending an order to Camelot, if you receive the following error message, you'll need to update the XMLport objects in Camelot to match the latest XMLport objects.

Error message: order not accepted

  1. To ensure that orders can be synced, make sure that both Shipment Methods and Carrier Codes are configured.
  1. If you receive the following error message:

Error message: could not send order

Contact DropStream Support at to receive a list of current DropStream IP addresses to whitelist.

Next: GetOrderStatus methods

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request



Please sign in to leave a comment.