dingo failures

gistfile1.txt

result =  Message.all.map do |m|
  body = JSON.parse(m.body)
  action = m.action
  date = if m.action == 'new_customer_return'
    body["customer_return"]["receipt_date"]
  elsif m.action == 'shipment_shipped'
    body["shipped_at"]
  elsif action == 'shipment_canceled'
    body["canceled_at"]
  elsif action == 'order_fulfilled'
    body["order"]["placed_on"]
  elsif action == 'return_item_received'
    body["return_item"]["created_at"]
  elsif action == 'received_purchase_order'
    body["line_items"].first["receivedate"]
  end

  [m.id, action, date]
end.sort_by {|m| m.last}

irb(main):226:0> pp result
[[25352, "return_item_received", "2016-11-17T18:02:24.070Z"],
 [25349, "return_item_received", "2016-11-17T18:04:01.241Z"],
 [25347, "return_item_received", "2016-11-17T18:04:01.309Z"],
 [25348, "received_purchase_order", "2016-11-25T14:35:34.4828349Z"],
 [25343, "received_purchase_order", "2016-11-25T14:35:46.9638749Z"],
 [25307, "shipment_canceled", "2016-11-27T02:57:55.4787714Z"],
 [25301, "new_customer_return", "2016-11-28T20:02:37.817Z"],
 [25356, "order_fulfilled", "2016-11-29T17:11:14Z"],
 [25369, "received_purchase_order", "2016-11-29T17:15:00.6659219Z"],
 [25291, "shipment_shipped", "2016-11-30T14:06:40.8624648Z"],
 [25331, "new_customer_return", "2016-11-30T17:32:49.7Z"],
 [25318, "new_customer_return", "2016-11-30T17:35:40.75Z"],
 [25332, "new_customer_return", "2016-11-30T17:40:18.12Z"],
 [25337, "new_customer_return", "2016-11-30T17:41:14.83Z"],
 [25314, "new_customer_return", "2016-11-30T17:48:56.74Z"],
 [25317, "new_customer_return", "2016-11-30T17:52:40.55Z"],
 [25305, "new_customer_return", "2016-11-30T17:56:09.647Z"],
 [25334, "new_customer_return", "2016-11-30T18:54:04.277Z"],
 [25313, "new_customer_return", "2016-11-30T19:00:05.657Z"],
 [25312, "new_customer_return", "2016-11-30T19:10:03.767Z"],
 [25336, "new_customer_return", "2016-11-30T19:16:30.197Z"],
 [25315, "new_customer_return", "2016-11-30T19:30:34.127Z"],
 [25295, "new_customer_return", "2016-11-30T19:45:57.427Z"],
 [25299, "new_customer_return", "2016-11-30T19:49:20.097Z"],
 [25293, "new_customer_return", "2016-11-30T19:54:13.313Z"],
 [25302, "new_customer_return", "2016-11-30T20:00:51.29Z"],
 [25292, "new_customer_return", "2016-11-30T20:05:54.26Z"],
 [25308, "new_customer_return", "2016-11-30T20:09:36.83Z"],
 [25303, "new_customer_return", "2016-11-30T20:13:32.927Z"],
 [25324, "new_customer_return", "2016-11-30T20:16:30.517Z"],
 [25327, "new_customer_return", "2016-11-30T20:18:50.877Z"],
 [25300, "new_customer_return", "2016-11-30T20:21:22.83Z"],
 [25330, "new_customer_return", "2016-11-30T20:23:38.52Z"],
 [25333, "new_customer_return", "2016-12-01T19:05:44.427Z"],
 [25320, "new_customer_return", "2016-12-01T19:10:14.603Z"],
 [25325, "new_customer_return", "2016-12-02T15:32:09.323Z"],
 [25306, "new_customer_return", "2016-12-02T15:35:49.313Z"],
 [25340, "new_customer_return", "2016-12-02T15:40:32.873Z"],
 [25338, "new_customer_return", "2016-12-02T15:47:30.68Z"],
 [25309, "new_customer_return", "2016-12-02T15:51:27.46Z"],
 [25339, "new_customer_return", "2016-12-02T15:54:41.153Z"],
 [25329, "new_customer_return", "2016-12-02T16:03:50.277Z"],
 [25310, "new_customer_return", "2016-12-02T16:08:21.22Z"],
 [25297, "new_customer_return", "2016-12-02T16:10:50.55Z"],
 [25326, "new_customer_return", "2016-12-02T16:10:50.55Z"],
 [25322, "new_customer_return", "2016-12-02T16:13:41.293Z"],
 [25319, "new_customer_return", "2016-12-02T16:16:58.64Z"],
 [25323, "shipment_shipped", "2016-12-02T19:19:58.4478185Z"],
 [25328, "shipment_shipped", "2016-12-05T20:00:55.7614342Z"],
 [25353, "received_purchase_order", "2016-12-05T20:08:36.3176907Z"],
 [25316, "shipment_canceled", "2016-12-07T15:49:28.0832104Z"],
 [25341, "received_purchase_order", "2016-12-07T19:51:20.0340038Z"],
 [25351, "received_purchase_order", "2016-12-07T19:51:33.392055Z"],
 [25345, "received_purchase_order", "2016-12-07T19:51:49.1377018Z"],
 [25363, "received_purchase_order", "2016-12-07T19:52:44.1156161Z"],
 [25367, "received_purchase_order", "2016-12-07T19:55:44.2499026Z"],
 [25346, "received_purchase_order", "2016-12-07T19:55:59.8397971Z"],
 [25350, "received_purchase_order", "2016-12-07T19:56:11.4346836Z"],
 [25362, "received_purchase_order", "2016-12-07T19:56:28.2886236Z"],
 [25368, "received_purchase_order", "2016-12-07T19:56:41.5220876Z"],
 [25357, "received_purchase_order", "2016-12-07T19:56:54.0220931Z"],
 [25342, "received_purchase_order", "2016-12-07T19:57:04.150085Z"],
 [25361, "received_purchase_order", "2016-12-07T19:57:16.3537424Z"],
 [25364, "received_purchase_order", "2016-12-07T19:57:28.9007252Z"],
 [25354, "received_purchase_order", "2016-12-07T19:57:40.7922686Z"],
 [25358, "received_purchase_order", "2016-12-07T19:57:54.0415079Z"],
 [25366, "received_purchase_order", "2016-12-07T19:58:07.3999871Z"],
 [25359, "received_purchase_order", "2016-12-07T19:58:18.6829082Z"],
 [25304, "shipment_shipped", "2016-12-08T16:34:32.8810563Z"],
 [25298, "shipment_shipped", "2016-12-10T14:59:37.9647091Z"],
 [25344, "order_fulfilled", "2016-12-10T15:56:16Z"],
 [25365, "order_fulfilled", "2016-12-10T15:56:16Z"],
 [25294, "shipment_canceled", "2016-12-10T18:37:33.6837261Z"],
 [25296, "shipment_canceled", "2016-12-10T20:26:08.1725456Z"],
 [25355, "received_purchase_order", "2016-12-14T13:01:59.5573545Z"],
 [25360, "received_purchase_order", "2016-12-19T13:22:28.1227622Z"],
 [25335, "shipment_canceled", "2016-12-20T04:26:43.9000681Z"],
 [25311, "shipment_canceled", "2016-12-21T12:54:36.9501626Z"],
 [25321, "shipment_canceled", "2016-12-21T15:43:32.9367747Z"],
 [25370, "shipment_canceled", "2016-12-21T22:12:19.1088803Z"]]