Back to Collection Items
-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
DECLARE @hr int
DECLARE @iTmp0 int
-- Important: Do not use nvarchar(max). See the warning about using nvarchar(max).
DECLARE @sTmp0 nvarchar(4000)
-- This example assumes the Chilkat API to have been previously unlocked.
-- See Global Unlock Sample for sample code.
DECLARE @http int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.Http', @http OUT
IF @hr <> 0
BEGIN
PRINT 'Failed to create ActiveX component'
RETURN
END
DECLARE @success int
-- Use this online tool to generate code from sample JSON: Generate Code to Create JSON
-- The following JSON is sent in the request body.
-- {
-- "rate_options": {
-- "carrier_ids": [
-- "{{stamps_com}}",
-- "{{fedex}}",
-- "{{ups}}"
-- ],
-- "service_codes": [
-- "usps_priority_mail",
-- "fedex_ground",
-- "ups_ground"
-- ]
-- },
-- "shipment_id": "{{shipment_id}}"
-- }
DECLARE @json int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @json OUT
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'rate_options.carrier_ids[0]', '{{stamps_com}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'rate_options.carrier_ids[1]', '{{fedex}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'rate_options.carrier_ids[2]', '{{ups}}'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'rate_options.service_codes[0]', 'usps_priority_mail'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'rate_options.service_codes[1]', 'fedex_ground'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'rate_options.service_codes[2]', 'ups_ground'
EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'shipment_id', '{{shipment_id}}'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'API-Key', '{{API_KEY}}'
EXEC sp_OAMethod @http, 'SetRequestHeader', NULL, 'Content-Type', 'application/json'
DECLARE @resp int
EXEC sp_OAMethod @http, 'PostJson3', @resp OUT, 'https://api.shipengine.com/v1/rates', 'application/json', @json
EXEC sp_OAGetProperty @http, 'LastMethodSuccess', @iTmp0 OUT
IF @iTmp0 = 0
BEGIN
EXEC sp_OAGetProperty @http, 'LastErrorText', @sTmp0 OUT
PRINT @sTmp0
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
RETURN
END
DECLARE @sbResponseBody int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.StringBuilder', @sbResponseBody OUT
EXEC sp_OAMethod @resp, 'GetBodySb', @success OUT, @sbResponseBody
DECLARE @jResp int
EXEC @hr = sp_OACreate 'Chilkat_9_5_0.JsonObject', @jResp OUT
EXEC sp_OAMethod @jResp, 'LoadSb', @success OUT, @sbResponseBody
EXEC sp_OASetProperty @jResp, 'EmitCompact', 0
PRINT 'Response Body:'
EXEC sp_OAMethod @jResp, 'Emit', @sTmp0 OUT
PRINT @sTmp0
DECLARE @respStatusCode int
EXEC sp_OAGetProperty @resp, 'StatusCode', @respStatusCode OUT
PRINT 'Response Status Code = ' + @respStatusCode
IF @respStatusCode >= 400
BEGIN
PRINT 'Response Header:'
EXEC sp_OAGetProperty @resp, 'Header', @sTmp0 OUT
PRINT @sTmp0
PRINT 'Failed.'
EXEC @hr = sp_OADestroy @resp
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
RETURN
END
EXEC @hr = sp_OADestroy @resp
-- Sample JSON response:
-- (Sample code for parsing the JSON response is shown below)
-- {
-- "rate_response": {
-- "rates": [
-- {
-- "rate_id": "se-12444425",
-- "rate_type": "shipment",
-- "carrier_id": "se-121862",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 65.58
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": null,
-- "package_type": null,
-- "delivery_days": 4,
-- "guaranteed_service": true,
-- "estimated_delivery_date": "2019-09-23T23:00:00Z",
-- "carrier_delivery_days": "Monday 9/23 by 11:00 PM",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "UPS® Ground",
-- "service_code": "ups_ground",
-- "trackable": true,
-- "carrier_code": "ups",
-- "carrier_nickname": "ShipEngine Test Account - UPS",
-- "carrier_friendly_name": "UPS",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444426",
-- "rate_type": "shipment",
-- "carrier_id": "se-121861",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 98.14
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": 7,
-- "package_type": "package",
-- "delivery_days": 2,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-19T00:00:00Z",
-- "carrier_delivery_days": "2",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "USPS Priority Mail",
-- "service_code": "usps_priority_mail",
-- "trackable": true,
-- "carrier_code": "stamps_com",
-- "carrier_nickname": "ShipEngine Test Account - Stamps.com",
-- "carrier_friendly_name": "Stamps.com",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444427",
-- "rate_type": "shipment",
-- "carrier_id": "se-121861",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 12.72
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": 7,
-- "package_type": "medium_flat_rate_box",
-- "delivery_days": 2,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-19T00:00:00Z",
-- "carrier_delivery_days": "2",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "USPS Priority Mail",
-- "service_code": "usps_priority_mail",
-- "trackable": true,
-- "carrier_code": "stamps_com",
-- "carrier_nickname": "ShipEngine Test Account - Stamps.com",
-- "carrier_friendly_name": "Stamps.com",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444428",
-- "rate_type": "shipment",
-- "carrier_id": "se-121861",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 6.98
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": 7,
-- "package_type": "small_flat_rate_box",
-- "delivery_days": 2,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-19T00:00:00Z",
-- "carrier_delivery_days": "2",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "USPS Priority Mail",
-- "service_code": "usps_priority_mail",
-- "trackable": true,
-- "carrier_code": "stamps_com",
-- "carrier_nickname": "ShipEngine Test Account - Stamps.com",
-- "carrier_friendly_name": "Stamps.com",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444429",
-- "rate_type": "shipment",
-- "carrier_id": "se-121861",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 17.47
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": 7,
-- "package_type": "large_flat_rate_box",
-- "delivery_days": 2,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-19T00:00:00Z",
-- "carrier_delivery_days": "2",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "USPS Priority Mail",
-- "service_code": "usps_priority_mail",
-- "trackable": true,
-- "carrier_code": "stamps_com",
-- "carrier_nickname": "ShipEngine Test Account - Stamps.com",
-- "carrier_friendly_name": "Stamps.com",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444430",
-- "rate_type": "shipment",
-- "carrier_id": "se-121861",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 6.48
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": 7,
-- "package_type": "flat_rate_envelope",
-- "delivery_days": 2,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-19T00:00:00Z",
-- "carrier_delivery_days": "2",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "USPS Priority Mail",
-- "service_code": "usps_priority_mail",
-- "trackable": true,
-- "carrier_code": "stamps_com",
-- "carrier_nickname": "ShipEngine Test Account - Stamps.com",
-- "carrier_friendly_name": "Stamps.com",
-- "validation_status": "has_warnings",
-- "warning_messages": [
-- "Heads up! You've included custom dimensions for a package type with a standardized size. For more accurate rates, consider removing the dimensions for this shipment."
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444431",
-- "rate_type": "shipment",
-- "carrier_id": "se-121861",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 7.03
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": 7,
-- "package_type": "flat_rate_padded_envelope",
-- "delivery_days": 2,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-19T00:00:00Z",
-- "carrier_delivery_days": "2",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "USPS Priority Mail",
-- "service_code": "usps_priority_mail",
-- "trackable": true,
-- "carrier_code": "stamps_com",
-- "carrier_nickname": "ShipEngine Test Account - Stamps.com",
-- "carrier_friendly_name": "Stamps.com",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444432",
-- "rate_type": "shipment",
-- "carrier_id": "se-121861",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 6.78
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "zone": 7,
-- "package_type": "flat_rate_legal_envelope",
-- "delivery_days": 2,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-19T00:00:00Z",
-- "carrier_delivery_days": "2",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "USPS Priority Mail",
-- "service_code": "usps_priority_mail",
-- "trackable": true,
-- "carrier_code": "stamps_com",
-- "carrier_nickname": "ShipEngine Test Account - Stamps.com",
-- "carrier_friendly_name": "Stamps.com",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- },
-- {
-- "rate_id": "se-12444433",
-- "rate_type": "shipment",
-- "carrier_id": "se-121863",
-- "shipping_amount": {
-- "currency": "usd",
-- "amount": 58.37
-- },
-- "insurance_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "confirmation_amount": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "other_amount": {
-- "currency": "usd",
-- "amount": 4.09
-- },
-- "zone": null,
-- "package_type": null,
-- "delivery_days": 3,
-- "guaranteed_service": false,
-- "estimated_delivery_date": "2019-09-20T00:00:00Z",
-- "carrier_delivery_days": "3",
-- "ship_date": "2019-09-17T00:00:00Z",
-- "negotiated_rate": false,
-- "service_type": "FedEx Ground®",
-- "service_code": "fedex_ground",
-- "trackable": true,
-- "carrier_code": "fedex",
-- "carrier_nickname": "ShipEngine Test Account - FedEx",
-- "carrier_friendly_name": "FedEx",
-- "validation_status": "valid",
-- "warning_messages": [
-- ],
-- "error_messages": [
-- ]
-- }
-- ],
-- "invalid_rates": [
-- ],
-- "rate_request_id": "se-1426242",
-- "shipment_id": "se-4134271",
-- "created_at": "2019-09-17T18:33:10.7692662Z",
-- "status": "completed",
-- "errors": [
-- ]
-- },
-- "shipment_id": "se-4134271",
-- "carrier_id": null,
-- "service_code": null,
-- "external_shipment_id": null,
-- "ship_date": "2019-09-17T00:00:00Z",
-- "created_at": "2019-09-17T18:31:35.03Z",
-- "modified_at": "2019-09-17T18:31:35.03Z",
-- "shipment_status": "pending",
-- "ship_to": {
-- "name": "Amanda Miller",
-- "phone": null,
-- "company_name": null,
-- "address_line1": "525 S WINCHESTER BLVD",
-- "address_line2": "",
-- "address_line3": null,
-- "city_locality": "SAN JOSE",
-- "state_province": "CA",
-- "postal_code": "95128-2537",
-- "country_code": "US",
-- "address_residential_indicator": "no"
-- },
-- "ship_from": {
-- "name": "John Doe",
-- "phone": "512-555-5555",
-- "company_name": null,
-- "address_line1": "4009 Marathon Blvd",
-- "address_line2": null,
-- "address_line3": null,
-- "city_locality": "Austin",
-- "state_province": "TX",
-- "postal_code": "78756",
-- "country_code": "US",
-- "address_residential_indicator": "unknown"
-- },
-- "warehouse_id": null,
-- "return_to": {
-- "name": "John Doe",
-- "phone": "512-555-5555",
-- "company_name": null,
-- "address_line1": "4009 Marathon Blvd",
-- "address_line2": null,
-- "address_line3": null,
-- "city_locality": "Austin",
-- "state_province": "TX",
-- "postal_code": "78756",
-- "country_code": "US",
-- "address_residential_indicator": "unknown"
-- },
-- "confirmation": "none",
-- "customs": null,
-- "external_order_id": null,
-- "order_source_code": null,
-- "advanced_options": {
-- "bill_to_account": null,
-- "bill_to_country_code": null,
-- "bill_to_party": null,
-- "bill_to_postal_code": null,
-- "contains_alcohol": false,
-- "delivered_duty_paid": false,
-- "non_machinable": false,
-- "saturday_delivery": false,
-- "dry_ice": false,
-- "dry_ice_weight": null,
-- "freight_class": null,
-- "custom_field1": null,
-- "custom_field2": null,
-- "custom_field3": null
-- },
-- "insurance_provider": "none",
-- "tags": [
-- ],
-- "packages": [
-- {
-- "package_code": "package",
-- "weight": {
-- "value": 17,
-- "unit": "pound"
-- },
-- "dimensions": {
-- "unit": "inch",
-- "length": 36,
-- "width": 12,
-- "height": 24
-- },
-- "insured_value": {
-- "currency": "usd",
-- "amount": 0
-- },
-- "label_messages": {
-- "reference1": null,
-- "reference2": null,
-- "reference3": null
-- },
-- "external_package_id": null
-- }
-- ],
-- "total_weight": {
-- "value": 17,
-- "unit": "pound"
-- },
-- "items": [
-- ]
-- }
-- Sample code for parsing the JSON response...
-- Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
DECLARE @rate_id nvarchar(4000)
DECLARE @rate_type nvarchar(4000)
DECLARE @v_Currency nvarchar(4000)
DECLARE @Amount nvarchar(4000)
DECLARE @insurance_amountCurrency nvarchar(4000)
DECLARE @insurance_amountAmount int
DECLARE @confirmation_amountCurrency nvarchar(4000)
DECLARE @confirmation_amountAmount int
DECLARE @other_amountCurrency nvarchar(4000)
DECLARE @other_amountAmount int
DECLARE @zone nvarchar(4000)
DECLARE @package_type nvarchar(4000)
DECLARE @delivery_days int
DECLARE @guaranteed_service int
DECLARE @estimated_delivery_date nvarchar(4000)
DECLARE @carrier_delivery_days nvarchar(4000)
DECLARE @negotiated_rate int
DECLARE @service_type nvarchar(4000)
DECLARE @trackable int
DECLARE @carrier_code nvarchar(4000)
DECLARE @carrier_nickname nvarchar(4000)
DECLARE @carrier_friendly_name nvarchar(4000)
DECLARE @validation_status nvarchar(4000)
DECLARE @j int
DECLARE @count_j int
DECLARE @strVal nvarchar(4000)
DECLARE @package_code nvarchar(4000)
DECLARE @weightValue int
DECLARE @weightUnit nvarchar(4000)
DECLARE @dimensionsUnit nvarchar(4000)
DECLARE @Length int
DECLARE @Width int
DECLARE @Height int
DECLARE @insured_valueCurrency nvarchar(4000)
DECLARE @insured_valueAmount int
DECLARE @Reference1 nvarchar(4000)
DECLARE @Reference2 nvarchar(4000)
DECLARE @Reference3 nvarchar(4000)
DECLARE @external_package_id nvarchar(4000)
DECLARE @Rate_request_id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Rate_request_id OUT, 'rate_response.rate_request_id'
DECLARE @Shipment_id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Shipment_id OUT, 'rate_response.shipment_id'
DECLARE @Created_at nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Created_at OUT, 'rate_response.created_at'
DECLARE @Status nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Status OUT, 'rate_response.status'
DECLARE @shipment_id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @shipment_id OUT, 'shipment_id'
DECLARE @carrier_id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @carrier_id OUT, 'carrier_id'
DECLARE @service_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @service_code OUT, 'service_code'
DECLARE @external_shipment_id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @external_shipment_id OUT, 'external_shipment_id'
DECLARE @ship_date nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_date OUT, 'ship_date'
DECLARE @created_at nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @created_at OUT, 'created_at'
DECLARE @modified_at nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @modified_at OUT, 'modified_at'
DECLARE @shipment_status nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @shipment_status OUT, 'shipment_status'
DECLARE @Name nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Name OUT, 'ship_to.name'
DECLARE @Phone nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Phone OUT, 'ship_to.phone'
DECLARE @Company_name nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Company_name OUT, 'ship_to.company_name'
DECLARE @Address_line1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Address_line1 OUT, 'ship_to.address_line1'
DECLARE @Address_line2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Address_line2 OUT, 'ship_to.address_line2'
DECLARE @Address_line3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Address_line3 OUT, 'ship_to.address_line3'
DECLARE @City_locality nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @City_locality OUT, 'ship_to.city_locality'
DECLARE @State_province nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @State_province OUT, 'ship_to.state_province'
DECLARE @Postal_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Postal_code OUT, 'ship_to.postal_code'
DECLARE @Country_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Country_code OUT, 'ship_to.country_code'
DECLARE @Address_residential_indicator nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Address_residential_indicator OUT, 'ship_to.address_residential_indicator'
DECLARE @ship_fromName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromName OUT, 'ship_from.name'
DECLARE @ship_fromPhone nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromPhone OUT, 'ship_from.phone'
DECLARE @ship_fromCompany_name nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromCompany_name OUT, 'ship_from.company_name'
DECLARE @ship_fromAddress_line1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromAddress_line1 OUT, 'ship_from.address_line1'
DECLARE @ship_fromAddress_line2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromAddress_line2 OUT, 'ship_from.address_line2'
DECLARE @ship_fromAddress_line3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromAddress_line3 OUT, 'ship_from.address_line3'
DECLARE @ship_fromCity_locality nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromCity_locality OUT, 'ship_from.city_locality'
DECLARE @ship_fromState_province nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromState_province OUT, 'ship_from.state_province'
DECLARE @ship_fromPostal_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromPostal_code OUT, 'ship_from.postal_code'
DECLARE @ship_fromCountry_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromCountry_code OUT, 'ship_from.country_code'
DECLARE @ship_fromAddress_residential_indicator nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @ship_fromAddress_residential_indicator OUT, 'ship_from.address_residential_indicator'
DECLARE @warehouse_id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @warehouse_id OUT, 'warehouse_id'
DECLARE @return_toName nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toName OUT, 'return_to.name'
DECLARE @return_toPhone nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toPhone OUT, 'return_to.phone'
DECLARE @return_toCompany_name nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toCompany_name OUT, 'return_to.company_name'
DECLARE @return_toAddress_line1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toAddress_line1 OUT, 'return_to.address_line1'
DECLARE @return_toAddress_line2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toAddress_line2 OUT, 'return_to.address_line2'
DECLARE @return_toAddress_line3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toAddress_line3 OUT, 'return_to.address_line3'
DECLARE @return_toCity_locality nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toCity_locality OUT, 'return_to.city_locality'
DECLARE @return_toState_province nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toState_province OUT, 'return_to.state_province'
DECLARE @return_toPostal_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toPostal_code OUT, 'return_to.postal_code'
DECLARE @return_toCountry_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toCountry_code OUT, 'return_to.country_code'
DECLARE @return_toAddress_residential_indicator nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @return_toAddress_residential_indicator OUT, 'return_to.address_residential_indicator'
DECLARE @confirmation nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @confirmation OUT, 'confirmation'
DECLARE @customs nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @customs OUT, 'customs'
DECLARE @external_order_id nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @external_order_id OUT, 'external_order_id'
DECLARE @order_source_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @order_source_code OUT, 'order_source_code'
DECLARE @Bill_to_account nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Bill_to_account OUT, 'advanced_options.bill_to_account'
DECLARE @Bill_to_country_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Bill_to_country_code OUT, 'advanced_options.bill_to_country_code'
DECLARE @Bill_to_party nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Bill_to_party OUT, 'advanced_options.bill_to_party'
DECLARE @Bill_to_postal_code nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Bill_to_postal_code OUT, 'advanced_options.bill_to_postal_code'
DECLARE @Contains_alcohol int
EXEC sp_OAMethod @jResp, 'BoolOf', @Contains_alcohol OUT, 'advanced_options.contains_alcohol'
DECLARE @Delivered_duty_paid int
EXEC sp_OAMethod @jResp, 'BoolOf', @Delivered_duty_paid OUT, 'advanced_options.delivered_duty_paid'
DECLARE @Non_machinable int
EXEC sp_OAMethod @jResp, 'BoolOf', @Non_machinable OUT, 'advanced_options.non_machinable'
DECLARE @Saturday_delivery int
EXEC sp_OAMethod @jResp, 'BoolOf', @Saturday_delivery OUT, 'advanced_options.saturday_delivery'
DECLARE @Dry_ice int
EXEC sp_OAMethod @jResp, 'BoolOf', @Dry_ice OUT, 'advanced_options.dry_ice'
DECLARE @Dry_ice_weight nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Dry_ice_weight OUT, 'advanced_options.dry_ice_weight'
DECLARE @Freight_class nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Freight_class OUT, 'advanced_options.freight_class'
DECLARE @Custom_field1 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Custom_field1 OUT, 'advanced_options.custom_field1'
DECLARE @Custom_field2 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Custom_field2 OUT, 'advanced_options.custom_field2'
DECLARE @Custom_field3 nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Custom_field3 OUT, 'advanced_options.custom_field3'
DECLARE @insurance_provider nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @insurance_provider OUT, 'insurance_provider'
DECLARE @Value int
EXEC sp_OAMethod @jResp, 'IntOf', @Value OUT, 'total_weight.value'
DECLARE @Unit nvarchar(4000)
EXEC sp_OAMethod @jResp, 'StringOf', @Unit OUT, 'total_weight.unit'
DECLARE @i int
SELECT @i = 0
DECLARE @count_i int
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'rate_response.rates'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @rate_id OUT, 'rate_response.rates[i].rate_id'
EXEC sp_OAMethod @jResp, 'StringOf', @rate_type OUT, 'rate_response.rates[i].rate_type'
EXEC sp_OAMethod @jResp, 'StringOf', @carrier_id OUT, 'rate_response.rates[i].carrier_id'
EXEC sp_OAMethod @jResp, 'StringOf', @v_Currency OUT, 'rate_response.rates[i].shipping_amount.currency'
EXEC sp_OAMethod @jResp, 'StringOf', @Amount OUT, 'rate_response.rates[i].shipping_amount.amount'
EXEC sp_OAMethod @jResp, 'StringOf', @insurance_amountCurrency OUT, 'rate_response.rates[i].insurance_amount.currency'
EXEC sp_OAMethod @jResp, 'IntOf', @insurance_amountAmount OUT, 'rate_response.rates[i].insurance_amount.amount'
EXEC sp_OAMethod @jResp, 'StringOf', @confirmation_amountCurrency OUT, 'rate_response.rates[i].confirmation_amount.currency'
EXEC sp_OAMethod @jResp, 'IntOf', @confirmation_amountAmount OUT, 'rate_response.rates[i].confirmation_amount.amount'
EXEC sp_OAMethod @jResp, 'StringOf', @other_amountCurrency OUT, 'rate_response.rates[i].other_amount.currency'
EXEC sp_OAMethod @jResp, 'IntOf', @other_amountAmount OUT, 'rate_response.rates[i].other_amount.amount'
EXEC sp_OAMethod @jResp, 'StringOf', @zone OUT, 'rate_response.rates[i].zone'
EXEC sp_OAMethod @jResp, 'StringOf', @package_type OUT, 'rate_response.rates[i].package_type'
EXEC sp_OAMethod @jResp, 'IntOf', @delivery_days OUT, 'rate_response.rates[i].delivery_days'
EXEC sp_OAMethod @jResp, 'BoolOf', @guaranteed_service OUT, 'rate_response.rates[i].guaranteed_service'
EXEC sp_OAMethod @jResp, 'StringOf', @estimated_delivery_date OUT, 'rate_response.rates[i].estimated_delivery_date'
EXEC sp_OAMethod @jResp, 'StringOf', @carrier_delivery_days OUT, 'rate_response.rates[i].carrier_delivery_days'
EXEC sp_OAMethod @jResp, 'StringOf', @ship_date OUT, 'rate_response.rates[i].ship_date'
EXEC sp_OAMethod @jResp, 'BoolOf', @negotiated_rate OUT, 'rate_response.rates[i].negotiated_rate'
EXEC sp_OAMethod @jResp, 'StringOf', @service_type OUT, 'rate_response.rates[i].service_type'
EXEC sp_OAMethod @jResp, 'StringOf', @service_code OUT, 'rate_response.rates[i].service_code'
EXEC sp_OAMethod @jResp, 'BoolOf', @trackable OUT, 'rate_response.rates[i].trackable'
EXEC sp_OAMethod @jResp, 'StringOf', @carrier_code OUT, 'rate_response.rates[i].carrier_code'
EXEC sp_OAMethod @jResp, 'StringOf', @carrier_nickname OUT, 'rate_response.rates[i].carrier_nickname'
EXEC sp_OAMethod @jResp, 'StringOf', @carrier_friendly_name OUT, 'rate_response.rates[i].carrier_friendly_name'
EXEC sp_OAMethod @jResp, 'StringOf', @validation_status OUT, 'rate_response.rates[i].validation_status'
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'rate_response.rates[i].warning_messages'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
EXEC sp_OAMethod @jResp, 'StringOf', @strVal OUT, 'rate_response.rates[i].warning_messages[j]'
SELECT @j = @j + 1
END
SELECT @j = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_j OUT, 'rate_response.rates[i].error_messages'
WHILE @j < @count_j
BEGIN
EXEC sp_OASetProperty @jResp, 'J', @j
SELECT @j = @j + 1
END
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'rate_response.invalid_rates'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'rate_response.errors'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'tags'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'packages'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
EXEC sp_OAMethod @jResp, 'StringOf', @package_code OUT, 'packages[i].package_code'
EXEC sp_OAMethod @jResp, 'IntOf', @weightValue OUT, 'packages[i].weight.value'
EXEC sp_OAMethod @jResp, 'StringOf', @weightUnit OUT, 'packages[i].weight.unit'
EXEC sp_OAMethod @jResp, 'StringOf', @dimensionsUnit OUT, 'packages[i].dimensions.unit'
EXEC sp_OAMethod @jResp, 'IntOf', @Length OUT, 'packages[i].dimensions.length'
EXEC sp_OAMethod @jResp, 'IntOf', @Width OUT, 'packages[i].dimensions.width'
EXEC sp_OAMethod @jResp, 'IntOf', @Height OUT, 'packages[i].dimensions.height'
EXEC sp_OAMethod @jResp, 'StringOf', @insured_valueCurrency OUT, 'packages[i].insured_value.currency'
EXEC sp_OAMethod @jResp, 'IntOf', @insured_valueAmount OUT, 'packages[i].insured_value.amount'
EXEC sp_OAMethod @jResp, 'StringOf', @Reference1 OUT, 'packages[i].label_messages.reference1'
EXEC sp_OAMethod @jResp, 'StringOf', @Reference2 OUT, 'packages[i].label_messages.reference2'
EXEC sp_OAMethod @jResp, 'StringOf', @Reference3 OUT, 'packages[i].label_messages.reference3'
EXEC sp_OAMethod @jResp, 'StringOf', @external_package_id OUT, 'packages[i].external_package_id'
SELECT @i = @i + 1
END
SELECT @i = 0
EXEC sp_OAMethod @jResp, 'SizeOfArray', @count_i OUT, 'items'
WHILE @i < @count_i
BEGIN
EXEC sp_OASetProperty @jResp, 'I', @i
SELECT @i = @i + 1
END
EXEC @hr = sp_OADestroy @http
EXEC @hr = sp_OADestroy @json
EXEC @hr = sp_OADestroy @sbResponseBody
EXEC @hr = sp_OADestroy @jResp
END
GO
Curl Command
curl -X POST
-H "API-Key: {{API_KEY}}"
-H "Content-Type: application/json"
-d '{
"rate_options": {
"carrier_ids": [
"{{stamps_com}}",
"{{fedex}}",
"{{ups}}"
],
"service_codes": [
"usps_priority_mail",
"fedex_ground",
"ups_ground"
]
},
"shipment_id": "{{shipment_id}}"
}'
https://api.shipengine.com/v1/rates
Postman Collection Item JSON
{
"name": "Compare rates for a shipment",
"event": [
{
"listen": "test",
"script": {
"exec": [
"let response = pm.response.json();",
"",
"if (response.rate_response.rates.length > 0) {",
" pm.collectionVariables.set(\"rate_id\", response.rate_response.rates[0].rate_id);",
"}"
],
"type": "text/javascript"
}
}
],
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"type": "text",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n\t\"rate_options\": {\n\t\t\"carrier_ids\": [\n\t\t\t\"{{stamps_com}}\",\n\t\t\t\"{{fedex}}\",\n\t\t\t\"{{ups}}\"\n\t\t],\n\t\t\"service_codes\": [\n\t\t\t\"usps_priority_mail\",\n\t\t\t\"fedex_ground\",\n\t\t\t\"ups_ground\"\n\t\t]\n\t},\n\t\"shipment_id\": \"{{shipment_id}}\"\n}"
},
"url": {
"raw": "https://api.shipengine.com/v1/rates",
"protocol": "https",
"host": [
"api",
"shipengine",
"com"
],
"path": [
"v1",
"rates"
]
},
"description": "If you've already created a shipment in ShipEngine, then you can easily compare rates using the `shipment_id`."
},
"response": [
{
"name": "Compare rates for a shipment",
"originalRequest": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"name": "Content-Type",
"type": "text",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n\t\"rate_options\": {\n\t\t\"carrier_ids\": [\n\t\t\t\"{{stamps_com}}\",\n\t\t\t\"{{fedex}}\",\n\t\t\t\"{{ups}}\"\n\t\t],\n\t\t\"service_codes\": [\n\t\t\t\"usps_priority_mail\",\n\t\t\t\"fedex_ground\",\n\t\t\t\"ups_ground\"\n\t\t]\n\t},\n\t\"shipment_id\": \"{{shipment_id}}\"\n}",
"options": {
"raw": {
"language": "json"
}
}
},
"url": {
"raw": "https://api.shipengine.com/v1/rates",
"protocol": "https",
"host": [
"api",
"shipengine",
"com"
],
"path": [
"v1",
"rates"
]
}
},
"status": "OK",
"code": 200,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Date",
"value": "Tue, 17 Sep 2019 18:33:10 GMT"
},
{
"key": "Content-Type",
"value": "application/json; charset=utf-8"
},
{
"key": "Content-Length",
"value": "13899"
},
{
"key": "Connection",
"value": "keep-alive"
},
{
"key": "Access-Control-Allow-Origin",
"value": "https://www.shipengine.com"
},
{
"key": "Vary",
"value": "Origin"
},
{
"key": "x-shipengine-requestid",
"value": "5824483d-bb0d-4dfd-bb6c-86f657a87119"
}
],
"cookie": [
],
"body": "{\n \"rate_response\": {\n \"rates\": [\n {\n \"rate_id\": \"se-12444425\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121862\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 65.58\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": null,\n \"package_type\": null,\n \"delivery_days\": 4,\n \"guaranteed_service\": true,\n \"estimated_delivery_date\": \"2019-09-23T23:00:00Z\",\n \"carrier_delivery_days\": \"Monday 9/23 by 11:00 PM\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"UPS® Ground\",\n \"service_code\": \"ups_ground\",\n \"trackable\": true,\n \"carrier_code\": \"ups\",\n \"carrier_nickname\": \"ShipEngine Test Account - UPS\",\n \"carrier_friendly_name\": \"UPS\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444426\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121861\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 98.14\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": 7,\n \"package_type\": \"package\",\n \"delivery_days\": 2,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-19T00:00:00Z\",\n \"carrier_delivery_days\": \"2\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"USPS Priority Mail\",\n \"service_code\": \"usps_priority_mail\",\n \"trackable\": true,\n \"carrier_code\": \"stamps_com\",\n \"carrier_nickname\": \"ShipEngine Test Account - Stamps.com\",\n \"carrier_friendly_name\": \"Stamps.com\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444427\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121861\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 12.72\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": 7,\n \"package_type\": \"medium_flat_rate_box\",\n \"delivery_days\": 2,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-19T00:00:00Z\",\n \"carrier_delivery_days\": \"2\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"USPS Priority Mail\",\n \"service_code\": \"usps_priority_mail\",\n \"trackable\": true,\n \"carrier_code\": \"stamps_com\",\n \"carrier_nickname\": \"ShipEngine Test Account - Stamps.com\",\n \"carrier_friendly_name\": \"Stamps.com\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444428\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121861\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 6.98\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": 7,\n \"package_type\": \"small_flat_rate_box\",\n \"delivery_days\": 2,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-19T00:00:00Z\",\n \"carrier_delivery_days\": \"2\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"USPS Priority Mail\",\n \"service_code\": \"usps_priority_mail\",\n \"trackable\": true,\n \"carrier_code\": \"stamps_com\",\n \"carrier_nickname\": \"ShipEngine Test Account - Stamps.com\",\n \"carrier_friendly_name\": \"Stamps.com\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444429\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121861\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 17.47\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": 7,\n \"package_type\": \"large_flat_rate_box\",\n \"delivery_days\": 2,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-19T00:00:00Z\",\n \"carrier_delivery_days\": \"2\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"USPS Priority Mail\",\n \"service_code\": \"usps_priority_mail\",\n \"trackable\": true,\n \"carrier_code\": \"stamps_com\",\n \"carrier_nickname\": \"ShipEngine Test Account - Stamps.com\",\n \"carrier_friendly_name\": \"Stamps.com\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444430\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121861\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 6.48\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": 7,\n \"package_type\": \"flat_rate_envelope\",\n \"delivery_days\": 2,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-19T00:00:00Z\",\n \"carrier_delivery_days\": \"2\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"USPS Priority Mail\",\n \"service_code\": \"usps_priority_mail\",\n \"trackable\": true,\n \"carrier_code\": \"stamps_com\",\n \"carrier_nickname\": \"ShipEngine Test Account - Stamps.com\",\n \"carrier_friendly_name\": \"Stamps.com\",\n \"validation_status\": \"has_warnings\",\n \"warning_messages\": [\n \"Heads up! You've included custom dimensions for a package type with a standardized size. For more accurate rates, consider removing the dimensions for this shipment.\"\n ],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444431\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121861\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 7.03\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": 7,\n \"package_type\": \"flat_rate_padded_envelope\",\n \"delivery_days\": 2,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-19T00:00:00Z\",\n \"carrier_delivery_days\": \"2\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"USPS Priority Mail\",\n \"service_code\": \"usps_priority_mail\",\n \"trackable\": true,\n \"carrier_code\": \"stamps_com\",\n \"carrier_nickname\": \"ShipEngine Test Account - Stamps.com\",\n \"carrier_friendly_name\": \"Stamps.com\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444432\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121861\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 6.78\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"zone\": 7,\n \"package_type\": \"flat_rate_legal_envelope\",\n \"delivery_days\": 2,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-19T00:00:00Z\",\n \"carrier_delivery_days\": \"2\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"USPS Priority Mail\",\n \"service_code\": \"usps_priority_mail\",\n \"trackable\": true,\n \"carrier_code\": \"stamps_com\",\n \"carrier_nickname\": \"ShipEngine Test Account - Stamps.com\",\n \"carrier_friendly_name\": \"Stamps.com\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n },\n {\n \"rate_id\": \"se-12444433\",\n \"rate_type\": \"shipment\",\n \"carrier_id\": \"se-121863\",\n \"shipping_amount\": {\n \"currency\": \"usd\",\n \"amount\": 58.37\n },\n \"insurance_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"confirmation_amount\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"other_amount\": {\n \"currency\": \"usd\",\n \"amount\": 4.09\n },\n \"zone\": null,\n \"package_type\": null,\n \"delivery_days\": 3,\n \"guaranteed_service\": false,\n \"estimated_delivery_date\": \"2019-09-20T00:00:00Z\",\n \"carrier_delivery_days\": \"3\",\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"negotiated_rate\": false,\n \"service_type\": \"FedEx Ground®\",\n \"service_code\": \"fedex_ground\",\n \"trackable\": true,\n \"carrier_code\": \"fedex\",\n \"carrier_nickname\": \"ShipEngine Test Account - FedEx\",\n \"carrier_friendly_name\": \"FedEx\",\n \"validation_status\": \"valid\",\n \"warning_messages\": [],\n \"error_messages\": []\n }\n ],\n \"invalid_rates\": [],\n \"rate_request_id\": \"se-1426242\",\n \"shipment_id\": \"se-4134271\",\n \"created_at\": \"2019-09-17T18:33:10.7692662Z\",\n \"status\": \"completed\",\n \"errors\": []\n },\n \"shipment_id\": \"se-4134271\",\n \"carrier_id\": null,\n \"service_code\": null,\n \"external_shipment_id\": null,\n \"ship_date\": \"2019-09-17T00:00:00Z\",\n \"created_at\": \"2019-09-17T18:31:35.03Z\",\n \"modified_at\": \"2019-09-17T18:31:35.03Z\",\n \"shipment_status\": \"pending\",\n \"ship_to\": {\n \"name\": \"Amanda Miller\",\n \"phone\": null,\n \"company_name\": null,\n \"address_line1\": \"525 S WINCHESTER BLVD\",\n \"address_line2\": \"\",\n \"address_line3\": null,\n \"city_locality\": \"SAN JOSE\",\n \"state_province\": \"CA\",\n \"postal_code\": \"95128-2537\",\n \"country_code\": \"US\",\n \"address_residential_indicator\": \"no\"\n },\n \"ship_from\": {\n \"name\": \"John Doe\",\n \"phone\": \"512-555-5555\",\n \"company_name\": null,\n \"address_line1\": \"4009 Marathon Blvd\",\n \"address_line2\": null,\n \"address_line3\": null,\n \"city_locality\": \"Austin\",\n \"state_province\": \"TX\",\n \"postal_code\": \"78756\",\n \"country_code\": \"US\",\n \"address_residential_indicator\": \"unknown\"\n },\n \"warehouse_id\": null,\n \"return_to\": {\n \"name\": \"John Doe\",\n \"phone\": \"512-555-5555\",\n \"company_name\": null,\n \"address_line1\": \"4009 Marathon Blvd\",\n \"address_line2\": null,\n \"address_line3\": null,\n \"city_locality\": \"Austin\",\n \"state_province\": \"TX\",\n \"postal_code\": \"78756\",\n \"country_code\": \"US\",\n \"address_residential_indicator\": \"unknown\"\n },\n \"confirmation\": \"none\",\n \"customs\": null,\n \"external_order_id\": null,\n \"order_source_code\": null,\n \"advanced_options\": {\n \"bill_to_account\": null,\n \"bill_to_country_code\": null,\n \"bill_to_party\": null,\n \"bill_to_postal_code\": null,\n \"contains_alcohol\": false,\n \"delivered_duty_paid\": false,\n \"non_machinable\": false,\n \"saturday_delivery\": false,\n \"dry_ice\": false,\n \"dry_ice_weight\": null,\n \"freight_class\": null,\n \"custom_field1\": null,\n \"custom_field2\": null,\n \"custom_field3\": null\n },\n \"insurance_provider\": \"none\",\n \"tags\": [],\n \"packages\": [\n {\n \"package_code\": \"package\",\n \"weight\": {\n \"value\": 17,\n \"unit\": \"pound\"\n },\n \"dimensions\": {\n \"unit\": \"inch\",\n \"length\": 36,\n \"width\": 12,\n \"height\": 24\n },\n \"insured_value\": {\n \"currency\": \"usd\",\n \"amount\": 0\n },\n \"label_messages\": {\n \"reference1\": null,\n \"reference2\": null,\n \"reference3\": null\n },\n \"external_package_id\": null\n }\n ],\n \"total_weight\": {\n \"value\": 17,\n \"unit\": \"pound\"\n },\n \"items\": []\n}"
}
]
}
