These docs are for v1.0. Click to read the latest docs for v2024.09.

Discussions

Ask a Question
Back to All

Error on create shipment

Hi, I am doing the following request body:

{
  "allow_courier_fallback": "false",
  "destination_address_line_1": "test",
  "destination_address_line_2": "",
  "destination_city": "Sydney",
  "destination_company_name": "",
  "destination_country_alpha2": "AU",
  "destination_email_address": "[email protected]",
  "destination_name": "test",
  "destination_phone_number": "test",
  "destination_postal_code": "2020",
  "destination_state": "NSW",
  "easyship_shipment_id": "",
  "is_insured": "false",
  "items": [
    %{
      "actual_weight": "23.0",
      "category": "toys",
      "declared_currency": "AUD",
      "declared_customs_value": "45.0",
      "description": "test",
      "height": "20.0",
      "length": "10.0",
      "sku": "DM5NNR",
      "width": "12.0"
    }
  ],
  "order_notes": "",
  "platform_name": "Sheldon",
  "platform_order_number": "",
  "selected_courier_id": "f9c03bd5-dec7-4b5b-a3ac-7fa7b9d01674",
  "taxes_duties_paid_by": "Sender",
  "total_actual_weight": ""
}

but I am getting this error as response:

"{\"ActiveRecord::StatementInvalid\":\"PG::InFailedSqlTransaction: ERROR:  current transaction is aborted, commands ignored until end of transaction block\\n: /*application:ESAPI,controller:shipments,action:create*/ INSERT INTO \\\"shipments\\\" (\\\"type\\\", \\\"company_id\\\", \\\"shipment_state\\\", \\\"pickup_state\\\", \\\"transaction_state\\\", \\\"label_state\\\", \\\"manifest_state\\\", \\\"delivery_state\\\", \\\"store_state\\\", \\\"warehouse_state\\\", \\\"reconciliation_state\\\", \\\"destination_name\\\", \\\"destination_company_name\\\", \\\"platform_name\\\", \\\"order_notes\\\", \\\"destination_country_id\\\", \\\"incoterms\\\", \\\"buyer_selected_courier_id\\\", \\\"address_line_1\\\", \\\"state\\\", \\\"city\\\", \\\"postal_code\\\", \\\"phone_number\\\", \\\"email_address\\\", \\\"store_id\\\", \\\"origin_country_id\\\", \\\"currency\\\", \\\"service\\\", \\\"sort_by\\\", \\\"tracking_engine\\\", \\\"package_count\\\", \\\"easyship_shipment_id\\\", \\\"origin_address_id\\\", \\\"created_at\\\", \\\"updated_at\\\") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35) RETURNING \\\"id\\\"\"}"