How to get Username using user_id

GraphQL API
1

Hi,

I need to fetch the username by using user_id.
I am getting user_id from the inventory log.

query {
inventory_changes(date_from: “2021-05-30”) {
request_id
complexity
data {
edges {
node {
user_id
account_id
warehouse_id
sku
previous_on_hand
change_in_on_hand
reason
cycle_counted
location_id
created_at
}
}
}
}
}

How to get the username(Inventory Changed By) using user_id.

Thanks in advance.

1 Like
2

Hi @supritha ,
What is the request-id that is returned so I can take a closer look?

3

This query will give the user name:

query {
  picks_per_day(date_from: "2021-04-30") {
    request_id
    complexity
    data {
      edges {
        node {
          id
          user_id
          tote_id
          line_item_id
          location_id
          order_id
          order_number
          user_first_name
          user_last_name
          inventory_bin
          sku
          quantity
          picked_quantity
          pick_type
          barcode_scanned
          created_at
        }
        cursor
      }
    }
  }
}
1 Like
4

Thanks, @Theresa!

Yes, I got a user name using the mentioned Query.

1 Like
5

Hi,

Is there any case where user_id returned from inventory_changes API is not in packs_per_day to fetch user_first_name?
User Id returned from inventory_changes query, for all those id’s can we get the username from packs_per_day.

query {
        packs_per_day(user_id: ${userId}) {
          request_id  
          complexity
          data {
            edges {
              node {
                user_first_name
                user_last_name
              }
            }
          }
        }
      }

Thanks in advance.

6

Hi
If you get a userId, the query should return a result as long as the user did pack on that day.

7

Hi,
So this query will return username only if that user packed on that day.
If the user does an inventory change and will not pack on that day, this query will not return the username.
Can I get any other query where fetching username using user_id is not dependent on any other thing?

2 Likes
8

Is there any other API to fetch username using user id, which is not dependent on packs_per_day?

10

Hi @supritha!

We apologize for the delayed response about this.
We have made an internal request to add this either to a new query or to the account query as a connection.
Thanks again for the patience and we will keep you updated on the progress of the request!
Tom

11

I am interested in this as well.

We’re linking picks_per_day + packs_per_day data to our timesheet data. User first name + last name are a bit weak as far as keys go, so we’re hoping to translate user IDs to email addresses and link those to timesheets.

1 Like
12

Thanks @askthebird !
Added a +1 on our internal request :slightly_smiling_face:

2 Likes
13

I was about to post this exact question when I found this topic. I also need to know the user first+last name instead of user_id when querying for inventory changes.
This topic is more than an year old - was this ever implemented and is there a solution now?
Thank you

14

Hey @Raj,

Unfortunately, this has not been implemented yet and I don’t believe there is a work around for this.
I have added a +1 internally for this and left a comment.

I’ll keep you all posted on the progress of this feature request!

Best,
RayanP

15

Thank you @sh-agent, though it’s really disappointing to know. I hope it changes soon.

16

What is the status if this request? Will it get get added? When?

This is a very basic function that should be in your API.

17

Hey @bbarrett,

Thanks for reaching out!

I’m unable to share much information about our development process, but there are no updates to share at the moment. I’ll bump this internally and relay your feedback for this.

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

Best,
RayanP