Extracted Data

<< Click to Display Table of Contents >>

Raynet One Data Hub > 14.0 > Connectors > Alphabetic Connector List > ServiceNow License Data 

Extracted Data

 

Endpoint:

{+servery}/api/now/doc/table/schema/{tableName}

Description:

Fetch the column names of any table. This is not documented officially.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/{tableName}

Description:

Fetch data from the table {tableName}.

Documentation:

https://developer.servicenow.com/dev.do#!/reference/api/newyork/rest/c_TableAPI

 

Endpoint:

{+serverUrl}/api/now/v2/table/sys_user

Description:

Fetch data from the table sys_user.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/sys_user_has_license

Description:

Fetch data from the table sys_user_has_license.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/ua_app_usage

Description:

Fetch data from the table ua_app_usage.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/license_details

Description:

Fetch data from the table license_details.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/license_has_app

Description:

Fetch data from the table license_has_app.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/licensable_app

Description:

Fetch data from the table licensable_app.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/licensed_app_usage

Description:

Fetch data from the table licensed_app_usage.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/license_details_assoc_roles

Description:

Fetch data from the table license_details_asssoc_roles.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/license_role

Description:

Fetch data from the table license_role.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/sys_user_has_role

Description:

Fetch data from the table sys_user_has_role.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/api/now/v2/table/sys_user_role

Description:

Fetch data from the table sys_user_role.

Documentation:

n/a

 

Endpoint:

{+serverUrl}/oauth_token.de

Description:

Authenticate with the api an returns a token in exchange for valid credentials.

Documentation:

https://docs.servicenow.com/bundle/quebec-application-development/page/integrate/inbound-rest/reference/r_RESTOAuthExample.html

 

It collects the following tables:

 

sys_user (with a specified subset of all fields)

sys_user_role

sys_user_has_role

sys_user_group

sys_user_grmember

license_has_user_set

license_details

em_unique_nodes

sys_user_set

ua_app_usage

sys_db_object

 

Additionally, it collects the relations of sys_user_set_to_sys_user and sys_user_group.