Report Standard
GETLifetime Sales Card
{{magento_base_url}}rest/V1/mpreports/card/lifetimeSales
HEADERS
Content-Type
application/json
Authorization
Bearer {{admin_token}}
PARAMS
startDate
2020-02-09
endDate
2020-03-09
compareStartDate
compareEndDate
store
1
group
3
website
2
Example Request
Lifetime Sales Card Filter by Store ID
curl
curl --location -g '{{magento_base_url}}rest/V1/mpreports/card/lifetimeSales?store=1' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {{admin_token}}'200 OK
Example Response
json
{
"name": "lifetimeSales",
"data": {
"total": "$74.00"
}
}Date
Tue, 10 Mar 2020 02:12:26 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control
no-store, no-cache, must-revalidate
Pragma
no-cache
Set-Cookie
PHPSESSID=cjmklu1fkarqd28j4mirrg6657; expires=Tue, 10-Mar-2020 03:12:26 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
X-Frame-Options
SAMEORIGIN
Content-Length
50
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Content-Type
application/json; charset=utf-8
GETAverage Order Card
{{magento_base_url}}rest/V1/mpreports/card/averageOrder
HEADERS
Content-Type
application/json
Authorization
Bearer {{admin_token}}
PARAMS
startDate
2020-03-03
endDate
2020-03-03
compareStartDate
compareEndDate
store
3
group
3
website
2
Example Request
Average Order Card
curl
curl --location -g '{{magento_base_url}}rest/V1/mpreports/card/averageOrder' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {{admin_token}}'200 OK
Example Response
json
{
"name": "averageOrder",
"data": {
"total": "$32.80"
}
}Date
Tue, 10 Mar 2020 02:13:02 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control
no-store, no-cache, must-revalidate
Pragma
no-cache
Set-Cookie
PHPSESSID=cjmklu1fkarqd28j4mirrg6657; expires=Tue, 10-Mar-2020 03:13:03 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
X-Frame-Options
SAMEORIGIN
Content-Length
49
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Content-Type
application/json; charset=utf-8
GETLast Orders Card
{{magento_base_url}}rest/V1/mpreports/card/lastOrders
HEADERS
Content-Type
application/json
Authorization
Bearer {{admin_token}}
PARAMS
startDate
2020-03-03
endDate
2020-03-03
compareStartDate
compareEndDate
store
3
group
3
website
2
Example Request
Last Orders Card
curl
curl --location -g '{{magento_base_url}}rest/V1/mpreports/card/lastOrders' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {{admin_token}}'200 OK
Example Response
json
{
"name": "lastOrders",
"data": [
{
"entity_id": "15",
"state": "new",
"status": "pending",
"coupon_code": null,
"protect_code": "3900f41df6005fe5b155629e71210be0",
"shipping_description": "Flat Rate - Fixed",
"is_virtual": "0",
"store_id": "1",
"customer_id": null,
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_grand_total": "50.0000",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_invoiced": null,
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "45.0000",
"base_subtotal_canceled": null,
"base_subtotal_invoiced": null,
"base_subtotal_refunded": null,
"base_tax_amount": "0.0000",
"base_tax_canceled": null,
"base_tax_invoiced": null,
"base_tax_refunded": null,
"base_to_global_rate": "1.0000",
"base_to_order_rate": "1.0000",
"base_total_canceled": null,
"base_total_invoiced": null,
"base_total_invoiced_cost": null,
"base_total_offline_refunded": null,
"base_total_online_refunded": null,
"base_total_paid": null,
"base_total_qty_ordered": null,
"base_total_refunded": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_invoiced": null,
"discount_refunded": null,
"grand_total": "50.0000",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_invoiced": null,
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"shipping_tax_refunded": null,
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "45.0000",
"subtotal_canceled": null,
"subtotal_invoiced": null,
"subtotal_refunded": null,
"tax_amount": "0.0000",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_invoiced": null,
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "1.0000",
"total_refunded": null,
"can_ship_partially": null,
"can_ship_partially_item": null,
"customer_is_guest": "1",
"customer_note_notify": "1",
"billing_address_id": "30",
"customer_group_id": "0",
"edit_increment": null,
"email_sent": "1",
"send_email": "1",
"forced_shipment_with_invoice": null,
"payment_auth_expiration": null,
"quote_address_id": null,
"quote_id": "21",
"shipping_address_id": "29",
"adjustment_negative": null,
"adjustment_positive": null,
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_shipping_discount_amount": "0.0000",
"base_subtotal_incl_tax": "45.0000",
"base_total_due": "50.0000",
"payment_authorization_amount": null,
"shipping_discount_amount": "0.0000",
"subtotal_incl_tax": "45.0000",
"total_due": "50.0000",
"weight": "0.0000",
"customer_dob": null,
"increment_id": "000000010",
"applied_rule_ids": null,
"base_currency_code": "USD",
"customer_email": "test1@mail.com",
"customer_firstname": "Hang",
"customer_lastname": "Nguyen",
"customer_middlename": null,
"customer_prefix": null,
"customer_suffix": null,
"customer_taxvat": null,
"discount_description": null,
"ext_customer_id": null,
"ext_order_id": null,
"global_currency_code": "USD",
"hold_before_state": null,
"hold_before_status": null,
"order_currency_code": "USD",
"original_increment_id": null,
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"shipping_method": "flatrate_flatrate",
"store_currency_code": "USD",
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"x_forwarded_for": null,
"customer_note": null,
"created_at": "2020-03-09 10:45:38",
"updated_at": "2020-03-09 10:45:42",
"total_item_count": "1",
"customer_gender": null,
"discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"base_discount_tax_compensation_refunded": null,
"shipping_incl_tax": "5.0000",
"base_shipping_incl_tax": "5.0000",
"coupon_rule_name": null,
"gift_message_id": null,
"paypal_ipn_customer_notified": "0",
"items_count": "1",
"customer": "Hang Nguyen",
"revenue": "45.00000000"
},
{
"entity_id": "14",
"state": "new",
"status": "pending",
"coupon_code": null,
"protect_code": "82119faafe48f35b15c39abed7ca39f0",
"shipping_description": "Flat Rate - Fixed",
"is_virtual": "0",
"store_id": "3",
"customer_id": "5",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_grand_total": "27.0000",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_invoiced": null,
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "22.0000",
"base_subtotal_canceled": null,
"base_subtotal_invoiced": null,
"base_subtotal_refunded": null,
"base_tax_amount": "0.0000",
"base_tax_canceled": null,
"base_tax_invoiced": null,
"base_tax_refunded": null,
"base_to_global_rate": "1.0000",
"base_to_order_rate": "1.0000",
"base_total_canceled": null,
"base_total_invoiced": null,
"base_total_invoiced_cost": null,
"base_total_offline_refunded": null,
"base_total_online_refunded": null,
"base_total_paid": null,
"base_total_qty_ordered": null,
"base_total_refunded": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_invoiced": null,
"discount_refunded": null,
"grand_total": "27.0000",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_invoiced": null,
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"shipping_tax_refunded": null,
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "22.0000",
"subtotal_canceled": null,
"subtotal_invoiced": null,
"subtotal_refunded": null,
"tax_amount": "0.0000",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_invoiced": null,
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "1.0000",
"total_refunded": null,
"can_ship_partially": null,
"can_ship_partially_item": null,
"customer_is_guest": "0",
"customer_note_notify": "1",
"billing_address_id": "28",
"customer_group_id": "1",
"edit_increment": null,
"email_sent": "1",
"send_email": "1",
"forced_shipment_with_invoice": null,
"payment_auth_expiration": null,
"quote_address_id": null,
"quote_id": "20",
"shipping_address_id": "27",
"adjustment_negative": null,
"adjustment_positive": null,
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_shipping_discount_amount": "0.0000",
"base_subtotal_incl_tax": "22.0000",
"base_total_due": "27.0000",
"payment_authorization_amount": null,
"shipping_discount_amount": "0.0000",
"subtotal_incl_tax": "22.0000",
"total_due": "27.0000",
"weight": "1.0000",
"customer_dob": null,
"increment_id": "3000000003",
"applied_rule_ids": null,
"base_currency_code": "USD",
"customer_email": "test@mail.com",
"customer_firstname": "test",
"customer_lastname": "test",
"customer_middlename": null,
"customer_prefix": null,
"customer_suffix": null,
"customer_taxvat": null,
"discount_description": null,
"ext_customer_id": null,
"ext_order_id": null,
"global_currency_code": "USD",
"hold_before_state": null,
"hold_before_status": null,
"order_currency_code": "USD",
"original_increment_id": null,
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"shipping_method": "flatrate_flatrate",
"store_currency_code": "USD",
"store_name": "Site 2\nStore 2\nUK",
"x_forwarded_for": null,
"customer_note": null,
"created_at": "2020-03-09 04:49:16",
"updated_at": "2020-03-09 04:49:19",
"total_item_count": "1",
"customer_gender": null,
"discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"base_discount_tax_compensation_refunded": null,
"shipping_incl_tax": "5.0000",
"base_shipping_incl_tax": "5.0000",
"coupon_rule_name": null,
"gift_message_id": null,
"paypal_ipn_customer_notified": "0",
"items_count": "1",
"customer": "test test",
"revenue": "22.00000000"
},
{
"entity_id": "13",
"state": "new",
"status": "pending",
"coupon_code": null,
"protect_code": "a959a60ae19a267175601d62387e8be7",
"shipping_description": "Flat Rate - Fixed",
"is_virtual": "0",
"store_id": "3",
"customer_id": "4",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_grand_total": "53.7100",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_invoiced": null,
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "45.0000",
"base_subtotal_canceled": null,
"base_subtotal_invoiced": null,
"base_subtotal_refunded": null,
"base_tax_amount": "3.7100",
"base_tax_canceled": null,
"base_tax_invoiced": null,
"base_tax_refunded": null,
"base_to_global_rate": "1.0000",
"base_to_order_rate": "1.0000",
"base_total_canceled": null,
"base_total_invoiced": null,
"base_total_invoiced_cost": null,
"base_total_offline_refunded": null,
"base_total_online_refunded": null,
"base_total_paid": null,
"base_total_qty_ordered": null,
"base_total_refunded": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_invoiced": null,
"discount_refunded": null,
"grand_total": "53.7100",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_invoiced": null,
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"shipping_tax_refunded": null,
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "45.0000",
"subtotal_canceled": null,
"subtotal_invoiced": null,
"subtotal_refunded": null,
"tax_amount": "3.7100",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_invoiced": null,
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "1.0000",
"total_refunded": null,
"can_ship_partially": null,
"can_ship_partially_item": null,
"customer_is_guest": "0",
"customer_note_notify": "1",
"billing_address_id": "26",
"customer_group_id": "1",
"edit_increment": null,
"email_sent": null,
"send_email": null,
"forced_shipment_with_invoice": null,
"payment_auth_expiration": null,
"quote_address_id": null,
"quote_id": "17",
"shipping_address_id": "25",
"adjustment_negative": null,
"adjustment_positive": null,
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_shipping_discount_amount": "0.0000",
"base_subtotal_incl_tax": "48.7100",
"base_total_due": "53.7100",
"payment_authorization_amount": null,
"shipping_discount_amount": "0.0000",
"subtotal_incl_tax": "48.7100",
"total_due": "53.7100",
"weight": "1.0000",
"customer_dob": "1973-12-15 00:00:00",
"increment_id": "3000000002",
"applied_rule_ids": null,
"base_currency_code": "USD",
"customer_email": "roni_cost@example.com",
"customer_firstname": "Veronica",
"customer_lastname": "Costello",
"customer_middlename": null,
"customer_prefix": null,
"customer_suffix": null,
"customer_taxvat": null,
"discount_description": null,
"ext_customer_id": null,
"ext_order_id": null,
"global_currency_code": "USD",
"hold_before_state": null,
"hold_before_status": null,
"order_currency_code": "USD",
"original_increment_id": null,
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": null,
"shipping_method": "flatrate_flatrate",
"store_currency_code": "USD",
"store_name": "Site 2\nStore 2\nUK",
"x_forwarded_for": null,
"customer_note": null,
"created_at": "2020-03-09 04:47:59",
"updated_at": "2020-03-09 04:47:59",
"total_item_count": "1",
"customer_gender": "2",
"discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"base_discount_tax_compensation_refunded": null,
"shipping_incl_tax": "5.0000",
"base_shipping_incl_tax": "5.0000",
"coupon_rule_name": null,
"gift_message_id": null,
"paypal_ipn_customer_notified": "0",
"items_count": "1",
"customer": "Veronica Costello",
"revenue": "45.00000000"
},
{
"entity_id": "12",
"state": "new",
"status": "pending",
"coupon_code": null,
"protect_code": "b9bf9fa581ded4008f5dc33367aee779",
"shipping_description": "Flat Rate - Fixed",
"is_virtual": "0",
"store_id": "2",
"customer_id": "3",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_grand_total": "39.0000",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_invoiced": null,
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "34.0000",
"base_subtotal_canceled": null,
"base_subtotal_invoiced": null,
"base_subtotal_refunded": null,
"base_tax_amount": "0.0000",
"base_tax_canceled": null,
"base_tax_invoiced": null,
"base_tax_refunded": null,
"base_to_global_rate": "1.0000",
"base_to_order_rate": "1.0000",
"base_total_canceled": null,
"base_total_invoiced": null,
"base_total_invoiced_cost": null,
"base_total_offline_refunded": null,
"base_total_online_refunded": null,
"base_total_paid": null,
"base_total_qty_ordered": null,
"base_total_refunded": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_invoiced": null,
"discount_refunded": null,
"grand_total": "39.0000",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_invoiced": null,
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"shipping_tax_refunded": null,
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "34.0000",
"subtotal_canceled": null,
"subtotal_invoiced": null,
"subtotal_refunded": null,
"tax_amount": "0.0000",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_invoiced": null,
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "1.0000",
"total_refunded": null,
"can_ship_partially": null,
"can_ship_partially_item": null,
"customer_is_guest": "0",
"customer_note_notify": "1",
"billing_address_id": "24",
"customer_group_id": "2",
"edit_increment": null,
"email_sent": "1",
"send_email": "1",
"forced_shipment_with_invoice": null,
"payment_auth_expiration": null,
"quote_address_id": null,
"quote_id": "15",
"shipping_address_id": "23",
"adjustment_negative": null,
"adjustment_positive": null,
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_shipping_discount_amount": "0.0000",
"base_subtotal_incl_tax": "34.0000",
"base_total_due": "39.0000",
"payment_authorization_amount": null,
"shipping_discount_amount": "0.0000",
"subtotal_incl_tax": "34.0000",
"total_due": "39.0000",
"weight": "1.0000",
"customer_dob": null,
"increment_id": "2000000002",
"applied_rule_ids": null,
"base_currency_code": "USD",
"customer_email": "testws@mail.com",
"customer_firstname": "Test",
"customer_lastname": "Wholesale",
"customer_middlename": null,
"customer_prefix": null,
"customer_suffix": null,
"customer_taxvat": null,
"discount_description": null,
"ext_customer_id": null,
"ext_order_id": null,
"global_currency_code": "USD",
"hold_before_state": null,
"hold_before_status": null,
"order_currency_code": "USD",
"original_increment_id": null,
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"shipping_method": "flatrate_flatrate",
"store_currency_code": "USD",
"store_name": "Main Website\nMain Website Store\nVN",
"x_forwarded_for": null,
"customer_note": null,
"created_at": "2020-03-09 04:46:52",
"updated_at": "2020-03-09 04:46:56",
"total_item_count": "1",
"customer_gender": null,
"discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"base_discount_tax_compensation_refunded": null,
"shipping_incl_tax": "5.0000",
"base_shipping_incl_tax": "5.0000",
"coupon_rule_name": null,
"gift_message_id": null,
"paypal_ipn_customer_notified": "0",
"items_count": "1",
"customer": "Test Wholesale",
"revenue": "34.00000000"
},
{
"entity_id": "11",
"state": "new",
"status": "pending",
"coupon_code": null,
"protect_code": "984c72f3d311e1f666ef493bfa69f0d6",
"shipping_description": "Flat Rate - Fixed",
"is_virtual": "0",
"store_id": "1",
"customer_id": "3",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_grand_total": "59.0000",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_invoiced": null,
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "54.0000",
"base_subtotal_canceled": null,
"base_subtotal_invoiced": null,
"base_subtotal_refunded": null,
"base_tax_amount": "0.0000",
"base_tax_canceled": null,
"base_tax_invoiced": null,
"base_tax_refunded": null,
"base_to_global_rate": "1.0000",
"base_to_order_rate": "1.0000",
"base_total_canceled": null,
"base_total_invoiced": null,
"base_total_invoiced_cost": null,
"base_total_offline_refunded": null,
"base_total_online_refunded": null,
"base_total_paid": null,
"base_total_qty_ordered": null,
"base_total_refunded": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_invoiced": null,
"discount_refunded": null,
"grand_total": "59.0000",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_invoiced": null,
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"shipping_tax_refunded": null,
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "54.0000",
"subtotal_canceled": null,
"subtotal_invoiced": null,
"subtotal_refunded": null,
"tax_amount": "0.0000",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_invoiced": null,
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "1.0000",
"total_refunded": null,
"can_ship_partially": null,
"can_ship_partially_item": null,
"customer_is_guest": "0",
"customer_note_notify": "1",
"billing_address_id": "22",
"customer_group_id": "2",
"edit_increment": null,
"email_sent": "1",
"send_email": "1",
"forced_shipment_with_invoice": null,
"payment_auth_expiration": null,
"quote_address_id": null,
"quote_id": "14",
"shipping_address_id": "21",
"adjustment_negative": null,
"adjustment_positive": null,
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_shipping_discount_amount": "0.0000",
"base_subtotal_incl_tax": "54.0000",
"base_total_due": "59.0000",
"payment_authorization_amount": null,
"shipping_discount_amount": "0.0000",
"subtotal_incl_tax": "54.0000",
"total_due": "59.0000",
"weight": "1.0000",
"customer_dob": null,
"increment_id": "000000009",
"applied_rule_ids": "2",
"base_currency_code": "USD",
"customer_email": "testws@mail.com",
"customer_firstname": "Test",
"customer_lastname": "Wholesale",
"customer_middlename": null,
"customer_prefix": null,
"customer_suffix": null,
"customer_taxvat": null,
"discount_description": null,
"ext_customer_id": null,
"ext_order_id": null,
"global_currency_code": "USD",
"hold_before_state": null,
"hold_before_status": null,
"order_currency_code": "USD",
"original_increment_id": null,
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"shipping_method": "flatrate_flatrate",
"store_currency_code": "USD",
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"x_forwarded_for": null,
"customer_note": null,
"created_at": "2020-03-09 04:45:54",
"updated_at": "2020-03-09 04:45:58",
"total_item_count": "1",
"customer_gender": null,
"discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"base_discount_tax_compensation_refunded": null,
"shipping_incl_tax": "5.0000",
"base_shipping_incl_tax": "5.0000",
"coupon_rule_name": null,
"gift_message_id": null,
"paypal_ipn_customer_notified": "0",
"items_count": "1",
"customer": "Test Wholesale",
"revenue": "54.00000000"
}
]
}Date
Tue, 10 Mar 2020 02:16:23 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control
no-store, no-cache, must-revalidate
Pragma
no-cache
Set-Cookie
PHPSESSID=cjmklu1fkarqd28j4mirrg6657; expires=Tue, 10-Mar-2020 03:16:23 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
X-Frame-Options
SAMEORIGIN
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Transfer-Encoding
chunked
Content-Type
application/json; charset=utf-8
GETLast Search Terms Card
{{magento_base_url}}rest/V1/mpreports/card/lastSearches
HEADERS
Content-Type
application/json
Authorization
Bearer {{admin_token}}
PARAMS
startDate
2020-03-03
endDate
2020-03-03
compareStartDate
compareEndDate
store
5
group
3
website
2
Example Request
Last Search Terms Card
curl
curl --location -g '{{magento_base_url}}rest/V1/mpreports/card/lastSearches' \
--header 'Content-Type: application/json' \
--header 'Authorization: Bearer {{admin_token}}'200 OK
Example Response
json
{
"name": "lastSearches",
"data": [
{
"query_id": "1",
"query_text": "bag",
"num_results": "10",
"popularity": "2",
"redirect": null,
"store_id": "1",
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"updated_at": "2020-03-04 10:45:44"
},
{
"query_id": "19",
"query_text": "tag",
"num_results": "1",
"popularity": "1",
"redirect": null,
"store_id": "1",
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"updated_at": "2020-03-04 10:45:28"
},
{
"query_id": "17",
"query_text": "tag",
"num_results": "1",
"popularity": "1",
"redirect": null,
"store_id": "3",
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"updated_at": "2020-03-04 10:45:14"
},
{
"query_id": "15",
"query_text": "tank",
"num_results": "23",
"popularity": "1",
"redirect": null,
"store_id": "3",
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"updated_at": "2020-03-04 10:44:56"
},
{
"query_id": "13",
"query_text": "gear",
"num_results": "5",
"popularity": "1",
"redirect": null,
"store_id": "3",
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"updated_at": "2020-03-04 10:44:42"
}
]
}Date
Tue, 10 Mar 2020 02:17:15 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Thu, 19 Nov 1981 08:52:00 GMT
Cache-Control
no-store, no-cache, must-revalidate
Pragma
no-cache
Set-Cookie
PHPSESSID=cjmklu1fkarqd28j4mirrg6657; expires=Tue, 10-Mar-2020 03:17:15 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
X-Frame-Options
SAMEORIGIN
Content-Length
1015
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Content-Type
application/json; charset=utf-8