GET
/
warehouse
/
reporting
/
asn
curl --request GET \
  --url https://api.loopreturns.com/api/v1/warehouse/reporting/asn \
  --header 'X-Authorization: <api-key>'
[
  {
    "id": 17,
    "return_line_item_id": "36",
    "order_id": "2685651685584",
    "order_name": "#1138",
    "order_number": "138",
    "provider_order_number": "1138",
    "state": "open",
    "customer_email": "h.testman@loopreturns.com",
    "title": "Mens Large Hydrostatic Inflatable PFD",
    "purchase_price": "199.99",
    "sku": "ad-alias-corporis-cum-ut-facilis-sed-non",
    "barcode": "789765484987",
    "carrier": "USPS",
    "service": "Parcel Select",
    "label_status": "out_for_delivery",
    "tracking_number": "9999999999999999999999",
    "integration_tracking_url": "N/A",
    "restock_status": "restocked",
    "currency": "USD",
    "label_updated_at": "2023-08-21T14:09:17.000Z",
    "label_url": "https://test-bucket.s3-us-west-2.amazonaws.com/files/postage_label/01234567/0df7eea6147b44b7ac204e9eb8293cfa.pdf",
    "label_rate": "250",
    "closed_at": "2023-09-01T14:00:41.000Z",
    "updated_at": "2023-08-21T14:06:32.000Z",
    "created_at": "2023-08-21T14:05:56.000Z",
    "return_reason": "Size was too small",
    "actioned_by": "N/A",
    "return_method": "happy-returns",
    "return_method_rma_code": "HR01234",
    "return_method_state": "in_transit",
    "date_delivered": "N/A",
    "outcome": "exchange",
    "scannable_id": "N/A",
    "package_reference": "9999999999999999999999",
    "shipping_box_barcode": "N/A",
    "provider_created_at": "2021-01-01T10:00:00.000Z",
    "destination_id": "17",
    "destination_name": "Maine Warehouse",
    "destination_address1": "55 Maine Street",
    "destination_address2": "Unit 3",
    "destination_city": "Portland",
    "destination_state": "Maine",
    "destination_zip": "54321",
    "consolidation_tracking": "N/A"
  }
]

Authorizations

​
X-Authorization
string
header
required

Query Parameters

​
from
string
Example:

"2023-08-21T00:00:00.000Z"

​
to
string
Example:

"2023-08-21T00:00:00.000Z"

Response

200
application/json
Success
​
id
integer

The unique identifier associated with the ASN report.

Example:

17

​
return_line_item_id
string

The unique identifier associated with the line item.

Example:

"36"

​
order_id
string

The unique identifier associated with the order.

Example:

"2685651685584"

​
order_name
string

The name of the order.

Example:

"#1138"

​
order_number
string

The order number.

Example:

"138"

​
provider_order_number
string

The Shopify or other provider order number.

Example:

"1138"

​
state
enum<string>

The status of the return.

Available options:
open,
closed,
expired,
cancelled,
review
​
customer_email
string

The customer's email address.

Example:

"h.testman@loopreturns.com"

​
title
string

The product's name.

Example:

"Mens Large Hydrostatic Inflatable PFD"

​
purchase_price
string

The product's purchase price.

Example:

"199.99"

​
sku
string

The SKU associated with the product.

Example:

"ad-alias-corporis-cum-ut-facilis-sed-non"

​
barcode
string

The barcode of the product.

Example:

"789765484987"

​
carrier
string

The carrier associated with the return.

Example:

"USPS"

​
service
string

The service used to ship the return.

Example:

"Parcel Select"

​
label_status
string

The delivery status of the return.

Example:

"out_for_delivery"

​
tracking_number
string

The tracking number associated with the return.

Example:

"9999999999999999999999"

​
integration_tracking_url
string

The link to the tracking details.

Example:

"N/A"

​
restock_status
string

The restock status of the return.

Example:

"restocked"

​
currency
string

The currency code of the store's default currency.

Example:

"USD"

​
label_updated_at
string

The date and time at which the label was last updated, using the ISO 8601 date format.

Example:

"2023-08-21T14:09:17.000Z"

​
label_url
string

The link to the shipping label.

Example:

"https://test-bucket.s3-us-west-2.amazonaws.com/files/postage_label/01234567/0df7eea6147b44b7ac204e9eb8293cfa.pdf"

​
label_rate
string

The shipping rate paid for the return label.

Example:

"250"

​
closed_at
string

The date and time at which the return was closed, using the ISO 8601 date format.

Example:

"2023-09-01T14:00:41.000Z"

​
updated_at
string

The date and time at which the return was last updated, using the ISO 8601 date format.

Example:

"2023-08-21T14:06:32.000Z"

​
created_at
string

The date and time at which the return was created, using the ISO 8601 date format.

Example:

"2023-08-21T14:05:56.000Z"

​
return_reason
string

The specific reason for return given by the customer.

Example:

"Size was too small"

​
actioned_by
string

The method in which the return was actioned.

Example:

"N/A"

​
return_method
string

The return method.

Example:

"happy-returns"

​
return_method_rma_code
string

The return material authorization code.

Example:

"HR01234"

​
return_method_state
string

The status of the return.

Example:

"in_transit"

​
date_delivered
string

The delivery date of the return.

Example:

"N/A"

​
outcome
enum<string>

The outcome of the return as limited by the merchant and as selected by the customer.

Available options:
exchange,
upsell,
refund,
credit,
exchange+refund,
exchange+credit
​
scannable_id
string

The scannable identifier of the return.

Example:

"N/A"

​
package_reference
string

The package reference of the return.

Example:

"9999999999999999999999"

​
shipping_box_barcode
string

The barcode for the box in which the return was shipped.

Example:

"N/A"

​
provider_created_at
string

The date and time at which the return was created by the provider, using the ISO 8601 date format.

Example:

"2021-01-01T10:00:00.000Z"

​
destination_id
string

The unique identifier associated with the return's destination.

Example:

"17"

​
destination_name
string

The name of the destination.

Example:

"Maine Warehouse"

​
destination_address1
string

The street address of the destination.

Example:

"55 Maine Street"

​
destination_address2
string

The secondary address details of the destination.

Example:

"Unit 3"

​
destination_city
string

The city in which the destination is located.

Example:

"Portland"

​
destination_state
string

The state in which the destination is located.

Example:

"Maine"

​
destination_zip
string

The ZIP code of the destination.

Example:

"54321"

​
consolidation_tracking
string

If a line item is part of a consolidated shipment of many return items, this value holds the tracking value for the consolidated shipment that contains this item such as the Happy Returns Outbound Shipment tracking number.

Example:

"N/A"