Account name null issue from GraphQl response

[Wei]

Hello,

We are using the GraphQL to get the 3PL customers as follows:
query {
account {
data {
email
username
customers(first: 500) {
edges {
node {
id
email
username
legacy_id
status
}
}
}
}
}
}

Everything looks like as we expected besides some user name returns NULL, even though we know every customer has set their business name propely, we’d also checked via name column from the table on the https://app.shiphero.com/3pl

{
“data”: {
“account”: {
“data”: {
…
“customers”: {
“edges”: [
…
{
“node”: {
“id”: “QWXXXXXXXXXXXX”,
“email”: “xxx@yyy.com”,
“username”: null,
“legacy_id”: zxcv,
“status”: “active”
}
},
…
]
}
}

So there are something what we need to get solved.

1. Why does this case happen for some users?
2. How can we get the account name in case of users which has null name?
3. On the shiphero 3PL list, do we have a way to list the email for users?

Thanks in advance.

[Theresa]

Hi Wei,
The username in your query is not the same field as the client name on this page:https://app.shiphero.com/3pl.
The information you are looking for can be found under warehouses{company_alias}
query {
account {
data {
email
username
customers(first: 500) {
edges {
node {
warehouses {
id
legacy_id
account_id
company_alias
}
}
}
}
}
}
}
Users are not listed in the 3PL list. If you need the users in the 3PL, you can go to My Account > Users and download the csv.
If you need the users email from a client account, you can enable the client access in your 3PL user settings pagehttps://app.shiphero.com/dashboard/users > Edit which will enable the dropdown in your 3PL account to enter the client account, then you can go to the user list in the client account and see the user email list. This also has the ability to download a csv.

Let me know if you have questions, I will be happy to help!