Skip to main content

Has anyone piped any API data directly to Tableau?

  • April 6, 2021
  • 2 replies
  • 170 views

Siobhan
Forum|alt.badge.img
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.

April 8, 2021

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

2 replies

Dillon Head
  • Scholar
  • April 8, 2021
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

Siobhan
Forum|alt.badge.img
  • Author
  • April 9, 2021
thanks @dillon! i'll pass this along.