using Tableau with ServiceNow

[howardrichter]

I am working with a developer who has been able to connect Tableau to SN and pull in data from the task table, however, he can't dotwalk. For example when looking at an incident, the assigned group is just the unique ID and not the name.

So I am looking for some documentation that I can point him to,on how to do this. That would be great.

As always thanks to all,

Howard

[Stefan Baldhof1]

Hi Howard,

so "Tableau" is the system retrieving data from ServiceNow? How is the connection implemented? Via table API with a REST call? Could you provide the code or REST call in detail?

Regards,

Stefan

[howardrichter]

Stefan,

Sorry to say I don't have that at this time. I was just asked to see what was out there and the correct way to build this integration.

Howard

[Stefan Baldhof1]

Hi Howard,

though it's a bit difficult then to point in the right direction the follwing might be helpful:

REST API Explorer - ServiceNow Wiki

REST API explorer

When the integration is done via REST playing around with the REST API Explorer gives a very good overview of the API features and how to use it.

Regards,

Stefan

[DChandlerKy]

We are still fine tuning out Tableau/SN integration. I did end up giving the tableau user in SN access to sys_user_grmember and sys_user_group to do the necessary joins to link the sys_id they have for the assignment group in the incident to more info like the group name. 

If you are still working on this, I can share more as we keep working on this. 

--Diana