Skip to content

Instantly share code, notes, and snippets.

@jsqu99

jsqu99/gist:7817326

Created December 6, 2013 01:51
Show Gist options
  • Save jsqu99/7817326 to your computer and use it in GitHub Desktop.
Save jsqu99/7817326 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
gem install 'ruby_odata'
require 'ruby_odata'
svc = OData::Service.new("https://data.shipstation.com/1.2", username: 'jeff.squires@gmail.com', password: 'see_email_for_real_password')
svc.Orders.filter("OrderNumber eq 'R727282485'").expand("OrderItems")
order = svc.execute.first
=> #<Order:0x007f8170a9a418 @__metadata={:uri=>"http://data.shipstation.com/1.2/Orders(61682074)"}, @OrderID=61682074, @SellerID=203724, @StoreID=39715, @MarketplaceID=0, @OrderStatusID=2, @CustomerID=nil, @PackageTypeID=nil, @OrderDate=2013-12-05 12:47:46 UTC, @PayDate=nil, @ShipDate=nil, @OrderNumber="R727282485", @ShipName="Jeffrey Squires", @ShipCompany=nil, @ShipStreet1="1517 BELLE POINT DR", @ShipStreet2="", @ShipCity="MOUNT PLEASANT", @ShipState="SC", @ShipPostalCode="29464-8266", @ShipCountryCode="US", @ShipPhone="8432599931", @AddressVerified="1", @ShippingAmount=#<BigDecimal:7f8170aa9c10,'0.0',9(18)>, @OrderTotal=#<BigDecimal:7f8170aa9878,'0.1199E2',18(18)>, @Username=nil, @NotesFromBuyer=nil, @NotesToBuyer=nil, @InternalNotes=nil, @ImportKey="f96ab65d-7b6d-43ee-975c-aa1b85105222", @WeightOz=nil, @Width=nil, @Length=nil, @Height=nil, @CreateDate=2013-12-05 12:50:18 UTC, @ModifyDate=2013-12-05 12:52:06 UTC, @Active="true", @ServiceID=nil, @ShipStreet3=nil, @AmountPaid=#<BigDecimal:7f8170ab1c30,'0.0',9(18)>, @BuyerEmail="spree@example.com", @InsuredValue=#<BigDecimal:7f8170ab1640,'0.1199E2',18(18)>, @InsuranceProvider="0", @InsuranceCost=#<BigDecimal:7f8170ab0f60,'0.0',9(18)>, @ProviderID=nil, @Confirmation="0", @ConfirmationCost=#<BigDecimal:7f8170ab04c0,'0.0',9(18)>, @HoldUntil=nil, @ImportBatch="d3545920-55e7-4624-8cd4-862c0d5c1234", @RequestedShippingService=nil, @WarehouseID=19093, @CustomsContents=nil, @NonDelivery=nil, @ResidentialIndicator="R", @ExternalUrl=nil, @AdditionalHandling="false", @SaturdayDelivery="false", @RateError=nil, @OtherCost=#<BigDecimal:7f8170aba358,'0.0',9(18)>, @ExternalPaymentID=nil, @NonMachinable="false", @ShowPostage="false", @PackingSlipID=nil, @EmailTemplateID=nil, @RequestedServiceID=nil, @Gift="false", @GiftMessage=nil, @ExportStatus=nil, @TaxAmount=#<BigDecimal:7f8170ab87b0,'0.0',9(18)>, @CustomField1=nil, @CustomField2=nil, @CustomField3=nil, @AssignedUser=nil, @Source=nil, @OrderItems=[#<OrderItem:0x007f8170ac14c8 @__metadata={:uri=>"http://data.shipstation.com/1.2/OrderItems(86590758)"}, @OrderItemID=86590758, @OrderID=61682074, @ProductID=nil, @ExternalID="56", @SKU="ACC-BTN-8BZMBI", @Adjustment="false", @UPC=nil, @Description="8-Bit Zombie Buttons", @Quantity=1, @UnitPrice=#<BigDecimal:7f8170acb220,'0.0',9(18)>, @ExtendedPrice=#<BigDecimal:7f8170acae88,'0.0',9(18)>, @UnitCost=nil, @TaxAmount=nil, @ShippingAmount=nil, @WeightOz=nil, @ThumbnailUrl=nil, @CreateDate=2013-12-05 12:50:28 UTC, @ModifyDate=nil, @ItemUrl=nil, @WarehouseLocation=nil, @Options="", @Inactive="false">, #<OrderItem:0x007f8170ad35d8 @__metadata={:uri=>"http://data.shipstation.com/1.2/OrderItems(86590767)"}, @OrderItemID=86590767, @OrderID=61682074, @ProductID=nil, @ExternalID="57", @SKU="LC-GOTFUN-CERL", @Adjustment="false", @UPC=nil, @Description="Funko Game of Thrones Collectible Vinyl", @Quantity=1, @UnitPrice=#<BigDecimal:7f8170ad1418,'0.699E1',18(18)>, @ExtendedPrice=#<BigDecimal:7f8170ad1058,'0.699E1',18(18)>, @UnitCost=nil, @TaxAmount=nil, @ShippingAmount=nil, @WeightOz=nil, @ThumbnailUrl=nil, @CreateDate=2013-12-05 12:50:28 UTC, @ModifyDate=nil, @ItemUrl=nil, @WarehouseLocation=nil, @Options="Character: Cersei Lanister", @Inactive="false">]>
order.ShipStreet2='apt 123'
svc.update_object(order)
=> [#<OData::Operation:0x007f8170ae8a00 @kind="Update", @klass_name="Order", @klass=#<Order:0x007f8170a9a418 @__metadata={:uri=>"http://data.shipstation.com/1.2/Orders(61682074)"}, @OrderID=61682074, @SellerID=203724, @StoreID=39715, @MarketplaceID=0, @OrderStatusID=2, @CustomerID=nil, @PackageTypeID=nil, @OrderDate=2013-12-05 12:47:46 UTC, @PayDate=nil, @ShipDate=nil, @OrderNumber="R727282485", @ShipName="Jeffrey Squires", @ShipCompany=nil, @ShipStreet1="1517 BELLE POINT DR", @ShipStreet2="apt 123", @ShipCity="MOUNT PLEASANT", @ShipState="SC", @ShipPostalCode="29464-8266", @ShipCountryCode="US", @ShipPhone="8432599931", @AddressVerified="1", @ShippingAmount=#<BigDecimal:7f8170aa9c10,'0.0',9(18)>, @OrderTotal=#<BigDecimal:7f8170aa9878,'0.1199E2',18(18)>, @Username=nil, @NotesFromBuyer=nil, @NotesToBuyer=nil, @InternalNotes=nil, @ImportKey="f96ab65d-7b6d-43ee-975c-aa1b85105222", @WeightOz=nil, @Width=nil, @Length=nil, @Height=nil, @CreateDate=2013-12-05 12:50:18 UTC, @ModifyDate=2013-12-05 12:52:06 UTC, @Active="true", @ServiceID=nil, @ShipStreet3=nil, @AmountPaid=#<BigDecimal:7f8170ab1c30,'0.0',9(18)>, @BuyerEmail="spree@example.com", @InsuredValue=#<BigDecimal:7f8170ab1640,'0.1199E2',18(18)>, @InsuranceProvider="0", @InsuranceCost=#<BigDecimal:7f8170ab0f60,'0.0',9(18)>, @ProviderID=nil, @Confirmation="0", @ConfirmationCost=#<BigDecimal:7f8170ab04c0,'0.0',9(18)>, @HoldUntil=nil, @ImportBatch="d3545920-55e7-4624-8cd4-862c0d5c1234", @RequestedShippingService=nil, @WarehouseID=19093, @CustomsContents=nil, @NonDelivery=nil, @ResidentialIndicator="R", @ExternalUrl=nil, @AdditionalHandling="false", @SaturdayDelivery="false", @RateError=nil, @OtherCost=#<BigDecimal:7f8170aba358,'0.0',9(18)>, @ExternalPaymentID=nil, @NonMachinable="false", @ShowPostage="false", @PackingSlipID=nil, @EmailTemplateID=nil, @RequestedServiceID=nil, @Gift="false", @GiftMessage=nil, @ExportStatus=nil, @TaxAmount=#<BigDecimal:7f8170ab87b0,'0.0',9(18)>, @CustomField1=nil, @CustomField2=nil, @CustomField3=nil, @AssignedUser=nil, @Source=nil, @OrderItems=[#<OrderItem:0x007f8170ac14c8 @__metadata={:uri=>"http://data.shipstation.com/1.2/OrderItems(86590758)"}, @OrderItemID=86590758, @OrderID=61682074, @ProductID=nil, @ExternalID="56", @SKU="ACC-BTN-8BZMBI", @Adjustment="false", @UPC=nil, @Description="8-Bit Zombie Buttons", @Quantity=1, @UnitPrice=#<BigDecimal:7f8170acb220,'0.0',9(18)>, @ExtendedPrice=#<BigDecimal:7f8170acae88,'0.0',9(18)>, @UnitCost=nil, @TaxAmount=nil, @ShippingAmount=nil, @WeightOz=nil, @ThumbnailUrl=nil, @CreateDate=2013-12-05 12:50:28 UTC, @ModifyDate=nil, @ItemUrl=nil, @WarehouseLocation=nil, @Options="", @Inactive="false">, #<OrderItem:0x007f8170ad35d8 @__metadata={:uri=>"http://data.shipstation.com/1.2/OrderItems(86590767)"}, @OrderItemID=86590767, @OrderID=61682074, @ProductID=nil, @ExternalID="57", @SKU="LC-GOTFUN-CERL", @Adjustment="false", @UPC=nil, @Description="Funko Game of Thrones Collectible Vinyl", @Quantity=1, @UnitPrice=#<BigDecimal:7f8170ad1418,'0.699E1',18(18)>, @ExtendedPrice=#<BigDecimal:7f8170ad1058,'0.699E1',18(18)>, @UnitCost=nil, @TaxAmount=nil, @ShippingAmount=nil, @WeightOz=nil, @ThumbnailUrl=nil, @CreateDate=2013-12-05 12:50:28 UTC, @ModifyDate=nil, @ItemUrl=nil, @WarehouseLocation=nil, @Options="Character: Cersei Lanister", @Inactive="false">]>, @child_klass=nil>]
result = svc.save_changes
=> 400 Bad Request: <?xml version="1.0" encoding="utf-8" standalone="yes"?>
<error xmlns="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata">
<code></code>
<message xml:lang="en-US">Error processing request stream. Binding to new entities is not supported in PUT operations.</message>
</error>
puts "Was order updated? #{result}"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment