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.
Page 1 / 1
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.htm
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.htm
thanks @dillon ! i'll pass this along.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.