Report Standard GraphQL
POSTLifetime Sales Card
{{magento_base_url}}graphql
HEADERS
Content-Type
application/json
Example Request
Lifetime Sales Card
curl
curl --location -g '{{magento_base_url}}graphql' \
--header 'Content-Type: application/json' \
--data '{"query":"query {\r\n\tmpReportsLifetimeSalesCard(\r\n\t\tfilters: { accessToken: \"d592rvtv8ey3zr9yr2fmmlyrfsusqrvn\", store: \"1\" }\r\n\t) {\r\n\t\ttotal\r\n\t}\r\n}","variables":{}}'200 OK
Example Response
json
{
"data": {
"mpReportsLifetimeSalesCard": {
"total": "$194.10"
}
}
}Date
Tue, 10 Mar 2020 09:07:22 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Sun, 10 Mar 2019 09:07:22 GMT
Cache-Control
max-age=0, must-revalidate, no-cache, no-store
Pragma
no-cache
Set-Cookie
PHPSESSID=rl1d9cf8rlr63l5f1fi73ndcsc; expires=Tue, 10-Mar-2020 10:07:22 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
Set-Cookie
private_content_version=8c3dfd633038dae6620d0eb968cc9d5f; expires=Fri, 08-Mar-2030 09:07:22 GMT; Max-Age=315360000; path=/
X-Magento-Tags
FPC
X-Content-Type-Options
nosniff
X-XSS-Protection
1; mode=block
X-Frame-Options
SAMEORIGIN
Content-Length
59
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Content-Type
application/json
POSTAverage Order Card
{{magento_base_url}}graphql
HEADERS
Content-Type
application/json
Example Request
Average Order Card
curl
curl --location -g '{{magento_base_url}}graphql' \
--header 'Content-Type: application/json' \
--data '{"query":"query {\r\n\tmpReportsAverageOrderCard(\r\n\t\tfilters: { accessToken: \"d592rvtv8ey3zr9yr2fmmlyrfsusqrvn\", store: \"1\" }\r\n\t) {\r\n\t\ttotal\r\n\t}\r\n}","variables":{}}'200 OK
Example Response
json
{
"data": {
"mpReportsAverageOrderCard": {
"total": "$27.73"
}
}
}Date
Tue, 10 Mar 2020 09:12:22 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Sun, 10 Mar 2019 09:12:23 GMT
Cache-Control
max-age=0, must-revalidate, no-cache, no-store
Pragma
no-cache
Set-Cookie
PHPSESSID=rl1d9cf8rlr63l5f1fi73ndcsc; expires=Tue, 10-Mar-2020 10:12:22 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
Set-Cookie
private_content_version=bab54916e892511edc2f3728b10ffa64; expires=Fri, 08-Mar-2030 09:12:22 GMT; Max-Age=315360000; path=/
X-Magento-Tags
FPC
X-Content-Type-Options
nosniff
X-XSS-Protection
1; mode=block
X-Frame-Options
SAMEORIGIN
Content-Length
57
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Content-Type
application/json
POSTLast Orders Card
{{magento_base_url}}graphql
HEADERS
Content-Type
application/json
Example Request
Last Orders Card
curl
curl --location -g '{{magento_base_url}}graphql' \
--header 'Content-Type: application/json' \
--data '{"query":"query {\r\n\tmpReportsLastOrdersCard(\r\n\t\tfilters: { accessToken: \"d592rvtv8ey3zr9yr2fmmlyrfsusqrvn\", store: \"1\" }\r\n\t) {\r\n\t\titems{\r\n adjustment_negative\r\n adjustment_positive\r\n applied_rule_ids\r\n base_adjustment_negative\r\n base_adjustment_positive\r\n base_currency_code\r\n base_discount_amount\r\n base_discount_canceled\r\n base_discount_invoiced\r\n base_discount_refunded\r\n base_discount_tax_compensation_amount\r\n base_discount_tax_compensation_invoiced\r\n base_discount_tax_compensation_refunded\r\n base_grand_total\r\n base_shipping_amount\r\n base_shipping_canceled\r\n base_shipping_discount_amount\r\n base_shipping_discount_tax_compensation_amnt\r\n base_shipping_incl_tax\r\n base_shipping_invoiced\r\n base_shipping_refunded\r\n base_shipping_tax_amount\r\n base_shipping_tax_refunded\r\n base_subtotal\r\n base_subtotal_canceled\r\n base_subtotal_incl_tax\r\n base_subtotal_invoiced\r\n base_subtotal_refunded\r\n base_tax_amount\r\n base_tax_canceled\r\n base_tax_invoiced\r\n base_tax_refunded\r\n base_to_global_rate\r\n base_to_order_rate\r\n base_total_canceled\r\n base_total_due\r\n base_total_invoiced\r\n base_total_invoiced_cost\r\n base_total_offline_refunded\r\n base_total_online_refunded\r\n base_total_paid\r\n base_total_qty_ordered\r\n base_total_refunded\r\n billing_address_id\r\n can_ship_partially\r\n can_ship_partially_item\r\n coupon_code\r\n coupon_rule_name\r\n created_at\r\n customer\r\n customer_dob\r\n customer_email\r\n customer_firstname\r\n customer_gender\r\n customer_group_id\r\n customer_id\r\n customer_is_guest\r\n customer_lastname\r\n customer_middlename\r\n customer_note\r\n customer_note_notify\r\n customer_suffix\r\n customer_prefix\r\n customer_taxvat\r\n discount_amount\r\n discount_canceled\r\n discount_description\r\n discount_invoiced\r\n discount_refunded\r\n discount_tax_compensation_amount\r\n discount_tax_compensation_invoiced\r\n discount_tax_compensation_refunded\r\n edit_increment\r\n email_sent\r\n entity_id\r\n ext_customer_id\r\n ext_order_id\r\n forced_shipment_with_invoice\r\n gift_message_id\r\n global_currency_code\r\n grand_total\r\n hold_before_state\r\n hold_before_status\r\n increment_id\r\n is_virtual\r\n items_count\r\n order_currency_code\r\n original_increment_id\r\n payment_auth_expiration\r\n payment_authorization_amount\r\n paypal_ipn_customer_notified\r\n protect_code\r\n quote_address_id\r\n quote_id\r\n relation_child_id\r\n relation_child_real_id\r\n relation_parent_id\r\n relation_parent_real_id\r\n remote_ip\r\n revenue\r\n send_email\r\n shipping_address_id\r\n shipping_amount\r\n shipping_canceled\r\n shipping_description\r\n shipping_discount_amount\r\n shipping_discount_tax_compensation_amount\r\n shipping_incl_tax\r\n subtotal_invoiced\r\n shipping_method\r\n shipping_refunded\r\n shipping_tax_amount\r\n state\r\n status\r\n store_currency_code\r\n store_id\r\n store_name\r\n store_to_base_rate\r\n store_to_order_rate\r\n subtotal\r\n subtotal_canceled\r\n subtotal_invoiced\r\n subtotal_refunded\r\n subtotal_incl_tax\r\n tax_amount\r\n tax_canceled\r\n tax_invoiced\r\n tax_refunded\r\n total_canceled\r\n total_due\r\n total_invoiced\r\n total_refunded\r\n total_item_count\r\n total_offline_refunded\r\n total_online_refunded\r\n total_paid\r\n total_qty_ordered\r\n updated_at\r\n weight\r\n x_forwarded_for\r\n }\r\n\t}\r\n}","variables":{}}'200 OK
Example Response
json
{
"data": {
"mpReportsLastOrdersCard": {
"items": [
{
"adjustment_negative": null,
"adjustment_positive": null,
"applied_rule_ids": "2",
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_currency_code": "USD",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_refunded": null,
"base_grand_total": "123.0600",
"base_shipping_amount": "10.0000",
"base_shipping_canceled": null,
"base_shipping_discount_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"base_shipping_incl_tax": "10.0000",
"base_shipping_invoiced": null,
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "113.0000",
"base_subtotal_canceled": null,
"base_subtotal_incl_tax": "113.0600",
"base_subtotal_invoiced": null,
"base_subtotal_refunded": null,
"base_tax_amount": "0.0600",
"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_due": "123.0600",
"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,
"billing_address_id": "40",
"can_ship_partially": null,
"can_ship_partially_item": null,
"coupon_code": null,
"coupon_rule_name": null,
"created_at": "2020-03-10 08:20:11",
"customer": "Veronica Costello",
"customer_dob": "1973-12-15 00:00:00",
"customer_email": "roni_cost@example.com",
"customer_firstname": "Veronica",
"customer_gender": "2",
"customer_group_id": "1",
"customer_id": "1",
"customer_is_guest": "0",
"customer_lastname": "Costello",
"customer_middlename": null,
"customer_note": null,
"customer_note_notify": "1",
"customer_suffix": null,
"customer_prefix": null,
"customer_taxvat": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_description": null,
"discount_invoiced": null,
"discount_refunded": null,
"discount_tax_compensation_amount": "0.0000",
"discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"edit_increment": null,
"email_sent": "1",
"entity_id": "20",
"ext_customer_id": null,
"ext_order_id": null,
"forced_shipment_with_invoice": null,
"gift_message_id": null,
"global_currency_code": "USD",
"grand_total": "123.0600",
"hold_before_state": null,
"hold_before_status": null,
"increment_id": "000000015",
"is_virtual": "0",
"items_count": "2",
"order_currency_code": "USD",
"original_increment_id": null,
"payment_auth_expiration": null,
"payment_authorization_amount": null,
"paypal_ipn_customer_notified": "0",
"protect_code": "f1307c3fa3bb66151a364f4dac09cb02",
"quote_address_id": null,
"quote_id": "22",
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"revenue": "113.0000",
"send_email": "1",
"shipping_address_id": "39",
"shipping_amount": "10.0000",
"shipping_canceled": null,
"shipping_description": "Flat Rate - Fixed",
"shipping_discount_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"shipping_incl_tax": "10.0000",
"subtotal_invoiced": null,
"shipping_method": "flatrate_flatrate",
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"state": "processing",
"status": "processing",
"store_currency_code": "USD",
"store_id": "1",
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "113.0000",
"subtotal_canceled": null,
"subtotal_refunded": null,
"subtotal_incl_tax": "113.0600",
"tax_amount": "0.0600",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_due": "123.0600",
"total_invoiced": null,
"total_refunded": null,
"total_item_count": "2",
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "2.0000",
"updated_at": "2020-03-10 08:20:15",
"weight": "1.0000",
"x_forwarded_for": null
},
{
"adjustment_negative": null,
"adjustment_positive": null,
"applied_rule_ids": null,
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_currency_code": "USD",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_refunded": null,
"base_grand_total": "50.0000",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_discount_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"base_shipping_incl_tax": "5.0000",
"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_incl_tax": "45.0000",
"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_due": "50.0000",
"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,
"billing_address_id": "38",
"can_ship_partially": null,
"can_ship_partially_item": null,
"coupon_code": null,
"coupon_rule_name": null,
"created_at": "2020-03-10 07:32:06",
"customer": "Test Retail",
"customer_dob": null,
"customer_email": "testrt@mail.com",
"customer_firstname": "Test",
"customer_gender": null,
"customer_group_id": "3",
"customer_id": "2",
"customer_is_guest": "0",
"customer_lastname": "Retail",
"customer_middlename": null,
"customer_note": null,
"customer_note_notify": "1",
"customer_suffix": null,
"customer_prefix": null,
"customer_taxvat": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_description": null,
"discount_invoiced": null,
"discount_refunded": null,
"discount_tax_compensation_amount": "0.0000",
"discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"edit_increment": null,
"email_sent": "1",
"entity_id": "19",
"ext_customer_id": null,
"ext_order_id": null,
"forced_shipment_with_invoice": null,
"gift_message_id": null,
"global_currency_code": "USD",
"grand_total": "50.0000",
"hold_before_state": null,
"hold_before_status": null,
"increment_id": "000000014",
"is_virtual": "0",
"items_count": "1",
"order_currency_code": "USD",
"original_increment_id": null,
"payment_auth_expiration": null,
"payment_authorization_amount": null,
"paypal_ipn_customer_notified": "0",
"protect_code": "2318e5a1489493aef7e829732cf0bfea",
"quote_address_id": null,
"quote_id": "26",
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"revenue": "45.0000",
"send_email": "1",
"shipping_address_id": "37",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_description": "Flat Rate - Fixed",
"shipping_discount_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"shipping_incl_tax": "5.0000",
"subtotal_invoiced": null,
"shipping_method": "flatrate_flatrate",
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"state": "processing",
"status": "processing",
"store_currency_code": "USD",
"store_id": "1",
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "45.0000",
"subtotal_canceled": null,
"subtotal_refunded": null,
"subtotal_incl_tax": "45.0000",
"tax_amount": "0.0000",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_due": "50.0000",
"total_invoiced": null,
"total_refunded": null,
"total_item_count": "1",
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "1.0000",
"updated_at": "2020-03-10 07:32:09",
"weight": "0.0000",
"x_forwarded_for": null
},
{
"adjustment_negative": null,
"adjustment_positive": null,
"applied_rule_ids": null,
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_currency_code": "USD",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": null,
"base_discount_refunded": null,
"base_discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_invoiced": null,
"base_discount_tax_compensation_refunded": null,
"base_grand_total": "50.0000",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_discount_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"base_shipping_incl_tax": "5.0000",
"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_incl_tax": "45.0000",
"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_due": "50.0000",
"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,
"billing_address_id": "36",
"can_ship_partially": null,
"can_ship_partially_item": null,
"coupon_code": null,
"coupon_rule_name": null,
"created_at": "2020-03-10 07:26:54",
"customer": "Test Retail",
"customer_dob": null,
"customer_email": "testrt@mail.com",
"customer_firstname": "Test",
"customer_gender": null,
"customer_group_id": "3",
"customer_id": "2",
"customer_is_guest": "0",
"customer_lastname": "Retail",
"customer_middlename": null,
"customer_note": null,
"customer_note_notify": "1",
"customer_suffix": null,
"customer_prefix": null,
"customer_taxvat": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_description": null,
"discount_invoiced": null,
"discount_refunded": null,
"discount_tax_compensation_amount": "0.0000",
"discount_tax_compensation_invoiced": null,
"discount_tax_compensation_refunded": null,
"edit_increment": null,
"email_sent": "1",
"entity_id": "18",
"ext_customer_id": null,
"ext_order_id": null,
"forced_shipment_with_invoice": null,
"gift_message_id": null,
"global_currency_code": "USD",
"grand_total": "50.0000",
"hold_before_state": null,
"hold_before_status": null,
"increment_id": "000000013",
"is_virtual": "0",
"items_count": "1",
"order_currency_code": "USD",
"original_increment_id": null,
"payment_auth_expiration": null,
"payment_authorization_amount": null,
"paypal_ipn_customer_notified": "0",
"protect_code": "20b600803afc9bb03dd0fab0686ff260",
"quote_address_id": null,
"quote_id": "25",
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"revenue": "45.0000",
"send_email": "1",
"shipping_address_id": "35",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_description": "Flat Rate - Fixed",
"shipping_discount_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"shipping_incl_tax": "5.0000",
"subtotal_invoiced": null,
"shipping_method": "flatrate_flatrate",
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"state": "new",
"status": "pending",
"store_currency_code": "USD",
"store_id": "1",
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "45.0000",
"subtotal_canceled": null,
"subtotal_refunded": null,
"subtotal_incl_tax": "45.0000",
"tax_amount": "0.0000",
"tax_canceled": null,
"tax_invoiced": null,
"tax_refunded": null,
"total_canceled": null,
"total_due": "50.0000",
"total_invoiced": null,
"total_refunded": null,
"total_item_count": "1",
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": null,
"total_qty_ordered": "1.0000",
"updated_at": "2020-03-10 07:26:58",
"weight": "0.0000",
"x_forwarded_for": null
},
{
"adjustment_negative": null,
"adjustment_positive": null,
"applied_rule_ids": "4",
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_currency_code": "USD",
"base_discount_amount": "-4.9000",
"base_discount_canceled": null,
"base_discount_invoiced": "-4.9000",
"base_discount_refunded": null,
"base_discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_invoiced": "0.0000",
"base_discount_tax_compensation_refunded": null,
"base_grand_total": "7.1000",
"base_shipping_amount": "5.0000",
"base_shipping_canceled": null,
"base_shipping_discount_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"base_shipping_incl_tax": "5.0000",
"base_shipping_invoiced": "5.0000",
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "7.0000",
"base_subtotal_canceled": null,
"base_subtotal_incl_tax": "7.0000",
"base_subtotal_invoiced": "7.0000",
"base_subtotal_refunded": null,
"base_tax_amount": "0.0000",
"base_tax_canceled": null,
"base_tax_invoiced": "0.0000",
"base_tax_refunded": null,
"base_to_global_rate": "1.0000",
"base_to_order_rate": "1.0000",
"base_total_canceled": null,
"base_total_due": "0.0000",
"base_total_invoiced": "7.1000",
"base_total_invoiced_cost": "0.0000",
"base_total_offline_refunded": null,
"base_total_online_refunded": null,
"base_total_paid": "7.1000",
"base_total_qty_ordered": null,
"base_total_refunded": null,
"billing_address_id": "34",
"can_ship_partially": null,
"can_ship_partially_item": null,
"coupon_code": "H20",
"coupon_rule_name": "$4 Luma water bottle (save 70%)",
"created_at": "2020-03-10 03:37:57",
"customer": "Hang Nguyen",
"customer_dob": null,
"customer_email": "test1@mail.com",
"customer_firstname": "Hang",
"customer_gender": null,
"customer_group_id": "0",
"customer_id": null,
"customer_is_guest": "1",
"customer_lastname": "Nguyen",
"customer_middlename": null,
"customer_note": null,
"customer_note_notify": "0",
"customer_suffix": null,
"customer_prefix": null,
"customer_taxvat": null,
"discount_amount": "-4.9000",
"discount_canceled": null,
"discount_description": "Use promo code H20 at checkout",
"discount_invoiced": "-4.9000",
"discount_refunded": null,
"discount_tax_compensation_amount": "0.0000",
"discount_tax_compensation_invoiced": "0.0000",
"discount_tax_compensation_refunded": null,
"edit_increment": null,
"email_sent": "1",
"entity_id": "17",
"ext_customer_id": null,
"ext_order_id": null,
"forced_shipment_with_invoice": null,
"gift_message_id": null,
"global_currency_code": "USD",
"grand_total": "7.1000",
"hold_before_state": null,
"hold_before_status": null,
"increment_id": "000000012",
"is_virtual": "0",
"items_count": "1",
"order_currency_code": "USD",
"original_increment_id": null,
"payment_auth_expiration": null,
"payment_authorization_amount": null,
"paypal_ipn_customer_notified": "0",
"protect_code": "4752ef5dee377bcb69ab1914839e4336",
"quote_address_id": null,
"quote_id": "24",
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"revenue": "2.1000",
"send_email": "1",
"shipping_address_id": "33",
"shipping_amount": "5.0000",
"shipping_canceled": null,
"shipping_description": "Flat Rate - Fixed",
"shipping_discount_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"shipping_incl_tax": "5.0000",
"subtotal_invoiced": "7.0000",
"shipping_method": "flatrate_flatrate",
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"state": "complete",
"status": "complete",
"store_currency_code": "USD",
"store_id": "1",
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "7.0000",
"subtotal_canceled": null,
"subtotal_refunded": null,
"subtotal_incl_tax": "7.0000",
"tax_amount": "0.0000",
"tax_canceled": null,
"tax_invoiced": "0.0000",
"tax_refunded": null,
"total_canceled": null,
"total_due": "0.0000",
"total_invoiced": "7.1000",
"total_refunded": null,
"total_item_count": "1",
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": "7.1000",
"total_qty_ordered": "1.0000",
"updated_at": "2020-03-10 03:40:02",
"weight": "0.0000",
"x_forwarded_for": null
},
{
"adjustment_negative": null,
"adjustment_positive": null,
"applied_rule_ids": "2",
"base_adjustment_negative": null,
"base_adjustment_positive": null,
"base_currency_code": "USD",
"base_discount_amount": "0.0000",
"base_discount_canceled": null,
"base_discount_invoiced": "0.0000",
"base_discount_refunded": null,
"base_discount_tax_compensation_amount": "0.0000",
"base_discount_tax_compensation_invoiced": "0.0000",
"base_discount_tax_compensation_refunded": null,
"base_grand_total": "127.7400",
"base_shipping_amount": "0.0000",
"base_shipping_canceled": null,
"base_shipping_discount_amount": "0.0000",
"base_shipping_discount_tax_compensation_amnt": "0.0000",
"base_shipping_incl_tax": "0.0000",
"base_shipping_invoiced": "0.0000",
"base_shipping_refunded": null,
"base_shipping_tax_amount": "0.0000",
"base_shipping_tax_refunded": null,
"base_subtotal": "118.0000",
"base_subtotal_canceled": null,
"base_subtotal_incl_tax": "127.7400",
"base_subtotal_invoiced": "118.0000",
"base_subtotal_refunded": null,
"base_tax_amount": "9.7400",
"base_tax_canceled": null,
"base_tax_invoiced": "9.7400",
"base_tax_refunded": null,
"base_to_global_rate": "1.0000",
"base_to_order_rate": "1.0000",
"base_total_canceled": null,
"base_total_due": "0.0000",
"base_total_invoiced": "127.7400",
"base_total_invoiced_cost": "0.0000",
"base_total_offline_refunded": null,
"base_total_online_refunded": null,
"base_total_paid": "127.7400",
"base_total_qty_ordered": null,
"base_total_refunded": null,
"billing_address_id": "32",
"can_ship_partially": null,
"can_ship_partially_item": null,
"coupon_code": null,
"coupon_rule_name": null,
"created_at": "2020-03-10 03:19:57",
"customer": "Veronica Costello",
"customer_dob": "1973-12-15 00:00:00",
"customer_email": "roni_cost@example.com",
"customer_firstname": "Veronica",
"customer_gender": "2",
"customer_group_id": "1",
"customer_id": "1",
"customer_is_guest": "0",
"customer_lastname": "Costello",
"customer_middlename": null,
"customer_note": null,
"customer_note_notify": "0",
"customer_suffix": null,
"customer_prefix": null,
"customer_taxvat": null,
"discount_amount": "0.0000",
"discount_canceled": null,
"discount_description": null,
"discount_invoiced": "0.0000",
"discount_refunded": null,
"discount_tax_compensation_amount": "0.0000",
"discount_tax_compensation_invoiced": "0.0000",
"discount_tax_compensation_refunded": null,
"edit_increment": null,
"email_sent": "1",
"entity_id": "16",
"ext_customer_id": null,
"ext_order_id": null,
"forced_shipment_with_invoice": null,
"gift_message_id": null,
"global_currency_code": "USD",
"grand_total": "127.7400",
"hold_before_state": null,
"hold_before_status": null,
"increment_id": "000000011",
"is_virtual": "0",
"items_count": "1",
"order_currency_code": "USD",
"original_increment_id": null,
"payment_auth_expiration": null,
"payment_authorization_amount": null,
"paypal_ipn_customer_notified": "0",
"protect_code": "21a1c00198e5ba8f5bf8932ae8fe6b03",
"quote_address_id": null,
"quote_id": "8",
"relation_child_id": null,
"relation_child_real_id": null,
"relation_parent_id": null,
"relation_parent_real_id": null,
"remote_ip": "192.168.1.105",
"revenue": "118.0000",
"send_email": "1",
"shipping_address_id": "31",
"shipping_amount": "0.0000",
"shipping_canceled": null,
"shipping_description": "Best Way - Table Rate",
"shipping_discount_amount": "0.0000",
"shipping_discount_tax_compensation_amount": "0.0000",
"shipping_incl_tax": "0.0000",
"subtotal_invoiced": "118.0000",
"shipping_method": "tablerate_bestway",
"shipping_refunded": null,
"shipping_tax_amount": "0.0000",
"state": "complete",
"status": "complete",
"store_currency_code": "USD",
"store_id": "1",
"store_name": "Main Website\nMain Website Store\nDefault Store View",
"store_to_base_rate": "0.0000",
"store_to_order_rate": "0.0000",
"subtotal": "118.0000",
"subtotal_canceled": null,
"subtotal_refunded": null,
"subtotal_incl_tax": "127.7400",
"tax_amount": "9.7400",
"tax_canceled": null,
"tax_invoiced": "9.7400",
"tax_refunded": null,
"total_canceled": null,
"total_due": "0.0000",
"total_invoiced": "127.7400",
"total_refunded": null,
"total_item_count": "1",
"total_offline_refunded": null,
"total_online_refunded": null,
"total_paid": "127.7400",
"total_qty_ordered": "2.0000",
"updated_at": "2020-03-10 03:41:07",
"weight": "0.0000",
"x_forwarded_for": null
}
]
}
}
}Date
Tue, 10 Mar 2020 09:49:29 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Sun, 10 Mar 2019 09:49:30 GMT
Cache-Control
max-age=0, must-revalidate, no-cache, no-store
Pragma
no-cache
Set-Cookie
PHPSESSID=rl1d9cf8rlr63l5f1fi73ndcsc; expires=Tue, 10-Mar-2020 10:49:29 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
Set-Cookie
private_content_version=90f5ca09edd3544bb3010ac086d58880; expires=Fri, 08-Mar-2030 09:49:30 GMT; Max-Age=315360000; path=/
X-Magento-Tags
FPC
X-Content-Type-Options
nosniff
X-XSS-Protection
1; mode=block
X-Frame-Options
SAMEORIGIN
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Transfer-Encoding
chunked
Content-Type
application/json
POSTLast Searches Card
{{magento_base_url}}graphql
HEADERS
Content-Type
application/json
Example Request
Last Searches Card
curl
curl --location -g '{{magento_base_url}}graphql' \
--header 'Content-Type: application/json' \
--data '{"query":"query {\r\n\tmpReportsLastSearchesCard(\r\n\t\tfilters: { accessToken: \"d592rvtv8ey3zr9yr2fmmlyrfsusqrvn\", store: \"1\" }\r\n\t) {\r\n\t\titems\r\n {\r\n display_in_terms\r\n is_active\r\n is_processed\r\n num_results\r\n popularity\r\n query_id\r\n query_text\r\n redirect\r\n store_id\r\n updated_at\r\n }\r\n }\r\n}","variables":{}}'200 OK
Example Response
json
{
"data": {
"mpReportsLastSearchesCard": {
"items": [
{
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"num_results": "10",
"popularity": "2",
"query_id": "1",
"query_text": "bag",
"redirect": null,
"store_id": "1",
"updated_at": "2020-03-04 10:45:44"
},
{
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"num_results": "1",
"popularity": "1",
"query_id": "19",
"query_text": "tag",
"redirect": null,
"store_id": "1",
"updated_at": "2020-03-04 10:45:28"
},
{
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"num_results": "5",
"popularity": "1",
"query_id": "7",
"query_text": "shirt",
"redirect": null,
"store_id": "1",
"updated_at": "2020-03-04 10:44:12"
},
{
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"num_results": "0",
"popularity": "1",
"query_id": "5",
"query_text": "2046",
"redirect": null,
"store_id": "1",
"updated_at": "2020-03-04 10:44:04"
},
{
"display_in_terms": "1",
"is_active": "1",
"is_processed": "0",
"num_results": "19",
"popularity": "1",
"query_id": "3",
"query_text": "pant",
"redirect": null,
"store_id": "1",
"updated_at": "2020-03-04 10:43:32"
}
]
}
}
}Date
Tue, 10 Mar 2020 10:10:55 GMT
Server
Apache/2.4.38 (Ubuntu)
Expires
Sun, 10 Mar 2019 10:10:55 GMT
Cache-Control
max-age=0, must-revalidate, no-cache, no-store
Pragma
no-cache
Set-Cookie
PHPSESSID=rl1d9cf8rlr63l5f1fi73ndcsc; expires=Tue, 10-Mar-2020 11:10:55 GMT; Max-Age=3600; path=/hang/ce234b; domain=192.168.1.200; HttpOnly
Set-Cookie
private_content_version=6c9190d4e74fea9d00d6247fb32f59d5; expires=Fri, 08-Mar-2030 10:10:55 GMT; Max-Age=315360000; path=/
X-Magento-Tags
FPC
X-Content-Type-Options
nosniff
X-XSS-Protection
1; mode=block
X-Frame-Options
SAMEORIGIN
Content-Length
1032
Keep-Alive
timeout=5, max=100
Connection
Keep-Alive
Content-Type
application/json