How to get users through API

[Alberto_Consonn]

Hi community,

I’m working on the integration between ServiceNow and AirTable, the goal is to manage AirTable subscriptions through ServiceNow, so I need to get AirTable user subscriptions into ServiceNow.

Looking at the AirTable API documentation, I don’t see anywhere how to do a simple “Get Users”.

Using the Enterprise Account > Get Information, I’m only getting the userIds without the other parameters.
https://api.airtable.com/v0/meta/enterpriseAccounts/EnterpriseAccountId

How can I get the list of AirTable users including all the following basic information?

"state": "provisioned",
"email": "foo@bar.com",
"name": "foo baz",
"lastActivityTime": "2019-01-03T12:33:12.421Z"

Thanks a lot for your support
Regards
Alberto

[Alberto_Consonn]

Any chance to get support from community experts? thanks

[ScottWorld]

Check the “Enterprise Account User” section of the Enterprise API Documentation. Specifically, the “Get Information” section.

[Alberto_Consonn]

Alberto_Consonni:

Using the Enterprise Account > Get Information , I’m only getting the userIds without the other parameters

Like I said in the post, using the Enterprise Account > Get Information , I’m only getting the userIds without the other information (state, email, name, lastActivityTime, etc.). How can I get all these additional information for all the users not for a single user? Thanks a lot

[ScottWorld]

No, you are incorrect. You are looking in the wrong place.

You are looking in Enterprise Account > Get Information.

You need to be looking in Enterprise Account User > Get Information.

Are you seeing the extra word “User” that I put in bold?

In your very first post, you said that you are using:

https://api.airtable.com/v0/meta/enterpriseAccounts/EnterpriseAccountId

This is NOT what is listed in the API documentation for getting info on the users.

This is what the documentation says:

https://api.airtable.com/v0/meta/enterpriseAccounts/EnterpriseAccountId/users/UserId?include=collaborations

[Alberto_Consonn]

I’m aware of the “Get Information” API mentioned but here we need to specify the “UserId” parameter, which means it’s getting the information of one single user which is obviously not acceptable for us as we might need to do thousands of REST API calls for getting all the users subscriptions.

Is there a way to modify this “Get Information” API to get all users in one single REST API call?

Thanks a lot

[ScottWorld]

The answer is no.

You are also limited to 5 requests per second.

[Alberto_Consonn]

Thanks for your reply.

Another question please, I can’t find any API for “Create User” here: AirTable API Enterprise, is there a way to Create/Add a User to the AirTable Enterprise Admin portal?

Thanks a lot.

[ScottWorld]

Not sure… there is an “Add Collaborator” command, but it looks like you need to already know the person’s Airtable Account ID in order to add them as a collaborator onto your workspace.

I would email support@airtable.com with your questions & feature requests, and report back here with what they say!