Incorrect return query result

GraphQL API
1

Here is the query:
{return(id:“UmV0dXJuOjQ0MzYwMjE=”){request_id data{id partner_id account_id legacy_id label_cost total_items_received total_items_restocked address{name address1 address2 city state country zip phone} order{billing_address{first_name last_name email} order_number rma_labels{id cost tracking_number legacy_id updated_at}} reason status created_at line_items{updated_at id return_id type reason quantity quantity_received restock line_item{sku product_name barcode} condition}}}}

Here is the result:
“data”: {
“return”: {
“request_id”: “63f764e8511283ea125a5650”,
“data”: {
“id”: “UmV0dXJuOjQ0MzYwMjE=”,
“partner_id”: “RMA102417|2016-02-23”,
“account_id”: “QWNjb3VudDo3MDU4Nw==”,
“legacy_id”: 4436021,
“label_cost”: “0.00”,
“total_items_received”: 1,
“total_items_restocked”: 1,
“address”: {
“name”: null,
“address1”: “0 No Street”,
“address2”: “”,
“city”: “Ithaca”,
“state”: “NY”,
“country”: “US”,
“zip”: “14850”,
“phone”: null
},
“order”: {
“billing_address”: {
“first_name”: “Ithaca”,
“last_name”: “Sports”,
“company”: “Customer For RMA102417”,
“email”: null
},
“order_number”: “O_RMA102417”,
“rma_labels”:
},
“reason”: “”,
“status”: “complete”,
“created_at”: “2023-02-22T21:07:12”,
“line_items”: [
{
“updated_at”: “2023-02-23T04:23:39”,
“id”: “UmV0dXJuSXRlbTo3MTAwMzIz”,
“return_id”: “UmV0dXJuOjQ0MzYwMjE=”,
“type”: “refund”,
“reason”: “1|Return from Battle Customer”,
“quantity”: 1,
“quantity_received”: 1,
“restock”: 1,
“line_item”: {
“sku”: “8802”,
“product_name”: “1-White Battle Oxygen MG-Thick Strap”,
“barcode”: “811243020713”
},
“condition”: “unknown”
}
]
}
}
}

Here is what I see on the order in the Shiphero app:
error1

Clearly the order billing_customer has an email. Why is the return query getting null?

2

Hey @bbarrett,

Thanks for reaching out!
Looking into this one now, I’ll update you here shortly.

Best,
RayanP

3

Hey @bbarrett,

Apologies for the late update here!

This is a bug, and I’ve gone ahead and created an Engineering Ticket for this issue.
I’ll update you here once a fix has been deployed.

Please let me know if you have any questions or concerns.

Best,
RayanP

5

Hey @bbarrett,

Thanks for hanging in there!

An engineer was able to confirm that the email field under billing address points to nowhere in our database. Instead to get that field you can call it from the Order field:

{
2  return(id: "string") {
3    request_id
4    complexity
5    data {
6      id
7      account_id
8      partner_id
9      legacy_id
10      label_cost
11      total_items_received
12      total_items_restocked
13      address {
14        name
15        address1
16        address2
17        city
18        state
19        country
20        zip
21        phone
22      }
23      order {
24		email
25        billing_address {
26          first_name
27          last_name
28          company
29        }
30      }
31    }
32  }
33}

This should return the information you’re looking for.
Please let me know if you have any questions or concerns.

Best,
RayanP