Has anyone piped any API data directly to Tableau?

  • 6 April 2021
  • 2 replies
  • 15 views

Userlevel 3
Badge
Hi folks! Has anyone piped any API data directly to Tableau? I'm a bit out of my depth here and hoping to get some more info to share with some team members who have a bit more knowledge around this than I do.

Dillon Head 6 months ago

Hi Siobhan,
API data is returned in json format. you can set up a json data source for Tableau and Tableau will infer a schema from it.
"When you connect Tableau to a JSON file, Tableau scans the data in the first 10,000 rows of the JSON file and infers the schema from that process. Tableau flattens the data using this inferred schema. The JSON file schema levels are listed in the Select Schema Levels dialog box."
https://help.tableau.com/current/pro/desktop/en-us/examplesjson.htmJSON File
View original

2 replies

Userlevel 3
Hi Siobhan,
API data is returned in json format. you can set up a json data source for Tableau and Tableau will infer a schema from it.
"When you connect Tableau to a JSON file, Tableau scans the data in the first 10,000 rows of the JSON file and infers the schema from that process. Tableau flattens the data using this inferred schema. The JSON file schema levels are listed in the Select Schema Levels dialog box."
https://help.tableau.com/current/pro/desktop/en-us/examplesjson.htmJSON File
Userlevel 3
Badge
thanks @dillon! i'll pass this along.

Reply